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