private void btnOKKH_Click(object sender, EventArgs e)
{
if (txtMaKH.Text != "" || txtSDTKH.Text != "" || txtDCKH.Text != "" || txtTenKH.Text != "")
{
tb_KhachHangDBO obj = new tb_KhachHangDBO();
obj.MaKhachHang = txtMaKH.Text;
obj.TenKhachHang = txtTenKH.Text;
obj.SDT = txtSDTKH.Text;
obj.DiaChi = txtDCKH.Text;
if (flag == "them")
{
if (tb_KhachHangBLL.kiemTraTonTai(obj.MaKhachHang) == 1)
{
MessageBox.Show("Thông Báo Đã tồn tại!");
}
else
{
tb_KhachHangBLL.them(obj);
MessageBox.Show("Thêm thành công!");
this.Dispose();
}
}
else if (flag == "sua")
{
tb_KhachHangBLL.sua(obj);
MessageBox.Show("Sửa thành công!");
this.Dispose();
}
}
}
public static void sua(tb_KhachHangDBO obj)
{
tb_KhachHangDAL.sua(obj);
}
public static void sua(tb_KhachHangDBO obj)
{
Unility.ExcuteSQL(string.Format("UPDATE tb_KhachHang SET TenKhachHang = N'{1}' ,DiaChi = N'{2}',SDT = N'{3}' WHERE MaKhachHang = N'{0}'", obj.MaKhachHang, obj.TenKhachHang, obj.DiaChi, obj.SDT));
}
public static void them(tb_KhachHangDBO obj)
{
tb_KhachHangDAL.them(obj);
}
public static void them(tb_KhachHangDBO obj)
{
Unility.ExcuteSQL(string.Format("INSERT INTO tb_KhachHang (MaKhachHang ,TenKhachHang ,DiaChi ,SDT) VALUES (N'{0}',N'{1}',N'{2}',N'{3}')", obj.MaKhachHang, obj.TenKhachHang, obj.DiaChi, obj.SDT));
}
