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 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 btnSubmit_Click(object sender, EventArgs e) { tea01Entities2 db = new tea01Entities2(); Bill bill = db.Bills.Find(gridView.CurrentRow.Cells[0].Value); if (MessageBox.Show("Xóa hóa đơn " + bill.BillId + " ?", "Message", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes) { db.Bills.Remove(bill); db.SaveChanges(); MessageBox.Show("Đã xóa"); } }
private void btnDelete_Click(object sender, EventArgs e) { if (MessageBox.Show("Đồng ý xóa " + gridView.CurrentRow.Cells[1].Value.ToString(), "Message", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes) { String idCurrent = gridView.CurrentRow.Cells[0].Value.ToString(); tea01Entities2 db = new tea01Entities2(); db.DrinkTypes.Remove(db.DrinkTypes.Find(idCurrent)); db.SaveChanges(); updateGridView(); } }
private void btnDelete_Click(object sender, EventArgs e) { tea01Entities2 db = new tea01Entities2(); Staff staff = db.Staffs.Find(gridViewStaff.CurrentRow.Cells[0].Value); if (MessageBox.Show("Xóa nhân viên " + staff.FullName + " ?", "Message", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes) { staff.DayOf = DateTime.Now; db.SaveChanges(); MessageBox.Show("Đã xóa"); updateGridViewStaff(); } }
private void bunifuFlatButton2_Click(object sender, EventArgs e) { if (MessageBox.Show("Yes or no", "Bạn có chắc chắn muốn xóa voucher này ?", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes) { tea01Entities2 db = new tea01Entities2(); txCode.Text = gridView.CurrentRow.Cells[0].Value.ToString(); var tmp = db.Vouchers.Find(txCode.Text); db.Vouchers.Remove(tmp); db.SaveChanges(); updateGridView(); } }
private void bunifuFlatButton1_Click(object sender, EventArgs e) { tea01Entities2 db = new tea01Entities2(); if (MessageBox.Show("Xác nhận khách hàng " + gridViewCustomerActice.CurrentRow.Cells[1].Value + " đã về", "Message", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes) { var bill = db.Bills.Find(gridViewCustomerActice.CurrentRow.Cells[4].Value); bill.OrderTimeEnd = DateTime.Now; db.SaveChanges(); updateGridViewCustomerActive(currentIdTable); loadTables(); } }
private void z(object sender, EventArgs e) { tea01Entities2 db = new tea01Entities2(); if (txAmountResource.Text != "" && txIdResource.Text != "" && txNameResource.Text != "") { db.Resources.AddOrUpdate(new Resource() { ResourceId = txIdResource.Text, ResourceName = txNameResource.Text, Amount = Convert.ToInt32(txAmountResource.Text) }); db.SaveChanges(); updateGridViewListResource(); MessageBox.Show("Đã cập nhật cơ sở dữ liệu"); } }
private void btnSubmit_Click(object sender, EventArgs e) { if (txId.Text != "" && txName.Text != "") { tea01Entities2 db = new tea01Entities2(); db.TableSpaces.AddOrUpdate(new TableSpace() { TableId = txId.Text, TableName = txName.Text, Status = 1 }); db.SaveChanges(); updateGridView(); loadTables(); txName.Text = ""; } }
private void bunifuButton7_Click(object sender, EventArgs e) { if (phone.Text.Length == 10 && name.Text != "" && address.Text != "") { tea01Entities2 db = new tea01Entities2(); db.Customers.AddOrUpdate(new Customer() { PhoneNumber = phone.Text, FullName = name.Text, Address = address.Text, Level = 0 }); db.SaveChanges(); MessageBox.Show("Đã cập nhật vào cơ sở dữ liệu"); } }
private void btnUpdate_Click(object sender, EventArgs e) { String idCurrent = gridView.CurrentRow.Cells[0].Value.ToString(); tea01Entities2 db = new tea01Entities2(); var drinks = db.Drinks; int c = 0; foreach (var i in drinks.ToList()) { if (checkList.GetItemCheckState(c) == CheckState.Checked) { i.DrinkTypeId = idCurrent; db.SaveChanges(); } c++; } }
private void btnAdd_Click(object sender, EventArgs e) { if (txID.Text != "" && txName.Text != "") { tea01Entities2 db = new tea01Entities2(); int count = db.DrinkTypes.ToList().Count; db.DrinkTypes.Add(new DrinkType() { DrinkTypeId = (++count).ToString(), DrinkTypeName = txName.Text }); db.SaveChanges(); updateGridView(); txName.Text = ""; txID.Text = (count + 1).ToString(); } }
private void bunifuFlatButton1_Click(object sender, EventArgs e) { if (txCode.Text != "" && txRatio.Text != "") { tea01Entities2 db = new tea01Entities2(); db.Vouchers.AddOrUpdate(new Voucher() { Code = txCode.Text, dateStart = (DateTime)start.Value, dateEnd = end.Value, ratio = Convert.ToInt32(txRatio.Text) }); db.SaveChanges(); MessageBox.Show("Đã cập nhật"); updateGridView(); } }
private void btnSubmit_Click(object sender, EventArgs e) { if (txId.Text != "" && txName.Text != "" && txPrice.Text != "") { tea01Entities2 db = new tea01Entities2(); db.Toppings.AddOrUpdate(new Topping() { ToppingId = txId.Text, ToppingName = txName.Text, Price = Convert.ToInt32(txPrice.Text), }); db.SaveChanges(); txId.Text = (db.Toppings.ToList().Count + 1).ToString(); txName.Text = ""; txPrice.Text = ""; updateGridView(); } }
private void btnSubmit_Click(object sender, EventArgs e) { //tea01Entities2 db = new tea01Entities2(); /* * for (int i = 0; i < checkedListBox1.Items.Count; i++) * { * if (checkedListBox1.GetItemCheckState(i) == CheckState.Checked) * { * MessageBox.Show(checkedListBox1.Items[i].ToString()); * * // var permision = db.Permisions.Where(u=>u.PermisionName == checkedListBox1.Items[i].ToString()).Select(u=>u).First(); * using (var context = new tea01Entities2()) * { * Staff userCurrent = context.Staffs.Find(gridView.CurrentRow.Cells[1].Value.ToString()); * userCurrent.Permisions.Add(new Permision() * { * PermisionID = (++count).ToString(), * PermisionName = checkedListBox1.Items[i].ToString() * }); * * context.SaveChanges(); * * } * } * } */ tea01Entities2 db = new tea01Entities2(); Staff userCurrent = db.Staffs.Find(gridView.CurrentRow.Cells[1].Value.ToString()); for (int i = 0; i < userCurrent.Permisions.Count; i++) { var rm = db.Permisions.Find(userCurrent.Permisions.ToList()[i].PermisionID); userCurrent.Permisions.Remove(userCurrent.Permisions.ToList()[i]); // db.Permisions.Remove(rm); } string permisionName = ""; if (checkFull.Checked) { permisionName = "Full"; } else if (checkCreate.Checked) { permisionName = "Create"; } else if (checkEdit.Checked) { permisionName = "Edit"; } else if (checkView.Checked) { permisionName = "View"; } else if (checkAdmin.Checked) { permisionName = "Admin"; } else { permisionName = "Custom"; } Permision permision = new Permision() { PermisionID = (++count).ToString(), PermisionName = permisionName }; userCurrent.Permisions.Add(permision); db.SaveChanges(); if (checkXem.Checked) { int count = db.PermisionDetails.ToList().Count; permision.PermisionDetails.Add(new PermisionDetail() { PermisionDetailId = (++count).ToString(), ActionName = "V" }); } db.SaveChanges(); if (checkXoa.Checked) { int count = db.PermisionDetails.ToList().Count; permision.PermisionDetails.Add(new PermisionDetail() { PermisionDetailId = (++count).ToString(), ActionName = "D" }); } db.SaveChanges(); if (checkSua.Checked) { int count = db.PermisionDetails.ToList().Count; permision.PermisionDetails.Add(new PermisionDetail() { PermisionDetailId = (++count).ToString(), ActionName = "E" }); } db.SaveChanges(); if (checkThem.Checked) { int count = db.PermisionDetails.ToList().Count; permision.PermisionDetails.Add(new PermisionDetail() { PermisionDetailId = (++count).ToString(), ActionName = "C" }); } db.SaveChanges(); /* * var listPer = userCurrent.Permisions.ToList(); * * foreach (var i in listPer) * { * i.PermisionDetails.remove(); * } */ db.SaveChanges(); MessageBox.Show("Đã cập nhật quyền cho nhân viên này"); }
private void bunifuFlatButton2_Click(object sender, EventArgs e) { tea01Entities2 db = new tea01Entities2(); string payment = ""; if (checkRawMoney.Checked == true) { payment = "OFFLINE"; } else { payment = "ONLINE"; } if (txVoucher.Text != "") { if (AddTable.idTableChoose != "") { db.Bills.Add(new Bill() { BillId = codeBill, OrderTimeStart = DateTime.Now, Payments = payment, Total = Convert.ToInt32(sumRaw.Text.Split(' ')[0]), UserName = SignIn.username, PhoneNumber = Home.phoneCustomer, CodeVoucher = txVoucher.Text, TableId = AddTable.idTableChoose }); } else { db.Bills.Add(new Bill() { BillId = codeBill, OrderTimeStart = DateTime.Now, Payments = payment, Total = Convert.ToInt32(sumRaw.Text.Split(' ')[0]), UserName = SignIn.username, PhoneNumber = Home.phoneCustomer, CodeVoucher = txVoucher.Text, }); } } else { if (AddTable.idTableChoose != "") { db.Bills.Add(new Bill() { BillId = codeBill, OrderTimeStart = DateTime.Now, Payments = payment, Total = Convert.ToInt32(sumRaw.Text.Split(' ')[0]), UserName = SignIn.username, PhoneNumber = Home.phoneCustomer, TableId = AddTable.idTableChoose }); } else { db.Bills.Add(new Bill() { BillId = codeBill, OrderTimeStart = DateTime.Now, Payments = payment, Total = Convert.ToInt32(sumRaw.Text.Split(' ')[0]), UserName = SignIn.username, PhoneNumber = Home.phoneCustomer }); } } //db.SaveChanges(); //MessageBox.Show(SignIn.username); foreach (var i in Home.listView) { String idDrink = i[0]; var drink = db.Drinks.Find(idDrink); Item item = new Item(); item.DrinkId = idDrink; item.BillId = codeBill; /* * drink.Items.Add(new Item() { * DrinkId = idDrink, * BillId = codeBill * }); * * */ drink.Items.Add(item); //db.SaveChanges(); for (int j = 1; j < i.Count; j++) { var topping = db.Toppings.Find(i[j]); //drink.Toppings.Add(topping); //item.Toppings.Add(); //fix:item.Toppings.Add(topping); item.ItemToppings.Add(new ItemTopping() { BillId = item.BillId, DrinkId = item.DrinkId, ToppingId = topping.ToppingId, ItemId = item.ItemId }); } } db.SaveChanges(); MessageBox.Show("Thanh toán thành công"); this.Close(); }