public void suakhachhang(Khachhangobject khach) { kn.connect(); SqlCommand cmd = new SqlCommand("SUAKHACH", kn.con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter kh = new SqlParameter("@ID", khach.Makh); cmd.Parameters.Add(kh); kh = new SqlParameter("@MAKH", khach.Makh); cmd.Parameters.Add(kh); kh = new SqlParameter("@TENKH", khach.Tenkh); cmd.Parameters.Add(kh); kh = new SqlParameter("@CMT", khach.Cmt); cmd.Parameters.Add(kh); kh = new SqlParameter("@SDT", khach.Sdt); cmd.Parameters.Add(kh); kh = new SqlParameter("@GT", khach.Gt); cmd.Parameters.Add(kh); kh = new SqlParameter("@MADOAN", khach.Madoan); cmd.Parameters.Add(kh); kh = new SqlParameter("@DIACHI", khach.Diachi); cmd.Parameters.Add(kh); int count = cmd.ExecuteNonQuery(); if (count > 0) { MessageBox.Show("Sửa mới thành công"); } else { MessageBox.Show("Không thể sửa"); } kn.disconnect(); }
public static bool Deletekhachhang(Khachhangobject khach) { Khachhangmodel kh = new Khachhangmodel(); kh.xoakhachhang(khach); return(true); }
public static bool Updatekhachhang(Khachhangobject khach) { Khachhangmodel kh = new Khachhangmodel(); kh.suakhachhang(khach); return(true); }
public static bool Addkhachhang(Khachhangobject khach) { Khachhangmodel kh = new Khachhangmodel(); kh.addkhachhang(khach); return(true); }
//xóa khách hàng private void btnxoaKH_Click(object sender, EventArgs e) { try { DialogResult dg = new DialogResult(); dg = MessageBox.Show("Bạn có muốn xóa không", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dg == DialogResult.Yes) { Khachhangobject kh = new Khachhangobject(); kh.Makh = txtMAKH.Text; Khachhangcontrol.Deletekhachhang(kh); dataGridView2.DataSource = Khachhangcontrol.getdataK(); } } catch { } }
public void xoakhachhang(Khachhangobject khach) { kn.connect(); SqlCommand cmd = new SqlCommand("XOAKHACH", kn.con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter kh = new SqlParameter("@ID", khach.Makh); cmd.Parameters.Add(kh); int count = cmd.ExecuteNonQuery(); if (count > 0) { MessageBox.Show("Xóa thành công"); } else { MessageBox.Show("Không thể xóa@@@"); } kn.disconnect(); }
//sửa khách hàng private void btnsuaKH_Click(object sender, EventArgs e) { try { Khachhangobject kh = new Khachhangobject(); kh.Makh = txtMAKH.Text; kh.Tenkh = txtTENKH.Text; kh.Cmt = txtCMT.Text; kh.Sdt = txtSDT.Text; if (this.radioGT.Checked == true) { kh.Gt = radioGT.Text; } else { kh.Gt = radioButton2.Text; } kh.Madoan = txtmadoan.Text; kh.Diachi = txtdiachi.Text; Khachhangcontrol.Updatekhachhang(kh); dataGridView2.DataSource = Khachhangcontrol.getdataK(); } catch { } }