public List<OverNightCustomerEN> GetOverNightCustomer(DateTime CheckPoint, int Status)
        {
            List<BookingRooms> aListBookingRooms = aBookingRoomsBO.Select_ByStatus_ByTime(CheckPoint, Status);
            List<BookingRoomsMembers> aListBookingRoomsMembers = new List<BookingRoomsMembers>();
            List<OverNightCustomerEN> aListOverNightCustomer = new List<OverNightCustomerEN>();
            OverNightCustomerEN aOverNightCustomer = new OverNightCustomerEN();
            Customers aCustomers;

            // get tất cả dữ liệu
            List<int> aListIDBookingRoom = new List<int>();
            int aTemp;
            for (int i = 0; i < aListBookingRooms.Count; i++)
            {
                aTemp = new int();
                aTemp = aListBookingRooms[i].ID;
                aListIDBookingRoom.Add(aTemp);
            }
            List<string> aListCodeRoom = new List<string>();

            for (int i = 0; i < aListBookingRooms.Count; i++)
            {
                string aCode;
                aCode = aListBookingRooms[i].CodeRoom;
                aListCodeRoom.Add(aCode);
            }

            List<BookingRoomsMembers> aListAllBookingRoomsMembers = aBookingRoomsMembersBO.Select_ByListIDBookingRoom(aListIDBookingRoom);
            List<Companies> aListCompanies = aCompaniesBO.Select_ByListIDBookingRoom(aListIDBookingRoom);
            List<CustomerGroups> aListCustomerGroups = aCustomerGroupsBO.Select_ByListIDBookingRoom(aListIDBookingRoom);
            List<Rooms> aListRooms = aRoomsBO.Select_ByListCodeRoom(aListCodeRoom, 1);
            List<Customers> aListCustomers = aCustomersBO.SelectListCustomer_ByListIDBookingRoom(aListIDBookingRoom);
            List<BookingRs> aListBookingRs = aBookingRsBO.Select_ByListIDBookingRoom(aListIDBookingRoom);

            for (int i = 0; i < aListBookingRooms.Count; i++)
            {
                aListBookingRoomsMembers = aListAllBookingRoomsMembers.Where(p => p.IDBookingRoom == aListBookingRooms[i].ID).ToList();

                for (int y = 0; y < aListBookingRoomsMembers.Count; y++)
                {
                    aOverNightCustomer = new OverNightCustomerEN();

                    aCustomers = new Customers();
                    int IDCustomer = aListBookingRoomsMembers[y].IDCustomer;
                    aCustomers = aListCustomers.Where(p => p.ID == IDCustomer).ToList()[0];

                    int IDCustomerGroup = aListBookingRs.Where(p => p.ID == aListBookingRooms[i].IDBookingR).ToList()[0].IDCustomerGroup;
                    int IDCompany = aListCustomerGroups.Where(p => p.ID == IDCustomerGroup).ToList()[0].IDCompany;
                    if (IDCompany != null)
                    {
                        aOverNightCustomer.CompanyName = aListCompanies.Where(p => p.ID == IDCompany).ToList()[0].Name;
                    }

                    aOverNightCustomer.PurposeComeVietnam = aListBookingRoomsMembers[y].PurposeComeVietnam;
                    aOverNightCustomer.DateEnterCountry = aListBookingRoomsMembers[y].DateEnterCountry;
                    aOverNightCustomer.EnterGate = aListBookingRoomsMembers[y].EnterGate;
                    aOverNightCustomer.TemporaryResidenceDate = aListBookingRoomsMembers[y].TemporaryResidenceDate;
                    aOverNightCustomer.LeaveDate = aListBookingRoomsMembers[y].LeaveDate;
                    aOverNightCustomer.Organization = aListBookingRoomsMembers[y].Organization;
                    aOverNightCustomer.LimitDateEnterCountry = aListBookingRoomsMembers[y].LimitDateEnterCountry;

                    aOverNightCustomer.IDBookingRoom = aListBookingRooms[i].ID;

                    if (aListRooms.Where(p => p.Code == aListBookingRooms[i].CodeRoom).ToList()[0] != null)
                    {
                        aOverNightCustomer.Sku = aListRooms.Where(p => p.Code == aListBookingRooms[i].CodeRoom).ToList()[0].Sku;
                    }

                    if (aListBookingRs.Where(p => p.ID == aListBookingRooms[i].IDBookingR).ToList()[0] != null)
                    {
                        aOverNightCustomer.CustomerType = aListBookingRs.Where(p => p.ID == aListBookingRooms[i].IDBookingR).ToList()[0].CustomerType;
                    }
                    aOverNightCustomer.CheckInActual = aListBookingRooms[i].CheckInActual;
                    aOverNightCustomer.CheckOutPlan = aListBookingRooms[i].CheckOutPlan;
                    aOverNightCustomer.Name = aCustomers.Name;
                    aOverNightCustomer.IDCustomer = aCustomers.ID;
                    aOverNightCustomer.Identifier1 = aCustomers.Identifier1;
                    aOverNightCustomer.Identifier2 = aCustomers.Identifier2;
                    aOverNightCustomer.Identifier3 = aCustomers.Identifier3;
                    aOverNightCustomer.Nationality = aCustomers.Nationality;
                    aOverNightCustomer.Birthday = String.Format("{0:MM-dd-yyyy}", aCustomers.Birthday);
                    aOverNightCustomer.Tel = aCustomers.Tel;
                    aOverNightCustomer.Address = aCustomers.Address;
                    aOverNightCustomer.Email = aCustomers.Email;
                    aOverNightCustomer.Info = aCustomers.Info;
                    aOverNightCustomer.Gender = aCustomers.Gender;
                    aOverNightCustomer.Citizen = aCustomers.Citizen;
                    aOverNightCustomer.Identifier1CreatedDate = aCustomers.Identifier1CreatedDate;
                    aOverNightCustomer.Identifier2CreatedDate = aCustomers.Identifier2CreatedDate;
                    aOverNightCustomer.Identifier3CreatedDate = aCustomers.Identifier3CreatedDate;
                    aOverNightCustomer.PlaceOfIssue1 = aCustomers.PlaceOfIssue1;
                    aOverNightCustomer.PlaceOfIssue2 = aCustomers.PlaceOfIssue2;
                    aOverNightCustomer.PlaceOfIssue3 = aCustomers.PlaceOfIssue3;
                    aOverNightCustomer.AgencyOfIssue1 = aCustomers.AgencyOfIssue1;
                    aOverNightCustomer.AgencyOfIssue2 = aCustomers.AgencyOfIssue2;
                    aOverNightCustomer.AgencyOfIssue3 = aCustomers.AgencyOfIssue3;
                    aOverNightCustomer.CAN_BO_NM = "NVNK";
                    aOverNightCustomer.IsVietNam = "N";
                    aOverNightCustomer.Quan = "HK";
                    aOverNightCustomer.DIACHI_TT = "2 Lê Thạch";
                    aOverNightCustomer.NgayTruyen = DateTime.Now.Date.ToShortDateString();

                    aListOverNightCustomer.Add(aOverNightCustomer);
                }
            }

            return aListOverNightCustomer;
        }
        //=======================================================
        //Author: LinhTing
        //Function : Tìm danh sách khách qua đêm
        //=======================================================
        //public List<OverNightCustomerEN> GetOverNightCustomer(DateTime CheckPoint, int Status)
        //{
        //    List<BookingRooms> aListBookingRooms = aBookingRoomsBO.Select_ByStatus_ByTime(CheckPoint, Status);
        //    List<BookingRoomsMembers> aListBookingRoomsMembers = new List<BookingRoomsMembers>();
        //    List<OverNightCustomerEN> aListOverNightCustomer = new List<OverNightCustomerEN>();
        //    OverNightCustomerEN aOverNightCustomer = new OverNightCustomerEN();
        //    Customers aCustomers;
        //    string a = DateTime.Now.Ticks.ToString();
        //    for (int i = 0; i < aListBookingRooms.Count; i++)
        //    {
        //        aListBookingRoomsMembers = aBookingRoomsMembersBO.Select_ByIDBookingRoom(aListBookingRooms[i].ID);
        //        for (int y = 0; y < aListBookingRoomsMembers.Count; y++)
        //        {
        //            aOverNightCustomer = new OverNightCustomerEN();
        //            aCustomers = new Customers();
        //            int IDCustomer = aListBookingRoomsMembers[y].IDCustomer;
        //            aCustomers = aCustomersBO.Select_ByID(IDCustomer);
        //            if (aCompaniesBO.Select_ByIDBookingRoom(aListBookingRooms[i].ID) != null)
        //            {
        //                aOverNightCustomer.CompanyName = aCompaniesBO.Select_ByIDBookingRoom(aListBookingRooms[i].ID).Name;
        //            }
        //            aOverNightCustomer.PurposeComeVietnam = aListBookingRoomsMembers[y].PurposeComeVietnam;
        //            aOverNightCustomer.IDBookingRoom = aListBookingRooms[i].ID;
        //            if (aRoomsBO.Select_ByCodeRoom(aListBookingRooms[i].CodeRoom, 1) != null)
        //            {
        //                aOverNightCustomer.Sku = aRoomsBO.Select_ByCodeRoom(aListBookingRooms[i].CodeRoom, 1).Sku;
        //            }
        //            if (aBookingRsBO.Select_ByID(aListBookingRooms[i].IDBookingR) != null)
        //            {
        //                aOverNightCustomer.CustomerType = aBookingRsBO.Select_ByID(aListBookingRooms[i].IDBookingR).CustomerType;
        //            }
        //            aOverNightCustomer.CheckInActual = aListBookingRooms[i].CheckInActual;
        //            aOverNightCustomer.CheckOutPlan = aListBookingRooms[i].CheckOutPlan;
        //            aOverNightCustomer.Name = aCustomers.Name;
        //            aOverNightCustomer.IDCustomer = aCustomers.ID;
        //            aOverNightCustomer.Identifier1 = aCustomers.Identifier1;
        //            aOverNightCustomer.Identifier2 = aCustomers.Identifier2;
        //            aOverNightCustomer.Identifier3 = aCustomers.Identifier3;
        //            aOverNightCustomer.Nationality = aCustomers.Nationality;
        //            aOverNightCustomer.Birthday = aCustomers.Birthday;
        //            aOverNightCustomer.Tel = aCustomers.Tel;
        //            aOverNightCustomer.Address = aCustomers.Address;
        //            aOverNightCustomer.Email = aCustomers.Email;
        //            aOverNightCustomer.Info = aCustomers.Info;
        //            aOverNightCustomer.Gender = aCustomers.Gender;
        //            aOverNightCustomer.Citizen = aCustomers.Citizen;
        //            aOverNightCustomer.Identifier1CreatedDate = aCustomers.Identifier1CreatedDate;
        //            aOverNightCustomer.Identifier2CreatedDate = aCustomers.Identifier2CreatedDate;
        //            aOverNightCustomer.Identifier3CreatedDate = aCustomers.Identifier3CreatedDate;
        //            aOverNightCustomer.PlaceOfIssue1 = aCustomers.PlaceOfIssue1;
        //            aOverNightCustomer.PlaceOfIssue2 = aCustomers.PlaceOfIssue2;
        //            aOverNightCustomer.PlaceOfIssue3 = aCustomers.PlaceOfIssue3;
        //            aListOverNightCustomer.Add(aOverNightCustomer);
        //        }
        //    }
        //    a = a + "---" + DateTime.Now.Ticks.ToString();
        //    return aListOverNightCustomer;
        //}
        // Author : LinhTing
        // Select list khách qua đêm mới
        public List<OverNightCustomerEN> GetNewOverNightCustomer(DateTime CheckPoint, int Status)
        {
            List<BookingRooms> aListNewBookingRooms = aBookingRoomsBO.Select_ByStatus_ByTime(CheckPoint, CheckPoint.AddDays(-1), Status);
            List<BookingRoomsMembers> aListNewBookingRoomsMembers = new List<BookingRoomsMembers>();
            List<OverNightCustomerEN> aListNewOverNightCustomer = new List<OverNightCustomerEN>();
            OverNightCustomerEN aNewOverNightCustomer = new OverNightCustomerEN();
            Customers aCustomers;

            for (int i = 0; i < aListNewBookingRooms.Count; i++)
            {
                aListNewBookingRoomsMembers = aBookingRoomsMembersBO.Select_ByIDBookingRoom(aListNewBookingRooms[i].ID);

                for (int y = 0; y < aListNewBookingRoomsMembers.Count; y++)
                {
                    aNewOverNightCustomer = new OverNightCustomerEN();

                    aCustomers = new Customers();
                    int IDCustomer = aListNewBookingRoomsMembers[y].IDCustomer;
                    aCustomers = aCustomersBO.Select_ByID(IDCustomer);

                    aNewOverNightCustomer.CompanyName = aCompaniesBO.Select_ByIDBookingRoom(aListNewBookingRooms[i].ID).Name;

                    aNewOverNightCustomer.PurposeComeVietnam = aListNewBookingRoomsMembers[y].PurposeComeVietnam;
                    aNewOverNightCustomer.IDBookingRoom = aListNewBookingRooms[i].ID;

                    aNewOverNightCustomer.Sku = aRoomsBO.Select_ByCodeRoom(aListNewBookingRooms[i].CodeRoom, 1).Sku;

                    aNewOverNightCustomer.CustomerType = aBookingRsBO.Select_ByID(aListNewBookingRooms[i].IDBookingR).CustomerType;

                    aNewOverNightCustomer.CheckInActual = aListNewBookingRooms[i].CheckInActual;
                    aNewOverNightCustomer.CheckOutPlan = aListNewBookingRooms[i].CheckOutPlan;
                    aNewOverNightCustomer.Name = aCustomers.Name;
                    aNewOverNightCustomer.IDCustomer = aCustomers.ID;
                    aNewOverNightCustomer.Identifier1 = aCustomers.Identifier1;
                    aNewOverNightCustomer.Identifier2 = aCustomers.Identifier2;
                    aNewOverNightCustomer.Identifier3 = aCustomers.Identifier3;
                    aNewOverNightCustomer.Nationality = aCustomers.Nationality;
                    aNewOverNightCustomer.Birthday = String.Format("{0:MM-dd-yyyy}", aCustomers.Birthday);

                    aNewOverNightCustomer.Tel = aCustomers.Tel;
                    aNewOverNightCustomer.Address = aCustomers.Address;
                    aNewOverNightCustomer.Email = aCustomers.Email;
                    aNewOverNightCustomer.Info = aCustomers.Info;
                    aNewOverNightCustomer.Gender = aCustomers.Gender;
                    aNewOverNightCustomer.Citizen = aCustomers.Citizen;
                    aNewOverNightCustomer.Identifier1CreatedDate = aCustomers.Identifier1CreatedDate;
                    aNewOverNightCustomer.Identifier2CreatedDate = aCustomers.Identifier2CreatedDate;
                    aNewOverNightCustomer.Identifier3CreatedDate = aCustomers.Identifier3CreatedDate;
                    aNewOverNightCustomer.PlaceOfIssue1 = aCustomers.PlaceOfIssue1;
                    aNewOverNightCustomer.PlaceOfIssue2 = aCustomers.PlaceOfIssue2;
                    aNewOverNightCustomer.PlaceOfIssue3 = aCustomers.PlaceOfIssue3;
                    aNewOverNightCustomer.AgencyOfIssue1 = aCustomers.AgencyOfIssue1;
                    aNewOverNightCustomer.AgencyOfIssue2 = aCustomers.AgencyOfIssue2;
                    aNewOverNightCustomer.AgencyOfIssue3 = aCustomers.AgencyOfIssue3;

                    aListNewOverNightCustomer.Add(aNewOverNightCustomer);
                }
            }
            return aListNewOverNightCustomer;
        }