public List <Modelo.Areas> SelectAll()
{
Modelo.Areas aArea;
List <Modelo.Areas> aListAreas = new List <Modelo.Areas>();
SqlConnection conn = new SqlConnection(connectionstring);
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "Select * from area_Esportiva";
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
aArea = new Modelo.Areas(dr["id"].ToString(),
dr["nome"].ToString(),
dr["descricao"].ToString()
);
aListAreas.Add(aArea);
}
}
dr.Close();
conn.Close();
return(aListAreas);
}
public void Delete(Modelo.Areas obj)
{
SqlConnection conn = new SqlConnection(connectionstring);
conn.Open();
SqlCommand com = conn.CreateCommand();
SqlCommand cmd = new SqlCommand("DELETE FROM area_Esportiva WHERE ID = @id", conn);
cmd.Parameters.AddWithValue("@id", obj.id);
cmd.ExecuteNonQuery();
}
public bool Insert(Modelo.Areas obj)
{
try
{
SqlConnection conn = new SqlConnection(connectionstring);
conn.Open();
SqlCommand com = conn.CreateCommand();
SqlCommand cmd = new SqlCommand("INSERT INTO area_Esportiva (nome,descricao) VALUES(@nome,@descricao)", conn);
cmd.Parameters.AddWithValue("@nome", obj.nome); cmd.Parameters.AddWithValue("@descricao", obj.desc);
cmd.ExecuteNonQuery();
return(true);
}
catch
{
return(false);
}
}
