public ActionResult InsertOrUpdateQuery(int id, string name, string where, int tabid, int tid, List <QueryModel> qLines)
{
int no = -1;
var uq = new VAdvantage.Model.MUserQuery(Session["ctx"] as VAdvantage.Utility.Ctx, id, null);
//set query name
if (name != null && name.Length > 0)
{
uq.SetName(name);
}
// set query code
uq.SetCode(where);
// set tab id
uq.SetAD_Tab_ID(tabid);
// set table id
uq.SetAD_Table_ID(tid);
// save the values in database
if (uq.Save())
{
no = 1;
// delete existing query lines
uq.DeleteLines();
// if no lines then return
if (qLines == null || qLines.Count < 1)
{
;
}
else
{
int totCnt = qLines.Count;
// save each the query lines in the dataset
for (int i = 0; i < totCnt; i++)
{
QueryModel m = qLines[i];
// set values
VAdvantage.Model.MUserQueryLine line = new VAdvantage.Model.MUserQueryLine(uq, (i + 1) * 10, m.KEYNAME ?? "",
m.KEYVALUE ?? "", m.OPERATORNAME ?? "",
m.VALUE1NAME ?? "", m.VALUE1VALUE ?? "",
m.VALUE2NAME ?? "", m.VALUE2VALUE ?? "");
// save query line
line.Save();
}
}
}
return(Json(no));
}
public ActionResult DeleteQuery(int id)
{
int no = -1;
var uq = new VAdvantage.Model.MUserQuery(Session["ctx"] as VAdvantage.Utility.Ctx, id, null);
if (uq != null)
{
// get name of the query
string name = uq.GetName();
// delete query
if (uq.Delete(true))
{
no = 1;
}
}
return(Json(no));
}
