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