Example #1
0
        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();
        }