Hi,
I have one gridview with one button named as edit
after clicking of edit button it was displaying relevant values on form
after clicking of save button updated values are coming to controller
but it was not saving to database
[HttpPost]
public ActionResult SaveSettings(Report1 ordersdata)
{
string result = "Error! Settings Is Not Complete!";
bool isNameExist = db.Report1.Where(x => x.RId == ordersdata.RId).ToList().Count > 0 ? true : false;
var oldName = db.Report1.Where(x => x.RId == ordersdata.RId).FirstOrDefault();
if (isNameExist)
{
int orderId = ordersdata.RId;
foreach (var reports in ordersdata.details)
{
var oldDetail = db.ReportSettings.Where(x => x.RSId == reports.RSId).FirstOrDefault();
if (oldDetail == null)
{
try
{
ReportSetting subitem = new ReportSetting();
subitem.RId = orderId;
subitem.CName = reports.CName;
subitem.CType = reports.CType;
subitem.DisplayCName = reports.DisplayCName + "";
subitem.ValueCName = reports.ValueCName + "";
subitem.FromTable = reports.FromTable + "";
subitem.Date = reports.Date + "";
db.ReportSettings.Add(subitem);
db.SaveChanges();
result = "Settings has been Created Succuessfully!";
}
catch (Exception ex)
{
return Json(ex.Message, JsonRequestBehavior.AllowGet);
}
}
else
{
ReportSetting subitem = new ReportSetting();
subitem.RId = reports.RId;
subitem.RSId = reports.RSId;
subitem.CName = reports.CName;
subitem.CType = reports.CType;
subitem.DisplayCName = reports.DisplayCName + "";
subitem.ValueCName = reports.ValueCName + "";
subitem.FromTable = reports.FromTable + "";
subitem.Date = reports.Date + "";
db.SaveChanges();
result = "Settings has been Upadted Succuessfully!";
}
}
}
return Json(result, JsonRequestBehavior.AllowGet);
}