private void PrtExpDocClickHandler(object sender, EventArgs e)
{
MgmtRpts rpt = new MgmtRpts();
rpt.WindowState = FormWindowState.Maximized;
rpt.rptName = "DocExpiring";
rpt.Show();
}
private void btnPreview_Click(object sender, EventArgs e)
{
if (rdoMonthly.Checked == true && cboMonthly.SelectedIndex == -1)
{
MessageBox.Show("Please select month.", Application.ProductName);
return;
}
if (rdoQtrly.Checked == true && cboQtrly.SelectedIndex == -1)
{
MessageBox.Show("Please select quarter.", Application.ProductName);
return;
}
DataTable dtActual = GISClass.Financials.GetActualAmount(Convert.ToInt16(cboFY.Text));
decimal nBudget = 0;
Int16 nMonth = 1; Int16 nQ = 1;
for (int i = 0; i < dtActual.Rows.Count; i++)
{
if (Convert.ToInt16(dtActual.Rows[i]["BSCode"]) == 4)
{
nBudget = 0;
DataRow[] foundRows;
foundRows = dtFile.Select("AcctID = " + dtActual.Rows[i]["AccountID"]);
if (foundRows.Length > 0)
{
for (int j = 1; j <= 12; j++)
{
nBudget += Convert.ToDecimal(foundRows[0]["MonthBudget" + j.ToString("00")]);
}
}
dtActual.Rows[i]["Budget"] = nBudget;
}
}
MgmtRpts rpt = new MgmtRpts();
if (rdoYTD.Checked == true)
{
rpt.rptName = "VarianceYTD";
nMonth = Convert.ToInt16(DateTime.Now.Month);
}
else if (rdoMonthly.Checked == true)
{
rpt.rptName = "VarianceMonthly";
nMonth = Convert.ToInt16(cboMonthly.SelectedIndex + 1);
}
else if (rdoQtrly.Checked == true)
{
rpt.rptName = "VarianceQtrly";
nQ = Convert.ToInt16(cboQtrly.SelectedIndex + 1);
}
rpt.nYr = Convert.ToInt16(cboFY.Text);
rpt.nMo = nMonth;
rpt.nQtr = nQ;
rpt.dtRpt = dtActual;
try
{
rpt.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
