public void delete(Modelo.AlunoDocumento obj)
{
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "DELETE FROM AlunoDocumento WHERE IdAluno=@IdAluno AND IdDocumento=@IdDocumento";
cmd.Parameters.AddWithValue("@IdDocumento", obj.idDocumento);
cmd.Parameters.AddWithValue("@IdAluno", obj.idAluno);
cmd.ExecuteNonQuery();
conn.Close();
}
public void insert(Modelo.AlunoDocumento alunoDocumento)
{
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "INSERT INTO AlunoDocumento (IdAluno,IdDocumento) VALUES (@IdAluno,@IdDocumento)";
cmd.Parameters.AddWithValue("@IdAluno", alunoDocumento.idAluno);
cmd.Parameters.AddWithValue("@IdDocumento", alunoDocumento.idDocumento);
cmd.ExecuteNonQuery();
conn.Close();
}
