private void btnluu_Click(object sender, EventArgs e) { bool flag; if (rdbnam.Checked == true) { flag = true; } else { flag = false; } using (_db = new QLSQADataContext()) { db_User user = new db_User { TenNV = txttnd.Text, TenDangNhap = txttdn.Text, MatKhau = txtmk.Text, EmailDK = txtemail.Text, Vaitro = cmbvaitro.SelectedItem.ToString(), GioiTinhDK = flag, NgaySinh = dateTimePicker1.Value }; _db.db_Users.InsertOnSubmit(user); _db.SubmitChanges(); loadata(); }; MessageBox.Show("Thêm thành công", "Thông báo", MessageBoxButtons.OK); enableNutLenh(false); cleardata(); }
private void btnluu_Click(object sender, EventArgs e) { bool flag; if (rdbnam.Checked == true) { flag = true; } else { flag = false; } using (_db = new QLSQADataContext()) { db_KhachHang user = new db_KhachHang { TenKH = txttenkh.Text, DiaChiKH = txtdiachi.Text, sdtKH = txtsdt.Text, EmailKH = txtemail.Text, GioiTInh = flag, NgaySinh = dateTimePicker1.Value }; _db.db_KhachHangs.InsertOnSubmit(user); _db.SubmitChanges(); loadata(); }; MessageBox.Show("Thêm thành công", "Thông báo", MessageBoxButtons.OK); enableNutLenh(false); cleardata(); }
private void btnsua_Click(object sender, EventArgs e) { bool flag; int pid = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value.ToString()); if (rdbnam.Checked == true) { flag = true; } else { flag = false; } using (_db = new QLSQADataContext()) { var item = _db.db_KhachHangs.Where(r => r.MaKH == pid).FirstOrDefault(); item.TenKH = txttenkh.Text; item.DiaChiKH = txtdiachi.Text; item.sdtKH = txtsdt.Text; item.EmailKH = txtemail.Text; item.GioiTInh = flag; item.NgaySinh = dateTimePicker1.Value; _db.SubmitChanges(); loadata(); } MessageBox.Show("Sửa thành công", "Thông báo", MessageBoxButtons.OK); cleardata(); }
private void btnsua_Click(object sender, EventArgs e) { bool flag; int pid = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value.ToString()); if (rdbnam.Checked == true) { flag = true; } else { flag = false; } using (_db = new QLSQADataContext()) { var item = _db.db_Users.Where(r => r.MaNV == pid).FirstOrDefault(); item.TenNV = txttnd.Text; item.TenDangNhap = txttdn.Text; item.MatKhau = txtmk.Text; item.EmailDK = txtemail.Text; item.Vaitro = cmbvaitro.SelectedItem.ToString(); item.GioiTinhDK = flag; item.NgaySinh = dateTimePicker1.Value; _db.SubmitChanges(); loadata(); } MessageBox.Show("Sửa thành công", "Thông báo", MessageBoxButtons.OK); cleardata(); }
private void btnx_Click(object sender, EventArgs e) { int pid = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value.ToString()); using (_db = new QLSQADataContext()) { var item = _db.db_KhachHangs.Where(r => r.MaKH == pid).FirstOrDefault(); _db.db_KhachHangs.DeleteOnSubmit(item); _db.SubmitChanges(); loadata(); } MessageBox.Show("Xóa thành công", "Thông báo", MessageBoxButtons.OK); cleardata(); }
private void btnluu_Click(object sender, EventArgs e) { db_HoaDon hd = new db_HoaDon { MaHD = txtmhd.Text, MaKH = int.Parse(cmbtkh.SelectedValue.ToString()), MaNV = 1, NgayBan = dtpnd.Value }; db.db_HoaDons.InsertOnSubmit(hd); db.SubmitChanges(); lblmhd.Text = txtmhd.Text; }
private void btnsua_Click(object sender, EventArgs e) { int pid = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value.ToString()); using (QLSQADataContext _db = new QLSQADataContext()) { var item = _db.db_SanPhams.Where(r => r.MaSP == pid).FirstOrDefault(); item.TenSP = txttensp.Text; item.AnhSP = txtanh.Text; item.SoLuongSP = Convert.ToInt32(txtsoluong.Text); item.GiaSP = Convert.ToDouble(txtgia.Text); _db.SubmitChanges(); loadata(); } MessageBox.Show("Sửa thành công", "Thông báo", MessageBoxButtons.OK); cleardata(); }
private void btnluu_Click(object sender, EventArgs e) { using (QLSQADataContext _db = new QLSQADataContext()) { db_SanPham product = new db_SanPham { TenSP = txttensp.Text, AnhSP = txtanh.Text, SoLuongSP = Convert.ToInt32(txtsoluong.Text), GiaSP = Convert.ToDouble(txtgia.Text), }; _db.db_SanPhams.InsertOnSubmit(product); _db.SubmitChanges(); loadata(); }; MessageBox.Show("Thêm thành công", "Thông báo", MessageBoxButtons.OK); enableNutLenh(false); cleardata(); }
private void btnluusp_Click(object sender, EventArgs e) { _db.SubmitChanges(); QLSQADataContext ql = new QLSQADataContext(); double tongtien = 0; var item = (from tb in ql.db_ChiTietDonHangs join tb1 in ql.db_HoaDons on tb.MaHD equals tb1.MaHD where tb.MaHD == lblmhd.Text select tb).ToList(); foreach (var hd in item) { tongtien += (double)hd.ThanhTien; } label3.Text = tongtien.ToString(); using (QLSQADataContext dbnew = new QLSQADataContext()) { var item1 = dbnew.db_HoaDons.Where(r => r.MaHD == txtmhd.Text).Single(); item1.TongTien = tongtien; dbnew.SubmitChanges(); dataGridView1.Rows.Clear(); loadgrid(); } }