public frmRpt_Revenue_Rooms(DateTime From, DateTime To, int IDLang)
        {
            InitializeComponent();
            this.From = From;
            this.To = To;
            this.IDLang = IDLang;

            try
            {
                lblFrom.Text = From.ToString();
                lblTo.Text = To.ToString();
                ReportTaskBO aReportTaskBO = new ReportTaskBO();
                RoomsBO aRoomsBO = new RoomsBO();
                List<Rooms> aListRooms = aRoomsBO.Select_ByIDLang(IDLang);
                List<string> aListCodeRoom = new List<string>();
                for (int i = 0; i < aListRooms.Count; i++)
                {
                    string CodeRoom = aListRooms[i].Code;
                    aListCodeRoom.Add(CodeRoom);
                }
                List<RevenueEN> aListRevenueEN = aReportTaskBO.GetRevenueRoom(From, To, aListCodeRoom);
                this.DataSource = aListRevenueEN;

                cellSkuRoom.DataBindings.Add("Text", this.DataSource, "Sku");
                cellRevenue.DataBindings.Add("Text", this.DataSource, "Revenue","{0:0,0}");

                double TotalMoney = aListRevenueEN.Select(r => r.Revenue).Sum();
                lblRevenue.Text = String.Format("{0:0,0} (VND)",TotalMoney);
            }
            catch (Exception ex)
            {
                MessageBox.Show("frmRpt_Revenue_Rooms.frmRpt_Revenue_Rooms\n" + ex.ToString());
            }
        }
        public void LoadDataRevenueRooms(DateTime FromDate,DateTime ToDate)
        {
            try
            {
                if (FromDate >= ToDate)
                {
                    MessageBox.Show("Vui lòng nhập ngày bắt đầu kiểm tra nhỏ hơn ngày kết thúc .", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                else
                {
                    ReportTaskBO aReportTaskBO = new ReportTaskBO();
                    RoomsBO aRoomsBO = new RoomsBO();
                    List<Rooms> aListRooms = aRoomsBO.Select_ByIDLang(1);
                    List<string> aListCodeRoom = new List<string>();
                    for (int i = 0; i < aListRooms.Count; i++)
                    {
                        string CodeRoom = aListRooms[i].Code;
                        aListCodeRoom.Add(CodeRoom);
                    }
                    List<RevenueEN> aListRevenueEN = aReportTaskBO.GetRevenueRoom(this.FromDate,this.ToDate,aListCodeRoom);
                    colRevenue.DisplayFormat.FormatType = FormatType.Numeric;
                    colRevenue.DisplayFormat.FormatString = "{0:0,0}";
                    dgvRevenue.DataSource = aListRevenueEN;

                    double TotalMoney = aListRevenueEN.Select(r => r.Revenue).Sum();
                    lblTotalRevenue.Text = String.Format("{0:0,0}", TotalMoney);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("frmTsk_Calculator_Revenue.LoadDataRevenueRooms\n" + ex.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }