private void cmbCategory_TextChanged(object sender, EventArgs e) { CoffeeContextDB context = new CoffeeContextDB(); List <Food> listFood = context.Foods.ToList().Where(p => p.FoodCategory.name == cmbCategory.Text).ToList(); cmbFoody(listFood); }
private void Admin_Load(object sender, EventArgs e) { //Format Date //Init SQL DB CoffeeContextDB context = new CoffeeContextDB(); List <Account> listAcc = context.Accounts.ToList(); BindGrid_Account(listAcc); BindGrid_InCome(); }
private void fTable_Load(object sender, EventArgs e) { CoffeeContextDB context = new CoffeeContextDB(); List <FoodCategory> listCategory = context.FoodCategories.ToList(); List <Food> listFood = context.Foods.ToList(); List <TableFood> listTable = context.TableFoods.ToList(); InitTable(); cmbType(listCategory); cmbFoody(listFood); cmbTableChanged(listTable); }
private void BindGrid_InCome() { using (CoffeeContextDB _contextDB = new CoffeeContextDB()) { List <BillInfo> listBill = _contextDB.BillInfoes.ToList(); dgvInCome.Rows.Clear(); foreach (var item in listBill) { int index = dgvInCome.Rows.Add(); dgvInCome.Rows[index].Cells[0].Value = item.Bill.TableFood.name; dgvInCome.Rows[index].Cells[1].Value = item.Bill.DateCheckIn; dgvInCome.Rows[index].Cells[2].Value = item.Bill.DateCheckOut; dgvInCome.Rows[index].Cells[3].Value = item.Bill.discount; dgvInCome.Rows[index].Cells[4].Value = item.count * item.Food.price; } } }
private void btnSignIn_Click(object sender, EventArgs e) { string UserName = txtUserName.Text.Trim(); string Password = txtPassword.Text.Trim(); if (string.IsNullOrEmpty(UserName) || string.IsNullOrEmpty(Password)) { MessageBox.Show("Tài Khoản hoặc mật khẩu chưa chính xác, Vui lòng nhập lại !", "Thông Báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Error); return; } else { using (var _dbContext = new CoffeeContextDB()) { Account checkUser = _dbContext.Accounts.Where(p => p.UserName == UserName).FirstOrDefault(); Account checkPassword = _dbContext.Accounts.Where(p => p.PassWord == Password).FirstOrDefault(); if (checkUser == null && checkPassword == null) { MessageBox.Show("Tài Khoản Không Tồn Tài !", "Thông Báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Error); } else if (checkUser == null) { MessageBox.Show("Sai Tài Khoản !", "Thông Báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Error); } else if (checkPassword == null) { MessageBox.Show("Sai Mật Khẩu !", "Thông Báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Error); } else { this.Hide(); if (accountAccuracy != null) { accountAccuracy(checkUser); } } } } }
private void bindDgvBill(int id) { using (CoffeeContextDB _contextDB = new CoffeeContextDB()) { List <List> listBillInfo = MenuDAO.Instance.GetListMenu(id); dgvTableDetails.Rows.Clear(); float total = 0; foreach (List item in listBillInfo) { int index = dgvTableDetails.Rows.Add(); dgvTableDetails.Rows[index].Cells[0].Value = item.name; dgvTableDetails.Rows[index].Cells[1].Value = item.count; dgvTableDetails.Rows[index].Cells[2].Value = item.Price; dgvTableDetails.Rows[index].Cells[3].Value = item.Totalprice; total += item.Totalprice; } CultureInfo culture = new CultureInfo("vi-VN"); txtTotalPrice.Text = total.ToString("c", culture); } }