public void UpdateSupplier(SupplierModel supplier)
{
var dbSupplier = new SUPPLIER
{
SUPLADDR = supplier.Address,
SUPLNAME = supplier.Name,
SUPLNO = supplier.Id
};
dbContext.Entry(dbSupplier).State = EntityState.Modified;
dbContext.SaveChanges();
}
/// <summary>
/// Add new supplier
/// </summary>
/// <param name="supplier"></param>
/// <returns></returns>
public string CreateSupplier(SupplierModel supplier)
{
var dbSupplier = new SUPPLIER
{
SUPLADDR = supplier.Address,
SUPLNAME = supplier.Name,
SUPLNO = supplier.Id
};
dbContext.SUPPLIER.Add(dbSupplier);
dbContext.SaveChanges();
return(dbSupplier.SUPLNO);
}
public string AddSupplier(SUPPLIER Supplier)
{
string Result = "Success";
try
{
poDb.SUPPLIERs.Add(Supplier);
poDb.SaveChanges();
}
catch (Exception ex)
{
Result = ex.Message;
}
return(Result);
}
public string UpdateSupplier(SUPPLIER Supplier)
{
string Result = "Success";
try
{
Purchase_Order_Processing_System.SUPPLIER _supplier = poDb.SUPPLIERs.Where(x => x.SUPLNO == Supplier.SUPLNO).ToList().FirstOrDefault();
_supplier.SUPLADDR = Supplier.SUPLADDR;
_supplier.SUPLNAME = Supplier.SUPLNAME;
poDb.SaveChanges();
}
catch (Exception ex)
{
Result = ex.Message;
}
return(Result);
}