public object DeleteDepartment(DepartmentParam MP) { try { Tbl_Department_Master objdepartment = db.Tbl_Department_Master.Where(r => r.DepartmentID == MP.DepartmentID).FirstOrDefault(); if (objdepartment.Status == 1) { objdepartment.Status = 0; } else { objdepartment.Status = 1; } db.SaveChanges(); return(new Result() { IsSucess = true, ResultData = "Department Updated Successfully!" }); } catch (Exception ex) { return(new Error() { IsError = true, Message = ex.Message }); } }
public object SaveDepartment(DepartmentParam MP) { try { string msg = ""; if (MP.BtnStatus == "Save") { var usercode = db.Tbl_Department_Master.Where(r => r.Department == MP.Department.ToUpper()).FirstOrDefault(); if (usercode != null) { return(new Error() { IsError = true, Message = "Department Name Already Exists!" }); } Tbl_Department_Master objDepartment = new Tbl_Department_Master(); objDepartment.Department = MP.Department.ToUpper(); objDepartment.CreatedBy = MP.CreatedBy; objDepartment.CreatedDate = DateTime.Now; objDepartment.Status = 1; db.Tbl_Department_Master.Add(objDepartment); db.SaveChanges(); msg = "Department Saved Successfully!"; } else { Tbl_Department_Master objDepartment = db.Tbl_Department_Master.Where(r => r.DepartmentID == MP.DepartmentID).FirstOrDefault(); var Data = db.Tbl_Department_Master.Where(r => r.Department == MP.Department.ToUpper()).FirstOrDefault(); if (Data != null) { return(new Error() { IsError = true, Message = "Department Name Already Exists!" }); } objDepartment.Department = MP.Department.ToUpper(); objDepartment.ModifiedDate = DateTime.Now; objDepartment.DepartmentID = MP.DepartmentID; db.SaveChanges(); msg = "Department Updated Successfully!"; } return(new Result() { IsSucess = true, ResultData = msg }); } catch (Exception ex) { return(new Error() { IsError = true, Message = ex.Message }); } }