private void loaddanhmuc() { isloaddanhmuc = true; setNullAllButton(); SQLDataContext db = new SQLDataContext(); var arr = from list in db.LoaiMonAns select list.LoaiMonAn1; int i = 0; foreach (Button btn in btnMa) { if (i < arr.ToList().Count) { if (btn != btnMa.Last()) { btn.Click += new System.EventHandler(this.btnDanhmuc_click); btn.Text = arr.ToList().ElementAt(i).ToString(); btn.BackColor = Color.DarkBlue; btn.ForeColor = Color.White; btn.Visible = true; } } i++; } }
private void button1_Click(object sender, EventArgs e) { this.Close(); KhachHang kh = new KhachHang(); kh.Tenkhachhang = tb.Khachhang; kh.SoDienThoai = tb.Sdt; kh.Tongsotien = tong; SQLDataContext db = new SQLDataContext(); db.KhachHangs.InsertOnSubmit(kh); db.SubmitChanges(); }
private void button13_Click(object sender, EventArgs e) { SQLDataContext db = new SQLDataContext(); var log = from nd in db.NguoiDungs where nd.username == txtU.Text && nd.pass == txtP.Text select nd; if (log.Any()) { main.removeLogin(); main.showTable(); String name = log.First().name; main.showTop(name); main.User = name; } else { MessageBox.Show("Lỗi đăng nhập! ID hoặc mật khẩu không chính xác!"); } }
public void goiMon(object sender, EventArgs e) { Button btn = (Button)sender; SQLDataContext db = new SQLDataContext(); if (btn.Text.Equals(m)) { tb.LstGoimon.Last().Soluong += 1; } else { m = btn.Text; Food food = new Food(); food.Tenmonan = m; food.Soluong = 1; food.Time = DateTime.Now.ToString("HH:mm:ss"); var gia = db.MonAns.First(n => n.TenMonAn.ToLower().Equals(m.ToLower())).Gia; food.Gia = gia; tb.LstGoimon.Add(food); } loadData(); }
private void loadmonan(string tendanhmuc) { setNullAllButton(); SQLDataContext db = new SQLDataContext(); var lma = db.LoaiMonAns.FirstOrDefault(m => m.LoaiMonAn1.ToLower().Equals(tendanhmuc)).Id; var arr = db.MonAns.Where(n => n.MaLoaiMonAn == lma).Select(n => n.TenMonAn); int i = 0; foreach (Button btn in btnMa) { if (i < arr.ToList().Count) { if (btn != btnMa.Last()) { btn.Click += new System.EventHandler(this.goiMon); btn.Text = arr.ToList().ElementAt(i).ToString(); btn.BackColor = Color.DarkBlue; btn.ForeColor = Color.White; btn.Visible = true; } } i++; } }