public Boolean AddSchoolMessage(Message message,School school) { MessageDAO mesdao = new MessageDAO(); mesdao.InsertMessage(message); OracleCommand command = new OracleCommand("Insert into SCHOOLMESSAGE values( message_seg.currval,"+ school.Id +")", connection); OracleDataReader reader; reader = command.ExecuteReader(); return command.ExecuteNonQuery() > 0; }
public Boolean InsertMessage(Message message) { string connectionString = GetConnectionStringA("sw4", "sw4"); using (OracleConnection connection = new OracleConnection()) { connection.ConnectionString = connectionString; connection.Open(); OracleCommand command = new OracleCommand("Insert into Message values(message_seq.nextval," + message.Autor.getStudentID() + "," + message.MessageDetail + ")", connection); connection.Close(); return command.ExecuteNonQuery() > 0; } }