private void frmBillInfo_Load(object sender, EventArgs e) { db = new CitiZoneDataContext(); var bill = (from p in db.billInfos join x in db.foods on p.foodID equals(x.foodID) where p.billID == Convert.ToInt32(lblBillID.Text.ToString()) select new { FoodName = x.foodName, Amount = p.amount, TotalPrice = x.price }).ToList(); dgvBill.DataSource = bill; int totalpc = 0; for (int i = 0; i < dgvBill.RowCount; i++) { int prc = Convert.ToInt32(dgvBill.Rows[i].Cells[2].Value.ToString()); int amt = Convert.ToInt32(dgvBill.Rows[i].Cells[1].Value.ToString()); totalpc += prc * amt; } txtTotal.Text = totalpc.ToString(); dgvBill.Rows[0].Selected = false; }
private void ptbFoodNamesDelete_Click(object sender, EventArgs e) { MC = new CitiZoneDataContext(); int FoodID = Int32.Parse(dgvFoods.SelectedCells[0].OwningRow.Cells[2].Value.ToString()); string Food = dgvFoods.SelectedCells[0].OwningRow.Cells[0].Value.ToString(); if (check(FoodID)) { MessageBox.Show("You must delete all bill contains this food first", "Notification"); } else { if (MessageBox.Show("Food " + FoodID + " - " + Food + " will be permanently DELETED", "Notification", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { food food = new food(); food.foodID = FoodID; foodServices.deleteFood(food); ptbFoodDelete.Visible = false; } string CategoryID = dgvCategories.SelectedCells[0].OwningRow.Cells[0].Value.ToString(); var dgv = (from s in MC.foods where s.categoryID == CategoryID select new { Food = s.foodName, Price = s.price, ID = s.foodID }).ToList(); dgvFoods.DataSource = dgv; } }
//thêm 1 billinfo public void addBillinfo(billInfo billInfo) { db = new CitiZoneDataContext(); billInfo bifo = new billInfo(); bifo = billInfo; db.billInfos.InsertOnSubmit(bifo); db.SubmitChanges(); }
//lấy dữ liệu từ database public BillImpl() { db = new CitiZoneDataContext(); using (db) { var bl = from x in db.bills select x; bills = bl.ToList(); } }
//thêm bill public void addBill(bill bill) { db = new CitiZoneDataContext(); bill bl = new bill(); bl = bill; db.bills.InsertOnSubmit(bl); db.SubmitChanges(); }
private void frmAddFood_Load(object sender, EventArgs e) { add = new CitiZoneDataContext(); var cbC = (from s in add.categories select s.categoryName).ToList(); cbCategories.DataSource = cbC; cbCategories.SelectedItem = ct; }
//lấy dữ liệu từ database public FoodImpl() { db = new CitiZoneDataContext(); using (db) { var fd = from x in db.foods select x; foods = fd.ToList(); } }
public TableImpl() { db = new CitiZoneDataContext(); using (db) { var tbl = from x in db.coffeeTables select x; tables = tbl.ToList(); } }
//thêm một nhân viên mới public void addAccount(account account) { db = new CitiZoneDataContext(); account acc = new account(); acc = account; db.accounts.InsertOnSubmit(acc); db.SubmitChanges(); }
//thêm món mới public void addFood(food food) { db = new CitiZoneDataContext(); food fd = new food(); fd = food; db.foods.InsertOnSubmit(fd); db.SubmitChanges(); }
//lấy database từ csdl public AccountImpl() { db = new CitiZoneDataContext(); using (db) { var account = from ac in db.accounts select ac; accounts = account.ToList(); } }
//thêm danh mục public void addCategory(category category) { db = new CitiZoneDataContext(); category ct = new category(); ct = category; db.categories.InsertOnSubmit(ct); db.SubmitChanges(); }
//đổ dữ liệu từ database vào public CategoryImpl() { db = new CitiZoneDataContext(); using (db) { var category = from ct in db.categories select ct; categories = category.ToList(); } }
//xoá nhân viên public void deleteAccount(account account) { db = new CitiZoneDataContext(); account acc = new account(); acc = account; acc = db.accounts.Single(x => x.username == account.username); db.accounts.DeleteOnSubmit(acc); db.SubmitChanges(); }
//cập nhật danh mục public void updateCategory(category category) { db = new CitiZoneDataContext(); category ct = new category(); ct = category; ct = db.categories.Single(x => x.categoryID == category.categoryID); setUpdateCategory(ct, category); db.SubmitChanges(); }
//xoá danh mục public void deleteCategory(category category) { db = new CitiZoneDataContext(); category ct = new category(); ct = category; ct = db.categories.Single(x => x.categoryID == category.categoryID); db.categories.DeleteOnSubmit(ct); db.SubmitChanges(); }
//xoá bill public void deleteBill(bill bill) { db = new CitiZoneDataContext(); bill bl = new bill(); bl = bill; bl = db.bills.Single(x => x.billID == bill.billID); db.bills.DeleteOnSubmit(bl); db.SubmitChanges(); }
//cập nhật món public void updateFood(food food) { db = new CitiZoneDataContext(); food fd = new food(); fd = food; fd = db.foods.Single(x => x.foodID == food.foodID); setUpdateFood(fd, food); db.SubmitChanges(); }
//cập nhật bàn public void updateTable(coffeeTable table) { db = new CitiZoneDataContext(); coffeeTable tab = new coffeeTable(); tab = table; tab = db.coffeeTables.Single(x => x.tableID == table.tableID); setUpdateTable(tab, table); db.SubmitChanges(); }
//xoá món public void deleteFood(food food) { db = new CitiZoneDataContext(); food fd = new food(); fd = food; fd = db.foods.Single(x => x.foodID == food.foodID); db.foods.DeleteOnSubmit(fd); db.SubmitChanges(); }
private void frmManageAccount_Load(object sender, EventArgs e) { MA = new CitiZoneDataContext(); dgvQLTK.DataSource = from q in MA.accounts orderby q.position ascending select new { usn = q.username, Fullname = q.fullname, quyen = q.position, pw = q.password }; }
private void frmManageCategories_Load(object sender, EventArgs e) { MC = new CitiZoneDataContext(); var dgv = (from s in MC.categories select new { CategoryID = s.categoryID, CategoryName = s.categoryName }).ToList(); dgvCategories.DataSource = dgv; dgvFN(); }
private void ptbCategoriesDelete_Click(object sender, EventArgs e) { MC = new CitiZoneDataContext(); string ctgID = dgvCategories.SelectedCells[0].OwningRow.Cells[0].Value.ToString(); string ctgName = dgvCategories.SelectedCells[0].OwningRow.Cells[1].Value.ToString(); if (dgvCategories.RowCount > 0) { bool chk = true; if (dgvFoods.RowCount > 0) { for (int i = 0; i < dgvFoods.RowCount; i++) { int fID = Int32.Parse(dgvFoods.Rows[i].Cells[2].Value.ToString()); if (check(fID)) { chk = false; break; } } } if (chk == true) { if (dgvFoods.RowCount < 1) { if (MessageBox.Show("Category " + ctgID + " - " + ctgName + " will be permanently DELETED", "Notification", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { MC.deleteCategories(ctgID); ptbCategoriesDelete.Visible = false; frmManageCategories_Load(sender, e); } } else { if (MessageBox.Show("All Food in Category " + ctgName + " will be permanently DELETED", "Notification", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { MC.deleteFoodsByCategories(ctgID); MC.deleteCategories(ctgID); frmManageCategories_Load(sender, e); } } } else { MessageBox.Show("You must delete all bill contains foods of this category first", "Notification"); } } }
private bool checkName(string ctgName) { add = new CitiZoneDataContext(); var c = from p in add.categories where p.categoryName == ctgName select p.categoryName; if (c.Any()) { return(true); } else { return(false); } }
private bool check(string usn) { db = new CitiZoneDataContext(); var q = from p in db.accounts where p.username == usn select p; if (q.Any()) { return(false); } else { return(true); } }
private bool checkID(string ctgID) { add = new CitiZoneDataContext(); var q = from p in add.categories where p.categoryID == ctgID select p; if (q.Any()) { return(true); } else { return(false); } }
private bool check(string fn) { add = new CitiZoneDataContext(); var chk = (from p in add.foods where p.foodName == fn select p.foodName); if (chk.Any()) { return(true); } else { return(false); } }
private bool check(int fid) { MC = new CitiZoneDataContext(); var c = from p in MC.billInfos where p.foodID == fid select p.foodID; if (c.Any()) { return(true); } else { return(false); } }
void dgvFN() { if (dgvCategories.RowCount > 0) { MC = new CitiZoneDataContext(); string CategoryID = dgvCategories.SelectedCells[0].OwningRow.Cells[0].Value.ToString(); var dgv = (from s in MC.foods where s.categoryID == CategoryID select new { Food = s.foodName, Price = s.price, ID = s.foodID }).ToList(); dgvFoods.DataSource = dgv; } }
//cập nhật thông tin của nhân viên public void updateAccount(account account) { db = new CitiZoneDataContext(); account acc = new account(); acc = account; acc = db.accounts.Single(x => x.username == account.username); setAccountUpdate(acc, account); /*acc = db.accounts.Where(ac => ac.username == account.username).Single(); * acc.password = account.password; * acc.fullname = account.fullname; * acc.birthday = account.birthday; * acc.address = account.address; * acc.phone = account.phone; * acc.pictureLocation = account.pictureLocation; */ db.SubmitChanges(); }