public static void SuaKH(KhachHangDV kh, string so_tk)
{
DataAccess db = new DataAccess();
int gt = 0;
if (kh.gioi_tinh)
{
gt = 1;
}
SqlParameter[] Params = new SqlParameter[]
{
new SqlParameter("@cmnd", kh.cmt),
new SqlParameter("@hoten", kh.ho_ten),
new SqlParameter("@makh", kh.ma_KH),
new SqlParameter("@dienthoai", kh.dien_thoai),
new SqlParameter("@email", kh.email),
new SqlParameter("@diachi", kh.dia_chi),
new SqlParameter("@ngaysinh", kh.ngay_sinh),
new SqlParameter("@ngaycap", kh.ngay_cap),
new SqlParameter("@noicap", kh.noi_cap),
new SqlParameter("@quoctich", kh.quoc_tich),
new SqlParameter("@sotk", so_tk),
new SqlParameter("@gioitinh", gt)
};
db.dt("SuaKH", Params);
}
public static KhachHangDV TimKiemKH_TheoCMND(string cmnd)
{
DataAccess db = new DataAccess();
SqlParameter[] Params = new SqlParameter[]
{
new SqlParameter("@cmnd", cmnd)
};
DataTable dt = db.dt("DV_TimKiemKH_TheoCMND", Params);
if (dt.Rows.Count == 0)
{
return(null);
}
else
{
KhachHangDV kh = new KhachHangDV(dt.Rows[0]);
return(kh);
}
}
