private void backgroundWorker1_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e) { shippingDate = richTxtSendingDate.Text.Trim(); cmd = new SqlCommand("Update_ReturnReportHeader", parentForm1.conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Clear(); cmd.Parameters.Add("@Seq", SqlDbType.Int).Value = 1; cmd.Parameters.Add("@rrID", SqlDbType.BigInt).Value = RRID; cmd.Parameters.Add("@rrShippingDate", SqlDbType.NVarChar).Value = shippingDate; cmd.Parameters.Add("@rrSubmitDate", SqlDbType.DateTime).Value = DateTime.Now; cmd.Parameters.Add("@rrReturnedDate", SqlDbType.DateTime).Value = DateTime.Now; cmd.Parameters.Add("@rrTrackingNumber", SqlDbType.NVarChar).Value = totalTrackingNumber; cmd.Parameters.Add("@rrReturnTotalAmount", SqlDbType.Money).Value = 0; cmd.Parameters.Add("@rrReceivingTotalAmount", SqlDbType.Money).Value = 0; cmd.Parameters.Add("@rrConfirmationID", SqlDbType.NVarChar).Value = "N/A"; cmd.Parameters.Add("@rrStatus", SqlDbType.NVarChar).Value = "SUBMITTED"; cmd.Parameters.Add("@rrFirstContact", SqlDbType.NVarChar).Value = "N/A"; parentForm1.conn.Open(); cmd.ExecuteNonQuery(); parentForm1.conn.Close(); MessageBox.Show("SUCCESSFULLY SUBMITTED !", "INFORMATION", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); parentForm3.RRShippingDate = shippingDate; parentForm3.RRTrackingNumber = totalTrackingNumber; parentForm3.dataGridView2.Enabled = false; parentForm3.btnSelectAll.Enabled = false; parentForm3.btnAdd.Enabled = false; parentForm3.btnReset2.Enabled = false; parentForm3.btnSaveReturnReport.Enabled = false; parentForm3.btnDelete.Enabled = false; parentForm3.lblReturnReportStatus.Text = "SUBMITTED"; if (this.parentForm2 != null) { if (this.parentForm2.dataGridView1.RowCount != 0) { parentForm2.SearchReturnReportList(); } } }
private void btnOK_Click(object sender, EventArgs e) { if (txtStartDate.Text == "") { MessageBox.Show("SELECT START DATE", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); txtStartDate.SelectAll(); txtStartDate.Focus(); return; } if (txtEndDate.Text == "") { MessageBox.Show("SELECT END DATE", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); txtEndDate.SelectAll(); txtEndDate.Focus(); return; } if (DateTime.TryParse(txtStartDate.Text, out d)) { } else { MessageBox.Show("INVALID DATE", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); txtStartDate.SelectAll(); txtStartDate.Focus(); return; } if (DateTime.TryParse(txtEndDate.Text, out d)) { } else { MessageBox.Show("INVALID DATE", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); txtEndDate.SelectAll(); txtEndDate.Focus(); return; } if (option == 2) { if (rdoBtnCreateDate.Checked == true) { parentForm3.dateOption = 0; } else if (rdoBtnReceiveDate.Checked == true) { parentForm3.dateOption = 1; } parentForm3.startDate = txtStartDate.Text.ToString(); parentForm3.endDate = txtEndDate.Text.ToString(); parentForm3.SearchAllReturnReportList(); } else { if (rdoBtnCreateDate.Checked == true) { parentForm2.dateOption = 0; } else if (rdoBtnReceiveDate.Checked == true) { parentForm2.dateOption = 1; } parentForm2.startDate = txtStartDate.Text.ToString(); parentForm2.endDate = txtEndDate.Text.ToString(); if (option == 0) { parentForm2.SearchReturnReportList(); } else if (option == 1) { parentForm2.SearchAllReturnReportList(); } } this.Close(); }