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