private void BindFormElements()
        {
            //Bind the Region Lookup (Zone and Woredas will be bind after selection Region)
            lkRegion.Properties.DataSource = BLL.Region.GetAllRegions().DefaultView;
            lkRegion.EditValue = regionId;

            //Bind the Receiving units Types Lookup
            InstitutionType institutionsTypes = new InstitutionType();
            institutionsTypes.LoadAll();
            institutionsTypes.Sort = "Name ASC";
            lkType.Properties.DataSource = institutionsTypes.DefaultView;
            lkType.EditValue = ruType;

            //Bind the Ownership Type Lookup
            OwnershipType ownershipTypes = new OwnershipType();
            ownershipTypes.LoadAll();
            ownershipTypes.Sort = "Name ASC";
            lkOwnership.Properties.DataSource = ownershipTypes.DefaultView;
            lkOwnership.EditValue = OwnershipType.Constants.Public;

            //Bind the Active lookup
            lkActive.Properties.ValueMember = lkActive.Properties.DisplayMember = "Column";
            lkActive.Properties.DataSource = new string[3] { "All", "Active", "InActive" };
            lkActive.ItemIndex = 0;

            //Bind the others
            LoadZones();
            lkZone.EditValue = zoneID;

            LoadWoredas();
            lkWoreda.EditValue = woredaID;

            LoadReceivingUnits();
        }
        /// <summary>
        /// Gets the receiving unit type by region and number RU.
        /// </summary>
        /// <param name="WoredaID">The woreda ID.</param>
        /// <param name="OwnershipID">The ownership ID.</param>
        /// <returns></returns>
        public static DataTable GetReceivingUnitTypeByRegionAndNumberRU(int WoredaID,int OwnershipID)
        {
            InstitutionType RUType = new InstitutionType();
            //            string query =
            //                string.Format(@"Select rt.ID,rt.Name,rt.Name+ ' (' + CAST(COUNT(ru.ID) as varchar) + ')' as Count from  Institution ru Join InstitutionType rt  on rt.ID = ru.RUType
            //                                        WHERE ru.Woreda= {0} and Ownership ={1} and ru.RUType <> {2}
            //                                        Group by rt.ID,rt.Name
            //                                        Union
            //                                        Select rt.ID,rt.Name,rt.Name +'(0)' Count from InstitutionType rt
            //                                            where rt.ID <> {2} and rt.ID  Not In (
            //                                        Select Distinct ru.RUType from  Institution ru  WHERE ru.Woreda= {0} and Ownership ={1})", WoredaID, OwnershipID,Constants.HUB);
            //The above query string is commented because it filters out the hubs assuming that the hub to hub transfer is supposed to handle the hubs.  Therefore, it's commented until we make sure the hub to hub transfer is working perfectly as it should
            var query = HCMIS.Repository.Queries.InstitutionType.SelectGetReceivingUnitTypeByRegionAndNumberRU(WoredaID, OwnershipID);

            RUType.LoadFromRawSql(query);
            return RUType.DataTable;
        }
        /// <summary>
        /// Gets the receiving unit type by region and number RU.
        /// </summary>
        /// <param name="WoredaID">The woreda ID.</param>
        /// <param name="OwnershipID">The ownership ID.</param>
        /// <returns></returns>
        public static DataTable GetReceivingUnitTypeByRegionAndNumberRU(int WoredaID, int OwnershipID)
        {
            InstitutionType RUType = new InstitutionType();
//            string query =
//                string.Format(@"Select rt.ID,rt.Name,rt.Name+ ' (' + CAST(COUNT(ru.ID) as varchar) + ')' as Count from  Institution ru Join InstitutionType rt  on rt.ID = ru.RUType
//                                        WHERE ru.Woreda= {0} and Ownership ={1} and ru.RUType <> {2}
//                                        Group by rt.ID,rt.Name
//                                        Union
//                                        Select rt.ID,rt.Name,rt.Name +'(0)' Count from InstitutionType rt
//                                            where rt.ID <> {2} and rt.ID  Not In (
//                                        Select Distinct ru.RUType from  Institution ru  WHERE ru.Woreda= {0} and Ownership ={1})", WoredaID, OwnershipID,Constants.HUB);
            //The above query string is commented because it filters out the hubs assuming that the hub to hub transfer is supposed to handle the hubs.  Therefore, it's commented until we make sure the hub to hub transfer is working perfectly as it should
            var query = HCMIS.Repository.Queries.InstitutionType.SelectGetReceivingUnitTypeByRegionAndNumberRU(WoredaID, OwnershipID);


            RUType.LoadFromRawSql(query);
            return(RUType.DataTable);
        }
        private void ReceiveingForm_Load(object sender, EventArgs e)
        {
            SetPermissions();
            LoadDecimalFormatings();
            //Bind ReceiptType
            cboReceiveType.Properties.DataSource = ReceiptType.GetAllReceiptTypesForReceive();
            cboReceiveType.EditValue = ReceiptType.CONSTANTS.STANDARD_RECEIPT;

            //Bind the Receiving units Types Lookup
            InstitutionType institutionsTypes = new InstitutionType();
            institutionsTypes.LoadAll();
            institutionsTypes.Sort = "Name ASC";
            lkType.Properties.DataSource = institutionsTypes.DefaultView;
            lkType.EditValue = InstitutionType.Constants.HEALTH_CENTER;
            //---

            //Bind the Ownership Type Lookup
            LoadOwnershipType();
            lkOwnership.EditValue = OwnershipType.Constants.Public;
            LoadReceivingUnits();
            //----------------------------
            // reset the receiving date
            dtRecDate.Value = DateTimeHelper.ServerDateTime;
            // Load the logical stores and populate the combo boxes
            //lkStoreType.Properties.DataSource = BLL.StoreType.GetStoreTypesForAUser(NewMainWindow.UserId).DefaultView;
            lkAccounts.SetupActivityEditor().SetDefaultActivity();

            // Load the possible suppliers and populate

            // Load all occupied Pallet location list for the consolidate lookup editManuf2
            repoLKConsolidate.DataSource = PalletLocation.GetAllOccupied();

            // load the receiving unit's to the combo box
            Institution rus = new Institution();
            rus.LoadAll();
            lkFacilitySelection.Properties.DataSource = rus.DefaultView;

            lkStorageType.DataSource = StorageType.AllStorageTypes;

            // bulkPalletLocationLookup.DataSource = PalletLocation.GetAllFree(StorageType.BulkStore);
            nonBulkPalletLocationLookup.DataSource = PalletLocation.GetAllFreeNonBulk();
            //OnSelectedFilterChanged(new object(), new DevExpress.XtraEditors.Controls.ChangingEventArgs(null,"Drug"));

            // load all item Units
            ItemUnit itemUnit = new ItemUnit();
            itemUnit.LoadAll();
            editUnits.DataSource = itemUnit.DefaultView;

            lkCategories.Properties.DataSource = BLL.CommodityType.GetAllTypes();
            lkCategories.ItemIndex = 0;

            // Get the default who's receiving this
            txtReceivedBy.Text = CurrentContext.LoggedInUserName;

            // for RDF, Hide the packs column on receipt
            if (BLL.Settings.IsRdfMode)
            {
                colPacks.Visible = false;
            }

            //lcDeliveryNoteCheck.Visibility = BLL.Settings.HandleDeliveryNotes ? DevExpress.XtraLayout.Utils.LayoutVisibility.Always : DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
            colPricePerPack.Visible = !BLL.Settings.HandleGRV && srm != true;
            lcRefNoInput.Visibility =
                lcRefNo.Visibility =
                    BLL.Settings.HandleGRV
                        ? DevExpress.XtraLayout.Utils.LayoutVisibility.Never
                        : DevExpress.XtraLayout.Utils.LayoutVisibility.Always;

            if (BLL.Settings.IsCenter)
            {
                colShipper.Visible = false;
                colPercentReceived.Visible = true;
                colPrintedDate.Visible = false;
                PalletizeTab.PageVisible = false;
                txtPassCode.Enabled = false;
                lcPassCode .Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
                tabReceiveTabs.TabPages[3].Text = "Step Three - Store Selection";
            }

            //Load the allowed Warehouses
            DataView PossibleWarehouses = BLL.Warehouse.getActiveWarehouseWithCluster(CurrentContext.UserId);
            lkWarehouse.Properties.DataSource = PossibleWarehouses;
            if (PossibleWarehouses.Count > 0)
            {
                lkWarehouse.EditValue = ((DataView)lkWarehouse.Properties.DataSource)[0]["ID"];
            }

            //Load IsElectronicReceiveOnly Setting
            LoadIsPOElectronicSetting();
        }
        private void BindFormElements()
        {
            // Find the next order number and write it on the order ID Field
            // The order ID is generated here in code

            DataTable tbl = BLL.CommodityType.GetAllTypes();
            tbl.Rows.Add(0, "All");
            lkCategoires.Properties.DataSource = tbl;
            //lkCategoires.ItemIndex = 0;
            lkCategoires.EditValue = 0;
            lkRequisitionType.EditValue = RequisitionType.Demand;
            // lkPeriod.Visible = false;

            //Bind the Region Lookup (Zone and Woredas will be bind after selection Region)
            lkRegion.Properties.DataSource = BLL.Region.GetAllRegions().DefaultView;
            if (!GeneralInfo.Current.IsColumnNull("Region"))
            {
                lkRegion.EditValue = GeneralInfo.Current.Region;
            }
            else
            {
                lkRegion.Properties.NullText = "Select Region";
            }
            //Bind the Receiving units Types Lookup
            InstitutionType institutionsTypes = new InstitutionType();
            institutionsTypes.LoadAll();
            institutionsTypes.Sort = "Name ASC";
            lkType.Properties.DataSource = institutionsTypes.DefaultView;
            lkType.EditValue = InstitutionType.Constants.HEALTH_CENTER;

            //Bind the Ownership Type Lookup
            LoadOwnershipType();
            lkOwnership.EditValue = OwnershipType.Constants.Public;
            LoadReceivingUnits();

            // txtRefNo.Text = Order.GetNextOrderReference();

            // bind the selected data table to the hidden grid on the CDR request screen

            LoadReceivingUnits();
            // load all the logical stores that exist in the system.
            lkModes.SetupModeEditor().SetDefaultMode();
            //if (BLL.Stores.GetDefaultStore(NewMainWindow.UserId).RowCount > 0 && !BLL.Stores.GetDefaultStore(NewMainWindow.UserId).IsColumnNull("ID"))
            //{
            //    lkModes.EditValue = BLL.Stores.GetDefaultStore(NewMainWindow.UserId).ID;
            //}
            //else
            //{
            //    lkModes.ItemIndex = 0;
            //    //lkModes.EditValue = null;
            //}
            //lkModes_EditValueChanged(null, null);
            boxSizedList.DataSource = BLL.ItemManufacturer.PackageLevelKeys;

            // Load all RRF Period
            var periods = BLL.Period.GetAllPeriods();
            lkPeriod.Properties.DataSource = periods.DefaultView;

               // requisition Type: for the Time being it is hard coded
            var requisitionTypes = Enum.GetValues(typeof(RequisitionType)).Cast<RequisitionType>()
                           .Select(e => new { Value = (int)e, Description = e.ToString() })
                           .ToList();
            //For this release - Mrach-20 remove consumption Type
            requisitionTypes.RemoveAt(requisitionTypes.IndexOf(new { Value = (int)RequisitionType.Consumption, Description = "Consumption" }));
            lkRequisitionType.Properties.DataSource = requisitionTypes;
        }
        private void LoadReceivingUnits()
        {
            BLL.Region reg = new BLL.Region();
            reg.LoadAll();
            lkRegion.Properties.DataSource = reg.DefaultView;

            BLL.InstitutionType ruType = new InstitutionType();
            ruType.Where.IsActive.Value = 1;
            ruType.Query.Load();
            lkRUType.Properties.DataSource = ruType.DefaultView;

            BLL.OwnershipType ownershipType = new OwnershipType();
            ownershipType.LoadAll();
            lkOwnership.Properties.DataSource = ownershipType.DefaultView;

            Route r = new Route();
            r.LoadAll();
            lkRoute.Properties.DataSource = r.DefaultView;
        }