public List <Modelo.Sports> Select(string id)
{
Modelo.Sports aSports;
List <Modelo.Sports> aListSports = new List <Modelo.Sports>();
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "Select * from atividadeEsportiva Where id = @id";
cmd.Parameters.AddWithValue("@id", id);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
aSports = new Modelo.Sports(dr["id"].ToString(), dr["nome"].ToString(), dr["descricao"].ToString());
aListSports.Add(aSports);
}
}
dr.Close();
conn.Close();
return(aListSports);
}
public void Delete(Modelo.Sports obj)
{
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlCommand com = conn.CreateCommand();
SqlCommand cmd = new SqlCommand("DELETE FROM atividadeEsportiva WHERE id = @id", conn);
cmd.Parameters.AddWithValue("@id", obj.id);
cmd.ExecuteNonQuery();
}
public void Update(Modelo.Sports obj)
{
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlCommand com = conn.CreateCommand();
SqlCommand cmd = new SqlCommand("UPDATE atividadeEsportiva SET nome = @nome, descricao = @desc WHERE id = @id", conn);
cmd.Parameters.AddWithValue("@id", obj.id);
cmd.Parameters.AddWithValue("@nome", obj.nome);
cmd.Parameters.AddWithValue("@desc", obj.descricao);
cmd.ExecuteNonQuery();
}
public bool Insert(Modelo.Sports obj)
{
try {
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlCommand com = conn.CreateCommand();
SqlCommand cmd = new SqlCommand("INSERT INTO atividadeEsportiva VALUES(@nome, @descricao)", conn);
cmd.Parameters.AddWithValue("@nome", obj.nome);
cmd.Parameters.AddWithValue("@descricao", obj.descricao);
cmd.ExecuteNonQuery();
return(true);
}
catch
{
return(false);
}
}