public List <KhachDatBL> GetKhachDat_Search_V2(DateTime TGTiepNhanTu, DateTime TGTiepNhanDen, string TenKhachHang, string DiaChiDon, string SoDienThoai) { try { List <KhachDatBL> lstKhachDat = new List <KhachDatBL>(); using (DataTable dt = new KhachDatDA().GetKhachDat_Search_V2(TGTiepNhanTu, TGTiepNhanDen, TenKhachHang, DiaChiDon, SoDienThoai)) { if (dt != null) { if (dt.Rows.Count <= 0) { return(null); } else { foreach (DataRow row in dt.Rows) { lstKhachDat.Add(GetKhachDat_Row(row)); } } } } return(lstKhachDat); } catch (Exception ex) { return(null); } }
/// <summary> /// Lay dữ liệu Khách đặt. theo search /// </summary> /// <param name="ThoiDiemTiepNhan"></param> /// <param name="TenKhachHang"></param> /// <param name="DiaChiDon"></param> /// <param name="SoDienThoai"></param> /// <param name="VungKenh"></param> /// <param name="IsLapLai"></param> /// <param name="GioDon"></param> /// <param name="ThoiDiemBatDau"></param> /// <param name="ThoiDiemKetThuc"></param> /// <param name="SoPhutBaoTruoc"></param> /// <returns></returns> public List <KhachDatBL> GetKhachDat_Search(DateTime TGTiepNhanTu, DateTime TGTiepNhanDen, string TenKhachHang, string DiaChiDon, string SoDienThoai, int VungKenh , int IsLapLai, DateTime GioDonTu, DateTime GioDonDen, DateTime ThoiDiemBatDau, DateTime ThoiDiemKetThuc, int SoPhutBaoTruoc, string LoaiXe, int SoLuongXe) { try { List <KhachDatBL> lstKhachDat = new List <KhachDatBL>(); using (DataTable dt = new KhachDatDA().GetKhachDat_Search(TGTiepNhanTu, TGTiepNhanDen, TenKhachHang, DiaChiDon, SoDienThoai, VungKenh, IsLapLai, GioDonTu, GioDonDen, ThoiDiemBatDau, ThoiDiemKetThuc, SoPhutBaoTruoc, LoaiXe, SoLuongXe)) { if (dt != null) { if (dt.Rows.Count <= 0) { return(null); } else { foreach (DataRow row in dt.Rows) { lstKhachDat.Add(GetKhachDat_Row(row)); } } } } return(lstKhachDat); } catch (Exception ex) { return(null); } }
/// <summary> /// lay ra tat ca thong tin khach dat theo ngay tiếp nhận /// </summary> public List <KhachDatBL> GetKhachDat_TGTiepNhan(DateTime ThoiDiemTiepNhan) { try { List <KhachDatBL> lstKhachDat = new List <KhachDatBL>(); using (DataTable dt = new KhachDatDA().GetKhachDat_TGTiepNhan(ThoiDiemTiepNhan)) { if (dt != null) { if (dt.Rows.Count <= 0) { return(null); } else { foreach (DataRow row in dt.Rows) { lstKhachDat.Add(GetKhachDat_Row(row)); } } } } return(lstKhachDat); } catch (Exception ex) { return(null); } }
/// <summary> /// lay ra tat ca thong tin khach dat theo ngay tiếp nhận /// </summary> public List <KhachDatBL> GetKhachDat_ChenCuocGoi(DateTime ThoiDiemTiepNhan) { try { List <KhachDatBL> lstKhachDat = new List <KhachDatBL>(); using (DataTable dt = new KhachDatDA().GetKhachDat_ChenCuocGoi(ThoiDiemTiepNhan)) { if (dt != null) { if (dt.Rows.Count <= 0) { return(null); } else { foreach (DataRow row in dt.Rows) { lstKhachDat.Add(GetKhachDat_Row_Line(row, "90")); } } } } return(lstKhachDat); } catch (Exception ex) { LogError.WriteLogError("GetKhachDat_ChenCuocGoi:", ex); return(null); } }
/// <summary> /// Lấy thông tin khách đặt /// </summary> /// <returns>Khách đặt Entity</returns> public KhachDatBL GetKhachDat(int PK_KhachDatID) { using (DataTable dt = new KhachDatDA().GetKhachDat(PK_KhachDatID)) { if (dt == null) { return(null); } if (dt.Rows.Count <= 0) { return(null); } return(GetKhachDat_Row(dt.Rows[0])); } }