private void updateGridBox() { tea01Entities2 db = new tea01Entities2(); listBox.Items.Clear(); int price = 0; foreach (var i in listView) { String res = db.Drinks.Find(i[0]).DrinkName; price += Convert.ToInt32(db.Drinks.Find(i[0]).Price); for (int iter = 1; iter < i.Count; iter++) { String topping = db.Toppings.Find(i[iter]).ToppingName; res += "+ " + topping; price += Convert.ToInt32(db.Toppings.Find(i[iter]).Price); } listBox.Items.Add(res); } lbPrice.Text = price.ToString() + " VNĐ"; }
private void gridView_CellClick(object sender, DataGridViewCellEventArgs e) { tea01Entities2 db = new tea01Entities2(); var drink = db.Drinks.Find(gridView.CurrentRow.Cells[0].Value.ToString()); txId.Text = drink.DrinkId; txName.Text = drink.DrinkName; txPrice.Text = drink.Price.ToString(); imgBox.Image = Image.FromFile(drink.Image); url = drink.Image; var drinkType = db.DrinkTypes.Find(drink.DrinkTypeId); int c = 0; foreach (var i in listBox.Items) { if (i.ToString() == drinkType.DrinkTypeName) { listBox.SetSelected(c, true); break; } c++; } }
private void filterStaff() { DateTime start = startStaff.Value; DateTime end = endStaff.Value; tea01Entities2 db = new tea01Entities2(); var query = (from bill in db.Set <Bill>() join staff in db.Set <Staff>() on bill.UserName equals staff.UserName where bill.OrderTimeStart >= start && bill.OrderTimeStart <= end select new { staff.FullName, bill.BillId, staff.UserName } into x group x by new { x.UserName, x.FullName } into y select new { Name = y.Key.FullName, Count = y.Count() }).OrderByDescending(i => i.Count); gridViewStaff.DataSource = query.ToList(); if (gridViewStaff.ColumnCount > 0) { gridViewStaff.Columns[1].Width = 100; gridViewStaff.Columns[0].HeaderText = "Tên "; gridViewStaff.Columns[1].HeaderText = "Số bills"; } }
private void loadFirstBill() { tea01Entities2 db = new tea01Entities2(); var tomorow = DateTime.Now.AddDays(1); gridViewBill.DataSource = db.Bills.Where(u => DbFunctions.TruncateTime(u.OrderTimeStart) == DbFunctions.TruncateTime(DateTime.Now)).OrderByDescending(i => i.Total).ToList(); if (gridViewBill.ColumnCount > 0) { for (int i = 0; i < gridViewBill.ColumnCount; i++) { if (i == 0 || i == 4) { gridViewBill.Columns[i].Visible = true; continue; } gridViewBill.Columns[i].Visible = false; } gridViewBill.Columns[0].HeaderText = "Mã hóa đơn"; gridViewBill.Columns[4].HeaderText = "Tổng tiền"; } var sum = db.Bills.Where(u => DbFunctions.TruncateTime(u.OrderTimeStart) == DbFunctions.TruncateTime(DateTime.Now)).Sum(i => i.Total); var count = db.Bills.Where(u => DbFunctions.TruncateTime(u.OrderTimeStart) == DbFunctions.TruncateTime(DateTime.Now)).ToList().Count; txCountBill.Text = count.ToString() + " hóa đơn"; txSumBill.Text = sum.ToString() + " VNĐ"; }
private void filterTopping() { tea01Entities2 db = new tea01Entities2(); DateTime start = startTopping.Value; DateTime end = endTopping.Value; var query = (from bill in db.Set <Bill>() join item in db.Set <Item>() on bill.BillId equals item.BillId join itemTopping in db.Set <ItemTopping>() on item.BillId equals itemTopping.BillId join topping in db.Set <Topping>() on itemTopping.ToppingId equals topping.ToppingId where bill.OrderTimeStart >= start && bill.OrderTimeStart <= end select new { topping.ToppingId, topping.ToppingName, topping.Price } into x group x by new { x.ToppingId, x.ToppingName, x.Price } into y select new { Topping = y.Key.ToppingName, Count = y.Count(), y.Key.Price }).OrderByDescending(i => i.Count); gridViewTopping.DataSource = query.ToList(); if (gridViewTopping.ColumnCount > 0) { gridViewTopping.Columns[1].Width = 50; gridViewTopping.Columns[0].HeaderText = "Tên topping"; gridViewTopping.Columns[1].HeaderText = "Tổng"; gridViewTopping.Columns[2].HeaderText = "Giá"; gridViewTopping.Columns[2].Width = 50; } if (gridViewTopping.RowCount > 0) { var sum = query.Sum(u => u.Price * u.Count); var count = query.Sum(u => u.Count); txSumTopping.Text = sum.ToString() + " VNĐ"; txCountTopping.Text = count.ToString() + " Topping"; } else { txSumTopping.Text = "0 VNĐ"; txCountTopping.Text = "0 Topping"; } }
private void filterBill() { tea01Entities2 db = new tea01Entities2(); DateTime start = startBill.Value; DateTime end = endBill.Value; gridViewBill.DataSource = db.Bills.Where(u => u.OrderTimeStart >= start && u.OrderTimeStart <= end).OrderByDescending(i => i.Total).ToList(); if (gridViewBill.ColumnCount > 0) { for (int i = 0; i < gridViewBill.ColumnCount; i++) { if (i == 0 || i == 4) { gridViewBill.Columns[i].Visible = true; continue; } gridViewBill.Columns[i].Visible = false; } gridViewBill.Columns[0].HeaderText = "Mã hóa đơn"; gridViewBill.Columns[4].HeaderText = "Tổng tiền"; } var sum = db.Bills.Where(u => u.OrderTimeStart >= start && u.OrderTimeStart <= end).Sum(i => i.Total); var count = db.Bills.Where(u => u.OrderTimeStart >= start && u.OrderTimeStart <= end).ToList().Count; txCountBill.Text = count.ToString() + " hóa đơn"; txSumBill.Text = sum.ToString() + " VNĐ"; }
private void btnSubmitDrink_Click(object sender, EventArgs e) { tea01Entities2 db = new tea01Entities2(); var drink = db.Drinks.Find(gridViewListDrink.CurrentRow.Cells[0].Value); //Clear drink.Drink_Resource.Clear(); db.SaveChanges(); foreach (var resource in listCheckbox) { if (resource.amount > 0 && resource.Checked == true) { var res = db.Resources.Find(resource.idItem); Drink_Resource drink_Resource = new Drink_Resource(); drink_Resource.DrinkId = drink.DrinkId; drink_Resource.ResourceId = res.ResourceId; drink_Resource.Amount = resource.amount; drink.Drink_Resource.Add(drink_Resource); db.SaveChanges(); } } MessageBox.Show("Đã cập nhật thành phần cho trà này"); }
private void bunifuButton13_Click(object sender, EventArgs e) { tea01Entities2 db = new tea01Entities2(); Staff staff = db.Staffs.Find(SignIn.username); Boolean flag = false; foreach (var i in staff.Permisions) { if (i.PermisionName == "Full" || i.PermisionName == "Admin") { //MessageBox.Show(i.PermisionName); flag = true; ManageBill manageBill = new ManageBill(); this.Hide(); manageBill.ShowDialog(); this.Close(); } } if (!flag) { MessageBox.Show("Hãy phấn đấu và bạn sẽ có quyền vào đây"); } }
private void bunifuButton8_Click(object sender, EventArgs e) { tea01Entities2 db = new tea01Entities2(); Staff staff = db.Staffs.Find(SignIn.username); Boolean flag = false; foreach (var i in staff.Permisions) { foreach (var j in i.PermisionDetails) { if (j.ActionName == "D") { //MessageBox.Show(j.ActionName); flag = true; ManageStaff manageStaff = new ManageStaff(); this.Hide(); manageStaff.ShowDialog(); this.Close(); } } } if (!flag) { MessageBox.Show("Hãy phấn đấu và bạn sẽ có quyền vào đây"); } }
private void btnSubmitTopping_Click(object sender, EventArgs e) { tea01Entities2 db = new tea01Entities2(); var topping = db.Toppings.Find(gridViewListTopping.CurrentRow.Cells[0].Value); //Clear topping.Topping_Resource.Clear(); db.SaveChanges(); foreach (var resource in listCheckbox) { if (resource.amount > 0 && resource.Checked == true) { var res = db.Resources.Find(resource.idItem); Topping_Resource topping_Resource = new Topping_Resource(); topping_Resource.ToppingId = topping.ToppingId; topping_Resource.ResourceId = res.ResourceId; topping_Resource.Amount = resource.amount; topping.Topping_Resource.Add(topping_Resource); db.SaveChanges(); } } MessageBox.Show("Đã cập nhật thành phần cho topping này"); }
private void btnSubmit_Click(object sender, EventArgs e) { if (txId.Text != "" && txName.Text != "" && txPrice.Text != "") { tea01Entities2 db = new tea01Entities2(); db.Drinks.AddOrUpdate(new Drink() { DrinkId = txId.Text, DrinkName = txName.Text, Price = Convert.ToInt32(txPrice.Text), Image = url, DrinkTypeId = idListBox[listBox.SelectedIndex] }); db.SaveChanges(); txId.Text = (db.Drinks.ToList().Count + 1).ToString(); txName.Text = ""; txPrice.Text = ""; updateGridView(); } }
private void loadTables() { tea01Entities2 db = new tea01Entities2(); var tables = db.TableSpaces.ToList(); listButtonTable = new List <buttonCustom>(); foreach (var i in tables) { buttonCustom btn = new buttonCustom(); btn.Text = i.TableName; btn.idItem = i.TableId; btn.Size = new Size(180, 80); Image image; btn.Click += (s, e) => { inforTable.Text = btn.Text; updateGridViewCustomerActive(i.TableId); currentIdTable = i.TableId; if (i.Status == 1) { btnSubmitTable.Text = "Xác nhận chọn: " + i.TableName; idTableChoose = i.TableId; } else { MessageBox.Show("Bàn này đã đủ người"); btnSubmitTable.Text = "Xác nhận chọn: "; idTableChoose = ""; } }; if (i.Status == 1) { image = Image.FromFile("D:\\TeaManagement\\Project\\bin\\Debug\\Images\\tableActive.png"); } else { image = Image.FromFile("D:\\TeaManagement\\Project\\bin\\Debug\\Images\\tableNotActive.png"); } btn.Image = image; btn.BackgroundImageLayout = ImageLayout.Stretch; /*btn.ImageAlign = ContentAlignment.MiddleRight; * btn.TextAlign = ContentAlignment.MiddleLeft; */ listButtonTable.Add(btn); } panel.Controls.Clear(); foreach (buttonCustom i in listButtonTable) { panel.Controls.Add(i); } }
private void loadFirstTea() { tea01Entities2 db = new tea01Entities2(); var query = (from drink in db.Set <Drink>() join item in db.Set <Item>() on drink.DrinkId equals item.DrinkId join bill in db.Set <Bill>() on item.BillId equals bill.BillId where DbFunctions.TruncateTime(bill.OrderTimeStart) == DbFunctions.TruncateTime(DateTime.Now) select new { drink } into x group x by new { x.drink.DrinkId, x.drink.DrinkName, x.drink.Price } into y select new { Drink = y.Key.DrinkName, Count = y.Count(), y.Key.Price }).OrderByDescending(i => i.Count); // var query = from drink in db.Set<Drink>() join item in db.Set<Item>() on drink.DrinkId equals item.DrinkId join bill in db.Set<Bill>() on item.BillId equals bill.BillId select new { drink }; var res = query.Select(u => new { u.Drink, u.Count, u.Price }); gridViewTea.DataSource = res.ToList(); if (gridViewTea.ColumnCount > 0) { gridViewTea.Columns[1].Width = 50; gridViewTea.Columns[0].HeaderText = "Tên trà"; gridViewTea.Columns[1].HeaderText = "Tổng"; gridViewTea.Columns[2].Width = 50; gridViewTea.Columns[2].HeaderText = "Giá"; } if (gridViewTea.RowCount > 0) { var sum = res.Sum(u => u.Price * u.Count); var count = res.Sum(u => u.Count); txSumTea.Text = sum.ToString() + " VNĐ"; txCountTea.Text = count.ToString() + " Trà"; } else { txSumTea.Text = "0 VNĐ"; txCountTea.Text = "0 Trà"; } }
private void txVoucher_KeyPress(object sender, KeyPressEventArgs e) { if (e.KeyChar == (char)Keys.Enter) { tea01Entities2 db = new tea01Entities2(); var voucher = db.Vouchers.Find(txVoucher.Text); if (voucher == null) { MessageBox.Show("Không tồn tại voucher"); txVoucher.Text = ""; } else { if (voucher.dateStart <= DateTime.Now && voucher.dateEnd >= DateTime.Now) { int sub = Convert.ToInt32(sumRaw.Text.Split(' ')[0]) * ((int)voucher.ratio) / 100; sumSub.Text = sub.ToString() + " VNĐ"; sumRes.Text = (Convert.ToInt32(sumRaw.Text.Split(' ')[0]) - Convert.ToInt32(sumSub.Text.Split(' ')[0])).ToString() + " VNĐ"; } else { sumSub.Text = "0 VNĐ"; sumRes.Text = (Convert.ToInt32(sumRaw.Text.Split(' ')[0]) - Convert.ToInt32(sumSub.Text.Split(' ')[0])).ToString() + " VNĐ"; MessageBox.Show("Voucher không khả dụng tại thời điểm này"); } } } }
private void updateGridBox() { int price = 0; tea01Entities2 db = new tea01Entities2(); foreach (var i in Home.listView) { String res = db.Drinks.Find(i[0]).DrinkName; price += Convert.ToInt32(db.Drinks.Find(i[0]).Price); int currentPrice = Convert.ToInt32(db.Drinks.Find(i[0]).Price); for (int iter = 1; iter < i.Count; iter++) { String topping = db.Toppings.Find(i[iter]).ToppingName; res += "+ " + topping; price += Convert.ToInt32(db.Toppings.Find(i[iter]).Price); currentPrice += Convert.ToInt32(db.Toppings.Find(i[iter]).Price); } listBox.Items.Add(res + ": " + currentPrice.ToString() + "VNĐ"); } sumRaw.Text = price.ToString() + " VNĐ"; sumSub.Text = "0 VNĐ"; sumRes.Text = (Convert.ToInt32(sumRaw.Text.Split(' ')[0]) - Convert.ToInt32(sumSub.Text.Split(' ')[0])).ToString() + " VNĐ"; }
private void loadPanel() { tea01Entities2 db = new tea01Entities2(); var resources = db.Resources; panel.Controls.Clear(); panel.FlowDirection = FlowDirection.LeftToRight; listCheckbox = new List <checkBoxBunifuCustom>(); foreach (var resource in resources) { checkBoxBunifuCustom checkBox = new checkBoxBunifuCustom(); buttonBunifuCustom button = new buttonBunifuCustom(); Label label = new Label(); FlowLayoutPanel subPanel = new FlowLayoutPanel(); label.Text = "0"; checkBox.idItem = resource.ResourceId; button.idItem = resource.ResourceId; button.Text = resource.ResourceName; button.Size = new Size(193, 30); checkBox.Checked = false; checkBox.amount = 0; checkBox.MouseClick += (s, e) => { if (checkBox.Checked == true) { checkBox.Checked = true; string value = "0"; if (DialogCustom.InputBox("Input", "Nhập vào số lượng:", ref value) == DialogResult.OK) { checkBox.amount = Convert.ToInt32(value); label.Text = (checkBox.amount).ToString(); if (checkBox.amount == 0) { checkBox.Checked = false; } } } else { checkBox.Checked = false; checkBox.amount = 0; label.Text = (checkBox.amount).ToString(); } }; listCheckbox.Add(checkBox); subPanel.FlowDirection = FlowDirection.LeftToRight; subPanel.Controls.Add(checkBox); subPanel.Controls.Add(label); subPanel.Controls.Add(button); panel.Controls.Add(subPanel); } }
private void updateGridView() { tea01Entities2 db = new tea01Entities2(); txId.Text = (db.TableSpaces.ToList().Count + 1).ToString(); gridView.DataSource = db.TableSpaces.Select(u => new { u.TableId, u.TableName }).ToList(); gridView.Columns[1].HeaderText = "Tên bàn khả dụng"; gridView.Columns[0].Visible = false; }
private void gridView_CellClick(object sender, DataGridViewCellEventArgs e) { tea01Entities2 db = new tea01Entities2(); txCode.Text = gridView.CurrentRow.Cells[0].Value.ToString(); txRatio.Text = gridView.CurrentRow.Cells[3].Value.ToString(); start.Value = (DateTime)db.Vouchers.Find(txCode.Text).dateStart; end.Value = (DateTime)db.Vouchers.Find(txCode.Text).dateEnd; }
private void updateGridView() { tea01Entities2 db = new tea01Entities2(); gridView.DataSource = db.DrinkTypes.Select(x => new { x.DrinkTypeId, x.DrinkTypeName }).ToList(); gridView.Columns[0].HeaderText = "ID"; gridView.Columns[1].HeaderText = "Tên loại trà"; }
private void gridView_CellClick(object sender, DataGridViewCellEventArgs e) { tea01Entities2 db = new tea01Entities2(); var topping = db.Toppings.Find(gridView.CurrentRow.Cells[0].Value.ToString()); txId.Text = topping.ToppingId; txName.Text = topping.ToppingName; txPrice.Text = topping.Price.ToString(); }
private void ManageDrinkType_Load(object sender, EventArgs e) { updateGridView(); updateCheckList(); tea01Entities2 db = new tea01Entities2(); int count = db.DrinkTypes.ToList().Count; txID.Text = (count + 1).ToString(); }
private void updateGridView() { tea01Entities2 db = new tea01Entities2(); gridView.DataSource = db.Vouchers.ToList(); gridView.Columns[0].HeaderText = "Code"; gridView.Columns[1].HeaderText = "Bắt đầu"; gridView.Columns[2].HeaderText = "Kết thúc"; gridView.Columns[3].HeaderText = "% giảm giá"; }
public ShowAddDrink() { InitializeComponent(); tea01Entities2 db = new tea01Entities2(); idListBox = new string[db.DrinkTypes.ToList().Count + 5]; count = 0; txId.Text = (db.Drinks.ToList().Count + 1).ToString(); }
private void updatePanelTopping() { tea01Entities2 db = new tea01Entities2(); var toppings = db.Toppings.ToList(); Random rand = new Random(); Color[] c = { Color.Red, Color.Blue, Color.Green, Color.Cyan, Color.Magenta }; listButtonTopping = new List <buttonCustom>(); foreach (var i in toppings) { //Bunifu.UI.WinForms.BunifuButton.BunifuButton btn = new Bunifu.UI.WinForms.BunifuButton.BunifuButton(); buttonCustom btn = new buttonCustom(); btn.Text = i.ToppingName + " " + i.Price + "đ"; btn.idItem = i.ToppingId; btn.Size = new Size(120, 80); Image image; Label lb = new Label(); lb.Size = new Size(20, 20); lb.Text = "0"; btn.Click += (s, e) => { currentTopping = btn; currentLabelTopping = lb; toppingClick(); }; btn.BackColor = c[rand.Next(0, c.Length)]; btn.ForeColor = Color.White; btn.Font = new Font(btn.Font.FontFamily, 10); btn.Font = new Font(btn.Font, FontStyle.Bold); btn.ForeColorChanged += (s, e) => { btn.Font = new Font(btn.Font, FontStyle.Bold); }; btn.BackgroundImageLayout = ImageLayout.Stretch; /*btn.ImageAlign = ContentAlignment.MiddleRight; * btn.TextAlign = ContentAlignment.MiddleLeft; */ listButtonTopping.Add(btn); listLabelTopping.Add(lb); } panelTopping.Controls.Clear(); for (int i = 0; i < listButtonTopping.Count; i++) { panelTopping.Controls.Add(listButtonTopping[i]); panelTopping.Controls.Add(listLabelTopping[i]); } }
private void updateComboBox() { tea01Entities2 db = new tea01Entities2(); foreach (var i in db.DrinkTypes) { comboBox.Items.Add(i.DrinkTypeName + "-" + i.DrinkTypeId); } comboBox.Items.Add("Tất cả"); }
private void updateGridView() { tea01Entities2 db = new tea01Entities2(); var res = db.Staffs.Select(x => new { x.FullName, x.UserName }).ToList(); gridView.DataSource = res; gridView.Columns[0].HeaderText = "Họ và tên"; gridView.Columns[1].HeaderText = "Tên người dùng"; }
private void Permision_Load(object sender, EventArgs e) { updateGridView(); reloadUncheck(); reloadUncheck2(); tea01Entities2 db = new tea01Entities2(); var listPer = db.Permisions.ToList(); listPermistion = listPer; count = listPer.Count; }
private void updateCheckList() { tea01Entities2 db = new tea01Entities2(); var drinks = db.Drinks; int c = 0; foreach (var i in drinks) { checkList.Items.Add(i.DrinkName); } }
private void updateGridViewListResource() { tea01Entities2 db = new tea01Entities2(); gridViewListResource.DataSource = db.Resources.ToList(); gridViewListResource.Columns[0].Visible = false; gridViewListResource.Columns[2].Visible = false; gridViewListResource.Columns[3].Visible = false; gridViewListResource.Columns[4].Visible = false; gridViewListResource.Columns[1].HeaderText = "Tên nguyên liệu"; }
private void updatePanelTea() { tea01Entities2 db = new tea01Entities2(); var drinks = db.Drinks.ToList(); listButtonTea = new List <buttonCustom>(); foreach (var i in drinks) { //Bunifu.UI.WinForms.BunifuButton.BunifuButton btn = new Bunifu.UI.WinForms.BunifuButton.BunifuButton(); buttonCustom btn = new buttonCustom(); btn.Text = i.DrinkName + " " + i.Price.ToString() + "đ"; btn.idItem = i.DrinkId; btn.Size = new Size(120, 80); Image image; Label lb = new Label(); lb.Size = new Size(20, 20); lb.Text = "0"; btn.Click += (s, e) => { //MessageBox.Show(btn.idItem); currentTea = btn; currentLabel = lb; teaClick(); }; image = Image.FromFile(i.Image); btn.BackgroundImage = image; btn.ForeColor = Color.White; btn.Font = new Font(btn.Font.FontFamily, 10); btn.Font = new Font(btn.Font, FontStyle.Bold); btn.ForeColorChanged += (s, e) => { btn.Font = new Font(btn.Font, FontStyle.Bold); }; btn.BackgroundImageLayout = ImageLayout.Stretch; /*btn.ImageAlign = ContentAlignment.MiddleRight; * btn.TextAlign = ContentAlignment.MiddleLeft; */ listButtonTea.Add(btn); listLabelTea.Add(lb); } panelTea.Controls.Clear(); for (int i = 0; i < listButtonTea.Count; i++) { panelTea.Controls.Add(listButtonTea[i]); panelTea.Controls.Add(listLabelTea[i]); } }