private string GetOrganizationsByBL(string BusinessLine) { var ds = FundStatus.GetOrganizationList().ToDataSet(); var org = ""; var dr_col = ds.Tables[0].Select(String.Format("BL_CD='{0}'", BusinessLine)); foreach (var dr in dr_col) { org += dr["ORG_CD"].ToString() + ","; } return(org); }
protected void btnSave_ServerClick(object sender, EventArgs e) { try { var rr = Result.Value.Split(new char[] { '|' }); for (var i = 0; i < rr.Length; i++) { var cc = rr[i].Split(new char[] { ';' }); var cnt = 1; var m1 = DateTime.Parse(cc[2] + "/2000").Month; var m2 = DateTime.Parse(cc[3] + "/2000").Month; var s = m1.ToString().Length < 2 ? "0" + m1.ToString() : m1.ToString(); while (m1 != m2) { m1 = m1 % 12 + 1; s += "," + (m1.ToString().Length < 2 ? "0" + m1.ToString() : m1.ToString()); cnt++; } var saveAllowanceReturn = FundAllowance.SaveFYAllowance(Convert.ToInt32(cc[0]), ddlFiscalYear.SelectedValue, GetDecimal(cc[1]), s, cnt, CurrentUserID); if (saveAllowanceReturn > 0) { History.InsertHistoryOnUpdateAllowance( cc[0] == "0" ? (int)HistoryActions.haAddNewAllowanceAmount : (int)HistoryActions.haUpdateAllowance, ddlFiscalYear.SelectedValue, cc[1], s, "", CurrentUserID); } } var dt = FundStatus.GetOrganizationList().ToDataSet().Tables[0]; for (var i = 0; i < dt.Rows.Count; i++) { FSSummaryReport.DataObsoleteFlag(ddlFiscalYear.SelectedValue, dt.Rows[i]["ORG_CD"].ToString()); } InitControls(); } catch (Exception ex) { AddError(ex); } finally { //if (Errors.Count > 0) // lblError.Text = GetErrors(); } }
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; } }