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);; }