public List <Modelo.Telefone> Select(string Id) { Modelo.Telefone aTelefone; List <Modelo.Telefone> aListTelefone = new List <Modelo.Telefone>(); SqlConnection conn = new SqlConnection(connectionString); conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "Select * from Telefone Where Id = @Id"; cmd.Parameters.AddWithValue("@Id", Id); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { aTelefone = new Modelo.Telefone( Convert.ToInt32(dr["Id"].ToString()), dr["Nome"].ToString() ); aListTelefone.Add(aTelefone); } } dr.Close(); conn.Close(); return(aListTelefone); }
public List <Modelo.Telefone> SelectAll() { Modelo.Telefone aTelefone; List <Modelo.Telefone> aListTelefone = new List <Modelo.Telefone>(); SqlConnection conn = new SqlConnection(connectionString); conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "Select * from Telefone"; SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { aTelefone = new Modelo.Telefone( Convert.ToInt32(dr["Id"].ToString()), dr["Numero"].ToString() ); aListTelefone.Add(aTelefone); } } dr.Close(); conn.Close(); return(aListTelefone); }
public void Delete(Modelo.Telefone obj) { SqlConnection conn = new SqlConnection(connectionString); conn.Open(); SqlCommand com = conn.CreateCommand(); SqlCommand cmd = new SqlCommand("DELETE FROM Telefone WHERE Id = @Id", conn); cmd.Parameters.AddWithValue("@Id", obj.Id); cmd.ExecuteNonQuery(); }
public void Update(Modelo.Telefone obj) { SqlConnection conn = new SqlConnection(connectionString); conn.Open(); SqlCommand com = conn.CreateCommand(); SqlCommand cmd = new SqlCommand("UPDATE Telefone SET Numero = @Numero WHERE Id = @Id", conn); cmd.Parameters.AddWithValue("@Id", obj.Id); cmd.Parameters.AddWithValue("@Numero", obj.Numero); cmd.ExecuteNonQuery(); }
public void Insert(Modelo.Telefone obj) { SqlConnection conn = new SqlConnection(connectionString); conn.Open(); SqlCommand com = conn.CreateCommand(); SqlCommand cmd = new SqlCommand("INSERT INTO Telefone (Id, Numero) VALUES (@Id, @Numero)", conn); cmd.Parameters.AddWithValue("@Id", obj.Id); cmd.Parameters.AddWithValue("@Numero", obj.Numero); cmd.ExecuteNonQuery(); }