public void ReloadData()
        {
            try
            {
                dgvAvailableCompanies.DataSource = null;

                List<Companies> aListCompanies = new List<Companies>();
                CompaniesBO aCompaniesBO = new CompaniesBO();
                if (afrmIns_CustomerGroups_Customers_Old != null)
                {
                    aListCompanies = aCompaniesBO.Select_All();
                    btnAdd.Visible = false;
                }
                else if(this.afrmTsk_BookingHall_Goverment != null)
                {
                    aListCompanies = aCompaniesBO.Select_ByType(Type);
                    btnAdd.Visible = false;
                }
                else if (this.afrmTsk_BookingHall_Group != null)
                {
                    aListCompanies = aCompaniesBO.Select_ByType(Type);
                    btnAdd.Visible = false;
                }
                else if (this.afrmTsk_UpdBooking != null)
                {
                    aListCompanies = aCompaniesBO.Select_ByType(Type);
                    btnAdd.Visible = false;
                }
                else
                {
                    aListCompanies = aCompaniesBO.Select_All();
                    btnAdd.Visible = true;
                }
                dgvAvailableCompanies.DataSource = aListCompanies;
            }
            catch (Exception ex)
            {
                MessageBox.Show("frmLst_Companies.ReloadData\n" + ex.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
        private void frmIns_CustomerGroups_Load(object sender, EventArgs e)
        {
            try
            {
                CompaniesBO aCompaniesBO = new CompaniesBO();
                List<Companies> aListCompanies = aCompaniesBO.Select_All();
                Companies aItem = new Companies();
                aItem.Name ="[Tất cả]";
                aItem.ID = 0;
                aListCompanies.Add(aItem);

                lueFilterCompany.Properties.DataSource = aListCompanies;
                lueFilterCompany.Properties.DisplayMember = "Name";
                lueFilterCompany.Properties.ValueMember = "ID";

                this.IsReadyInit = true;
            }
            catch (Exception ex)
            {
                MessageBox.Show("frmIns_CustomerGroups.frmIns_CustomerGroups_Load\n" + ex.Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
        private void frmUpd_CustomerGroups_Load(object sender, EventArgs e)
        {
            try
            {
                CustomerGroups aCustomerGroups = aCustomerGroupsBO.Select_ByID(IDCustomerGroups_Old);
                CompaniesBO aCompaniesBO = new CompaniesBO();
                lueCompany.Properties.DataSource = aCompaniesBO.Select_All();
                lueCompany.Properties.DisplayMember = "Name";
                lueCompany.Properties.ValueMember = "ID";
                lueCompany.EditValue = aCustomerGroups.IDCompany;
                lblIDCustomerGroup.Text = aCustomerGroups.ID.ToString();

                txtName.Text = aCustomerGroups.Name.ToString();
                cboType.Text = aCustomerGroups.Type.ToString();
                cboStatus.Text = aCustomerGroups.Status.ToString();
                cboDisable.Text = aCustomerGroups.Disable.ToString();

            }
            catch (Exception ex)
            {
                MessageBox.Show("frmEditCustomerGroup.frmEditCustomerGroup_Load\n" + ex.ToString(), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
 public void LoadIDCompanies()
 {
     try
     {
         CompaniesBO aCompaniesBO = new CompaniesBO();
         lueCompany.Properties.DataSource = aCompaniesBO.Select_All();
         lueCompany.Properties.DisplayMember = "Name";
         lueCompany.Properties.ValueMember = "ID";
     }
     catch (Exception ex)
     {
         MessageBox.Show("frmIns_CustomerGroups_Customers.LoadIDCompanies\n" + ex.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
 }
 private List<Companies> LoadListCompaniesByType()
 {
     try
     {
         CompaniesBO aCompaniesBO = new CompaniesBO();
         Companies aItem = new Companies();
         aItem.Name = "[Hiện tất cả]";
         aItem.ID = 0;
         List<Companies> aList = new List<Companies>();
         aList = aCompaniesBO.Select_All();
         aList.Add(aItem);
         return aList;
     }
     catch (Exception ex)
     {
         MessageBox.Show("frmTsk_BookingForRoom.LoadListCompaniesByType()\n" + ex.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
         return null;
     }
 }
        private void frmIns_CustomerGroups_Load(object sender, EventArgs e)
        {
            try
            {
                CompaniesBO aCompaniesBO = new CompaniesBO();
                List<Companies> aListCompanies = aCompaniesBO.Select_All();
                lueCompany.Properties.DataSource = aListCompanies;
                lueCompany.Properties.DisplayMember = "Name";
                lueCompany.Properties.ValueMember = "ID";

                if (IDCompany == 0)
                {
                    if(aListCompanies.Count > 0)
                    {
                        lueCompany.EditValue = aListCompanies[0].ID;
                    }
                }
                else
                {
                    lueCompany.Enabled = false;
                    lueCompany.EditValue = IDCompany;
                }

            }
            catch (Exception ex)
            {
                MessageBox.Show("frmIns_CustomerGroups.frmIns_CustomerGroups_Load\n" + ex.Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
        //Ngoc da sua lai ten ham 26/12/2014
        public List<BookingRStatusPayViewEN> GetListBookingRByStatus(DateTime? From, DateTime? To, int? CustomerType, string StatusPay)
        {
            List<sp_BookingRsExt_GetInfo_ByTime_ByCustomerType_ByStatusPay_Result> aListTemp = new List<sp_BookingRsExt_GetInfo_ByTime_ByCustomerType_ByStatusPay_Result>();
            aListTemp = aDatabaseDA.sp_BookingRsExt_GetInfo_ByTime_ByCustomerType_ByStatusPay(From, To, CustomerType, StatusPay).ToList();

            List<BookingRStatusPayViewEN> aListReturn = new List<BookingRStatusPayViewEN>();
            BookingRStatusPayViewEN aBookingRStatusPayViewEN;
            CompaniesBO aCompaniesBO = new CompaniesBO();
            List<Companies> aListCompaniesTemp = aCompaniesBO.Select_All();

            BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
            List<BookingRooms> aListBookingRoomTemp = aBookingRoomsBO.Select_All();

            for (int i = 0; i < aListTemp.Count; i++)
            {
                aBookingRStatusPayViewEN = new BookingRStatusPayViewEN();
                aBookingRStatusPayViewEN.IDBookingR = aListTemp[i].BookingRs_ID;
                aBookingRStatusPayViewEN.CreatedDate = aListTemp[i].BookingRs_CreatedDate;
                aBookingRStatusPayViewEN.Customer_Name = aListTemp[i].Customers_Name;
                aBookingRStatusPayViewEN.Subject = aListTemp[i].BookingRs_Subject;
                aBookingRStatusPayViewEN.IDCustomer = aListTemp[i].Customers_ID;
                aBookingRStatusPayViewEN.IDCustomerGroup = aListTemp[i].CustomerGroups_ID;
                aBookingRStatusPayViewEN.BookingRs_Status = aListTemp[i].BookingRs_Status;
                aBookingRStatusPayViewEN.CustomerGroups_Name = aListTemp[i].CustomerGroups_Name;
                int IDCompany = !String.IsNullOrEmpty(aListTemp[i].Companies_ID.ToString()) ? Convert.ToInt32(aListTemp[i].Companies_ID) : 0;
                if (aListCompaniesTemp.Where(c => c.ID == IDCompany).ToList().Count > 0)
                {
                    aBookingRStatusPayViewEN.NameCompany = aListCompaniesTemp.Where(c => c.ID == IDCompany).ToList()[0].Name;
                }
                else
                {
                    aBookingRStatusPayViewEN.NameCompany = string.Empty;
                }
                aBookingRStatusPayViewEN.StatusPay = aListTemp[i].BookingRs_StatusPay;
                aBookingRStatusPayViewEN.BookingMoney = aListTemp[i].BookingRs_BookingMoney;
                aBookingRStatusPayViewEN.Sku = aListTemp[i].Rooms_Sku;
                aBookingRStatusPayViewEN.IDBookingH = aListTemp[i].BookingRs_BookingHs_IDBookingH;
                aBookingRStatusPayViewEN.BookingHs_Status = aListTemp[i].BookingHs_Status;
                aBookingRStatusPayViewEN.BookingHs_StatusPay = aListTemp[i].BookingHs_StatusPay;
                aBookingRStatusPayViewEN.BookingHs_Type = aListTemp[i].BookingHs_Type;
                aBookingRStatusPayViewEN.BookingHs_Disable = aListTemp[i].BookingHs_Disable;
                aBookingRStatusPayViewEN.BookingHs_Subject = aListTemp[i].BookingHs_Subject;

                List<BookingRooms> aListBookingRooms = aListBookingRoomTemp.Where(br => br.IDBookingR == aListTemp[i].BookingRs_ID && br.CodeRoom == aListTemp[i].Rooms_Code).ToList();
                if (aListBookingRooms.Count > 0)
                {
                    switch (aListBookingRooms[0].Status)
                    {
                        case 3:
                            aBookingRStatusPayViewEN.BookingRoomStatusPayDisplay = "Đã check in";
                            break;
                        case 5:
                            aBookingRStatusPayViewEN.BookingRoomStatusPayDisplay = "Pending";
                            break;
                        case 7:
                            aBookingRStatusPayViewEN.BookingRoomStatusPayDisplay = "Đã check out nhưng chưa thanh toán";
                            break;
                        case 8:
                            aBookingRStatusPayViewEN.BookingRoomStatusPayDisplay = "Đã thanh toán";
                            break;
                        default:
                            aBookingRStatusPayViewEN.BookingRoomStatusPayDisplay = "Chưa xác định";
                            break;
                    }
                    aBookingRStatusPayViewEN.IDBookingRoom = aListBookingRooms[0].ID;
                    aBookingRStatusPayViewEN.BookingRooms_CodeRoom = aListBookingRooms[0].CodeRoom;
                    aBookingRStatusPayViewEN.CheckInActual = aListBookingRooms[0].CheckInActual;
                    aBookingRStatusPayViewEN.CheckOut = aListBookingRooms[0].CheckOutPlan;
                }

                switch (aBookingRStatusPayViewEN.StatusPay)
                {
                    case 1:
                        aBookingRStatusPayViewEN.BookingRStatusPayDisplay = "Chưa thanh toán";
                        break;
                    case 2:
                        aBookingRStatusPayViewEN.BookingRStatusPayDisplay = "Tạm ứng";
                        break;
                    case 3:
                        aBookingRStatusPayViewEN.BookingRStatusPayDisplay = "Đã thanh toán";
                        break;
                    default:
                        aBookingRStatusPayViewEN.BookingRStatusPayDisplay = "Chưa xác định";
                        break;
                }
                switch (aListTemp[i].BookingRs_CustomerType)
                {
                    case 1:
                        aBookingRStatusPayViewEN.CustomerTypeDisplay = "Nhà nước";
                        break;
                    case 2:
                        aBookingRStatusPayViewEN.CustomerTypeDisplay = "Khách đoàn";
                        break;
                    case 3:
                        aBookingRStatusPayViewEN.CustomerTypeDisplay = "Khách lẻ";
                        break;
                    case 4:
                        aBookingRStatusPayViewEN.CustomerTypeDisplay = "Khách vãng lai";
                        break;
                    case 5:
                        aBookingRStatusPayViewEN.CustomerTypeDisplay = "Khách bộ ngoại giao";
                        break;
                    default:
                        aBookingRStatusPayViewEN.CustomerTypeDisplay = "Chưa xác định";
                        break;
                }
                aListReturn.Add(aBookingRStatusPayViewEN);

            }
            return aListReturn;
        }