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 { }
}