public DELIVERY(int iD, DateTime arrivalDate, SUPPLIER supplierDelivery, string driverName)
{
ID = iD;
OrderDate = DateTime.Now;
ArrivalDate = arrivalDate;
supplierDelivery = SupplierDelivery;
DriverName = driverName;
_deliveryOrderList = new ObservableCollection <Classes.ORDER>();
}
private void UpdateSuppliers()
{
SqlConnection con = Database.DatabaseLocator.GenerateConnection.GenerateNewConnection();
SqlDataAdapter sda2 = new SqlDataAdapter("SELECT * From [SUPPLIER]", con);
DataTable dt = new DataTable();
sda2.Fill(dt);
con.Open();
ViewModels.ViewModelLocator.MainWindowViewModel.SupplierList.Clear();
for (int x = 0; x < dt.Rows.Count; x++)
{
Classes.SUPPLIER newSupplier = new Classes.SUPPLIER();
newSupplier.ID = Convert.ToInt16(dt.Rows[x]["ID"]);
newSupplier.SupplierName = dt.Rows[x]["SupplierName"].ToString();
newSupplier.SupplierAddress = dt.Rows[x]["SupplierAddress"].ToString();
newSupplier.SupplierDetails = dt.Rows[x]["SupplierDetails"].ToString();
ViewModels.ViewModelLocator.MainWindowViewModel.SupplierList.Add(newSupplier);
}
con.Close();
}
