public List<VisitorBooksEntry> getAllVisitorsBookData() { List<VisitorBooksEntry> visitorsBookEntryList = new List<VisitorBooksEntry>(); try { using(SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["museum.Properties.Settings.museumConnectionString"].ConnectionString)) { connection.Open(); string sqlString = "SELECT * FROM Visitorsbook"; SqlCommand command = new SqlCommand(sqlString, connection); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { var vbe = new VisitorBooksEntry(); vbe.id = (int)reader["id"]; vbe.name = (string)reader["name"]; vbe.text = (string)reader["text"]; visitorsBookEntryList.Add(vbe); } } } catch (SqlException sql){ MessageBox.Show("The data from the visitors book could not be collected." + sql); } return visitorsBookEntryList; }
public bool addVisitorMessage(VisitorBooksEntry entry) { try{ using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["museum.Properties.Settings.museumConnectionString"].ConnectionString)) { connection.Open(); string sqlQuery = "INSERT INTO visitorsbook (text,name) VALUES (@text,@name)"; SqlCommand command = new SqlCommand(sqlQuery, connection); command.Parameters.AddWithValue("@text", entry.text); command.Parameters.AddWithValue("@name", entry.name); int oe = command.ExecuteNonQuery(); } }catch(SqlException sql){ MessageBox.Show("The entry could not be inserted" + sql); return false; } return true; }
private void dynamicallyCreateControl(VisitorBooksEntry vbe) { /*we build in the designer the prototype, then we copy it here since we want this to be created dynamically and then we erase the prototype*/ GroupBox messageGroupBox = new GroupBox(); Label visitorsBookNameTag = new Label(); Label visitorsBookMessageTag = new Label(); Label visitorsBookMessage = new Label(); Label visitorsBookName = new Label(); messageGroupBox.AutoSize = true; messageGroupBox.Controls.Add(visitorsBookNameTag); messageGroupBox.Controls.Add(visitorsBookMessage); messageGroupBox.Controls.Add(visitorsBookMessageTag); messageGroupBox.Controls.Add(visitorsBookName); //splitContainer1.BackColor = System.Drawing.Color.Gainsboro; messageGroupBox.Dock = System.Windows.Forms.DockStyle.Top; splitContainer1.Panel1.Controls.Add(messageGroupBox); messageGroupBox.Name = "messageGroupBox"; messageGroupBox.Size = new System.Drawing.Size(1023, 86); messageGroupBox.TabIndex = 4; messageGroupBox.TabStop = false; messageGroupBox.Text = "Μήνυμα Επισκέπτη"; messageGroupBox.MouseEnter += new System.EventHandler(this.messageGroupBox_MouseEnter); // // visitorsBookNameTag // visitorsBookNameTag.AutoSize = true; visitorsBookNameTag.Location = new System.Drawing.Point(29, 33); visitorsBookNameTag.Name = "visitorsBookNameTag"; visitorsBookNameTag.Size = new System.Drawing.Size(38, 13); visitorsBookNameTag.TabIndex = 0; visitorsBookNameTag.Text = "Name:"; // // visitorsBookMessageTag // visitorsBookMessageTag.AutoSize = true; visitorsBookMessageTag.Location = new System.Drawing.Point(29, 57); visitorsBookMessageTag.Name = "visitorsBookMessageTag"; visitorsBookMessageTag.Size = new System.Drawing.Size(56, 13); visitorsBookMessageTag.TabIndex = 1; visitorsBookMessageTag.Text = "Message :"; // // visitorsBookName // visitorsBookName.AutoSize = true; visitorsBookName.Location = new System.Drawing.Point(106, 33); visitorsBookName.Name = "visitorsBookName"; visitorsBookName.Size = new System.Drawing.Size(35, 13); visitorsBookName.TabIndex = 2; visitorsBookName.Text = vbe.name; visitorsBookName.MaximumSize = new Size(900, 0); // // visitorsBookMessage // visitorsBookMessage.AutoSize = true; visitorsBookMessage.Location = new System.Drawing.Point(106, 57); visitorsBookMessage.Name = "visitorsBookMessage"; visitorsBookMessage.Size = new System.Drawing.Size(35, 13); visitorsBookMessage.TabIndex = 3; visitorsBookMessage.Text = vbe.text; visitorsBookMessage.MaximumSize = new Size(900, 0); }
private void visitorBookButtonSend_Click(object sender, EventArgs e) { var message = visitorMessageBox.Text; var entry = new VisitorBooksEntry(); entry.text = message; entry.name = Globals.currentUser.name + " " + Globals.currentUser.last; if (visitorDao.addVisitorMessage(entry)) { MessageBox.Show("Message entered successfully!"); /*load the message in the upper part of the form*/ dynamicallyCreateControl(entry); } }