protected void bindResults()
{
//clearMessages();
//resultDiv.Visible = true;
string _sb1 = "", _td1 = "", _tw1 = "", _eb1 = "";
try
{
DataSet dsresult = new DataSet();
dsresult = ImportYEBData.getYEBData(ddlYrmo.SelectedItem.Text, _sb1);
foreach (DataRow dr in dsresult.Tables[0].Rows)
{
string _type = dr["Type"].ToString();
switch (_type)
{
case "Start Balance":
_sb1 = Convert.ToDecimal(dr["Amount"]).ToString("C");
break;
case "Total Deposits":
_td1 = Convert.ToDecimal(dr["Amount"]).ToString("C");
break;
case "Total Withdrawls":
_tw1 = ((-1) * Convert.ToDecimal(dr["Amount"])).ToString("C");
break;
case "End Balance":
_eb1 = Convert.ToDecimal(dr["Amount"]).ToString("C");
break;
}
}
//if (dsresult.Tables[0].Rows.Count > 0)
//{
// //Summary
// lblSBalance.Text = _sb1;
// lblDeposits.Text = _td1;
// lblWithdrawls.Text = _tw1;
// lblEnding.Text = _eb1;
// decimal _tot1 = decimal.Parse(_sb1, System.Globalization.NumberStyles.Currency)
// + decimal.Parse(_td1, System.Globalization.NumberStyles.Currency)
// + decimal.Parse(_tw1, System.Globalization.NumberStyles.Currency);
// lblTotalV.Text = _tot1.ToString("C");
// decimal _tot2 = _tot1 - decimal.Parse(_eb1, System.Globalization.NumberStyles.Currency);
// lblFinalV.Text = _tot2.ToString("C");
// if (_tot2 != 0)
// {
// Image3.Visible = true;
// }
// else
// {
// Image1.Visible = true;
// }
// //Deposits
// decimal _dep1 =
// decimal.Parse((dsresult.Tables[0].Compute("SUM([Amount])", "[importType] = 'Detail' AND ([Type] = 'DEP' OR [Type] = 'MSCC')")).ToString(), System.Globalization.NumberStyles.Currency);
// decimal _tot3 = decimal.Parse(_td1, System.Globalization.NumberStyles.Currency) - _dep1;
// lblDep11.Text = _dep1.ToString("C");
// lblDep12.Text = _td1;
// lblDeptotal.Text = _tot3.ToString("C");
// if (_tot2 != 0)
// {
// Image5.Visible = true;
// }
// else
// {
// Image4.Visible = true;
// }
// //Deposits
// decimal _withd1 =
// decimal.Parse((dsresult.Tables[0].Compute("SUM([Amount])", "[importType] = 'Detail' AND ([Type] <> 'DEP' AND [Type] <> 'MSCC')")).ToString(), System.Globalization.NumberStyles.Currency);
// decimal _tot4 = decimal.Parse(_tw1, System.Globalization.NumberStyles.Currency) + _withd1;
// lblWithd11.Text = _withd1.ToString("C");
// lblWithd12.Text = ((-1) * decimal.Parse(_tw1, System.Globalization.NumberStyles.Currency)).ToString("C");
// lblWithdtotal.Text = _tot4.ToString("C");
// if (_tot4 != 0)
// {
// Image7.Visible = true;
// }
// else
// {
// Image6.Visible = true;
// }
//}
}
catch (Exception ex)
{
//errorDiv1.Visible = true;
//lblError1.Text = ex.Message;
}
}
