private void closeButton_Click(object sender, EventArgs e)
{
this.Hide();
PreviousOrderList frm = new PreviousOrderList();
frm.Show();
}
private void btnWorkOrder_Click(object sender, EventArgs e)
{
this.Hide();
PreviousOrderList frm = new PreviousOrderList();
frm.Show();
}
public void GetData2()
{
try
{
con = new SqlConnection(cs.DBConn);
con.Open();
cmd = new SqlCommand("SELECT RTRIM(ImportOrderNo),RTRIM(OrderDate),RTRIM(LCNumber),RTRIM(LCDate),RTRIM(InvoiceNumber),RTRIM(InvoiceDate),RTRIM(PackingListNo) from ImportOrder order by ImportOrderNo desc", con);
rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
PreviousOrderList afrm = new PreviousOrderList();
afrm.dataGridView1.Rows.Clear();
while (rdr.Read() == true)
{
afrm.dataGridView1.Rows.Add(rdr[0], rdr[1], rdr[2], rdr[3], rdr[4], rdr[5], rdr[6]);
}
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void button1_Click(object sender, EventArgs e)
{
if (txtImportOrderNo.Text == "")
{
MessageBox.Show("Please type Purchase Order", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtImportOrderNo.Focus();
return;
}
if (invoiceNumberTextBox.Text == "")
{
MessageBox.Show("Please type Invoice No", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
invoiceNumberTextBox.Focus();
return;
}
if (packingListNoTextBox.Text == "")
{
MessageBox.Show("Please type Packing List No", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
packingListNoTextBox.Focus();
return;
}
try
{
con = new SqlConnection(cs.DBConn);
con.Open();
string ct = "select ImportOrderNo from ImportOrder where ImportOrderNo='" + txtImportOrderNo.Text + "'";
cmd = new SqlCommand(ct);
cmd.Connection = con;
rdr = cmd.ExecuteReader();
if (rdr.Read())
{
MessageBox.Show("This Import Order Already Exists", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtImportOrderNo.Text = "";
txtImportOrderNo.Focus();
if ((rdr != null))
{
rdr.Close();
}
return;
}
con = new SqlConnection(cs.DBConn);
con.Open();
string cb = "insert into ImportOrder(ImportOrderNo,OrderDate,LCNumber,LCDate,InvoiceNumber,InvoiceDate,PackingListNo,OrderStatus,ReceiveStatus,OrderByUId,OrderEntryDate) VALUES (@d1,@d2,@d3,@d4,@d5,@d6,@d7,@d8,@d9,@d10,@d11)";
cmd = new SqlCommand(cb);
cmd.Connection = con;
cmd.Parameters.AddWithValue("@d1", txtImportOrderNo.Text);
cmd.Parameters.AddWithValue("@d2", Convert.ToDateTime(importOrderDate.Value, System.Globalization.CultureInfo.GetCultureInfo("hi-IN").DateTimeFormat));
cmd.Parameters.AddWithValue("@d3", lcNumberTextBox.Text);
cmd.Parameters.AddWithValue("@d4", Convert.ToDateTime(lcDate.Value, System.Globalization.CultureInfo.GetCultureInfo("hi-IN").DateTimeFormat));
cmd.Parameters.AddWithValue("@d5", invoiceNumberTextBox.Text);
cmd.Parameters.AddWithValue("@d6", Convert.ToDateTime(invoiceDate.Value, System.Globalization.CultureInfo.GetCultureInfo("hi-IN").DateTimeFormat));
cmd.Parameters.AddWithValue("@d7", packingListNoTextBox.Text);
cmd.Parameters.AddWithValue("@d8", "NewOrder");
cmd.Parameters.AddWithValue("@d9", "NewOrder");
cmd.Parameters.AddWithValue("@d10", submittedBy);
cmd.Parameters.AddWithValue("@d11", System.DateTime.UtcNow.ToLocalTime());
cmd.ExecuteReader();
con.Close();
con = new SqlConnection(cs.DBConn);
con.Open();
string cty4 = "select Name from Registration where UserId='" + submittedBy + "'";
cmd = new SqlCommand(cty4);
cmd.Connection = con;
rdr = cmd.ExecuteReader();
if (rdr.Read())
{
fullName = (rdr.GetString(0));
}
MessageBox.Show("Successfully Submitted.", "Record", MessageBoxButtons.OK, MessageBoxIcon.Information);
Reset3();
this.Dispose();
this.Hide();
PreviousOrderList frm = new PreviousOrderList();
frm.GetData2();
frm.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
