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