TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
ahmed elbarbary
NA
1.6k
277.8k
cannot modify function GetSelectStatement to generate select
Sep 21 2019 3:10 PM
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
json
string
i generate sql from it
{
"Details"
:{
"table"
:[
"MasterTable"
,
"FooterTable"
],
"fields"
:{
"ItemCode"
:
"string"
,
"Quantity"
:
"int"
,
"Price"
:
"decimal"
},
"keys"
:{
"BranchCode"
:1,
"Year"
:2019,
"Serial"
:2
}
}
}
Reply
Answers (
1
)
Prequisite for .Net core
How call controller Action result with Ajax in Mvc?