public void InitControls() { DataRow dr; DataSet ds; //init Business Line list: ds = FundStatus.GetBusinessLineList().ToDataSet(); if (ds == null || ds.Tables[0].Rows.Count == 0) { throw new Exception("Application error. Business Line list is missing."); } ddlBusinessLine.DataSource = ds.Tables[0]; ddlBusinessLine.DataTextField = "BLDesc"; ddlBusinessLine.DataValueField = "BL_CD"; ddlBusinessLine.DataBind(); //init Organizations list: DataTable dt; if (ScreenType == (int)FundsStatusScreenType.stFundsSearch) { dt = OrganizationsDT.Copy(); dr = dt.NewRow(); dr["ORG_CD"] = ""; dt.Rows.InsertAt(dr, 0); } else { dt = OrganizationsDT; } ddlOrganization.DataSource = dt; ddlOrganization.DataTextField = "ORG_CD"; ddlOrganization.DataValueField = "ORG_CD"; ddlOrganization.DataBind(); //init fiscal year list: ddlFiscalYear.DataSource = LoadFiscalYearList(); ddlFiscalYear.DataTextField = "Text"; ddlFiscalYear.DataValueField = "Value"; ddlFiscalYear.DataBind(); ddlFiscalYear.SelectedValue = DateTime.Now.Year.ToString(); ArrayList al; ListItem li; if (ScreenType != (int)FundsStatusScreenType.stFundSummaryReport) { //init book month list for selected fiscal year: al = new ArrayList(); if (ScreenType == (int)FundsStatusScreenType.stFundsSearch) { li = new ListItem("", ""); al.Add(li); } if (ScreenType == (int)FundsStatusScreenType.stFundsReview) { li = new ListItem("All Available", "00"); al.Add(li); } var str_month = ""; for (var i = 1; i < 13; i++) { str_month = String.Format("{0:MMMM}", DateTime.Parse((i < 10 ? "0" + i.ToString() : i.ToString()) + "/2000")); li = new ListItem(str_month, i < 10 ? "0" + i.ToString() : i.ToString()); al.Add(li); } ddlBookMonth.DataSource = al; ddlBookMonth.DataTextField = "Text"; ddlBookMonth.DataValueField = "Value"; ddlBookMonth.DataBind(); } else { lblBookMonth.Visible = false; ddlBookMonth.Visible = false; } if (ScreenType == (int)FundsStatusScreenType.stFundsReview || ScreenType == (int)FundsStatusScreenType.stFundsSearch) { //init view mode: al = new ArrayList(); li = new ListItem("Obligations", ((int)FundsReviewViewMode.fvObligations).ToString()); al.Add(li); li = new ListItem("Income", ((int)FundsReviewViewMode.fvIncome).ToString()); al.Add(li); li = new ListItem("One Time Adjustments", ((int)FundsReviewViewMode.fvOneTimeAdjustments).ToString()); al.Add(li); ddlView.DataSource = al; ddlView.DataTextField = "Text"; ddlView.DataValueField = "Value"; ddlView.DataBind(); } else { trViewSelection.Visible = false; } if (ScreenType == (int)FundsStatusScreenType.stFundsSearch) { //init Summary Functions list: ds = FundStatus.GetSummaryFunctionsList().ToDataSet(); dr = ds.Tables[0].NewRow(); dr["FUNC_CD"] = ""; ds.Tables[0].Rows.InsertAt(dr, 0); lstSumFunc.DataSource = ds.Tables[0]; lstSumFunc.DataTextField = "FUNC_CD"; lstSumFunc.DataValueField = "FUNC_CD"; lstSumFunc.DataBind(); //init all object class codes: ds = FundStatus.GetObjectClassCodeList().ToDataSet(); dr = ds.Tables[0].NewRow(); dr["OBJ_CLASS_CD"] = ""; dr["OC_DESC"] = ""; ds.Tables[0].Rows.InsertAt(dr, 0); lstOCCode.DataSource = ds.Tables[0]; lstOCCode.DataTextField = "OC_DESC"; lstOCCode.DataValueField = "OBJ_CLASS_CD"; lstOCCode.DataBind(); btnClear.Visible = true; btnEmail.Visible = true; } else { trSearchCriteria.Visible = false; } if (ScreenType == (int)FundsStatusScreenType.stFundsReview) { btnExpand.Visible = true; } if (ScreenType == (int)FundsStatusScreenType.stFundStatusReport || ScreenType == (int)FundsStatusScreenType.stFundSummaryReport) { btnSubmit.Text = "View Report"; btnSubmit.ToolTip = "View Report"; } else { btnSubmit.Text = "Search"; btnSubmit.ToolTip = "Search"; } //add client side functions: btnExcel.AddOnClick("javascript:return funds_data_to_excel(" + ScreenType.ToString() + ");"); }
public void FillControls() { try { Search.AddOnClick("return checkOrg();"); DataRow dr; var dt = FundStatus.GetBusinessLineList().ToDataSet().Tables[0]; dt.Columns[0].ReadOnly = true; ddgBLine.Table = dt; //init Organizations list: var ds = FundStatus.GetOrganizationList().ToDataSet(); if (ds == null || ds.Tables[0].Rows.Count == 0) { throw new Exception("Application error. Organization list is missing."); } dt = ds.Tables[0]; while (dt.Columns.Count != 2) { dt.Columns.RemoveAt(2); } dt.Columns[1].ReadOnly = true; ddlOrganization.Table = dt;//"ORG_CD"; //init fiscal year list: var doc = new XmlDocument(); doc.Load(Request.PhysicalApplicationPath + "FundStatus\\include\\FS_SupportedFiscalYears.xml"); dt = new DataTable(); dt.Columns.Add("Year"); foreach (XmlNode node in doc.DocumentElement.ChildNodes) { dr = dt.NewRow(); dr[0] = node.InnerText; dt.Rows.Add(dr); } var s = FiscalYear; ddlFiscalYear.Table = dt; if (s == "") { FiscalYear = DateTime.Now.Year.ToString(); } ds = FundStatus.GetBAList().ToDataSet(); if (ds == null || ds.Tables[0].Rows.Count == 0) { throw new Exception("Application error. No Budget Activity found."); } s = BudgetActivity; ddgBA.Table = ds.Tables[0]; if (s == "") { BudgetActivity = Settings.Default.Default_BUDGET_ACTIVITY; } //init book month list for selected fiscal year: dt = new DataTable(); dt.Columns.Add("BOOK_MONTH"); for (var i = 0; i < 12; i++) { dr = dt.NewRow(); dr[0] = Month[i]; dt.Rows.Add(dr); } ddlBookMonth.Table = dt; if (VMode) { //init view mode: dt = new DataTable(); dt.Columns.Add("Mode"); dr = dt.NewRow(); dr[0] = "Obligations"; dt.Rows.Add(dr); dr = dt.NewRow(); dr[0] = "Income"; dt.Rows.Add(dr); dr = dt.NewRow(); dr[0] = "One Time Adjustments"; dt.Rows.Add(dr); ddlView.Table = dt; } if (GroupFunc) { //init Report Function Group Code list: dt = FundStatus.GetReportFunctionGroupList().Tables[0]; dt.Columns[0].ReadOnly = true; lstGroupCD.Table = dt; } if (Function) { //init Summary Functions list: lstSumFunc.Table = FundStatus.GetSummaryFunctionsList().ToDataSet().Tables[0]; } if (OCC) { //init all object class codes: dt = FundStatus.GetObjectClassCodeList().ToDataSet().Tables[0]; dt.Columns[0].ReadOnly = true; lstOCCode.Table = dt; } if (CostElem) { dt = FundStatus.GetCostElemList().ToDataSet().Tables[0]; dt.Columns[0].ReadOnly = true; mgCostElem.Table = dt; } } catch (Exception ex) { lblCriteriaMsg.CssClass = "errorsum"; lblCriteriaMsg.Text = ex.Message; } }