示例#1
0
        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());
        }
示例#2
0
        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);
        }
示例#3
0
 public int UpdateDepartment(TblDepartmentMaster tblDepartment)
 {
     return(MastersDAL.UpdateDepartment(tblDepartment));
 }
示例#4
0
 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));
        }