private void btnCodesAdd_Click(object sender, EventArgs e) { try { //Open new pop up for adding the data AddRegExpStatistics popUp = new AddRegExpStatistics("", false, ""); if (popUp.ShowDialog() == System.Windows.Forms.DialogResult.OK) { var regExp = popUp.regExp; var replace = popUp.replace; var replaceText = popUp.replaceText; //Insert to database string cmdText = "INSERT INTO [RegExpStatistics] ([Regexp],[IsReplace], [ReplacementText]) VALUES (?,?,?);"; OleDbCommand cmd = new OleDbCommand(cmdText, _views.MainForm.adapterDocuments.Connection); cmd.Parameters.Add("RegExpStatistics", OleDbType.Char).Value = regExp; cmd.Parameters.Add("IsReplace", OleDbType.Boolean).Value = replace; cmd.Parameters.Add("ReplacementText", OleDbType.Char).Value = replaceText; cmd.ExecuteNonQuery(); string query2 = "Select @@Identity"; cmd.CommandText = query2; var tag = (int)cmd.ExecuteScalar(); //Add to listbox ListViewItem listItem = new ListViewItem(new[] { regExp, replace.ToString(), replaceText }); listItem.Tag = tag.ToString(); lvRegExp.Items.Add(listItem); } } catch { } }
private void btnCodesEdit_Click(object sender, EventArgs e) { try { if (lvRegExp.SelectedItems.Count > 0) { ListViewItem selectedItem = lvRegExp.SelectedItems[0]; var id = selectedItem.Tag.ToString(); var regExpFromList = selectedItem.SubItems[0].Text; var replaceT = selectedItem.SubItems[1].Text; var replaceFromList = true; if (replaceT == "False") { replaceFromList = false; } var replaceTextFromList = selectedItem.SubItems[2].Text; //Open new pop up for adding the data AddRegExpStatistics popUp = new AddRegExpStatistics(regExpFromList, replaceFromList, replaceTextFromList); if (popUp.ShowDialog() == System.Windows.Forms.DialogResult.OK) { var regExp = popUp.regExp; var replace = popUp.replace; var replaceText = popUp.replaceText; //Add to listbox lvRegExp.SelectedItems[0].SubItems[0].Text = regExp; lvRegExp.SelectedItems[0].SubItems[1].Text = replace.ToString(); lvRegExp.SelectedItems[0].SubItems[2].Text = replaceText; //Update database string cmdText = "UPDATE [RegExpStatistics] SET [Regexp] = ?,[IsReplace] = ?, [ReplacementText] = ? WHERE ID = " + id + ";"; OleDbCommand cmd = new OleDbCommand(cmdText, _views.MainForm.adapterDocuments.Connection); cmd.Parameters.Add("Regexp", OleDbType.Char).Value = regExp; cmd.Parameters.Add("IsReplace", OleDbType.Boolean).Value = replace; cmd.Parameters.Add("ReplacementText", OleDbType.Char).Value = replaceText; cmd.ExecuteNonQuery(); } } } catch { } }