//---------------------------------------------------------------------------------------------------------//
private static EKHACHHANG GetOneKHACHHANG(IDataReader idr)
{
EKHACHHANG OKHACHHANG = new EKHACHHANG();
if (idr["MAKH"] != DBNull.Value)
{
OKHACHHANG.MAKH = (string)idr["MAKH"];
}
if (idr["TENK"] != DBNull.Value)
{
OKHACHHANG.TENK = (string)idr["TENK"];
}
if (idr["GIOITINH"] != DBNull.Value)
{
OKHACHHANG.GIOITINH = (string)idr["GIOITINH"];
}
if (idr["SDT"] != DBNull.Value)
{
OKHACHHANG.SDT = (string)idr["SDT"];
}
if (idr["DIACHI"] != DBNull.Value)
{
OKHACHHANG.DIACHI = (string)idr["DIACHI"];
}
return(OKHACHHANG);
}
public static void Update(EKHACHHANG OKHACHHANG)
{
SqlParameter[] pr = new SqlParameter[5];
pr[0] = new SqlParameter(@"MAKH", OKHACHHANG.MAKH);
pr[1] = new SqlParameter(@"TENK", OKHACHHANG.TENK);
pr[2] = new SqlParameter(@"GIOITINH", OKHACHHANG.GIOITINH);
pr[3] = new SqlParameter(@"SDT", OKHACHHANG.SDT);
pr[4] = new SqlParameter(@"DIACHI", OKHACHHANG.DIACHI);
SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "KHACHHANG_Update", pr);
}
//---------------------------------------------------------------------------------------------------------//
public static void Insert(EKHACHHANG OKHACHHANG)
{
SqlParameter[] pr = new SqlParameter[5];
pr[0] = new SqlParameter(@"MAKH", OKHACHHANG.MAKH);
pr[1] = new SqlParameter(@"TENK", OKHACHHANG.TENK);
pr[2] = new SqlParameter(@"GIOITINH", OKHACHHANG.GIOITINH);
pr[3] = new SqlParameter(@"SDT", OKHACHHANG.SDT);
pr[4] = new SqlParameter(@"DIACHI", OKHACHHANG.DIACHI);
DataAccseL.ExecuteNonQuery(CommandType.StoredProcedure, "KHACHHANG_Insert", pr);
}
private void btnSua_Click(object sender, EventArgs e)
{
EKHACHHANG ek = new EKHACHHANG();
ek.MAKH = txtsdt.Text.Trim();
ek.TENK = txttenk.Text.Trim();
ek.GIOITINH = rdNam.Checked ? "Nam" : "Nữ";
ek.SDT = txtsdt.Text.Trim();
ek.DIACHI = txtdc.Text.Trim();
BKHACHHANG.Update(ek);
FormKhachhang_Load(sender, e);
}
public static EKHACHHANG SelectByID(string MAKH)
{
EKHACHHANG OKHACHHANG = new EKHACHHANG();
SqlParameter[] pr = new SqlParameter[1];
pr[0] = new SqlParameter(@"MAKH", MAKH);
IDataReader idr = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "KHACHHANG_SelectByID", pr);
if (idr.Read())
{
OKHACHHANG = GetOneKHACHHANG(idr);
}
idr.Close();
idr.Dispose();
return(OKHACHHANG);
}
private void btnThem_Click(object sender, EventArgs e)
{
for (int i = 0; i < dgvData.Rows.Count - 1; i++)
{
if (txtsdt.Text.Trim() == dgvData.Rows[i].Cells[0].Value.ToString())
{
MessageBox.Show("Khách hàng đã tồn tại, vui lồng nhấn nút sửa để cập nhật thông tin", "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
EKHACHHANG ek = new EKHACHHANG();
ek.MAKH = txtsdt.Text.Trim();
ek.TENK = txttenk.Text.Trim();
ek.GIOITINH = rdNam.Checked ? "Nam" : "Nữ";
ek.SDT = txtsdt.Text.Trim();
ek.DIACHI = txtdc.Text.Trim();
BKHACHHANG.Insert(ek);
FormKhachhang_Load(sender, e);
}
private void button1_Click(object sender, EventArgs e)
{
EKHACHHANG ek = new EKHACHHANG();
ek.MAKH = txtsdt.Text.Trim();
ek.TENK = txttenk.Text.Trim();
ek.GIOITINH = rdNam.Checked ? "Nam" : "Nữ";
ek.SDT = txtsdt.Text.Trim();
ek.DIACHI = txtdc.Text.Trim();
DataTable dt = BKHACHHANG.SelectAll(txtsdt.Text.Trim());
if (dt == null || dt.Rows.Count == 0)
{
BKHACHHANG.Insert(ek);
}
else
{
BKHACHHANG.Update(ek);
}
//hoa don
EHOADON ehd = new EHOADON();
ehd.SOHOADON = txtshd.Text.Trim();
ehd.NGAYHOADON = dtngay.Value.Day.ToString() + "/" + dtngay.Value.Month.ToString() + "/" + dtngay.Value.Year.ToString();
ehd.MAKH = txtsdt.Text.Trim();
ehd.NHANVIEN = txtnv.Text.Trim();
ehd.GHICHU = txtghichu.Text.Trim();
if (!isHD)
{
BHOADON.Insert(ehd);
isHD = true;
}
else
{
BHOADON.Update(ehd);
}
button1.Text = "Sửa hóa đơn";
grbcthd.Enabled = true;
}
