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