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