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 AddSectors(List <AddSector> sectors) { if (ModelState.IsValid) { using (mmpEntities mP = new mmpEntities()) { mP.Configuration.ProxyCreationEnabled = false; foreach (var i in sectors) { #region Sector Already Exists var isSectorExists = IsSectorExist(i.sector_name); if (isSectorExists) { ModelState.AddModelError("SectorExists", "Sector already exists"); return(View(sectors)); } #endregion sector sector = new sector() { sector_name = i.sector_name }; mP.sectors.Add(sector); } mP.SaveChanges(); return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet)); } } else { return(View(sectors)); } }
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 AddRegions(List <AddRegion> regions) { if (ModelState.IsValid) { using (mmpEntities mP = new mmpEntities()) { mP.Configuration.ProxyCreationEnabled = false; foreach (var i in regions) { #region Region Already exists var isRegionExists = IsRegionExist(i.region_name); if (isRegionExists) { ModelState.AddModelError("RegionExists", "Region already exists"); return(View(regions)); } #endregion region region = new region() { region_name = i.region_name }; mP.regions.Add(region); } mP.SaveChanges(); return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet)); } } else { return(View(regions)); } }
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 ChangePassword(ChangePasswordVM userpassVM) { using (mmpEntities mP = new mmpEntities()) { user user = mP.users.Where(x => x.user_id == userpassVM.user_id).FirstOrDefault(); #region Password Hashing user.user_password = Crypto.Hash(userpassVM.password); #endregion mP.SaveChanges(); return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult AddHolidays(List <AddHolidays> AHD) { if (ModelState.IsValid) { using (mmpEntities mP = new mmpEntities()) { mP.Configuration.ProxyCreationEnabled = false; foreach (var i in AHD) { #region Holiday Already Exists var isHolidayAssigned = IsHolidayAssigned(i.hd_name, i.hy_id, i.hd_from.Date); if (isHolidayAssigned) { ModelState.AddModelError("HolidayAssigned", "Holiday Already added for the year"); return(View(AHD)); } #endregion DateTime startDate = StartOfWeek(DateTime.Today, DayOfWeek.Monday); DateTime endDate = startDate.AddDays(6); #region Validate dates if (i.hd_from.Date > i.hd_to.Date) { ModelState.AddModelError("InvalidDate", "To Date should be equal to or greater than start date"); return(View(AHD)); } if (i.hd_from.Date < endDate) { ModelState.AddModelError("InvalidDate", "Cannot add dates for previous and current weeks"); return(View(AHD)); } #endregion holiday_details hd = new holiday_details() { hd_name = i.hd_name, hd_from = i.hd_from, hd_to = i.hd_to, //hy_id = null, // Since we are not using holiday_year table anymore generated_by = 1 // AUTOMATE USER ID }; mP.holiday_details.Add(hd); } mP.SaveChanges(); ModelState.Clear(); return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet)); } } return(View(AHD)); }
public ActionResult Delete(int id) { using (mmpEntities mP = new mmpEntities()) { DateTime startDate = StartOfWeek(DateTime.Today, DayOfWeek.Monday); DateTime endDate = startDate.AddDays(6); holiday_details hd = mP.holiday_details.Where(x => x.hd_id == id).FirstOrDefault <holiday_details>(); if (hd.hd_from > endDate) { mP.holiday_details.Remove(hd); mP.SaveChanges(); return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { success = false, message = "Cannot delete holiday entries for current and previous weeks!" }, JsonRequestBehavior.AllowGet)); } } }
public ActionResult GetData() { using (mmpEntities mP = new mmpEntities()) { mP.Configuration.ProxyCreationEnabled = false; DateTime date = DateTime.Now; ViewBag.Year = date.Year; var year = mP.holiday_year.Where(x => x.year == DateTime.Now.Year).FirstOrDefault <holiday_year>(); if (year == null) { holiday_year hy = new holiday_year() { //hy_name = "Holiday list for " + date.Year.ToString(), hy_name = "Holiday list", creation_date = date, year = (Int16)date.Year // Cast int to short }; mP.holiday_year.Add(hy); mP.SaveChanges(); return(Json(new { data = year }, JsonRequestBehavior.AllowGet)); } else { /*var holidays = (from hd in mP.holiday_details * join hy in mP.holiday_year on hd.hy_id equals hy.hy_id * select new * { * hd, * year = hy.year * }).OrderByDescending(x => x.year);*/ var holidays = (from hd in mP.holiday_details select new { hd, year = hd.hd_to.Year }).OrderByDescending(x => x.year); return(Json(new { data = holidays.AsNoTracking().ToList() }, 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 AddUser(AddUser newUser) { using (mmpEntities mP = new mmpEntities()) { ViewBag.roles = mP.roles.ToList <role>(); ViewBag.regions = mP.regions.ToList <region>(); ViewBag.supervisors = mP.users.Where(a => a.role_id == mP.roles.FirstOrDefault(x => x.role_name == "supervisor").role_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_status == "active").Select(p => new SelectListItem() { Text = p.employee_id + " " + p.user_name, Value = p.user_id.ToString() }).ToList(); #region Employee ID Already Exists var isEmployeeIDExists = isEmployeeIDExist(newUser.employee_id); if (isEmployeeIDExists) { ModelState.AddModelError("EmployeeExist", "Employee already exists"); return(View(newUser)); } #endregion /*#region User Already Exists * var isUserExists = isUserExist(newUser.user_name); * if (isUserExists) * { * ModelState.AddModelError("UserExist", "User already exists"); * return View(newUser); * } #endregion*/ #region Email Already exists var isEmailExists = IsEmailExist(newUser.user_email); if (isEmailExists) { ModelState.AddModelError("EmailExist", "Email already exists"); newUser.user_name = "Enter New Name"; return(View(newUser)); } #endregion if (ModelState.IsValid) { ModelState.AddModelError("UserExist", "User already exists"); #region Password Hashing newUser.user_password = Crypto.Hash(newUser.user_password); newUser.confirmPassword = Crypto.Hash(newUser.confirmPassword); #endregion user user = new user() { role_id = newUser.role_id, employee_id = newUser.employee_id, user_name = newUser.user_name, user_email = newUser.user_email, designation = newUser.designation, user_password = newUser.user_password, created_at = DateTime.Now, supervisor = newUser.supervisor, region_id = newUser.region_id, user_primary_department = newUser.user_primary_department, user_primary_project = newUser.user_primary_project, user_status = "active", join_date = newUser.joining_date }; mP.users.Add(user); //var timesheet = mP.timesheet_mr.Where(x => x.tsmr_valid_till > DateTime.Now && x.tsmr_start_date < DateTime.Now).FirstOrDefault<timesheet_mr>(); var timesheets = mP.timesheet_mr.Where(x => x.tsmr_valid_till > user.join_date).ToList <timesheet_mr>(); foreach (timesheet_mr timesheet in timesheets) { string body; if (timesheet != null) { timesheet ts = new timesheet() { timesheet_user = user.user_id, time_my = DateTime.Now, timesheet_status = "saved", timesheet_caller = timesheet.tsmr_id, tsmr_extension = timesheet.tsmr_valid_till > DateTime.Now ? timesheet.tsmr_valid_till : DateTime.Now.AddDays(-1) }; mP.timesheets.Add(ts); foreach (DateTime day in EachDay(timesheet.tsmr_start_date, timesheet.tsmr_valid_till)) { presence ps = new presence() { p_date = day, total_hours = 0, leave_status = "", user_id = user.user_id }; mP.presences.Add(ps); } body = "<br></br>" + user.user_name + ", New TimeSheet is assigned to you. TimeSheet is valid Till " + timesheet.tsmr_valid_till + ". Visit the following website to access timeSheet<br></br>" + "<a href='http://magcom-001-site3.etempurl.com'>http://magcom-001-site3.etempurl.com</a>"; Task.Run(() => EmailAlert.SendEmail(user.user_email, body)); } } #region Save to Database mP.SaveChanges(); #endregion return(Json(new { success = true, message = "Saved Successfully" })); } else { return(Json(new { success = true, message = "Invalid Request" })); } } }
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)); } }