private void button15_Click(object sender, EventArgs e) { dataGridView1.Rows.RemoveAt(dataGridView1.CurrentCell.RowIndex); if (dataGridView1.RowCount == 0) { ActiveControl = txtBoxDescription; // focus on Description textbox dataGridView1.BorderStyle = BorderStyle.Fixed3D; //change borderStyle to identify active control txtBoxDescription.BorderStyle = BorderStyle.FixedSingle; //change borderStyle to identify active control txtBoxDescription.Select(txtBoxDescription.Text.Length, 0); //move cursor into the end of text in the textbox } else { dataGridView1.Rows[0].Selected = true; dataGridView1.CurrentCell = dataGridView1[0, 0]; ActiveControl = txtBoxDescription; // focus on Description textbox dataGridView1.BorderStyle = BorderStyle.Fixed3D; //change borderStyle to identify active control txtBoxDescription.BorderStyle = BorderStyle.FixedSingle; //change borderStyle to identify active control txtBoxDescription.Select(txtBoxDescription.Text.Length, 0); //move cursor into the end of text in the textbox } BillGeneration bg = new BillGeneration(); bg.total(this); }
//------------------------------------------------------------------------------------------------------------------------------------------------------------------ public void dataGridView1_KeyDown(object sender, KeyEventArgs e) { try { string keyVal; keyVal = e.KeyValue.ToString(); if (int.Parse(keyVal) == 40) { if (dataGridView1.RowCount != 0 || dataGridView1.RowCount != 1) { KeyPressEvent kpe = new KeyPressEvent(); kpe.downArrow("bf", "dgv", this); //mb=ManualBilling, dgv=DataGridView } } else if (int.Parse(keyVal) == 38) { KeyPressEvent kpe = new KeyPressEvent(); kpe.upArrow("bf", "dgv", this); } else if (int.Parse(keyVal) == 13) { KeyPressEvent kpe = new KeyPressEvent(); kpe.enterButton("bf", "dgv", this); } else if (int.Parse(keyVal) == 27) { dataGridView1.Rows[0].Selected = true; dataGridView1.CurrentCell = dataGridView1[0, 0]; ActiveControl = txtBoxDescription; // focus on Description textbox dataGridView1.BorderStyle = BorderStyle.Fixed3D; //change borderStyle to identify active control txtBoxDescription.BorderStyle = BorderStyle.FixedSingle; //change borderStyle to identify active control txtBoxDescription.Select(txtBoxDescription.Text.Length, 0); //move cursor into the end of text in the textbox } else if (int.Parse(keyVal) == 46) { dataGridView1.Rows.RemoveAt(dataGridView1.CurrentCell.RowIndex); if (dataGridView1.RowCount == 0) { ActiveControl = txtBoxDescription; // focus on Description textbox dataGridView1.BorderStyle = BorderStyle.Fixed3D; //change borderStyle to identify active control txtBoxDescription.BorderStyle = BorderStyle.FixedSingle; //change borderStyle to identify active control txtBoxDescription.Select(txtBoxDescription.Text.Length, 0); //move cursor into the end of text in the textbox } else { dataGridView1.Rows[0].Selected = true; dataGridView1.CurrentCell = dataGridView1[0, 0]; ActiveControl = txtBoxDescription; // focus on Description textbox dataGridView1.BorderStyle = BorderStyle.Fixed3D; //change borderStyle to identify active control txtBoxDescription.BorderStyle = BorderStyle.FixedSingle; //change borderStyle to identify active control txtBoxDescription.Select(txtBoxDescription.Text.Length, 0); //move cursor into the end of text in the textbox } BillGeneration bg = new BillGeneration(); bg.total(this); } else { if (int.Parse(keyVal) < 65 && int.Parse(keyVal) > 105 && int.Parse(keyVal) != 32) { SystemSounds.Hand.Play(); } } } catch (Exception exc) { MessageBox.Show("Error Occured, Please Try Again, " + exc.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
//--------------endOfUpArrow Function--------------------------------------------------------------------------------------------------------------------------- //--------------startOfEnter Function--------------------------------------------------------------------------------------------------------------------------- public void enterButton(string form, string focus, object obj, object formobj = null) { try { if (form == "mb" && focus == "dgv") { ManualBilling mb = (ManualBilling)obj; Billingform bf = (Billingform)formobj; int row = mb.dataGridView1.CurrentCell.RowIndex; if (mb.dataGridView1.RowCount != 0) { int code = (int)mb.dataGridView1.Rows[row].Cells[0].Value; string des = mb.dataGridView1.Rows[row].Cells[1].Value.ToString(); decimal price = (decimal)mb.dataGridView1.Rows[row].Cells[2].Value; decimal l_price = (decimal)mb.dataGridView1.Rows[row].Cells[3].Value; decimal disc = (decimal)mb.dataGridView1.Rows[row].Cells[4].Value;; string other = mb.dataGridView1.Rows[row].Cells[5].Value.ToString(); bf.txtBoxCode.Text = code.ToString(); bf.txtBoxDescription.Text = des; bf.textBox8.Text = price.ToString(); bf.txtBoxDiscount.Text = disc.ToString(); mb.Close(); bf.ActiveControl = bf.textBox2; } } if (form == "bf" && focus == "qty") { Billingform bf = (Billingform)obj; string code = bf.txtBoxCode.Text; string des = bf.txtBoxDescription.Text; decimal price; Decimal.TryParse(bf.textBox8.Text, out price); decimal disc; Decimal.TryParse(bf.txtBoxDiscount.Text, out disc); decimal qty; Decimal.TryParse(bf.textBox2.Text, out qty); decimal tot = 0.00m; if (qty == 0) { qty = 1; } if (disc == 0) { tot = (price * qty); } else { decimal newprice; newprice = (price - ((price / 100) * disc)); tot = (newprice * qty); } Decimal.TryParse((tot.ToString().Substring(0, tot.ToString().Length)), out tot); Decimal total; Decimal.TryParse(bf.label7.Text, out total); tot = Math.Round(tot, 2); bf.dataGridView1.Rows.Add(bf.dataGridView1.RowCount + 1, code, des, qty, disc, price, tot); BillGeneration bg = new BillGeneration(); bg.total(bf); } if (form == "bf" && focus == "des") { Billingform bf = (Billingform)obj; if (bf.dataGridView1.RowCount != 0) { bf.ActiveControl = bf.textBox3; } else { SystemSounds.Hand.Play(); } } } catch (Exception exc) { MessageBox.Show("Error Occured, Please Try Again, " + exc.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
//--------------endOfUpArrow Function--------------------------------------------------------------------------------------------------------------------------- //--------------startOfEnter Function--------------------------------------------------------------------------------------------------------------------------- public void enterButton(string form, string focus, object obj, object formobj = null) { DBConnection db = new DBConnection(); try { if (form == "mb" && focus == "dgv") { ManualBilling mb = (ManualBilling)obj; Billingform bf = (Billingform)formobj; int row = mb.dataGridView1.CurrentCell.RowIndex; if (mb.dataGridView1.RowCount != 0) { int code = (int)mb.dataGridView1.Rows[row].Cells[0].Value; string des = mb.dataGridView1.Rows[row].Cells[1].Value.ToString(); decimal price = (decimal)mb.dataGridView1.Rows[row].Cells[4].Value; decimal l_price = (decimal)mb.dataGridView1.Rows[row].Cells[5].Value; decimal disc = (decimal)mb.dataGridView1.Rows[row].Cells[6].Value;; //string other = mb.dataGridView1.Rows[row].Cells[5].Value.ToString(); bf.txtBoxCode.Text = code.ToString(); bf.txtBoxDescription.Text = des; bf.textBox8.Text = price.ToString(); bf.txtBoxDiscount.Text = disc.ToString(); mb.Close(); bf.ActiveControl = bf.textBox2; } } if (form == "bf" && focus == "qty") { Billingform bf = (Billingform)obj; string code = bf.txtBoxCode.Text; string des = bf.txtBoxDescription.Text; decimal price; Decimal.TryParse(bf.textBox8.Text, out price); decimal disc; Decimal.TryParse(bf.txtBoxDiscount.Text, out disc); decimal qty; Decimal.TryParse(bf.textBox2.Text, out qty); decimal tot = 0.00m; if (qty == 0) { qty = 1; } if (disc == 0) { tot = (price * qty); } else { decimal newprice; newprice = (price - ((price / 100) * disc)); tot = (newprice * qty); } Decimal.TryParse((tot.ToString().Substring(0, tot.ToString().Length)), out tot); Decimal total; Decimal.TryParse(bf.label7.Text, out total); tot = Math.Round(tot, 2); bf.dataGridView1.Rows.Add(bf.dataGridView1.RowCount + 1, code, des, qty, disc, price, tot); //reduce qty if (db.OpenConnection() == true) { int quantity = 0; string query1 = "SELECT Quantity FROM items WHERE Item_Code=" + code + ""; MySqlCommand cmd = new MySqlCommand(query1, db.connection); MySqlDataAdapter adapter = new MySqlDataAdapter(cmd); DataTable table = new DataTable(); adapter.Fill(table); quantity = int.Parse(table.Rows[0].ItemArray[0].ToString()); if (quantity > int.Parse(qty.ToString())) { quantity = quantity - int.Parse(qty.ToString()); string query2 = "UPDATE items SET Quantity=" + quantity + " WHERE Item_Code=" + code + ""; MySqlCommand cmd1 = new MySqlCommand(query2, db.connection); cmd1.ExecuteNonQuery(); ItemDBConnection idc = new ItemDBConnection(); idc.reorder(code, quantity); BillGeneration bg = new BillGeneration(); bg.total(bf); } else { MessageBox.Show("According to Database Stocks in hand is lesser than the Quantity that you going to purchuase", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); bf.dataGridView1.Rows.RemoveAt(bf.dataGridView1.RowCount - 1); bf.txtBoxCode.Text = ""; bf.txtBoxDescription.Text = ""; bf.textBox8.Text = ""; bf.textBox2.Text = ""; bf.txtBoxDiscount.Text = ""; bf.ActiveControl = bf.txtBoxDescription; } } } if (form == "bf" && focus == "des") { Billingform bf = (Billingform)obj; if (bf.dataGridView1.RowCount != 0) { bf.ActiveControl = bf.textBox3; } else { SystemSounds.Hand.Play(); } } if (form == "bf" && focus == "dgv") { Form6 newform = new Form6(obj); newform.Show(); } } catch (Exception exc) { MessageBox.Show("Error Occured, Please Try Again, " + exc.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { db.CloseConnection(); } }
//--------------endOfUpArrow Function--------------------------------------------------------------------------------------------------------------------------- //--------------startOfEnter Function--------------------------------------------------------------------------------------------------------------------------- public void enterButton(string form, string focus, object obj, object formobj = null) { try { if (form == "mb" && focus == "dgv") { ManualBilling mb = (ManualBilling)obj; Billingform bf = (Billingform)formobj; int row = mb.dataGridView1.CurrentCell.RowIndex; if (mb.dataGridView1.RowCount != 0) { int code = (int)mb.dataGridView1.Rows[row].Cells[0].Value; string des = mb.dataGridView1.Rows[row].Cells[1].Value.ToString(); decimal price = (decimal)mb.dataGridView1.Rows[row].Cells[2].Value; decimal l_price = (decimal)mb.dataGridView1.Rows[row].Cells[3].Value; decimal disc = (decimal)mb.dataGridView1.Rows[row].Cells[4].Value; ; string other = mb.dataGridView1.Rows[row].Cells[5].Value.ToString(); bf.txtBoxCode.Text = code.ToString(); bf.txtBoxDescription.Text = des; bf.textBox8.Text = price.ToString(); bf.txtBoxDiscount.Text = disc.ToString(); mb.Close(); bf.ActiveControl = bf.textBox2; } } if (form == "bf" && focus == "qty") { Billingform bf = (Billingform)obj; string code = bf.txtBoxCode.Text; string des = bf.txtBoxDescription.Text; decimal price; Decimal.TryParse(bf.textBox8.Text, out price); decimal disc; Decimal.TryParse(bf.txtBoxDiscount.Text, out disc); decimal qty; Decimal.TryParse(bf.textBox2.Text, out qty); decimal tot = 0.00m; if (qty == 0) { qty = 1; } if (disc == 0) { tot = (price * qty); } else { decimal newprice; newprice = (price - ((price / 100) * disc)); tot = (newprice * qty); } Decimal.TryParse((tot.ToString().Substring(0, tot.ToString().Length)), out tot); Decimal total; Decimal.TryParse(bf.label7.Text, out total); tot = Math.Round(tot, 2); bf.dataGridView1.Rows.Add(bf.dataGridView1.RowCount + 1, code, des, qty, disc, price, tot); BillGeneration bg = new BillGeneration(); bg.total(bf); } if (form == "bf" && focus == "des") { Billingform bf = (Billingform)obj; if (bf.dataGridView1.RowCount != 0) { bf.ActiveControl = bf.textBox3; } else { SystemSounds.Hand.Play(); } } } catch (Exception exc) { MessageBox.Show("Error Occured, Please Try Again, " + exc.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }