public List <AllCoins> GetAllUserCoins()
{
string userId = UserService.GetCurrentUserId();
if (userId != null)
{
List <AllCoins> CoinList = new List <AllCoins>();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("dbo.Users_GetAllCoins", conn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserId", userId);
SqlDataReader reader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
while (reader.Read())
{
AllCoins model = Mapper2(reader);
CoinList.Add(model);
}
}
conn.Close();
}
return(CoinList);
}
return(null);
}
private AllCoins Mapper2(SqlDataReader reader)
{
AllCoins model = new AllCoins();
int index = 0;
model.CoinName = reader.GetString(index++);
model.Symbol = reader.GetString(index++);
model.NumberOfCoins = reader.GetDouble(index++);
model.Id = reader.GetInt32(index++);
model.AverageValue = reader.GetDouble(index++);
index++;
return(model);
}