public int DeleteDepartment(int key) { TblDepartmentMaster department = dbContext.TblDepartmentMaster.Where(x => x.DepartmentId == key).FirstOrDefault(); department.IsActive = false; dbContext.TblDepartmentMaster.Update(department); return(dbContext.SaveChanges()); }
public int UpdateDepartment(TblDepartmentMaster tblDepartment) { if (dbContext.TblDepartmentMaster.Where(r => r.Department.ToUpper() == tblDepartment.Department.ToUpper() && r.DepartmentId != tblDepartment.DepartmentId && r.IsActive == true).Count() > 0) { return(-1); } tblDepartment.IsActive = true; dbContext.Entry(tblDepartment).State = EntityState.Modified; dbContext.TblDepartmentMaster.Update(tblDepartment); int result = dbContext.SaveChanges(); dbContext.Entry(tblDepartment).State = EntityState.Detached; return(result); }
public int UpdateDepartment(TblDepartmentMaster tblDepartment) { return(MastersDAL.UpdateDepartment(tblDepartment)); }
public int CreateDepartment(TblDepartmentMaster tblDepartment) { return(MastersDAL.CreateDepartment(tblDepartment)); }
public IActionResult Department(int id, [FromBody] TblDepartmentMaster tblDepartment) { int result = _imasters.UpdateDepartment(tblDepartment); return(Ok(result)); }
public IActionResult Department(int id) { TblDepartmentMaster result = _imasters.GetDepartmentByCriteria(id); return(Ok(result)); }