public AccountBreakUp GetFamilyIncomeExpenditureAndSaving()
{
using (SqlConnection connection = new SqlConnection(Utilities.GetConnectionString()))
{
using (SqlCommand command = new SqlCommand("GetFamilyIncomeExpenditureAndSaving", connection))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
try
{
if (connection.State == System.Data.ConnectionState.Closed)
{
try
{
connection.Open();
SqlDataReader dr = command.ExecuteReader();
AccountBreakUp accountBreakUp = new AccountBreakUp();
if (dr.Read())
{
accountBreakUp.Income = Convert.ToInt32(dr["Income"]);
accountBreakUp.Expenditure = Convert.ToInt32(dr["Expenditure"]);
accountBreakUp.Savings = Convert.ToInt32(dr["Saving"].ToString());
}
return(accountBreakUp);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
if (connection.State == System.Data.ConnectionState.Open)
{
connection.Close();
}
}
}
}
catch (SqlException ex)
{
throw ex;
}
finally
{
if (connection.State == System.Data.ConnectionState.Open)
{
connection.Close();
}
}
}
}
return(null);
}
protected void Page_Load(object sender, EventArgs e)
{
ConsolidatedReportRepository consolidatedReportRepository =
new ConsolidatedReportRepository();
try
{
AccountBreakUp accountBreakUp = consolidatedReportRepository.GetFamilyIncomeExpenditureAndSaving();
lblIncome.Text = accountBreakUp.Income.ToString();
lblExpenditure.Text = accountBreakUp.Expenditure.ToString();
lblSavings.Text = accountBreakUp.Savings.ToString();
}
catch (Exception ex)
{
throw ex;
}
}
