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));
}
