public InvestmentNumbers GetInvestmentNumbers()
{
string userId = UserService.GetCurrentUserId();
if (userId != null)
{
InvestmentNumbers singleItem = null;
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("dbo.Users_GetInvestmentNumbers", conn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserId", userId);
SqlDataReader reader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
while (reader.Read())
{
singleItem = Mapper3(reader);
}
}
conn.Close();
}
return(singleItem);
}
return(null);
}
private InvestmentNumbers Mapper3(SqlDataReader reader)
{
InvestmentNumbers model = new InvestmentNumbers();
int index = 0;
model.Invested = reader.GetDouble(index++);
model.Revenue = reader.GetDouble(index++);
return(model);
}