/// <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); }
/// <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); }
/// <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; } }