public List <UsersPopsModel> list_user_collection(int id)
{
string sql = "SELECT * FROM users_pops where id_user like @id";
List <UsersPopsModel> lista = new List <UsersPopsModel> ();
List <SqlParameter> parametros = new List <SqlParameter> ()
{
new SqlParameter()
{
ParameterName = "@id", SqlDbType = SqlDbType.Int, Value = id
},
};
DataTable registos = DB.Instance.devolveConsulta(sql, parametros);
foreach (DataRow data in registos.Rows)
{
UsersPopsModel novo = new UsersPopsModel();
novo.id = int.Parse(data[0].ToString());
novo.id_user = int.Parse(data[1].ToString());
novo.id_pop = int.Parse(data[2].ToString());
lista.Add(novo);
}
return(lista);
}
public List <UsersPopsModel> list()
{
string sql = "SELECT * FROM users_pops";
DataTable registos = DB.Instance.devolveConsulta(sql);
List <UsersPopsModel> lista = new List <UsersPopsModel> ();
foreach (DataRow data in registos.Rows)
{
UsersPopsModel novo = new UsersPopsModel();
novo.id = int.Parse(data[0].ToString());
novo.id_user = int.Parse(data[1].ToString());
novo.id_pop = int.Parse(data[2].ToString());
lista.Add(novo);
}
return(lista);
}
public void create(UsersPopsModel novo)
{
string sql = @"INSERT INTO users_pops(id_user, id_pop) values(@id_user, @id_pop)";
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
},
};
DB.Instance.executaComando(sql, parametros);
}
public void update(UsersPopsModel novo)
{
string sql = @"UPDATE users_pops SET id_user = @id_user, id_pop=@id_pop WHERE id=@id";
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 = "@id", SqlDbType = SqlDbType.Int, Value = novo.id
},
};
DB.Instance.executaComando(sql, parametros);
}
