cannot modify function GetSelectStatement to generate select

I need to modify function GetSelectStatement to get select statment as below

select FooterTable.ItemCode,FooterTable.Quantity,FooterTable.UniPrice from
MasterTable inner join FooterTable on MasterTable.Serial=FooterTable.Serial,MasterTable.BranchCode=FooterTable.BranchCode,MasterTable.Year=FooterTable.Year
where MasterTable.Serial=10 AND MasterTable.Year=2019 AND MasterTable.BranchCode=1

What i try to get result above by csharp as following :

public string GetSelectStatement(string JsonDataForSelect)
{
var root = (JObject)JsonConvert.DeserializeObject(JsonDataForSelect);
var query = "";
var items = root.SelectToken("Details").Children().OfType().ToDictionary(p => p.Name, p => p.Value);
foreach (var item in items)
{
if (item.Key == "table")
{
var tableName = item.Value;
query = string.Format("select from table {0} inner join table{1} where", tableName);
}
else if (item.Key == "keys")
{
var key = item.Value.SelectToken("").OfType().ToDictionary(p => p.Name, p => p.Value);
var count = 0;
foreach (var id in key)
{
count++;
if (count == key.Count())
{
query += string.Format("{0} = {1}", id.Key, id.Value);
}
else
{
query += string.Format("{0} = {1} and ", id.Key, id.Value);
}
}
}
}
return query;
}

I need to modify code above to generate select statement as above :

How to do that please by modify code above

Hello ahmed,

can you please try below code.

public string GetSelectStatement(string JsonDataForSelect)

{

var root = (JObject)JsonConvert.DeserializeObject(JsonDataForSelect);

var query = "";

var items = root.SelectToken("Details").Children().OfType().ToDictionary(p => p.Name, p => p.Value);

foreach (var item in items)

{

if (item.Key == "table")

{

var tableName = (JArray)item.Value;

query = string.Format("select from {0} inner join {1} where ", tableName.ToArray());

}

else if (item.Key == "fields")

{

var value = (JObject)item.Value;

var fields = value.SelectToken("").Children().OfType().ToDictionary(p => p.Name, p => p.Value).Select(x => x.Key).ToList();

query = query.Replace("select", $"select {string.Join(", ", fields)} ");

}

else if (item.Key == "keys")

{

var value = (JObject)item.Value;

var count = 0;

var key = value.SelectToken("").Children().OfType().ToDictionary(p => p.Name, p => p.Value);

foreach (var id in key)

{

count++;

if (count == key.Count())

{

query += string.Format("{0} = {1}", id.Key, id.Value);

}

else

{

query += string.Format("{0} = {1} and ", id.Key, id.Value);

}

return query;

}

let me know if you have needed any other help.

Thanks

1 Reply

Know the answer? Post it — somebody with the same question will find it here.