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