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