public List <PopsRating> list()
{
string sql = "select avg(rating_pos), id_pop from pops_rating group by id_pop";
DataTable registos = DB.Instance.devolveConsulta(sql);
List <PopsRating> lista = new List <PopsRating> ();
foreach (DataRow data in registos.Rows)
{
PopsRating novo = new PopsRating();
novo.id_pop = int.Parse(data[1].ToString());
novo.rating_pos = int.Parse(data[0].ToString());
lista.Add(novo);
}
return(lista);
}
public void create(PopsRating novo)
{
string sql = @"INSERT INTO pops_rating(id_user, id_pop, rating_pos)
VALUES (@id_user,@id_pop, @rating_pos)";
List <SqlParameter> parametros = new List <SqlParameter> ()
{
new SqlParameter()
{
ParameterName = "@id_user", SqlDbType = SqlDbType.Int, Value = novo.id_user
},
new SqlParameter()
{
ParameterName = "@id_pop", SqlDbType = SqlDbType.Int, Value = novo.id_pop
},
new SqlParameter()
{
ParameterName = "@rating_pos", SqlDbType = SqlDbType.Int, Value = novo.rating_pos
},
};
DB.Instance.executaComando(sql, parametros);
}
