private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex >= 0) { btnPrintBill.Visible = true; btnMail.Visible = true; //int i = dataGridView1.CurrentRow.Index; hoadDonXuat hdx = db.hoadDonXuats.Where(s => s.maHDX == dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString()).FirstOrDefault(); //tranferId.id = hdx.maHDX; //hd = hdx.maHDX; khachHang kh = db.khachHangs.Where(s => s.maKH == hdx.maKH).FirstOrDefault(); txtCusName.Text = dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString(); txtCusPhone.Text = kh.sdt.ToString(); txtCusAddress.Text = kh.diaChi.ToString(); txtCusEmail.Text = kh.email.ToString(); txtBillid.Text = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString(); txtBillDate.Text = dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString(); txtBillStatus.Text = dataGridView1.Rows[e.RowIndex].Cells[5].Value.ToString(); txtStaffName.Text = dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString(); txtBillPrice.Text = dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString(); } }
//Sửa thông tin khách hàng public void updateCustomer(eCustomer cus) { khachHang custemp = db.khachHangs.Where(x => x.maKH.Equals(cus.CustomerID)).FirstOrDefault(); // Cập nhật dữ liệu custemp.maKH = cus.CustomerID; custemp.tenKH = cus.CustomerName; custemp.diaChi = cus.Address; custemp.phone = cus.Phone; db.SubmitChanges(); }
//Xóa khách hàng khỏi database public bool deleteCustomer(string id) { khachHang cus = db.khachHangs.Where(x => x.maKH == id).FirstOrDefault(); if (cus != null) { db.khachHangs.DeleteOnSubmit(cus); db.SubmitChanges(); //cập nhật việc xóa vào CSDL return(true); //xóa thành công } return(false); }
public void delete(khachHang k) { openC(); SqlCommand cmd = new SqlCommand("sp_delete_khachHang", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@maKH", k.MaKH)); cmd.ExecuteNonQuery(); closeC(); }
private void button2_Click(object sender, EventArgs e) { khachHang k = new khachHang(); k.MaKH = dg_khachhang.Rows[dg_khachhang.CurrentRow.Index].Cells[0].Value.ToString(); if (dg_donthuoc.RowCount == 0) { t.delete(k); load(); } else { MessageBox.Show("Không thể xóa"); } }
public void insert(khachHang k) { openC(); SqlCommand cmd = new SqlCommand("sp_insert_khachHang", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@maKH", k.MaKH)); cmd.Parameters.Add(new SqlParameter("@tenKH", k.TenKH)); cmd.Parameters.Add(new SqlParameter("@soDT", k.SoDT)); cmd.ExecuteNonQuery(); closeC(); }
private void SuaKhachHang() { if (tblDiachi.Text == "" || tblKhachhang.Text == "" || tblEmail.Text == "" || tblSdt.Text == "") { MessageBox.Show("Bạn phải chọn một dòng để sửa"); return; } khachHang kh = db.khachHangs.Single(item => item.ID == int.Parse(tblId.Text)); kh.TenKhachHang = tblKhachhang.Text; kh.SoDienthoai = int.Parse(tblSdt.Text); kh.DiaChi = tblDiachi.Text; kh.Email = tblEmail.Text; db.SubmitChanges(); MessageBox.Show("Sửa thành công"); }
private void ThemKhachHang() { if (tblKhachhang.Text == "" || tblDiachi.Text == "" || tblEmail.Text == "" || tblSdt.Text == "") { MessageBox.Show("Chưa nhập đủ thông tin"); return; } khachHang kh = new khachHang(); kh.TenKhachHang = tblKhachhang.Text; kh.DiaChi = tblDiachi.Text; kh.SoDienthoai = int.Parse(tblSdt.Text); kh.NgaySinh = DateTime.Parse(pdNgay.Text); kh.Email = tblEmail.Text; db.khachHangs.InsertOnSubmit(kh); db.SubmitChanges(); MessageBox.Show("Thêm thành công"); }
//Nhập khách hàng mới vào database public int insertCustomer(eCustomer cus) { if (checkIDExist(cus.CustomerID)) { return(0); } khachHang custemp = new khachHang(); custemp.maKH = cus.CustomerID; custemp.tenKH = cus.CustomerName; custemp.diaChi = cus.Address; custemp.phone = cus.Phone; db.khachHangs.InsertOnSubmit(custemp); db.SubmitChanges(); return(1); }
private void datagrid_SelectionChanged(object sender, SelectionChangedEventArgs e) { int rowindex = datagrid.SelectedIndex; if (rowindex == -1) { return; } else { khachHang kh = (khachHang)datagrid.SelectedItem; tblKhachhang.Text = kh.TenKhachHang; tblDiachi.Text = kh.DiaChi; tblSdt.Text = kh.SoDienthoai.ToString(); tblEmail.Text = kh.Email; tblId.Text = kh.ID.ToString(); pdNgay.Text = kh.NgaySinh.ToString(); } }
private void XoaKhachHang() { try { if (tblDiachi.Text == "" || tblKhachhang.Text == "" || tblEmail.Text == "" || tblSdt.Text == "") { MessageBox.Show("Bạn phải chọn một dòng để xóan"); return; } khachHang kh = db.khachHangs.Single(item => item.ID == int.Parse(tblId.Text)); db.khachHangs.DeleteOnSubmit(kh); db.SubmitChanges(); MessageBox.Show("Xóa thanh công"); } catch (Exception) { MessageBox.Show("Không được xóa"); } }
private void btnLuu_Click(object sender, EventArgs e) { switch (function) { case 1: { string gt = ""; if (rdbMale.Checked) { gt = "Nam"; } else { gt = "Nữ"; } if (txtAddress.Text == "" || txtEmail.Text == "" || txtName.Text == "" || txtPhone.Text == "") { MessageBox.Show("Please fill all information"); } else { int ma = 1; string id = ""; var kh = from u in db.khachHangs select u; if (kh.Count() == 0) { id = "KH" + ma; db.KH_Ins(id, txtName.Text, gt, dtpBirthday.Value, txtEmail.Text, txtAddress.Text, txtPhone.Text); } else if (kh.Count() > 0) { kh.OrderByDescending(s => s.maKH).FirstOrDefault(); var kh2 = db.khachHangs.OrderByDescending(s => s.maKH).FirstOrDefault(); ma = Convert.ToInt32(kh2.maKH.ToString().Substring(2)) + 1; id = "KH" + ma; db.KH_Ins(id, txtName.Text, gt, dtpBirthday.Value, txtEmail.Text, txtAddress.Text, txtPhone.Text); } Uc_Customer_Load(sender, e); } } break; case 2: { db.KH_Del(txtID.Text); Uc_Customer_Load(sender, e); } break; case 3: { string gt = ""; if (rdbMale.Checked) { gt = "Nam"; } else { gt = "Nữ"; } khachHang kh = db.khachHangs.Where(s => s.maKH.Equals(txtID.Text)).FirstOrDefault(); if (kh == null) { return; } else { db.KH_Up(txtID.Text, txtName.Text, gt, dtpBirthday.Value, txtEmail.Text, txtAddress.Text, txtPhone.Text); Uc_Customer_Load(sender, e); } } break; case 4: { string gt = ""; if (rdbMale.Checked) { gt = "Nam"; } else { gt = "Nữ"; } if (chbName.Checked == true && chbSex.Checked == true && chbBirthday.Checked == true) { var kh = from u in db.khachHangs where u.tenKH == txtName.Text && u.gioiTinh == gt && u.ngSinh == dtpBirthday.Value select u; dgvCustomers.DataSource = kh; } else if (chbName.Checked == true && chbSex.Checked == true) { var kh = from u in db.khachHangs where u.tenKH == txtName.Text && u.gioiTinh == gt select u; dgvCustomers.DataSource = kh; } else if (chbName.Checked == true && chbBirthday.Checked == true) { var kh = from u in db.khachHangs where u.tenKH == txtName.Text && u.ngSinh == dtpBirthday.Value select u; dgvCustomers.DataSource = kh; } else if (chbSex.Checked == true && chbBirthday.Checked == true) { var kh = from u in db.khachHangs where u.gioiTinh == gt && u.ngSinh == dtpBirthday.Value select u; dgvCustomers.DataSource = kh; } else if (chbName.Checked == true) { var kh = from u in db.khachHangs where u.tenKH == txtName.Text select u; dgvCustomers.DataSource = kh; } else if (chbSex.Checked == true) { var kh = from u in db.khachHangs where u.gioiTinh == gt select u; dgvCustomers.DataSource = kh; } else if (chbBirthday.Checked == true) { var kh = from u in db.khachHangs where u.ngSinh == dtpBirthday.Value select u; dgvCustomers.DataSource = kh; } else { var kh = from u in db.khachHangs where u.maKH == txtID.Text select u; dgvCustomers.DataSource = kh; } } break; } }
private void btn_ok_Click(object sender, EventArgs e) { switch (f.button) { case "insert": if (txt_mkh.Text != "") { if (!check(txt_mkh.Text)) { themdl(); f.load_donthuoc(); } else { MessageBox.Show("Đã tồn tại mã khách hàng"); } } else { MessageBox.Show("Không để trống mã khách hàng"); } break; case "update": suadl(); f.load_donthuoc(); break; } void themdl() { khachHang t = new khachHang(); t.MaKH = txt_mkh.Text.ToString(); t.TenKH = txt_tenkh.Text.ToString(); t.SoDT = txtsdt.Text.ToString(); khachhang.insert(t); f.load(); this.Close(); } void suadl() { khachHang t = new khachHang(); t.MaKH = txt_mkh.Text.ToString(); t.TenKH = txt_tenkh.Text.ToString(); t.SoDT = txtsdt.Text.ToString(); khachhang.update(t); f.load(); this.Close(); } bool check(string manv) { bool c = false; // true = tồn tại DataGridView d; d = f.dg_khachhang; // MessageBox.Show(f.dg_khachhang.Rows[0].Cells[0].Value.ToString()); for (int i = 0; i < d.RowCount; i++) { if (manv == f.dg_khachhang.Rows[i].Cells[0].Value.ToString().Trim()) { c = true; break; } } return(c); } }
public void delete(khachHang k) { kh.delete(k); }
public void update(khachHang k) { kh.update(k); }
public void insert(khachHang k) { kh.insert(k); }