public KhachHangInfo KhachHang_GetItem(int KhachHangID) { SQLDataHelper SQLDB = new SQLDataHelper(); SQLDB.Addparameter("@KhachHangID", KhachHangID); SqlDataReader rd = SQLDB.executereader("sp_KhachHang_GetItem", CommandType.StoredProcedure); KhachHangInfo item = null; while (rd.Read()) { item = new KhachHangInfo(); item.KhachHangID = int.Parse(rd["KhachHangID"].ToString()); item.HoTen = rd["HoTen"].ToString(); item.DiaChi = rd["DiaChi"].ToString(); item.DienThoai = rd["DienThoai"].ToString(); item.CMND = rd["CMND"].ToString(); item.NgaySinh = rd["NgaySinh"].ToString(); item.NoiSinh = rd["NoiSinh"].ToString(); item.SoVisa = rd["SoVisa"].ToString(); item.ThoiHanVisa = rd["ThoiHanVisa"].ToString(); item.NguoiTiepNhan = rd["NguoiTiepNhan"].ToString(); item.NgayNhapCanh = rd["NgayNhapCanh"].ToString(); item.TamTruTuNgay = rd["TamTruTuNgay"].ToString(); item.TamTruDenNgay = rd["TamTruDenNgay"].ToString(); item.QuocTichID = int.Parse(rd["QuocTichID"].ToString()); item.GioiTinh = int.Parse(rd["GioiTinh"].ToString()); } return item; }
public List<KhachHangInfo> KhachHang_GetItemsInPhong([Optional, DefaultParameterValue(0)] int PhongID) { SQLDataHelper SQLDB = new SQLDataHelper(); SQLDB.Addparameter("@PhongID", PhongID); SqlDataReader rd = SQLDB.executereader("sp_KhachHang_GetItemsInPhong", CommandType.StoredProcedure); List<KhachHangInfo> list = new List<KhachHangInfo>(); KhachHangInfo item = null; while (rd.Read()) { item = new KhachHangInfo(); item.KhachHangID = int.Parse(rd["KhachHangID"].ToString()); item.HoTen = rd["HoTen"].ToString(); item.DiaChi = rd["DiaChi"].ToString(); item.DienThoai = rd["DienThoai"].ToString(); item.CMND = rd["CMND"].ToString(); item.GioiTinh = int.Parse(rd["GioiTinh"].ToString()); list.Add(item); } return list; }