public int DeleteVendorContacts(int key)
{
TblVendorContacts vendorContacts = dbContext.TblVendorContacts.Where(x => x.ContactId == key).FirstOrDefault();
vendorContacts.IsActive = false;
dbContext.TblVendorContacts.Update(vendorContacts);
return(dbContext.SaveChanges());
}
public int UpdateVendorContacts(TblVendorContacts tblVendorContacts)
{
if (dbContext.TblVendorContacts.AsNoTracking().Where(r => r.ContactPerson.ToUpper() == tblVendorContacts.ContactPerson.ToUpper() && r.IsActive == true).Count() > 0)
{
return(-1);
}
tblVendorContacts.IsActive = true;
dbContext.Entry(tblVendorContacts).State = EntityState.Modified;
dbContext.TblVendorContacts.Update(tblVendorContacts);
int result = dbContext.SaveChanges();
dbContext.Entry(tblVendorContacts).State = EntityState.Detached;
return(result);
}
public int CreateVendorContacts(TblVendorContacts tblVendorContacts)
{
if (dbContext.TblVendorContacts.Where(r => r.ContactPerson.ToUpper() == tblVendorContacts.ContactPerson.ToUpper() && r.IsActive == true).Count() > 0)
{
return(-1);
}
tblVendorContacts.IsActive = true;
tblVendorContacts.ContactId = 0;
dbContext.Entry(tblVendorContacts).State = EntityState.Added;
dbContext.TblVendorContacts.Add(tblVendorContacts);
int result = dbContext.SaveChanges();
dbContext.Entry(tblVendorContacts).State = EntityState.Detached;
return(result);
}
public int UpdateVendorContacts(TblVendorContacts tblVendorContacts)
{
return(MastersDAL.UpdateVendorContacts(tblVendorContacts));
}
public IActionResult VendorContacts(int id, [FromBody] TblVendorContacts tblVendorContacts)
{
int result = _imasters.UpdateVendorContacts(tblVendorContacts);
return(Ok(result));
}
