private void LoadData() { menuItems = new List <MenuBeverage>(); menuItemsResult = new List <MenuBeverage>(); BUS_Beverage busBev = new BUS_Beverage(); DataTable BevsData = busBev.getAllBeverage(); foreach (DataRow row in BevsData.Rows) { string id = row["BeverageID"].ToString(); string name = row["BeverageName"].ToString(); int price = Int32.Parse(row["Price"].ToString()); byte[] image = (byte[])row["Link"]; bool isOutOfStock; if (row["IsOutOfStock"].ToString() == "0") { isOutOfStock = false; } else { isOutOfStock = true; } menuItems.Add(new MenuBeverage(id, name, price, isOutOfStock, image)); menuItemsResult.Add(new MenuBeverage(id, name, price, isOutOfStock, image)); menuItemsDisplay = menuItemsResult; } dgMenu.ItemsSource = menuItemsDisplay; dgMenu.Items.Refresh(); }
public MenuList() { InitializeComponent(); dgMenu.LoadingRow += new EventHandler <DataGridRowEventArgs>(datagrid_LoadingRow); bus = new BUS_Beverage(); Loaded += LoadData; }
private void btnConfirm_Click(object sender, RoutedEventArgs e) { BUS_Beverage busBever = new BUS_Beverage(); bool flag = true; for (int i = 0; i < menuItemsResult.Count; i++) { if (menuItemsResult[i].isOutOfStock != menuItems[i].isOutOfStock) { if (!busBever.ChangeIsOutOfStockValue(menuItemsResult[i].id, menuItemsResult[i].isOutOfStock)) { flag = false; } } } if (flag) { MessageBox.Show("Đã cập nhật tình trạng các món."); Window.GetWindow(this).Close(); } else { MessageBox.Show("Đã xảy ra lỗi trong quá trình cập nhật."); } }
private void LoadProfitChart() { BUS_Beverage busBev = new BUS_Beverage(); DataTable bevProfitData = busBev.GetBeverageOrderBySellIncome(start, end); int countValueProfit = bevProfitData.Rows.Count; LabelsProfitChart = new List <string>(); ChartValues <int> valuesProfit = new ChartValues <int>(); for (int i = 0; i < countValueProfit; i++) { valuesProfit.Add(Int32.Parse(bevProfitData.Rows[i]["SellIncome"].ToString())); LabelsProfitChart.Add(bevProfitData.Rows[i]["BeverageName"].ToString()); } ProfitChart = new SeriesCollection { new RowSeries { Title = "", Values = valuesProfit, Fill = Brushes.Orange } }; FormatterProfitChart = value => value.ToString("N", CultureInfo.CreateSpecificCulture("en-US")); profitChart.Height = (LabelsProfitChart.Count + 20) * 20; //Number of labels * 100 profitChart.Series = ProfitChart; profitChart.Update(); }
private void LoadSaleChart() { BUS_Beverage busBev = new BUS_Beverage(); DataTable bevData = busBev.GetBeverageOrderBySellAmount(start, end); int countValue = bevData.Rows.Count; Labels = new List <string>(); ChartValues <int> values = new ChartValues <int>(); for (int i = 0; i < countValue; i++) { values.Add(Int32.Parse(bevData.Rows[i]["SellAmount"].ToString())); Labels.Add(bevData.Rows[i]["BeverageName"].ToString()); } SaleChart = new SeriesCollection { new RowSeries { Title = "", Values = values, Fill = Brushes.Orange } }; Formatter = value => value.ToString("N"); saleChart.Height = (Labels.Count + 20) * 20; saleChart.Series = SaleChart; saleChart.Update(); }
public MenuList(MainWindow mainWindow) { InitializeComponent(); dgMenu.LoadingRow += new EventHandler <DataGridRowEventArgs>(datagrid_LoadingRow); bus = new BUS_Beverage(); currentNumpage = 1; this._context = mainWindow; Loaded += LoadData; }
public PopupEditMenu(string name, string type, string price, string id, byte[] imageLink, MainWindow context) { InitializeComponent(); bus = new BUS_Beverage(); tbName.Text = name; tbPrice.Text = price; cbBeverageType.ItemsSource = bus.getBeverageType(); cbBeverageType.SelectedItem = type; try { image.Source = ToImageSource(ConvertByteArrayToImage(imageLink)); imageBytes = imageLink; } catch (Exception) { } ID = id; window = context; }
public void LoadData() { tblockUsername.Text = user; newReceiptID = ""; menuItems = new List <MenuBeverage>(); menuItemsDisplay = new List <MenuBeverage>(); billItems = new List <BillItem>(); total = 0; received = 0; discount = 0; tblockChange.Text = "0 VNĐ"; tblockDiscount.Text = "0"; tblockDiscountAmount.Text = "0 VNĐ"; tblockPayAmount.Text = "0 VNĐ"; tblockTotal.Text = "0 VNĐ"; tboxAmountReceived.Text = "0"; BUS_Beverage busBev = new BUS_Beverage(); DataTable BevsData = busBev.getAllBeverage(); foreach (DataRow row in BevsData.Rows) { string id = row["BeverageID"].ToString(); string name = row["BeverageName"].ToString(); string type = row["BeverageTypeName"].ToString(); int price = Int32.Parse(row["Price"].ToString()); byte[] image = (byte[])row["Link"]; bool isOutOfStock; if (row["IsOutOfStock"].ToString() == "0") { isOutOfStock = false; } else { isOutOfStock = true; } menuItems.Add(new MenuBeverage(id, name, type, price, isOutOfStock, image)); menuItemsDisplay.Add(new MenuBeverage(id, name, type, price, isOutOfStock, image)); } filterButtons = new List <FilterButton>(); filterButtons.Add(new FilterButton("Tất cả", "Tất cả")); DataTable BevTypesData = busBev.GetBeverageTypeInfo(); foreach (DataRow row in BevTypesData.Rows) { string id = row["BeverageTypeID"].ToString(); string name = row["BeverageTypeName"].ToString(); filterButtons.Add(new FilterButton(id, name)); } ListViewMenu.ItemsSource = menuItemsDisplay; ListViewMenu.Items.Refresh(); dgBill.ItemsSource = billItems; dgBill.Items.Refresh(); ListFilterButton.ItemsSource = filterButtons; ListFilterButton.Items.Refresh(); BUS_Discount busDiscount = new BUS_Discount(); DTO_Discount curDiscount = busDiscount.GetCurrentDiscount(); tblockDiscount.Text = curDiscount.DiscountValue.ToString() + " %"; discount = curDiscount.DiscountValue; }