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