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(); } }