Example #1
0
        /// <summary>
        /// F34100_ the get AglandUseDetails.
        /// </summary>
        /// <param name="AglandID">The TIF id.</param>
        /// <returns>The TIFDistrict dataset.</returns>
        public static F34100AglandUseData F34100_GetAglandDetails(int AglandID)
        {
            F34100AglandUseData AglandData = new F34100AglandUseData();
            Hashtable           ht         = new Hashtable();

            //DataSet ds = new DataSet();
            ht.Add("@AglandID", AglandID);
            string[] tableNames = new string[] { AglandData.AglandUseDataTable.TableName, AglandData.AglandTypeDataTable.TableName, AglandData.AglandMethodDataTable.TableName };
            Utility.LoadDataSet(AglandData, "f39100_pcget_AglandUse", ht, tableNames);
            return(AglandData);
        }
Example #2
0
        /// <summary>
        /// Populates the TIF District fund detais.
        /// </summary>
        private void PopulateAgLandUseDetails()
        {
            this.pageLoadStatus = true;
            this.AglandUseData.Clear();
            //this.AglandUseData.AglandMethodDataTable.Clear();
            //this.AglandUseData.AglandTypeDataTable.Clear();
            this.AglandUseData.AglandUseDataTable.Clear();

            //this.TIFId = this.keyId;
            this.AglandUseData = this.form39100Controll.WorkItem.F34100_GetAglandDetails(this.keyId);
            int rollYear;

            //this.MethodData.Merge(this.AglandUseData.AglandMethodDataTable);
            //this.TypeData.Merge(this.AglandUseData.AglandTypeDataTable);
            int.TryParse(this.RollYearTextBox.Text, out rollYear);
            /// used for the display of combobox after leave active control
            if (this.AglandUseData.AglandMethodDataTable.Rows.Count > 0)
            {
                this.MethodComboBox.DataSource    = this.AglandUseData.AglandMethodDataTable;
                this.MethodComboBox.DisplayMember = this.AglandUseData.AglandMethodDataTable.AglandMethodColumn.ColumnName.ToString();
                this.MethodComboBox.ValueMember   = this.AglandUseData.AglandMethodDataTable.AglandMethodIDColumn.ColumnName.ToString();
            }
            else
            {
                this.MethodComboBox.SelectedIndex = -1;
            }

            if (this.AglandUseData.AglandTypeDataTable.Rows.Count > 0)
            {
                /// used for the display of combobox after leave active control

                this.TypeComboBox.DataSource    = this.AglandUseData.AglandTypeDataTable;
                this.TypeComboBox.DisplayMember = this.AglandUseData.AglandTypeDataTable.AglandTypeColumn.ColumnName.ToString();
                this.TypeComboBox.ValueMember   = this.AglandUseData.AglandTypeDataTable.AglandTypeIDColumn.ColumnName.ToString();
            }
            else
            {
                this.TypeComboBox.SelectedIndex = -1;
            }
            //// load the form f27081 using keyid and userid
            if (this.AglandUseData.AglandUseDataTable.Rows.Count > 0)
            {
                this.RollYearTextBox.Text    = this.AglandUseData.AglandUseDataTable.Rows[0][this.AglandUseData.AglandUseDataTable.RollYearColumn.ColumnName].ToString();
                this.UseTextBox.Text         = this.AglandUseData.AglandUseDataTable.Rows[0][this.AglandUseData.AglandUseDataTable.UseColumn.ColumnName].ToString();
                this.DescriptionTextBox.Text = this.AglandUseData.AglandUseDataTable.Rows[0][this.AglandUseData.AglandUseDataTable.DescriptionColumn.ColumnName].ToString();
                decimal factorValue;
                decimal.TryParse(this.AglandUseData.AglandUseDataTable.Rows[0][this.AglandUseData.AglandUseDataTable.FactorColumn.ColumnName].ToString(), out factorValue);
                factorValue *= 100;
                //this.BaseAdjustmentTextBox.Text = factorAdjValue.ToString();
                this.FactorTextBox.Text       = factorValue.ToString(); //this.AglandUseData.AglandUseDataTable.Rows[0][this.AglandUseData.AglandUseDataTable.FactorColumn.ColumnName].ToString();
                this.ValueTextBox.Text        = this.AglandUseData.AglandUseDataTable.Rows[0][this.AglandUseData.AglandUseDataTable.ValueColumn.ColumnName].ToString();
                this.MinimumValueTextBox.Text = this.AglandUseData.AglandUseDataTable.Rows[0][this.AglandUseData.AglandUseDataTable.MinimumValueColumn.ColumnName].ToString();
                int aglandTypeID;
                int.TryParse(this.AglandUseData.AglandUseDataTable.Rows[0][this.AglandUseData.AglandUseDataTable.AglandTypeIDColumn.ColumnName].ToString(), out aglandTypeID);
                this.TypeComboBox.SelectedValue = aglandTypeID;
                int aglandMethodID;
                int.TryParse(this.AglandUseData.AglandUseDataTable.Rows[0][this.AglandUseData.AglandUseDataTable.AglandMethodIDColumn.ColumnName].ToString(), out aglandMethodID);
                this.MethodComboBox.SelectedValue = aglandMethodID;
                this.LockControls(false);
            }
            else
            {
                this.ClearAGLANDText();
                this.LockControls(true);
            }


            this.pageMode       = TerraScanCommon.PageModeTypes.View;
            this.pageLoadStatus = false;
        }