private void ReturnNumberCustomer(sp_Get_Status_ListRooms_In_Month_Result tempt, ref RptRoomStatusEN retItem)
        {
            if (tempt.BookingRs_PayMethod == 4) // Bao cap
            {
                if (tempt.Company_Type == 5) //Khách bộ ngoại giao
                {
                    retItem.NumberCustomer = retItem.NumberCustomer + 1;
                    retItem.Text =  Convert.ToString(retItem.NumberCustomer) + "B";
                }
                else  // Tat cac cac khach bao cap khac
                {
                    retItem.NumberCustomer = retItem.NumberCustomer + 1;
                    retItem.Text = Convert.ToString(retItem.NumberCustomer) + "b";
                }
            }
            else if (tempt.BookingRs_PayMethod == 1) // Tu tra
            {
                if (tempt.Company_Type == 5) //Khách bộ ngoại giao
                {

                    retItem.NumberCustomer = retItem.NumberCustomer + 1;
                    retItem.Text = Convert.ToString(retItem.NumberCustomer) + "T";

                }
                else  // Tat cac cac khach bao cap khac
                {
                    retItem.NumberCustomer = retItem.NumberCustomer + 1;
                    retItem.Text = Convert.ToString(retItem.NumberCustomer) + "t";

                }
            }
        }
        private List<RptRoomStatusEN> GetTextInReport(List<sp_Get_Status_ListRooms_In_Month_Result> aListData, int Day, List<Rooms> aListAllRoom)
        {
            List<sp_Get_Status_ListRooms_In_Month_Result> tempt = new List<sp_Get_Status_ListRooms_In_Month_Result>();
            List<RptRoomStatusEN> ListRet = new List<RptRoomStatusEN>();
            RptRoomStatusEN retItem = new RptRoomStatusEN();

            for (int i = 0; i < aListAllRoom.Count; i++)
            {
                tempt = new List<sp_Get_Status_ListRooms_In_Month_Result>();
                tempt = aListData.Where(p => p.Rooms_Code == aListAllRoom[i].Code).Where(p => p.DayIndex == Day).ToList();

                retItem = new RptRoomStatusEN();
                retItem.DateIndex = Day;
                if (tempt.Count <= 0)
                {
                    retItem.RoomSku = aListAllRoom[i].Sku;
                    ListRet.Insert(ListRet.Count, retItem);
                }
                if (tempt.Count > 0)
                {
                    retItem.RoomSku = tempt[0].Rooms_Sku;
                    for (int ii = 0; ii < tempt.Count; ii++)
                    {
                        ReturnNumberCustomer(tempt[ii], ref retItem); // Xac dinh chu T/t, B/b
                        // Kiem tra neu la ngay dau tien checkIn thi set den viec di som
                        if (tempt[0].BookingRooms_CheckInActual.GetValueOrDefault().Day == Day)
                        {
                            if (tempt[0].BookingRooms_AddTimeStart > 0)
                            {
                                retItem.Text = "(" + retItem.Text;
                            }
                            else
                            {
                                retItem.Text = "|" + retItem.Text;
                            }
                        }
                        if (tempt[ii].BookingRooms_CheckOutActual.GetValueOrDefault().Day == Day)
                        {
                            if (tempt[ii].BookingRooms_AddTimeEnd > 0)
                            {
                                retItem.Text = retItem.Text + ")";
                            }
                            else
                            {
                                retItem.Text = retItem.Text + "|";
                            }
                        }

                        retItem.ListCustomers.Add("[" + tempt[ii].Company_Name + "] [" + tempt[ii].CustomerGroups_Name + "] [" + tempt[ii].Customers_Name + "]");
                        retItem.ListIDBookingR.Add(tempt[ii].BookingRs_ID);
                        retItem.ListIDBookingRooms.Add(tempt[ii].BookingRooms_ID);

                    }
                    ListRet.Insert(ListRet.Count, retItem);
                }
            }
            return ListRet;
        }