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