private static bool CanDeleteSupplierType(String supplierTypeCode) { try { using (NewcourtEntities ctx = new NewcourtEntities()) { // Check Suppliers List <Data_Supplier> supplier = Data_Supplier.GetSuppliersBySupplierType(supplierTypeCode); if (supplier.Count >= 1) { return(false); } } return(true); } catch (Exception ex) { throw ex; } }
public static void SaveSupplier(Data_Supplier supplier) { try { using (NewcourtEntities ctx = new NewcourtEntities()) { Suppliers record = ctx.Suppliers.FirstOrDefault(a => a.SupplierID == supplier.SupplierID); if (record != null) { record.SupplierTypes = ctx.SupplierTypes.FirstOrDefault(a => a.SupplierTypeCode == supplier.SupplierTypeCode); record.FirstName = supplier.FirstName; record.Surname = supplier.Surname; record.Address1 = supplier.Address1; record.Address2 = supplier.Address2; record.Address3 = supplier.Address3; record.Address4 = supplier.Address4; record.Address5 = supplier.Address5; record.Phone = supplier.Phone; record.Mobile = supplier.Mobile; record.PPSVat = supplier.PPSVat; record.BankName = supplier.BankName; record.BankAddress1 = supplier.BankAddress1; record.BankAddress2 = supplier.BankAddress2; record.BankAddress3 = supplier.BankAddress3; record.BankAddress4 = supplier.BankAddress4; record.BankAddress5 = supplier.BankAddress5; record.BankAccNumber = supplier.BankAccNumber; record.SortCode = supplier.SortCode; record.BIC = supplier.BIC; record.IBAN = supplier.IBAN; } else { ctx.Suppliers.Add(new Suppliers() { SupplierTypes = ctx.SupplierTypes.FirstOrDefault(a => a.SupplierTypeCode == supplier.SupplierTypeCode), FirstName = supplier.FirstName, Surname = supplier.Surname, Address1 = supplier.Address1, Address2 = supplier.Address2, Address3 = supplier.Address3, Address4 = supplier.Address4, Address5 = supplier.Address5, Phone = supplier.Phone, Mobile = supplier.Mobile, PPSVat = supplier.PPSVat, BankName = supplier.BankName, BankAddress1 = supplier.BankAddress1, BankAddress2 = supplier.BankAddress2, BankAddress3 = supplier.BankAddress3, BankAddress4 = supplier.BankAddress4, BankAddress5 = supplier.BankAddress5, BankAccNumber = supplier.BankAccNumber, SortCode = supplier.SortCode, BIC = supplier.BIC, IBAN = supplier.IBAN }); } ctx.SaveChanges(); } } catch (Exception ex) { throw ex; } }