private void btnConfirmation_Click(object sender, EventArgs e)
{
if (lblStatus.Text == "RETURNED")
{
MessageBox.Show("THIS RETURN IS ALREADY CONFIRMED", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
DialogResult MyDialogResult;
MyDialogResult = MessageBox.Show(this, "ARE YOU SURE?", "INFORMATION", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (MyDialogResult == DialogResult.Yes)
{
if (rrTotalReceivingAmount == 0)
{
DialogResult MyDialogResult2;
MyDialogResult2 = MessageBox.Show(this, "THIS RETURN HAS 0 RECEIVING AMOUNT. ARE YOU SURE?", "WARNING", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (MyDialogResult2 == DialogResult.Yes)
{
conn = new SqlConnection(parentForm1.OtherStoreConnectionString(rrStoreCode));
cmd = new SqlCommand("Update_ReturnReportHeader", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Seq", SqlDbType.Int).Value = 4;
cmd.Parameters.Add("@rrID", SqlDbType.BigInt).Value = rrID;
cmd.Parameters.Add("@rrShippingDate", SqlDbType.NVarChar).Value = string.Format("{0:MM/dd/yyyy}", DateTime.Today);
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 = "N/A";
cmd.Parameters.Add("@rrReturnTotalAmount", SqlDbType.Money).Value = 0;
cmd.Parameters.Add("@rrReceivingTotalAmount", SqlDbType.Money).Value = 0;
cmd.Parameters.Add("@rrConfirmationID", SqlDbType.NVarChar).Value = parentForm1.employeeID;
cmd.Parameters.Add("@rrStatus", SqlDbType.NVarChar).Value = "RETURNED";
cmd.Parameters.Add("@rrFirstContact", SqlDbType.NVarChar).Value = "N/A";
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
lblStatus.Text = "RETURNED";
lblReturnedDate.Text = string.Format("{0:MM/dd/yyyy HH:mm:ss}", DateTime.Now);
lblConfirmationID.Text = parentForm1.employeeID;
if (parentForm2.IsDisposed == false)
{
if (parentForm2.dataGridView1.RowCount == 0)
{
return;
}
parentForm2.SearchAllReturnReportList();
}
MessageBox.Show("SUCCESSFULLY CONFIRMED !", "INFORMATION", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
conn = new SqlConnection(parentForm1.OtherStoreConnectionString(rrStoreCode));
cmd = new SqlCommand("Update_ReturnReportHeader", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Seq", SqlDbType.Int).Value = 4;
cmd.Parameters.Add("@rrID", SqlDbType.BigInt).Value = rrID;
cmd.Parameters.Add("@rrShippingDate", SqlDbType.NVarChar).Value = string.Format("{0:MM/dd/yyyy}", DateTime.Today);
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 = "N/A";
cmd.Parameters.Add("@rrReturnTotalAmount", SqlDbType.Money).Value = 0;
cmd.Parameters.Add("@rrReceivingTotalAmount", SqlDbType.Money).Value = 0;
cmd.Parameters.Add("@rrConfirmationID", SqlDbType.NVarChar).Value = parentForm1.employeeID;
cmd.Parameters.Add("@rrStatus", SqlDbType.NVarChar).Value = "RETURNED";
cmd.Parameters.Add("@rrFirstContact", SqlDbType.NVarChar).Value = "N/A";
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
lblStatus.Text = "RETURNED";
lblReturnedDate.Text = string.Format("{0:MM/dd/yyyy HH:mm:ss}", DateTime.Today);
lblConfirmationID.Text = parentForm1.employeeID;
if (parentForm2.IsDisposed == false)
{
if (parentForm2.dataGridView1.RowCount == 0)
{
return;
}
parentForm2.SearchAllReturnReportList();
}
MessageBox.Show("SUCCESSFULLY CONFIRMED !", "INFORMATION", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
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();
}
private void btnDelete_Click(object sender, EventArgs e)
{
DialogResult MyDialogResult;
MyDialogResult = MessageBox.Show(this, "ARE YOU SURE?", "INFORMATION", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (MyDialogResult == DialogResult.Yes)
{
if (dataGridView1.RowCount == 1)
{
conn = new SqlConnection(parentForm1.OtherStoreConnectionString(cmRRStoreCode));
cmd = new SqlCommand("Delete_CreditMemo", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();
cmd.Parameters.Add("@seqNum", SqlDbType.BigInt).Value = Convert.ToInt64(dataGridView1.SelectedCells[0].Value);
cmd2 = new SqlCommand("Update_ReturnReportHeader", conn);
cmd2.CommandType = CommandType.StoredProcedure;
cmd2.Parameters.Add("@Seq", SqlDbType.Int).Value = 3;
cmd2.Parameters.Add("@rrID", SqlDbType.BigInt).Value = cmRRID;
cmd2.Parameters.Add("@rrShippingDate", SqlDbType.NVarChar).Value = string.Format("{0:MM/dd/yyyy}", DateTime.Today);
cmd2.Parameters.Add("@rrSubmitDate", SqlDbType.DateTime).Value = DateTime.Now;
cmd2.Parameters.Add("@rrReturnedDate", SqlDbType.DateTime).Value = DateTime.Now;
cmd2.Parameters.Add("@rrTrackingNumber", SqlDbType.NVarChar).Value = "N/A";
cmd2.Parameters.Add("@rrReturnTotalAmount", SqlDbType.Money).Value = 0;
cmd2.Parameters.Add("@rrReceivingTotalAmount", SqlDbType.Money).Value = -Convert.ToInt16(dataGridView1.SelectedCells[4].Value);
cmd2.Parameters.Add("@rrConfirmationID", SqlDbType.NVarChar).Value = "N/A";
cmd2.Parameters.Add("@rrStatus", SqlDbType.NVarChar).Value = "PROCESSING";
cmd2.Parameters.Add("@rrFirstContact", SqlDbType.NVarChar).Value = "N/A";
conn.Open();
cmd.ExecuteNonQuery();
cmd2.ExecuteNonQuery();
conn.Close();
Bind_DataGridview();
parentForm3.Show_CreditMemo_Count(cmRRID, cmRRStoreCode);
parentForm3.rrTotalReceivingAmount = creditMemoAmount;
parentForm3.lblTotalReceivingAmount.Text = string.Format("{0:c}", parentForm3.rrTotalReceivingAmount);
parentForm3.lblStatus.Text = "PROCESSING";
if (parentForm2.IsDisposed == false)
{
if (parentForm2.dataGridView1.RowCount == 0)
{
return;
}
parentForm2.SearchAllReturnReportList();
}
MessageBox.Show("SUCCESSFULLY DELETED !", "INFORMATION", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
conn = new SqlConnection(parentForm1.OtherStoreConnectionString(cmRRStoreCode));
cmd = new SqlCommand("Delete_CreditMemo", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();
cmd.Parameters.Add("@seqNum", SqlDbType.BigInt).Value = Convert.ToInt64(dataGridView1.SelectedCells[0].Value);
cmd2 = new SqlCommand("Update_ReturnReportHeader", conn);
cmd2.CommandType = CommandType.StoredProcedure;
cmd2.Parameters.Add("@Seq", SqlDbType.Int).Value = 3;
cmd2.Parameters.Add("@rrID", SqlDbType.BigInt).Value = cmRRID;
cmd2.Parameters.Add("@rrShippingDate", SqlDbType.NVarChar).Value = string.Format("{0:MM/dd/yyyy}", DateTime.Today);
cmd2.Parameters.Add("@rrSubmitDate", SqlDbType.DateTime).Value = DateTime.Now;
cmd2.Parameters.Add("@rrReturnedDate", SqlDbType.DateTime).Value = DateTime.Now;
cmd2.Parameters.Add("@rrTrackingNumber", SqlDbType.NVarChar).Value = "N/A";
cmd2.Parameters.Add("@rrReturnTotalAmount", SqlDbType.Money).Value = 0;
cmd2.Parameters.Add("@rrReceivingTotalAmount", SqlDbType.Money).Value = -Convert.ToInt16(dataGridView1.SelectedCells[4].Value);
cmd2.Parameters.Add("@rrConfirmationID", SqlDbType.NVarChar).Value = "N/A";
cmd2.Parameters.Add("@rrStatus", SqlDbType.NVarChar).Value = "RECEIVING";
cmd2.Parameters.Add("@rrFirstContact", SqlDbType.NVarChar).Value = "N/A";
conn.Open();
cmd.ExecuteNonQuery();
cmd2.ExecuteNonQuery();
conn.Close();
Bind_DataGridview();
parentForm3.Show_CreditMemo_Count(cmRRID, cmRRStoreCode);
parentForm3.rrTotalReceivingAmount = creditMemoAmount;
parentForm3.lblTotalReceivingAmount.Text = string.Format("{0:c}", parentForm3.rrTotalReceivingAmount);
parentForm3.lblStatus.Text = "RECEIVING";
if (parentForm2.IsDisposed == false)
{
if (parentForm2.dataGridView1.RowCount == 0)
{
return;
}
parentForm2.SearchAllReturnReportList();
}
MessageBox.Show("SUCCESSFULLY DELETED !", "INFORMATION", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
