Example #1
0
        /// <summary>
        /// F9503_s the get sub fund management details.
        /// </summary>
        /// <param name="subFundId">The sub fund id.</param>
        /// <returns>DataSet F9503SubFungMgmtData </returns>
        public static F9503SubFundManagementData F9503_GetSubFundManagementDetails(int?subFundId)
        {
            F9503SubFundManagementData subFundMgmtData = new F9503SubFundManagementData();
            Hashtable ht = new Hashtable();

            ht.Add("@SubFundID", subFundId);
            //Added another type datatable for returning configurwed state by purushotham
            string[] tableName = new string[] { subFundMgmtData.ConfiguredState.TableName, subFundMgmtData.ListSubFundIds.TableName, subFundMgmtData.ListSubFundType.TableName, subFundMgmtData.SubFundDetails.TableName, subFundMgmtData.ListDisbursementHistory.TableName };
            Utility.LoadDataSet(subFundMgmtData, "f9503_pcget_SubFund", ht, tableName);
            return(subFundMgmtData);
        }
Example #2
0
        /// <summary>
        /// F19503_s the get sub fund items.
        /// </summary>
        /// <param name="subFund">The sub fund.</param>
        /// <param name="rollYear">The roll year.</param>
        /// <returns>subfund itmes</returns>
        public static F9503SubFundManagementData F9503_GetSubFundItems(string subFund, short rollYear)
        {
            F9503SubFundManagementData subFundMgmtData = new F9503SubFundManagementData();
            Hashtable ht = new Hashtable();

            ht.Add("@SubFund", subFund);
            if (rollYear != -1)
            {
                ht.Add("@RollYear", rollYear);
            }
            else
            {
                ht.Add("@RollYear", DBNull.Value);
            }

            Utility.LoadDataSet(subFundMgmtData.getSubFundItems, "f9503_pcget_SubfundDetail", ht);
            return(subFundMgmtData);
        }
Example #3
0
        /// <summary>
        /// Handles the Validating event of the AccountingSubFundTextBox control.
        /// </summary>
        /// <param name="sender">The source of the event.</param>
        /// <param name="e">The <see cref="T:System.ComponentModel.CancelEventArgs"/> instance containing the event data.</param>
        private void AccountingSubFundTextBox_Validating(object sender, CancelEventArgs e)
        {
            try
            {
                ////check with last entered subfund
                if (!String.IsNullOrEmpty(this.AccountingSubFundTextBox.Text.Trim()) && this.subFundModified)
                {
                    this.subFundModified = false;
                    F9503SubFundManagementData subFundManagement = new F9503SubFundManagementData();
                    ////dbcall for subfund - rollyear default 0 for cash account
                    subFundManagement = this.form1531Control.WorkItem.F9503_GetSubFundItems(this.AccountingSubFundTextBox.Text.Trim(), 0);

                    ////get description and sunfund
                    if (subFundManagement.getSubFundItems.Rows.Count > 0)
                    {
                        this.DescriptionTextBox.Text = subFundManagement.getSubFundItems.Rows[0][subFundManagement.getSubFundItems.DescriptionColumn].ToString();
                        this.subFundId = Convert.ToInt32(subFundManagement.getSubFundItems.Rows[0][subFundManagement.getSubFundItems.SubFundIDColumn]);
                    }
                    else
                    {
                        ////assign invalid value
                        this.subFundId = -999;
                    }
                }
            }
            catch (SoapException ex)
            {
                ExceptionManager.ManageException(ex, ExceptionManager.ActionType.CloseCurrentForm, this);
            }
            catch (InvalidCastException ex)
            {
                ExceptionManager.ManageException(ex, ExceptionManager.ActionType.CloseCurrentForm, this);
            }
            catch (Exception ex)
            {
                ExceptionManager.ManageException(ex, ExceptionManager.ActionType.CloseCurrentForm, this);
            }
            finally
            {
                this.Cursor = Cursors.Default;
            }
        }