public ActionResult EditDeptProjection(DeptProjectionViewModel model) { try { if (ModelState.IsValid) { DbfunctionUtility dbfunction = new DbfunctionUtility(_appSettings); var query = "select * from tov.DeptProjection where DeptName = '" + model.DeptName + "' and mm =" + model.mm + " and DeptName != '" + model.DeptNameId + "' and mm !=" + model.mmId + " "; DataSet ds = dbfunction.GetDataset(query); if (ds.Tables[0].Rows.Count == 0) { query = " update tov.DeptProjection set DeptName = '" + model.DeptName + "',mm = " + model.mm + ",Projection = " + model.Projection + " where DeptName = '" + model.DeptNameId + "' and mm =" + model.mmId + " ;"; ds = dbfunction.GetDataset(query); ViewBag.SuccessMessage = "Department projection detail updated successfully"; } else { ViewBag.ErrorMessage = "Department projection detail is already exists"; } } } catch (Exception ex) { } return(View(model)); }
public ActionResult EditDeptProjection(string DeptName, string mm) { DeptProjectionViewModel model = new DeptProjectionViewModel(); try { if (ModelState.IsValid) { DbfunctionUtility dbfunction = new DbfunctionUtility(_appSettings); DataSet ds = dbfunction.GetDataset("select * from tov.DeptProjection where DeptName= '" + DeptName + "' and mm= " + mm + ";"); if (ds.Tables[0].Rows.Count > 0) { model.DeptName = Convert.ToString(ds.Tables[0].Rows[0]["DeptName"]); model.DeptNameId = Convert.ToString(ds.Tables[0].Rows[0]["DeptName"]); model.mm = Convert.ToInt32(ds.Tables[0].Rows[0]["mm"]); model.mmId = Convert.ToInt32(ds.Tables[0].Rows[0]["mm"]); model.Projection = Convert.ToDecimal(ds.Tables[0].Rows[0]["Projection"]); } else { return(RedirectToAction("DeptProjectionList", "DataEntry")); } } } catch (Exception ex) { } return(View(model)); }