private void button1_Click(object sender, EventArgs e)
{
int dno = Convert.ToInt32(cmbRetDocNo.SelectedItem.ToString());
//MessageBox.Show(dno.ToString());
ReportForms.rptfrm_Returns rt = new ReportForms.rptfrm_Returns(dno);
rt.Show();
}
private void btn_apply_Click(object sender, EventArgs e)
{
int st = 1;
DialogResult confirm = MessageBox.Show("Do you want to apply?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (confirm == DialogResult.Yes)
{
string dno = lbl_docnum.Text;
string date = dateTimePicker1.Value.ToShortDateString();
string cid = txtcid.Text;
string tot = lbl_subtotal.Text;
//data to returns, payment(to be discussed)
string q = "INSERT INTO returns(dno,cid,created,remarks,total) VALUES(@dno,@cid,@created,@remarks,@total)";
MySqlCommand cmd = new MySqlCommand(q, conn);
cmd.Parameters.Add("@dno", MySqlDbType.VarChar).Value = Convert.ToInt32(dno).ToString();
cmd.Parameters.Add("@cid", MySqlDbType.VarChar).Value = cid;
cmd.Parameters.Add("@created", MySqlDbType.VarChar).Value = date;
cmd.Parameters.Add("@remarks", MySqlDbType.VarChar).Value = txt_remark.Text;
cmd.Parameters.Add("@total", MySqlDbType.Double).Value = Convert.ToDouble(tot);
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
//data to returndetails, returnstock, mainstock
for (int i = 0; i < dataGridView1.RowCount; i++)
{
string q2 = "INSERT INTO returndetails(dno,itemNo,qty,wsp,total) VALUES(" + Convert.ToInt32(dno).ToString() + "," + Convert.ToInt32(dataGridView1.Rows[i].Cells[0].Value) + "," + Convert.ToInt32(dataGridView1.Rows[i].Cells[3].Value) + "," + Convert.ToDouble(dataGridView1.Rows[i].Cells[2].Value) + "," + Convert.ToDouble(dataGridView1.Rows[i].Cells[4].Value) + ");";
string q3 = "INSERT INTO returnstock(itemCode,description,wsp,qty) VALUES(" + dataGridView1.Rows[i].Cells[0].Value.ToString() + ",'" + dataGridView1.Rows[i].Cells[1].Value.ToString() + "'," + Convert.ToDouble(dataGridView1.Rows[i].Cells[2].Value) + "," + Convert.ToInt32(dataGridView1.Rows[i].Cells[3].Value) + ");";
string q4 = "UPDATE stock SET quantity = (quantity + " + Convert.ToInt32(dataGridView1.Rows[i].Cells[3].Value) + ") WHERE itemCodes = " + Convert.ToInt32(dataGridView1.Rows[i].Cells[0].Value) + ";";
MySqlCommand cmd2 = new MySqlCommand(q2, conn);
MySqlCommand cmd3 = new MySqlCommand(q3, conn);
MySqlCommand cmd4 = new MySqlCommand(q4, conn);
try
{
conn.Open();
cmd2.ExecuteNonQuery();
cmd3.ExecuteNonQuery();
cmd4.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
}
MessageBox.Show("Return Details added successfully!");
//clear fields & disable
dataGridView1.Rows.Clear();
dataGridView1.Refresh();
txtcid.Clear();
txtname.Clear();
txt_remark.Clear();
txt_itemcode.Clear();
txt_quantity.Clear();
txtcid.Enabled = false;
txtname.Enabled = false;
txt_remark.Enabled = false;
txt_itemcode.Enabled = false;
txt_quantity.Enabled = false;
//Display report
ReportForms.rptfrm_Returns rpfrm = new ReportForms.rptfrm_Returns(Convert.ToInt32(dno));
rpfrm.Show();
}
}
