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