/// <summary> /// Helper method to clear local and remove and create the database again /// </summary> private void CleanDatabaseAndEntities() { //Clear all the records to prevent exceptions context.Categories.Local.Clear(); context.Businesses.Local.Clear(); context.Products.Local.Clear(); context.Orders.Local.Clear(); context.SaveChanges(); context.Database.Delete(); context.Database.Create(); context.SaveChanges(); }
/// <summary> /// Load the data to the list box /// </summary> private void ReloadListBoxData() { context.SaveChanges(); context.Products.Load(); // We force the refresh of the listbox since without reassigning the data source // the listBox data doesn't change listBoxProduct.DataSource = null; listBoxProduct.DataSource = context.Products.Local.Where(p => p.Business == business).ToArray(); }
/// <summary> /// Load the data to the list box /// </summary> private void ReloadListBoxData() { context.SaveChanges(); context.Businesses.Load(); // We force the refresh of the listbox since without reassigning the data source // the listBox data doesn't change listBoxBusinessName.DataSource = null; listBoxBusinessName.DataSource = context.Businesses.Local.ToBindingList(); }
private void ShopForm_Load(object sender, EventArgs e) { context.SaveChanges(); context.Products.Load(); context.Businesses.Load(); context.Categories.Load(); order = new Order { TotalPrice = 0, Business = business }; //Display all business expect the business who is buying in the filters comboBoxBusiness.DataSource = context.Businesses.Local.Where(b => b != business).ToArray(); comboBoxCategory.DataSource = context.Categories.Local.ToBindingList(); //Diplay which business is shopping groupBoxShop.Text = $"{business.Name} is shopping"; ResetControlsToDefault(); MapOrderToForm(); }
/// <summary> /// Display the business' orders /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void OrdersForm_Load(object sender, EventArgs e) { context.SaveChanges(); context.Products.Load(); context.Orders.Load(); groupBoxOrders.Text = $"{business.Name} Orders"; var ordersFiltered = context.Orders.Local.Where(o => o.Business == business).ToArray(); FormUtils.InitalizeDataGridView(dataGridViewOrders, ordersFiltered, false, "Id", "BusinessId", "Products", "Business", "OrderDate", "TotalPrice"); labelOrdersCountData.Text = ordersFiltered.Count().ToString(); dataGridViewOrders.SelectionChanged += DataGridViewOrders_SelectionChanged; }