public ActionResult AddorEditDepartments(AddorEditDepartment aed) { if (ModelState.IsValid) { using (mmpEntities mP = new mmpEntities()) { /*#region Department Name already exists * var isDepartmentNameAssigned = IsCategoryTypeAssigned(aed.dept_name, aed.ctd_id, 1); * if (isDepartmentNameAssigned) * { * ModelState.AddModelError("DeparmentAssigned", "Department Name is already assigned"); * return View(aed); * } #endregion*/ #region Department Code already assigned var isDepartmentCodeAssigned = IsCategoryTypeAssigned(aed.code, aed.ctd_id, 0); if (isDepartmentCodeAssigned) { ModelState.AddModelError("DepartmentAssigned", "Department Code is already assigned"); return(View(aed)); } #endregion if (aed.ctd_id == 0) { category_type_details ctd = new category_type_details() { ctd_name = aed.dept_name, ctd_code = aed.code, category_id = aed.category_id, ctd_created_at = DateTime.Now }; mP.category_type_details.Add(ctd); mP.SaveChanges(); return(Json(new { success = true, message = "Saved Successfully " }, JsonRequestBehavior.AllowGet)); } else { category_type_details ctd = new category_type_details() { ctd_id = aed.ctd_id, ctd_name = aed.dept_name, ctd_code = aed.code, category_id = aed.category_id, ctd_created_at = aed.ctd_created_at, ctd_updated_at = DateTime.Now }; mP.Entry(ctd).State = EntityState.Modified; mP.SaveChanges(); return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet)); } } } else { return(View(aed)); } }
public ActionResult AddorEditDepartments(int id = 0) { using (mmpEntities mP = new mmpEntities()) { if (id == 0) { return(View(new AddorEditDepartment() { category_id = mP.categories.First(x => x.category_name == "departments").category_id })); } else { var query = mP.category_type_details.Where(x => x.ctd_id == id).FirstOrDefault <category_type_details>(); AddorEditDepartment aed = new AddorEditDepartment() { ctd_id = query.ctd_id, dept_name = query.ctd_name, code = query.ctd_code, category_id = query.category_id, ctd_created_at = query.ctd_created_at }; return(View(aed)); } } }