public ActionResult EditSector(EditSector ae) { if (ModelState.IsValid) { using (mmpEntities mP = new mmpEntities()) { #region Sector Already Exists var isSectorExists = IsSectorExist(ae.sector_name); if (isSectorExists) { ModelState.AddModelError("SectorExists", "Sector already exists"); return(View(ae)); } #endregion sector sector = new sector() { sector_id = ae.sector_id, sector_name = ae.sector_name }; mP.Entry(sector).State = EntityState.Modified; mP.SaveChanges(); return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet)); } } return(View()); }
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 EditRegion(EditRegion ae) { if (ModelState.IsValid) { using (mmpEntities mP = new mmpEntities()) { #region Region Already exists var isRegionExists = IsRegionExist(ae.region_name); if (isRegionExists) { ModelState.AddModelError("RegionExists", "Region already exists"); return(View(ae)); } #endregion region region = new region() { region_id = ae.region_id, region_name = ae.region_name }; mP.Entry(region).State = EntityState.Modified; mP.SaveChanges(); return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet)); } } return(View()); }
public ActionResult Delete(int id) { using (mmpEntities mP = new mmpEntities()) { user userDetails = mP.users.Where(x => x.user_id == id).FirstOrDefault <user>(); //mP.users.Remove(userDetails); //mP.SaveChanges(); userDetails.user_status = "inactive"; mP.Entry(userDetails).State = EntityState.Modified; mP.SaveChanges(); return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult EditUser(EditUser editUser) { using (mmpEntities mP = new mmpEntities()) { ViewBag.roles = mP.roles.ToList <role>(); ViewBag.regions = mP.regions.ToList <region>(); ViewBag.supervisors = mP.users.Where(a => a.user_id == mP.roles.FirstOrDefault(x => x.role_name == "supervisor").role_id&& a.user_id != editUser.user_id).ToList <user>(); ViewBag.departments = mP.category_type_details.Where(x => x.category_id == (mP.categories.FirstOrDefault(z => z.category_name == "departments").category_id)).ToList <category_type_details>(); ViewBag.projects = mP.category_type_details.Where(x => x.category_id == (mP.categories.FirstOrDefault(z => z.category_name == "projects").category_id)).ToList <category_type_details>(); ViewBag.supervisorsl = mP.users.Where(a => a.role_id == mP.roles.FirstOrDefault(x => x.role_name == "supervisor").role_id&& a.user_id != editUser.user_id && a.user_status == "active").Select(p => new SelectListItem() { Text = p.employee_id + " " + p.user_name, Value = p.user_id.ToString() }).ToList(); if (ModelState.IsValid) { #region Employee ID Already Exists var isEmployeeIDExists = isEmployeeIDExist(editUser.employee_id, editUser.user_id); if (isEmployeeIDExists) { ModelState.AddModelError("EmployeeExist", "Employee already exists"); return(View(editUser)); } #endregion /*#region User Already Exists * var isUserExists = isUserExist(editUser.user_name, editUser.user_id); * if (isUserExists) * { * ModelState.AddModelError("UserExist", "Username already exists"); * return View(editUser); * } #endregion*/ #region Email Already Exists var isEmailExists = IsEmailExist(editUser.user_email, editUser.user_id); if (isEmailExists) { ModelState.AddModelError("EmailExists", "Email already exists"); return(View(editUser)); } #endregion user user = mP.users.Where(x => x.user_id == editUser.user_id).First(); user.user_name = editUser.user_name; user.role_id = editUser.role_id; user.employee_id = editUser.employee_id; user.user_email = editUser.user_email; user.designation = editUser.designation; user.supervisor = editUser.supervisor; user.updated_at = DateTime.Now; user.region_id = editUser.region_id; user.user_primary_department = editUser.user_primary_department; user.user_primary_project = editUser.user_primary_project; mP.Entry(user).State = EntityState.Modified; mP.SaveChanges(); return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet)); } } return(View(editUser)); }
public ActionResult AddorEditLeaves(AddorEditLeave ael) { if (ModelState.IsValid) { using (mmpEntities mP = new mmpEntities()) { /*#region Leave Name already assigned * var isLeaveNameAssigned = IsCategoryTypeAssigned(ael.leave_name, ael.ctd_id, 1); * if (isLeaveNameAssigned) * { * ModelState.AddModelError("LeaveAssigned", "Leave Name is already assigned"); * return View(ael); * } #endregion*/ #region Leave Code already assigned var isLeaveCodeAssigned = IsCategoryTypeAssigned(ael.code, ael.ctd_id, 0); if (isLeaveCodeAssigned) { ModelState.AddModelError("LeaveAssigned", "Leave Code is already assigned"); return(View(ael)); } #endregion if (ael.ctd_id == 0) { category_type_details ctd = new category_type_details() { ctd_name = ael.leave_name, ctd_code = ael.code, category_id = ael.category_id, ctd_created_at = DateTime.Now }; mP.category_type_details.Add(ctd); mP.SaveChanges(); leave_details ld = new leave_details() { no_of_leaves = ael.no_of_leaves, encashable = ael.encashable, carry_forward = ael.carry_forward, category_type_id = ctd.ctd_id }; mP.leave_details.Add(ld); mP.SaveChanges(); return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet)); } else { category_type_details ctd = new category_type_details() { ctd_id = ael.ctd_id, ctd_name = ael.leave_name, ctd_code = ael.code, category_id = ael.category_id, ctd_created_at = ael.ctd_created_at, ctd_updated_at = DateTime.Now }; leave_details ld = new leave_details() { id = ael.leave_details_id, no_of_leaves = ael.no_of_leaves, encashable = ael.encashable, carry_forward = ael.carry_forward, category_type_id = ctd.ctd_id }; mP.Entry(ctd).State = EntityState.Modified; mP.Entry(ld).State = EntityState.Modified; mP.SaveChanges(); return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet)); } } } else { return(View(ael)); } }
public ActionResult AddorEditProjects(AddorEditProject aep) { if (ModelState.IsValid) { using (mmpEntities mP = new mmpEntities()) { ViewBag.Sectors = mP.sectors.ToList <sector>(); ViewBag.Regions = mP.regions.ToList <region>(); /*#region Project Name is already assigned * var isProjectNameAssigned = IsCategoryTypeAssigned(aep.proj_name, aep.ctd_id, 1); * if (isProjectNameAssigned) * { * ModelState.AddModelError("ProjectAssigned", "Project Name is already assigned"); * return View(aep); * } #endregion*/ #region Project Code is already assigned var isProjectCodeAssigned = IsCategoryTypeAssigned(aep.code, aep.ctd_id, 0); if (isProjectCodeAssigned) { ModelState.AddModelError("ProjectAssigned", "Project Code is already assigned"); return(View(aep)); } #endregion if (aep.ctd_id == 0) { category_type_details ctd = new category_type_details() { ctd_name = aep.proj_name, ctd_code = aep.code, category_id = aep.category_id, ctd_created_at = DateTime.Now }; mP.category_type_details.Add(ctd); //mP.SaveChanges(); project_details pd = new project_details() { sector_id = aep.sector_id, region_id = aep.region_id, project_model = aep.proj_model, category_type_id = ctd.ctd_id }; mP.project_details.Add(pd); mP.SaveChanges(); return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet)); } else { category_type_details ctd = new category_type_details() { ctd_id = aep.ctd_id, ctd_name = aep.proj_name, ctd_code = aep.code, category_id = aep.category_id, ctd_created_at = aep.ctd_created_at, ctd_updated_at = DateTime.Now }; project_details pd = new project_details() { id = aep.proj_details_id, sector_id = aep.sector_id, region_id = aep.region_id, project_model = aep.proj_model, category_type_id = aep.ctd_id }; Debug.WriteLine(aep.proj_model); mP.Entry(ctd).State = EntityState.Modified; mP.Entry(pd).State = EntityState.Modified; mP.SaveChanges(); return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet)); } } } else { return(View(aep)); } }