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