public string DeleteSupplier(string SupplierCode) { string Result = "Success"; try { Purchase_Order_Processing_System.SUPPLIER _SUPPLIER = poDb.SUPPLIERs.Where(x => x.SUPLNO == SupplierCode).ToList().FirstOrDefault(); poDb.SUPPLIERs.Remove(_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); }