public bool UpdateKhachHang(KhachHang_ET khachHang)
{
try
{
conn.Open();
SqlCommand cmd = new SqlCommand("SP_KhachHang_Update", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", khachHang.ID);
cmd.Parameters.AddWithValue("@hoten", khachHang.HoTen);
cmd.Parameters.AddWithValue("@gioitinh", khachHang.GioiTinh);
cmd.Parameters.AddWithValue("@diachi", khachHang.DiaChi);
cmd.Parameters.AddWithValue("@sdt", khachHang.SDT);
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
finally
{
conn.Close();
}
}
public bool DeleteKhachHang(KhachHang_ET khachHang)
{
try
{
conn.Open();
SqlCommand cmd = new SqlCommand("SP_KhachHang_Delete", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", khachHang.ID);
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
finally
{
conn.Close();
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
DialogResult res = MessageBox.Show("Bạn có muốn xóa không?", "Xóa khách hàng", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (res == DialogResult.Yes)
{
try
{
id_KhachHang = Int32.Parse(txtID_KhachHang.Text);
hoTenNV = txtTenKH.Text;
if (rabNam.Checked)
{
gioiTinh = "Nam";
}
if (rabNu.Checked)
{
gioiTinh = "Nữ";
}
diaChi = txtDiaChi.Text;
sdt = txtSDT.Text;
KhachHang_ET khachHang = new KhachHang_ET(id_KhachHang, hoTenNV, gioiTinh, diaChi, sdt);
if (bus_KhachHang.DeleteKhachHang(khachHang) == true)
{
MessageBox.Show("Xóa khách hàng thành công!", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information);
showButton(false);
clearText();
dtgvKhachHang.DataSource = bus_KhachHang.GetAllKhachHang();
}
else
{
MessageBox.Show("Xóa thất bại!", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show("Đã xảy ra lỗi: " + ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
public bool DeleteKhachHang(KhachHang_ET khachHang)
{
return(dal_KhachHang.DeleteKhachHang(khachHang));
}
public bool UpdateKhachHang(KhachHang_ET khachHang)
{
return(dal_KhachHang.UpdateKhachHang(khachHang));
}
public bool AddKhachHang(KhachHang_ET khachHang)
{
return(dal_KhachHang.AddKhachHang(khachHang));
}
private void btnLuu_Click(object sender, EventArgs e)
{
if (lenh == ADD)
{
try
{
//id_KhachHang = Int32.Parse(txtID_KhachHang.Text);
hoTenNV = txtTenKH.Text;
if (rabNam.Checked)
{
gioiTinh = "Nam";
}
if (rabNu.Checked)
{
gioiTinh = "Nữ";
}
diaChi = txtDiaChi.Text;
sdt = txtSDT.Text;
KhachHang_ET khachHang = new KhachHang_ET(hoTenNV, gioiTinh, diaChi, sdt);
if (bus_KhachHang.AddKhachHang(khachHang) == true)
{
MessageBox.Show("Thêm khách hàng thành công!", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information);
showButton(false);
clearText();
dtgvKhachHang.DataSource = bus_KhachHang.GetAllKhachHang();
}
else
{
MessageBox.Show("Thêm thất bại!", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show("Đã xảy ra lỗi: " + ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
if (lenh == EDIT)
{
try
{
id_KhachHang = Int32.Parse(txtID_KhachHang.Text);
hoTenNV = txtTenKH.Text;
if (rabNam.Checked)
{
gioiTinh = "Nam";
}
if (rabNu.Checked)
{
gioiTinh = "Nữ";
}
diaChi = txtDiaChi.Text;
sdt = txtSDT.Text;
KhachHang_ET khachHang = new KhachHang_ET(id_KhachHang, hoTenNV, gioiTinh, diaChi, sdt);
if (bus_KhachHang.UpdateKhachHang(khachHang) == true)
{
MessageBox.Show("Sửa khách hàng thành công!", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information);
showButton(false);
clearText();
dtgvKhachHang.DataSource = bus_KhachHang.GetAllKhachHang();
}
else
{
MessageBox.Show("Sửa thất bại!", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show("Đã xảy ra lỗi: " + ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
