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