public bool LoadCommentsFromDb(string esttype, long obj) { try { MySqlConnection con = new MySqlConnection(Connect); con.Open(); MySqlCommand cmd = new MySqlCommand("SELECT Rc_id, Rc_agent, Rc_mail, Rc_data, Rc_comment from rcomments WHERE ((Rc_object = @Val1) AND (Rc_estate_type = @Val2) ORDER by Rc_data)", con); cmd.Parameters.AddWithValue("@Val1", obj); cmd.Parameters.AddWithValue("@Val2", esttype); cmd.CommandType = System.Data.CommandType.Text; MySqlDataReader reader = cmd.ExecuteReader(); DataTable result = new DataTable(); result.Load(reader); for (int i = 0; i < result.Rows.Count - 1;i++ ) { Comment cmt = new Comment(); cmt.Id = Convert.ToInt64(result.Rows[i][0]); cmt.Author = result.Rows[i][1].ToString(); cmt.Email = result.Rows[i][2].ToString(); cmt.Date = Convert.ToDateTime(result.Rows[i][3]); cmt.Text = result.Rows[i][4].ToString(); cmt.IsNew = false; CommentsList.Add(cmt); } con.Close(); return true; } catch { return false; } }
private void simpleButton3_Click(object sender, EventArgs e) { if (textBox21.Text=="") { MessageBox.Show("Текст комментария пуст.", "Внимание", MessageBoxButtons.OK); } else { Comment cmt = new Comment(); cmt.Author = Program.user.FIO; cmt.Date = DateTime.Now; cmt.Email = Program.user.email; cmt.Text = textBox21.Text; dbcomm.CommentsList.Add(cmt); dbcomm.InsertCommentInDb(dbcomm.CommentsList.Count - 1, Program.objectedit.record.Restate_type, Program.objectedit.record.Rid); ListViewItem item = new ListViewItem(); item.SubItems.Add(cmt.Author); item.SubItems.Add(cmt.Email); item.SubItems.Add(cmt.Date.ToShortDateString()); item.SubItems.Add(cmt.Text); listView1.Items.Add(item); textBox21.Text = ""; } }