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