private void submitButton_Click(object sender, EventArgs e) { if (listView1.Items.Count == 0) { MessageBox.Show("Please add to Chart first", "Report", MessageBoxButtons.OK, MessageBoxIcon.Error); PersonIdtextBox.Focus(); return; } _con = new SqlConnection(_cs.DBConn); string cd1 = "INSERT INTO Batch (DispatchId,UserId,BatchTime) VALUES (@d1,@d2,@d3)" + "SELECT CONVERT(int, SCOPE_IDENTITY())"; _cmd = new SqlCommand(cd1, _con); _cmd.Parameters.AddWithValue("@d1", dispatchid); _cmd.Parameters.AddWithValue("@d2", user_id); _cmd.Parameters.AddWithValue("@d3", DateTime.UtcNow.ToLocalTime()); _con.Open(); Batchid = (int)_cmd.ExecuteScalar(); _con.Close(); try { for (int i = 0; i <= listView1.Items.Count - 1; i++) { _con = new SqlConnection(_cs.DBConn); string cd = "INSERT INTO DetailsOfBatch (BatchID,PersonsId,RefNo) VALUES (@d1,@d2,@d3)"; _cmd = new SqlCommand(cd, _con); _cmd.Parameters.AddWithValue("@d1", Batchid); _cmd.Parameters.AddWithValue("@d2", listView1.Items[i].SubItems[1].Text); //_cmd.Parameters.AddWithValue("@d3", (object)listView1.Items[i].SubItems[3].Text ?? DBNull.Value); _cmd.Parameters.Add(new SqlParameter("@d3", (listView1.Items[i].SubItems[3].Text == "") ? (Object)DBNull.Value : listView1.Items[i].SubItems[3].Text)); _con.Open(); _cmd.ExecuteNonQuery(); _con.Close(); } MessageBox.Show("Successfully Submitted.", "Record", MessageBoxButtons.OK, MessageBoxIcon.Information); listView1.Items.Clear(); cmbDispatchBy.Enabled = true; cmbDispatchBy.SelectedIndex = -1; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void button1_Click(object sender, EventArgs e) { if (PersonIdtextBox.Text == "") { MessageBox.Show("You must Enter Person Id", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error); PersonIdtextBox.Focus(); return; } //if (!string.IsNullOrWhiteSpace(RefNowaterMarkTextBox.Text)) //{ // _con = new SqlConnection(_cs.DBConn); // _con.Open(); // string cd = "Update Persons set RefNo=@d1 where Persons.PersonsId='"+ PersonIdtextBox.Text +"'"; // _cmd = new SqlCommand(cd, _con); // _cmd.Parameters.AddWithValue("@d1", RefNowaterMarkTextBox.Text); // rdr = _cmd.ExecuteReader(); // _con.Close(); //} try { _con = new SqlConnection(_cs.DBConn); _con.Open(); string ct = "select PersonName from Persons where Persons.PersonsId='" + PersonIdtextBox.Text + "' "; _cmd = new SqlCommand(ct); _cmd.Connection = _con; rdr = _cmd.ExecuteReader(); if (rdr.Read()) { if (listView1.Items.Count == 0) { ListViewItem lst = new ListViewItem(); lst.SubItems.Add(PersonIdtextBox.Text); lst.SubItems.Add(rdr.GetString(0)); lst.SubItems.Add(RefNowaterMarkTextBox.Text); listView1.Items.Add(lst); PersonIdtextBox.Clear(); RefNowaterMarkTextBox.ResetText(); cmbDispatchBy.Enabled = false; return; } String Val = PersonIdtextBox.Text; if (listView1.FindItemWithText(Val) == null) { ListViewItem lst1 = new ListViewItem(); lst1.SubItems.Add(PersonIdtextBox.Text); lst1.SubItems.Add(rdr.GetString(0)); lst1.SubItems.Add(RefNowaterMarkTextBox.Text); listView1.Items.Add(lst1); PersonIdtextBox.Clear(); RefNowaterMarkTextBox.ResetText(); return; } else { MessageBox.Show("You Can Not Add Same Person Id More than one times", "error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } else { MessageBox.Show("This is not a vilid Person Id", "error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }