private KhachHangVO GetKhachHangVO()
{
int id = 0;
try {
id = int.Parse(txt_MaKhachHang.Text.Substring(2));
}//end try
catch (Exception e) {
if (e is FormatException)
{
throw new FormatException("Nhập sai Mã Khách Hàng", e);
}
}//end catch
KhachHangVO khachHangVO = new KhachHangVO();
khachHangVO.MA_KHACH_HANG = id;
khachHangVO.MA_QUOC_GIA = int.Parse(cbo_QuocGia.SelectedValue.ToString());
khachHangVO.HO_KHACH_HANG = txt_HoKhachHang.Text;
khachHangVO.TEN_KHACH_HANG = txt_TenKhachHang.Text;
khachHangVO.CMND = txt_TenKhachHang.Text;
khachHangVO.HO_CHIEU = txt_HoChieu.Text;
khachHangVO.DIEN_THOAI = txt_DienThoai.Text;
khachHangVO.HIEU_LUC = true;
return(khachHangVO);
}
public int InsertAndGetID(KhachHangVO kh)
{
try {
return(khachHangDAO.InsertBySP(kh));
}//end try
catch {
throw;
} //end catch
} //end method InsertAndGetID
public int Update(KhachHangVO khachHangVO)
{
try
{
return(khachHangDAO.Update(khachHangVO));
}
catch (Exception e)
{
throw e;
}
}
public int Insert(KhachHangVO khachHangVO)
{
try
{
return(khachHangDAO.Insert(khachHangVO));
}
catch (Exception e)
{
throw e;
}
}
private KhachHangVO GetKhachHangVO()
{
KhachHangVO khachHangVO = new KhachHangVO();
khachHangVO.MA_KHACH_HANG = int.Parse(txt_MaKhachHang.Text.Substring(2));
khachHangVO.MA_QUOC_GIA = int.Parse(cbo_QuocGia.SelectedValue.ToString());
khachHangVO.HO_KHACH_HANG = txt_HoKhachHang.Text;
khachHangVO.TEN_KHACH_HANG = txt_TenKhachHang.Text;
khachHangVO.CMND = txt_TenKhachHang.Text;
khachHangVO.HO_CHIEU = txt_HoChieu.Text;
khachHangVO.DIEN_THOAI = txt_DienThoai.Text;
khachHangVO.HIEU_LUC = true;
return(khachHangVO);
}
public DataTable SearchByIndicator(KhachHangVO khachHangVO, bool bMKH, bool bMaQG, bool bHo, bool bTen, bool bCMND, bool bHochieu, bool bDienThoai)
{
string query = " SELECT 'KH' + REPLACE(STR(MA_KHACH_HANG,4),' ','0') AS MaKH," +
"'QG' + REPLACE(STR(MA_QUOC_GIA,2),' ','0') AS MaQG," +
"HO_KHACH_HANG,TEN_KHACH_HANG,CMND,HO_CHIEU,DIEN_THOAI " +
"FROM KHACH_HANG " +
"WHERE HIEU_LUC = '1'";
if (bMKH)
{
query = query + " AND MA_KHACH_HANG = @MA_KHACH_HANG";
}
if (bMaQG)
{
query = query + " AND MA_QUOC_GIA = @MA_QUOC_GIA";
}
if (bHo)
{
query = query + " AND HO_KHACH_HANG = @HO_KHACH_HANG";
}
if (bTen)
{
query = query + " AND TEN_KHACH_HANG = @TEN_KHACH_HANG";
}
if (bHochieu)
{
query = query + " AND HO_CHIEU = @HO_CHIEU";
}
if (bCMND)
{
query = query + " AND CMND = @CMND";
}
if (bDienThoai)
{
query = query + " AND DIEN_THOAI = @DIEN_THOAI";
}
SqlParameter[] sqlParameters = new SqlParameter[7];
sqlParameters[0] = new SqlParameter("@Ma_KHACH_HANG", khachHangVO.MA_KHACH_HANG);
sqlParameters[1] = new SqlParameter("@MA_QUOC_GIA", khachHangVO.MA_QUOC_GIA);
sqlParameters[2] = new SqlParameter("@HO_KHACH_HANG", khachHangVO.HO_KHACH_HANG);
sqlParameters[3] = new SqlParameter("@TEN_KHACH_HANG", khachHangVO.TEN_KHACH_HANG);
sqlParameters[4] = new SqlParameter("@HO_CHIEU", khachHangVO.HO_CHIEU);
sqlParameters[5] = new SqlParameter("@CMND", khachHangVO.CMND);
sqlParameters[6] = new SqlParameter("@DIEN_THOAI", khachHangVO.DIEN_THOAI);
return(Program.DBConnection.ExecuteSelectQuery(query, sqlParameters));
}
private void btt_Search_Click(object sender, EventArgs e)
{
try {
KhachHangVO khachHangVO = GetKhachHangVO();
DataTable dtTable = new DataTable();
dtTable = khachhangBUS.GetKhachHangByIndicator(khachHangVO, chk_MaKhachHang.Checked, chk_MaQG.Checked, chk_HoKhachHang.Checked, chk_TenKhachHang.Checked, chk_CMND.Checked, chk_HoCHieu.Checked, chk_DienThoai.Checked);
if (dtTable.Rows.Count == 0)
{
MessageBox.Show("Không tìm thấy khách hàng");
}
grdCtrlKhachHang.DataSource = dtTable;
}//end try
catch (FormatException ex) {
MessageBox.Show(ex.Message);
} //end catch
} //end method btt_Search_Click
public int Insert(KhachHangVO khachHangVO)
{
try
{
String query = "INSERT INTO KHACH_HANG VALUES(@MA_QUOC_GIA,@HO_KHACH_HANG,@TEN_KHACH_HANG,@CMND,@HO_CHIEU,@DIEN_THOAI,@HIEU_LUC)";
SqlParameter[] sqlParameters = new SqlParameter[7];
sqlParameters[0] = new SqlParameter("@MA_QUOC_GIA", khachHangVO.MA_QUOC_GIA);
sqlParameters[1] = new SqlParameter("@HO_KHACH_HANG", khachHangVO.HO_KHACH_HANG);
sqlParameters[2] = new SqlParameter("@TEN_KHACH_HANG", khachHangVO.TEN_KHACH_HANG);
sqlParameters[3] = new SqlParameter("@CMND", khachHangVO.CMND);
sqlParameters[4] = new SqlParameter("@HO_CHIEU", khachHangVO.HO_CHIEU);
sqlParameters[5] = new SqlParameter("@DIEN_THOAI", khachHangVO.DIEN_THOAI);
sqlParameters[6] = new SqlParameter("@HIEU_LUC", khachHangVO.HIEU_LUC);
return(Program.dbConnection.ExecuteNonQuery(query, sqlParameters));
}
catch (Exception e)
{
throw e;
}
}
public int Update(KhachHangVO khachHangVO)
{
try
{
String query = "UPDATE KHACH_HANG SET MA_QUOC_GIA=@MA_QUOC_GIA,HO_KHACH_HANG=@HO_KHACH_HANG,TEN_KHACH_HANG=@TEN_KHACH_HANG,CMND=@CMND,HO_CHIEU=@HO_CHIEU,DIEN_THOAI=@DIEN_THOAI WHERE MA_KHACH_HANG=@MA_KHACH_HANG";
SqlParameter[] sqlParameters = new SqlParameter[7];
sqlParameters[0] = new SqlParameter("@MA_KHACH_HANG", khachHangVO.MA_KHACH_HANG);
sqlParameters[1] = new SqlParameter("@MA_QUOC_GIA", khachHangVO.MA_QUOC_GIA);
sqlParameters[2] = new SqlParameter("@HO_KHACH_HANG", khachHangVO.HO_KHACH_HANG);
sqlParameters[3] = new SqlParameter("@TEN_KHACH_HANG", khachHangVO.TEN_KHACH_HANG);
sqlParameters[4] = new SqlParameter("@CMND", khachHangVO.CMND);
sqlParameters[5] = new SqlParameter("@HO_CHIEU", khachHangVO.HO_CHIEU);
sqlParameters[6] = new SqlParameter("@DIEN_THOAI", khachHangVO.DIEN_THOAI);
return(Program.dbConnection.ExecuteNonQuery(query, sqlParameters));
}
catch (Exception e)
{
throw e;
}
}
} //end method LoadFind
public int InsertBySP(KhachHangVO kh)
{
try {
String sp = "SP_INSERT_CUSTOMER";
SqlParameter[] param = new SqlParameter[7];
// Output parameter
param[0] = new SqlParameter("@IDENTITY", kh.MA_KHACH_HANG);
param[0].Direction = ParameterDirection.Output;
param[1] = new SqlParameter("@MA_QUOC_GIA", kh.MA_QUOC_GIA);
param[2] = new SqlParameter("@HO_KHACH_HANG", kh.HO_KHACH_HANG);
param[3] = new SqlParameter("@TEN_KHACH_HANG", kh.TEN_KHACH_HANG);
param[4] = new SqlParameter("@CMND", kh.CMND);
param[5] = new SqlParameter("@HO_CHIEU", kh.HO_CHIEU);
param[6] = new SqlParameter("@DIEN_THOAI", kh.DIEN_THOAI);
return((int)Program.DBConnection.ExecuteSPReturnsID(sp, param));
}//end try
catch {
throw;
} //end catch
} //end method InsertBySP
public DataTable GetKhachHangByIndicator(KhachHangVO khachHangVO, bool bMKH, bool bMaQG, bool bHo, bool bTen, bool bCMND, bool bHochieu, bool bDienThoai)
{
return(khachHangDAO.SearchByIndicator(khachHangVO, bMKH, bMaQG, bHo, bTen, bCMND, bHochieu, bDienThoai));
}
