public void LoadDLLs()
{
ddlCategoryType.DataSource = AccountCategoryType.GetDSLAccountCategoryType();
ddlCategoryType.DataValueField = "pvalue";
ddlCategoryType.DataTextField = "ptext";
ddlCategoryType.DataBind();
}
public void LoadGrid()
{
//string strWrite = "";
//int intCounter = 0;
//double dblCategoryBudget = 0;
//double dblCategoryAvailed = 0;
//double dblCategoryVariant = 0;
//double dblCategoryTotalBudget = 0;
//double dblCategoryTotalAvailed = 0;
//foreach (DataRow drCategory in AccountCategory.GetDSG().Rows)
//{
// foreach (DataRow drAccountItems in AccountBudget.GetDSGRCBudget(clsEmployee.GetRCCode(Request.Cookies["Speedo"]["UserName"].ToString()), Convert.ToInt16(ddlFiscalYear.SelectedValue), drCategory["accnt_cat_code"].ToString()).Rows)
// {
// intCounter += 1;
// strWrite += "<tr>";
// strWrite += "<td class='GridRows'>" + drAccountItems["oracle_code"] + "</td>";
// strWrite += "<td class='GridRows'>" + drAccountItems["accnt_items_name"] + "</td>";
// if (Convert.ToDouble(drAccountItems["bud_value"]) < 0)//negative
// {
// strWrite += "<td class='GridRows' style='text-align:right;'><a href='AccountBudgetAdjustmentViewer.aspx?rccode=" + clsEmployee.GetRCCode(Request.Cookies["Speedo"]["UserName"].ToString()) + "&accnt_cat_code=" + drCategory["accnt_cat_code"].ToString() + "&accnt_items_code=" + drAccountItems["accnt_items_code"] + "'>(" + (Convert.ToDouble(drAccountItems["bud_value"]) * -1).ToString("###,##0.00") + ")</a></td>";
// }
// else //positive
// {
// strWrite += "<td class='GridRows' style='text-align:right;'><a href='AccountBudgetAdjustmentViewer.aspx?rccode=" + clsEmployee.GetRCCode(Request.Cookies["Speedo"]["UserName"].ToString()) + "&accnt_cat_code=" + drCategory["accnt_cat_code"].ToString() + "&accnt_items_code=" + drAccountItems["accnt_items_code"] + "'>" + Convert.ToDouble(drAccountItems["bud_value"]).ToString("###,##0.00") + "</a></td>";
// }
// if (Convert.ToDouble(drAccountItems["availed_value"]) < 0) //negative
// {
// strWrite += "<td class='GridRows' style='text-align:right;'><a href='AccountBudgetActualsViewer.aspx?rccode=" + clsEmployee.GetRCCode(Request.Cookies["Speedo"]["UserName"].ToString()) + "&accnt_cat_code=" + drCategory["accnt_cat_code"].ToString() + "&accnt_items_code=" + drAccountItems["accnt_items_code"] + "'>(" + (Convert.ToDouble(drAccountItems["availed_value"]) * -1).ToString("###,##0.00") + ")</a></td>";
// }
// else //positive
// {
// strWrite += "<td class='GridRows' style='text-align:right;'><a href='AccountBudgetActualsViewer.aspx?rccode=" + clsEmployee.GetRCCode(Request.Cookies["Speedo"]["UserName"].ToString()) + "&accnt_cat_code=" + drCategory["accnt_cat_code"].ToString() + "&accnt_items_code=" + drAccountItems["accnt_items_code"] + "'>" + Convert.ToDouble(drAccountItems["availed_value"]).ToString("###,##0.00") + "</a></td>";
// }
// if ((Convert.ToDouble(drAccountItems["bud_value"]) - Convert.ToDouble(drAccountItems["availed_value"])) < 0) //negative
// {
// strWrite += "<td class='GridRows' style='text-align:right;'>(" + ((Convert.ToDouble(drAccountItems["bud_value"]) - Convert.ToDouble(drAccountItems["availed_value"])) * -1).ToString("###,##0.00") + ")</td>";
// }
// else //positive
// {
// strWrite += "<td class='GridRows' style='text-align:right;'>" + (Convert.ToDouble(drAccountItems["bud_value"]) - Convert.ToDouble(drAccountItems["availed_value"])).ToString("###,##0.00") + "</td>";
// }
// strWrite += "</tr>";
// strWrite += "<tr>";
// dblCategoryBudget += Convert.ToDouble(drAccountItems["bud_value"]);
// dblCategoryAvailed += Convert.ToDouble(drAccountItems["availed_value"]);
// }
// strWrite += "<td class='GridRows2' colspan='2'> " + drCategory["accnt_cat_name"].ToString() + "</td>";
// if (dblCategoryBudget < 0)
// {
// strWrite += "<td class='GridRows2' style='text-align:right;'>(" + (dblCategoryBudget * -1).ToString("###,##0.00") + ")</td>";
// }
// else
// {
// strWrite += "<td class='GridRows2' style='text-align:right;'>" + dblCategoryBudget.ToString("###,##0.00") + "</td>";
// }
// if (dblCategoryAvailed < 0)
// {
// strWrite += "<td class='GridRows2' style='text-align:right;'>(" + (dblCategoryAvailed * -1).ToString("###,##0.00") + ")</td>";
// }
// else
// {
// strWrite += "<td class='GridRows2' style='text-align:right;'>" + dblCategoryAvailed.ToString("###,##0.00") + "</td>";
// }
// if ((dblCategoryBudget - dblCategoryAvailed) < 0)
// {
// strWrite += "<td class='GridRows2' style='text-align:right;'>(" + ((dblCategoryBudget - dblCategoryAvailed) * -1).ToString("###,##0.00") + ")</td>";
// }
// else
// {
// strWrite += "<td class='GridRows2' style='text-align:right;'>" + (dblCategoryBudget - dblCategoryAvailed).ToString("###,##0.00") + "</td>";
// }
// strWrite += "</tr>";
// dblCategoryTotalBudget += dblCategoryBudget;
// dblCategoryTotalAvailed += dblCategoryAvailed;
// dblCategoryBudget = 0;
// dblCategoryAvailed = 0;
// //strWrite += "<td class='GridRows2' colspan='2'>Category 1</td>";
// //strWrite += "<td class='GridRows2' style='text-align:right;'>10,000,000</td>";
// //strWrite += "<td class='GridRows2' style='text-align:right;'>5,000,000</td>";
// //strWrite += "<td class='GridRows2' style='text-align:right;'>5,000,000</td>";
// //strWrite += "</tr>";
//}
//strWrite += "<tr>";
//strWrite += "<td class='GridRows' style='text-align:right;' colspan='2'>TOTAL</td>";
//if (dblCategoryTotalBudget < 0)
//{
// strWrite += "<td class='GridRows' style='text-align:right;'>(" + (dblCategoryTotalBudget * -1).ToString("###,##0.00") + ")</td>";
//}
//else
//{
// strWrite += "<td class='GridRows' style='text-align:right;'>" + dblCategoryTotalBudget.ToString("###,##0.00") + "</td>";
//}
//if (dblCategoryTotalAvailed < 0)
//{
// strWrite += "<td class='GridRows' style='text-align:right;'>(" + (dblCategoryTotalAvailed * -1).ToString("###,##0.00") + ")</td>";
//}
//else
//{
// strWrite += "<td class='GridRows' style='text-align:right;'>" + dblCategoryTotalAvailed.ToString("###,##0.00") + "</td>";
//}
//if ((dblCategoryTotalBudget - dblCategoryTotalAvailed) < 0)
//{
// strWrite += "<td class='GridRows' style='text-align:right;'>(" + ((dblCategoryTotalBudget - dblCategoryTotalAvailed) * -1).ToString("###,##0.00") + ")</td>";
//}
//else
//{
// strWrite += "<td class='GridRows' style='text-align:right;'>" + (dblCategoryTotalBudget - dblCategoryTotalAvailed).ToString("###,##0.00") + "</td>";
//}
//strWrite += "</tr>";
//strWrite += "<tr>";
//lblItems.Text = strWrite;
string strWrite = "";
int intCounter = 0;
double dblCategoryBudget = 0;
double dblCategoryAvailed = 0;
double dblCategoryVariant = 0;
double dblCategoryTotalBudget = 0;
double dblCategoryTotalAvailed = 0;
double dblTotalIncomeBudget = 0;
double dblTotalIncomeAvailed = 0;
double dblTotalExpensesBudget = 0;
double dblTotalExpensesAvailed = 0;
foreach (DataRow drCategoryType in AccountCategoryType.GetDSG().Rows)
{
foreach (DataRow drCategory in AccountCategory.GetDSG(drCategoryType["accnt_cat_type_code"].ToString()).Rows)
{
foreach (DataRow drAccountItems in AccountBudget.GetDSGRCBudget(clsEmployee.GetRCCode(Request.Cookies["Speedo"]["UserName"].ToString()), Convert.ToInt16(ddlFiscalYear.SelectedValue), drCategory["accnt_cat_code"].ToString()).Rows)
{
intCounter += 1;
strWrite += "<tr>";
strWrite += "<td class='GridRows'>" + drAccountItems["oracle_code"] + "</td>";
strWrite += "<td class='GridRows'>" + drAccountItems["accnt_items_name"] + "</td>";
if (Convert.ToDouble(drAccountItems["bud_value"]) < 0)//negative
{
strWrite += "<td class='GridRows' style='text-align:right;'><a href='AccountBudgetAdjustmentViewer.aspx?rccode=" + clsEmployee.GetRCCode(Request.Cookies["Speedo"]["UserName"].ToString()).ToString() + "&accnt_cat_code=" + drCategory["accnt_cat_code"].ToString() + "&accnt_items_code=" + drAccountItems["accnt_items_code"] + "'>(" + (Convert.ToDouble(drAccountItems["bud_value"]) * -1).ToString("###,##0.00") + ")</a></td>";
}
else //positive
{
strWrite += "<td class='GridRows' style='text-align:right;'><a href='AccountBudgetAdjustmentViewer.aspx?rccode=" + clsEmployee.GetRCCode(Request.Cookies["Speedo"]["UserName"].ToString()).ToString() + "&accnt_cat_code=" + drCategory["accnt_cat_code"].ToString() + "&accnt_items_code=" + drAccountItems["accnt_items_code"] + "'>" + Convert.ToDouble(drAccountItems["bud_value"]).ToString("###,##0.00") + "</a></td>";
}
if (Convert.ToDouble(drAccountItems["availed_value"]) < 0) //negative
{
strWrite += "<td class='GridRows' style='text-align:right;'><a href='AccountBudgetActualsViewer.aspx?rccode=" + clsEmployee.GetRCCode(Request.Cookies["Speedo"]["UserName"].ToString()).ToString() + "&accnt_cat_code=" + drCategory["accnt_cat_code"].ToString() + "&accnt_items_code=" + drAccountItems["accnt_items_code"] + "'>(" + (Convert.ToDouble(drAccountItems["availed_value"]) * -1).ToString("###,##0.00") + ")</a></td>";
}
else //positive
{
strWrite += "<td class='GridRows' style='text-align:right;'><a href='AccountBudgetActualsViewer.aspx?rccode=" + clsEmployee.GetRCCode(Request.Cookies["Speedo"]["UserName"].ToString()).ToString() + "&accnt_cat_code=" + drCategory["accnt_cat_code"].ToString() + "&accnt_items_code=" + drAccountItems["accnt_items_code"] + "'>" + Convert.ToDouble(drAccountItems["availed_value"]).ToString("###,##0.00") + "</a></td>";
}
if ((Convert.ToDouble(drAccountItems["bud_value"]) - Convert.ToDouble(drAccountItems["availed_value"])) < 0) //negative
{
strWrite += "<td class='GridRows' style='text-align:right;'>(" + ((Convert.ToDouble(drAccountItems["bud_value"]) - Convert.ToDouble(drAccountItems["availed_value"])) * -1).ToString("###,##0.00") + ")</td>";
}
else //positive
{
strWrite += "<td class='GridRows' style='text-align:right;'>" + (Convert.ToDouble(drAccountItems["bud_value"]) - Convert.ToDouble(drAccountItems["availed_value"])).ToString("###,##0.00") + "</td>";
}
strWrite += "</tr>";
strWrite += "<tr>";
dblCategoryBudget += Convert.ToDouble(drAccountItems["bud_value"]);
dblCategoryAvailed += Convert.ToDouble(drAccountItems["availed_value"]);
}
strWrite += "<td class='GridRows2' colspan='2'> " + drCategory["accnt_cat_name"].ToString() + "</td>";
if (dblCategoryBudget < 0)
{
strWrite += "<td class='GridRows2' style='text-align:right;'>(" + (dblCategoryBudget * -1).ToString("###,##0.00") + ")</td>";
}
else
{
strWrite += "<td class='GridRows2' style='text-align:right;'>" + dblCategoryBudget.ToString("###,##0.00") + "</td>";
}
if (dblCategoryAvailed < 0)
{
strWrite += "<td class='GridRows2' style='text-align:right;'>(" + (dblCategoryAvailed * -1).ToString("###,##0.00") + ")</td>";
}
else
{
strWrite += "<td class='GridRows2' style='text-align:right;'>" + dblCategoryAvailed.ToString("###,##0.00") + "</td>";
}
if ((dblCategoryBudget - dblCategoryAvailed) < 0)
{
strWrite += "<td class='GridRows2' style='text-align:right;'>(" + ((dblCategoryBudget - dblCategoryAvailed) * -1).ToString("###,##0.00") + ")</td>";
}
else
{
strWrite += "<td class='GridRows2' style='text-align:right;'>" + (dblCategoryBudget - dblCategoryAvailed).ToString("###,##0.00") + "</td>";
}
strWrite += "</tr>";
dblCategoryTotalBudget += dblCategoryBudget;
dblCategoryTotalAvailed += dblCategoryAvailed;
dblCategoryBudget = 0;
dblCategoryAvailed = 0;
if (drCategoryType["accnt_cat_type_code"].ToString() == "01")
{
dblTotalIncomeBudget += dblCategoryBudget;
dblTotalIncomeAvailed += dblCategoryTotalAvailed;
}
if (drCategoryType["accnt_cat_type_code"].ToString() == "02")
{
dblTotalExpensesBudget += dblCategoryBudget;
dblTotalExpensesAvailed += dblCategoryAvailed;
}
}
strWrite += "<tr>";
strWrite += "<td class='GridRows' style='text-align:right;' colspan='2'>TOTAL " + drCategoryType["accnt_cat_type_name"].ToString() + "</td>";
if (dblCategoryTotalBudget < 0)
{
strWrite += "<td class='GridRows' style='text-align:right;'>(" + (dblCategoryTotalBudget * -1).ToString("###,##0.00") + ")</td>";
}
else
{
strWrite += "<td class='GridRows' style='text-align:right;'>" + dblCategoryTotalBudget.ToString("###,##0.00") + "</td>";
}
if (dblCategoryTotalAvailed < 0)
{
strWrite += "<td class='GridRows' style='text-align:right;'>(" + (dblCategoryTotalAvailed * -1).ToString("###,##0.00") + ")</td>";
}
else
{
strWrite += "<td class='GridRows' style='text-align:right;'>" + dblCategoryTotalAvailed.ToString("###,##0.00") + "</td>";
}
if ((dblCategoryTotalBudget - dblCategoryTotalAvailed) < 0)
{
strWrite += "<td class='GridRows' style='text-align:right;'>(" + ((dblCategoryTotalBudget - dblCategoryTotalAvailed) * -1).ToString("###,##0.00") + ")</td>";
}
else
{
strWrite += "<td class='GridRows' style='text-align:right;'>" + (dblCategoryTotalBudget - dblCategoryTotalAvailed).ToString("###,##0.00") + "</td>";
}
strWrite += "</tr>";
strWrite += "<tr>";
dblCategoryTotalBudget = 0;
dblCategoryTotalAvailed = 0;
}
lblItems.Text = strWrite;
}
public void LoadGrid()
{
string strWrite = "";
int intCounter = 0;
double dblCategoryBudget = 0;
double dblCategoryAvailed = 0;
double dblCategoryVariant = 0;
double dblCategoryTotalBudget = 0;
double dblCategoryTotalAvailed = 0;
double dblTotalIncomeBudget = 0;
double dblTotalIncomeAvailed = 0;
double dblTotalExpensesBudget = 0;
double dblTotalExpensesAvailed = 0;
foreach (DataRow drCategoryType in AccountCategoryType.GetDSG().Rows)
{
foreach (DataRow drCategory in AccountCategory.GetDSG(drCategoryType["accnt_cat_type_code"].ToString()).Rows)
{
foreach (DataRow drAccountItems in AccountBudget.GetDSGRCBudget(Request.QueryString["rccode"].ToString(), Convert.ToInt16(Request.QueryString["fiscal_year_code"].ToString()), drCategory["accnt_cat_code"].ToString()).Rows)
{
intCounter += 1;
strWrite += "<tr>";
strWrite += "<td class='GridRows'>" + drAccountItems["oracle_code"] + "</td>";
strWrite += "<td class='GridRows'>" + drAccountItems["accnt_items_name"] + "</td>";
if (Convert.ToDouble(drAccountItems["bud_value"]) < 0)//negative
{
strWrite += "<td class='GridRows' style='text-align:right;'><a href='AccountBudgetAdjustment.aspx?rccode=" + Request.QueryString["rccode"].ToString() + "&accnt_cat_code=" + drCategory["accnt_cat_code"].ToString() + "&accnt_items_code=" + drAccountItems["accnt_items_code"] + "'>(" + (Convert.ToDouble(drAccountItems["bud_value"]) * -1).ToString("###,##0.00") + ")</a></td>";
}
else //positive
{
strWrite += "<td class='GridRows' style='text-align:right;'><a href='AccountBudgetAdjustment.aspx?rccode=" + Request.QueryString["rccode"].ToString() + "&accnt_cat_code=" + drCategory["accnt_cat_code"].ToString() + "&accnt_items_code=" + drAccountItems["accnt_items_code"] + "'>" + Convert.ToDouble(drAccountItems["bud_value"]).ToString("###,##0.00") + "</a></td>";
}
if (Convert.ToDouble(drAccountItems["availed_value"]) < 0) //negative
{
strWrite += "<td class='GridRows' style='text-align:right;'><a href='AccountBudgetActuals.aspx?rccode=" + Request.QueryString["rccode"].ToString() + "&accnt_cat_code=" + drCategory["accnt_cat_code"].ToString() + "&accnt_items_code=" + drAccountItems["accnt_items_code"] + "'>(" + (Convert.ToDouble(drAccountItems["availed_value"]) * -1).ToString("###,##0.00") + ")</a></td>";
}
else //positive
{
strWrite += "<td class='GridRows' style='text-align:right;'><a href='AccountBudgetActuals.aspx?rccode=" + Request.QueryString["rccode"].ToString() + "&accnt_cat_code=" + drCategory["accnt_cat_code"].ToString() + "&accnt_items_code=" + drAccountItems["accnt_items_code"] + "'>" + Convert.ToDouble(drAccountItems["availed_value"]).ToString("###,##0.00") + "</a></td>";
}
if ((Convert.ToDouble(drAccountItems["bud_value"]) - Convert.ToDouble(drAccountItems["availed_value"])) < 0) //negative
{
strWrite += "<td class='GridRows' style='text-align:right;'>(" + ((Convert.ToDouble(drAccountItems["bud_value"]) - Convert.ToDouble(drAccountItems["availed_value"])) * -1).ToString("###,##0.00") + ")</td>";
}
else //positive
{
strWrite += "<td class='GridRows' style='text-align:right;'>" + (Convert.ToDouble(drAccountItems["bud_value"]) - Convert.ToDouble(drAccountItems["availed_value"])).ToString("###,##0.00") + "</td>";
}
strWrite += "</tr>";
strWrite += "<tr>";
dblCategoryBudget += Convert.ToDouble(drAccountItems["bud_value"]);
dblCategoryAvailed += Convert.ToDouble(drAccountItems["availed_value"]);
}
strWrite += "<td class='GridRows2' colspan='2'> " + drCategory["accnt_cat_name"].ToString() + "</td>";
if (dblCategoryBudget < 0)
{
strWrite += "<td class='GridRows2' style='text-align:right;'>(" + (dblCategoryBudget * -1).ToString("###,##0.00") + ")</td>";
}
else
{
strWrite += "<td class='GridRows2' style='text-align:right;'>" + dblCategoryBudget.ToString("###,##0.00") + "</td>";
}
if (dblCategoryAvailed < 0)
{
strWrite += "<td class='GridRows2' style='text-align:right;'>(" + (dblCategoryAvailed * -1).ToString("###,##0.00") + ")</td>";
}
else
{
strWrite += "<td class='GridRows2' style='text-align:right;'>" + dblCategoryAvailed.ToString("###,##0.00") + "</td>";
}
if ((dblCategoryBudget - dblCategoryAvailed) < 0)
{
strWrite += "<td class='GridRows2' style='text-align:right;'>(" + ((dblCategoryBudget - dblCategoryAvailed) * -1).ToString("###,##0.00") + ")</td>";
}
else
{
strWrite += "<td class='GridRows2' style='text-align:right;'>" + (dblCategoryBudget - dblCategoryAvailed).ToString("###,##0.00") + "</td>";
}
strWrite += "</tr>";
dblCategoryTotalBudget += dblCategoryBudget;
dblCategoryTotalAvailed += dblCategoryAvailed;
dblCategoryBudget = 0;
dblCategoryAvailed = 0;
if (drCategoryType["accnt_cat_type_code"].ToString() == "01")
{
dblTotalIncomeBudget += dblCategoryBudget;
dblTotalIncomeAvailed += dblCategoryTotalAvailed;
}
if (drCategoryType["accnt_cat_type_code"].ToString() == "02")
{
dblTotalExpensesBudget += dblCategoryBudget;
dblTotalExpensesAvailed += dblCategoryAvailed;
}
}
strWrite += "<tr>";
strWrite += "<td class='GridRows' style='text-align:right;' colspan='2'>TOTAL " + drCategoryType["accnt_cat_type_name"].ToString() + "</td>";
if (dblCategoryTotalBudget < 0)
{
strWrite += "<td class='GridRows' style='text-align:right;'>(" + (dblCategoryTotalBudget * -1).ToString("###,##0.00") + ")</td>";
}
else
{
strWrite += "<td class='GridRows' style='text-align:right;'>" + dblCategoryTotalBudget.ToString("###,##0.00") + "</td>";
}
if (dblCategoryTotalAvailed < 0)
{
strWrite += "<td class='GridRows' style='text-align:right;'>(" + (dblCategoryTotalAvailed * -1).ToString("###,##0.00") + ")</td>";
}
else
{
strWrite += "<td class='GridRows' style='text-align:right;'>" + dblCategoryTotalAvailed.ToString("###,##0.00") + "</td>";
}
if ((dblCategoryTotalBudget - dblCategoryTotalAvailed) < 0)
{
strWrite += "<td class='GridRows' style='text-align:right;'>(" + ((dblCategoryTotalBudget - dblCategoryTotalAvailed) * -1).ToString("###,##0.00") + ")</td>";
}
else
{
strWrite += "<td class='GridRows' style='text-align:right;'>" + (dblCategoryTotalBudget - dblCategoryTotalAvailed).ToString("###,##0.00") + "</td>";
}
strWrite += "</tr>";
strWrite += "<tr>";
dblCategoryTotalBudget = 0;
dblCategoryTotalAvailed = 0;
}
lblItems.Text = strWrite;
}
