public int DeleteVendors(int key) { TblVendors vendors = dbContext.TblVendors.Where(x => x.VendorId == key).FirstOrDefault(); vendors.IsActive = false; dbContext.TblVendors.Update(vendors); return(dbContext.SaveChanges()); }
public int UpdateVendors(TblVendors tblVendors) { if (dbContext.TblVendors.Where(r => r.VendorName.ToUpper() == tblVendors.VendorName.ToUpper() && r.IsActive == true).Count() > 0) { return(-1); } tblVendors.IsActive = true; tblVendors.ModifiedBy = CurrentContext.EmployeeID; tblVendors.ModifiedDate = DateTime.Now; dbContext.Entry(tblVendors).State = EntityState.Modified; dbContext.TblVendors.Update(tblVendors); int result = dbContext.SaveChanges(); dbContext.Entry(tblVendors).State = EntityState.Detached; return(result); }
public int UpdateVendors(TblVendors tblVendors) { return(MastersDAL.UpdateVendors(tblVendors)); }
public int CreateVendors(TblVendors tblVendors) { return(MastersDAL.CreateVendors(tblVendors)); }
public IActionResult Vendors(int id, [FromBody] TblVendors tblVendors) { int result = _imasters.UpdateVendors(tblVendors); return(Ok(result)); }
public IActionResult Vendors(int id) { TblVendors result = _imasters.GetVendorsByCriteria(id); return(Ok(result)); }