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