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