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