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