public static KhachHang GetChiTietKhachHang(int IDKhachHang)
{
DataTable dt = new Data.QuanLyVe.KhachHang().GetChiTietKhachHang(IDKhachHang);
if ((dt != null) && (dt.Rows.Count > 0))
{
KhachHang objKH = new KhachHang();
DataRow dr = dt.Rows[0];
// [IDKhachHang]
// ,[TenKhachHang]
// ,[DiaChi]
// ,[NguoiLienHe]
// ,[DienThoai]
// ,[MaNhanVienQuanLy]
// ,[NgayKyKet]
objKH.IDKhachHang = int.Parse(dr["IDKhachHang"].ToString());
objKH.TenKhachHang = dr["TenKhachHang"].ToString();
objKH.DiaChi = dr["DiaChi"].ToString();
objKH.NguoiLienHe = dr["NguoiLienHe"].ToString();
objKH.DienThoai = dr["DienThoai"].ToString();
objKH.MaNhanVienQuanLy = dr["MaNhanVienQuanLy"].ToString();
objKH.NgayKyKet = DateTime.Parse(dr["NgayKyKet"].ToString());
return(objKH);
}
return(null);;
}
/// <summary>
/// lay ds khach hang
/// neu TenKhachHang !=null thi lay theo ten
/// if la null thi lay tat ca
/// </summary>
/// <param name="TenKhachHang"></param>
/// <returns></returns>
public static List <KhachHang> GetDSKhachHang(string TenKhachHang)
{
DataTable dt;
if (TenKhachHang.Length > 0)
{
dt = new Data.QuanLyVe.KhachHang().GetDSKhachHang(TenKhachHang);
}
else
{
dt = new Data.QuanLyVe.KhachHang().GetDSKhachHang();
}
List <KhachHang> listKhachHang = new List <KhachHang>();
if ((dt != null) && (dt.Rows.Count > 0))
{
foreach (DataRow dr in dt.Rows)
{
KhachHang objKH = new KhachHang();
// [IDKhachHang]
// ,[TenKhachHang]
// ,[DiaChi]
// ,[NguoiLienHe]
// ,[DienThoai]
// ,[MaNhanVienQuanLy]
// ,[NgayKyKet]
objKH.IDKhachHang = int.Parse(dr["IDKhachHang"].ToString());
objKH.TenKhachHang = dr["TenKhachHang"].ToString();
objKH.DiaChi = dr["DiaChi"].ToString();
objKH.NguoiLienHe = dr["NguoiLienHe"].ToString();
objKH.DienThoai = dr["DienThoai"].ToString();
objKH.MaNhanVienQuanLy = dr["MaNhanVienQuanLy"].ToString();
objKH.NgayKyKet = DateTime.Parse(dr["NgayKyKet"].ToString());
listKhachHang.Add(objKH);
}
}
return(listKhachHang);;
}
