public SchoolMessageFrm()
{
InitializeComponent();
stu = studao.read(4);
school = schodao.FindOne(stu.getSchoolID());
listView1.View = View.Details;
// Allow the user to edit item text.
listView1.LabelEdit = true;
// Allow the user to rearrange columns.
listView1.AllowColumnReorder = true;
// Display check boxes.
listView1.CheckBoxes = true;
// Select the item and subitems when selection is made.
listView1.FullRowSelect = true;
// Display grid lines.
listView1.GridLines = true;
// Sort the items in the list in ascending order.
listView1.Sorting = SortOrder.Ascending;
listView1.Columns.Add("AUTHOR", -2, HorizontalAlignment.Left);
listView1.Columns.Add("MESSAGE", -2, HorizontalAlignment.Left);
List<Message> list = mesdao.findAllSchool(1);
ListViewItem item;
foreach (Message m in list)
{
item = new ListViewItem(m.Autor.getForename(), 1);
item.SubItems.Add(m.MessageDetail);
listView1.Items.AddRange(new ListViewItem[] { item });
}
}
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 School FindOne(int id)
{
OracleCommand command = new OracleCommand("Select * from Message where School.id=" + id + ")", Connection);
OracleDataReader reader;
reader = command.ExecuteReader();
reader.Read();
StudentDAOImpl studentDao = new StudentDAOImpl();
List<Message> list = new List<Message>();
School school = new School((int)reader.GetOracleNumber(0), reader.GetString(1), list);
return school;
}
