public int SaveRecord(SETUP_Department lrow_Department) { int li_ReturnValue = 0; try { SCMSDataContext dbSCMS = Connection.Create(); SETUP_Department lRow_ExistingData = dbSCMS.SETUP_Departments.Where(c => c.Dpt_Id.Equals(lrow_Department.Dpt_Id)).SingleOrDefault(); if (lRow_ExistingData != null) { lRow_ExistingData.Dpt_Title = lrow_Department.Dpt_Title; lRow_ExistingData.Loc_Id = lrow_Department.Loc_Id; } else { dbSCMS.SETUP_Departments.InsertOnSubmit(lrow_Department); } dbSCMS.SubmitChanges(); li_ReturnValue = Convert.ToInt32(lrow_Department.Dpt_Id); } catch { return 0; } return li_ReturnValue; }
// Insertion public ActionResult SaveRecord(String ps_Code, String Location, String Title) { Int32 li_ReturnValue = 0; try { SETUP_Department lrow_Department = new SETUP_Department(); if (String.IsNullOrEmpty(ps_Code)) { if (DALCommon.AutoCodeGeneration("SETUP_Department") == 1) { ps_Code = DALCommon.GetMaximumCode("SETUP_Department"); } } if (!String.IsNullOrEmpty(ps_Code)) { lrow_Department.Dpt_Id = ps_Code; lrow_Department.Dpt_Code = ps_Code; lrow_Department.Dpt_Title = Title; lrow_Department.Loc_Id = Location; lrow_Department.Dpt_Active = 1; li_ReturnValue = objdalDeparment.SaveRecord(lrow_Department); ViewData["SaveResult"] = li_ReturnValue; } return PartialView("GridData"); } catch { return PartialView("GridData"); } }
public ActionResult Update(SETUP_Department department) { Department dpDepartment = new Department(); bool updated = dpDepartment.Update(department); if (updated) { return(RedirectToAction("ViewDetail", "Department", new { id = department.Dep_Id })); } else { TempData["error"] = "Opps! Somthing went wrong!"; return(RedirectToAction("Edit", "Department", new { id = department.Dep_Id })); } }
public ActionResult Add(SETUP_Department department) { Department dpDepartment = new Department(); int id = dpDepartment.Add(department); if (id > 0) { return(RedirectToAction("Index", "Department")); } else { TempData["error"] = "Opps! Somthing went wrong!"; return(RedirectToAction("Add", "Department")); } }
/// <summary> /// Updates modified values of department to the database.... /// </summary> /// <param name="department"></param> /// <returns>Returns true if updated successfully else returns false.</returns> public bool Update(SETUP_Department department) { using (eSuiteEntities db = new eSuiteEntities()) { try { db.Entry(department).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(true); } catch { return(false); } } }
/// <summary> /// Adds new department to the database.... /// </summary> /// <param name="department"></param> /// <returns>Returns new department id if saved successfully else returns 0</returns> public int Add(SETUP_Department department) { using (eSuiteEntities db = new eSuiteEntities()) { try { db.Entry(department).State = System.Data.Entity.EntityState.Added; db.SaveChanges(); return(department.Dep_Id); } catch { return(0); } } }