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