private void button1_Click(object sender, EventArgs e) { this.Hide(); frmTransaction t = new frmTransaction(); t.ShowDialog(); }
private void toolStripButton2_Click(object sender, EventArgs e) { frmTransaction frm = new frmTransaction(); if (frm.ShowDialog() == DialogResult.OK) { Refresh(); } }
private void Mnu_Click(object sender, EventArgs e) { frmTransaction transaction = new frmTransaction(); transaction.VoucherId = Convert.ToInt32(((ToolStripMenuItem)sender).Tag); transaction.MdiParent = this; transaction.Text = ((ToolStripMenuItem)sender).Text; transaction.Show(); transaction.BringToFront(); }
private void transactionToolStripMenuItem_Click(object sender, EventArgs e) { if (transaction.IsDisposed) { transaction = new frmTransaction(); } transaction.MdiParent = this; transaction.Show(); transaction.BringToFront(); }
private void button2_Click(object sender, EventArgs e) { if (validate() == true) { DataTable dtSave = new DataTable(); dtSave.Columns.Add("SKU"); dtSave.Columns.Add("SKUCode"); dtSave.Columns.Add("Description"); dtSave.Columns.Add("Packing"); dtSave.Columns.Add("Quantity"); dtSave.Columns.Add("Rate"); dtSave.Columns.Add("Inbillscheme"); dtSave.Columns.Add("CD"); dtSave.Columns.Add("Category_id"); dtSave.Columns.Add("Description_id"); dtSave.Columns.Add("cost"); dtSave.Columns.Add("Ino"); dtSave.Columns.Add("Idt"); for (int i = 0; i < dataGridView1.Rows.Count; i++) { dtSave.Rows.Add(); dtSave.Rows[i]["SKU"] = dataGridView1.Rows[i].Cells["dataGridViewTextBoxColumn3"].Value.ToString(); dtSave.Rows[i]["SKUCode"] = dataGridView1.Rows[i].Cells["dataGridViewTextBoxColumn2"].Value.ToString(); dtSave.Rows[i]["Description"] = dataGridView1.Rows[i].Cells["Description"].Value.ToString(); dtSave.Rows[i]["Packing"] = dataGridView1.Rows[i].Cells["Packing"].Value.ToString(); dtSave.Rows[i]["Quantity"] = dataGridView1.Rows[i].Cells["dataGridViewTextBoxColumn4"].Value.ToString(); if (dataGridView1.Rows[i].Cells["Rate"].Value == null) { dataGridView1.Rows[i].Cells["Rate"].Value = "0"; } dtSave.Rows[i]["Rate"] = dataGridView1.Rows[i].Cells["Rate"].Value.ToString(); dtSave.Rows[i]["Inbillscheme"] = dataGridView1.Rows[i].Cells["dataGridViewTextBoxColumn5"].Value.ToString(); dtSave.Rows[i]["CD"] = dataGridView1.Rows[i].Cells["CD"].Value.ToString(); dtSave.Rows[i]["Category_id"] = dataGridView1.Rows[i].Cells["Category_id"].Value.ToString(); dtSave.Rows[i]["Description_id"] = dataGridView1.Rows[i].Cells["description_id"].Value.ToString(); dtSave.Rows[i]["cost"] = dataGridView1.Rows[i].Cells["Rate"].Value.ToString(); dtSave.Rows[i]["Ino"] = label2.Text; dtSave.Rows[i]["Idt"] = dataGridView2.Rows[i].Cells["Date"].Value.ToString(); Database.CommandExecutor("UPDATE DESCRIPTION SET Skucode = '" + dataGridView1.Rows[i].Cells["dataGridViewTextBoxColumn2"].Value.ToString() + "' WHERE Des_id='" + dataGridView1.Rows[i].Cells["description_id"].Value.ToString() + "' "); } frmTransaction frm = new frmTransaction(); frm.MdiParent = this.MdiParent; frm.Show(); frm.LoadData("", "Purchase", true, false, false); frm.ImportData(dtSave); this.Close(); } }
private void transactionsToolStripMenuItem_Click(object sender, EventArgs e) { frmTransaction t = new frmTransaction(); t.Show(); }
private void accountingVoucherToolStripMenuItem_Click(object sender, EventArgs e) { frmTransaction t = new frmTransaction(); t.ShowDialog(); }
private void button1_Click_1(object sender, EventArgs e) { frmTransaction t = new frmTransaction(); t.ShowDialog(); }
private void ansGridView5_CellClick(object sender, DataGridViewCellEventArgs e) { if (ansGridView5.CurrentCell.OwningColumn.Name == "DocNumber") { string gstr = ansGridView5.Rows[ansGridView5.CurrentRow.Index].Cells["Type"].Value.ToString(); if (gstr == "Receipt") { if (ansGridView5.Rows[ansGridView5.CurrentRow.Index].Cells["Vid"].Value.ToString() == "0") { return; } frmCashRec frm = new frmCashRec(); frm.recpay = "Receipt"; frm.cmdnm = "edit"; frm.Text = "Edit Receipt"; frm.LoadData(ansGridView5.Rows[ansGridView5.CurrentRow.Index].Cells["Vid"].Value.ToString(), frm.Text); frm.MdiParent = this.MdiParent; frm.Show(); } else if (gstr == "Payment") { if (ansGridView5.Rows[ansGridView5.CurrentRow.Index].Cells["Vid"].Value.ToString() == "0") { return; } frmCashRec frm = new frmCashRec(); frm.recpay = "Payment"; frm.cmdnm = "edit"; frm.Text = "Edit Payment"; frm.LoadData(ansGridView5.Rows[ansGridView5.CurrentRow.Index].Cells["Vid"].Value.ToString(), frm.Text); frm.MdiParent = this.MdiParent; frm.Show(); } else if (gstr == "Contra") { if (ansGridView5.Rows[ansGridView5.CurrentRow.Index].Cells["Vid"].Value.ToString() == "0") { return; } frmCashRec frm = new frmCashRec(); frm.recpay = "Contra"; frm.cmdnm = "edit"; frm.Text = "Edit Contra"; frm.LoadData(ansGridView5.Rows[ansGridView5.CurrentRow.Index].Cells["Vid"].Value.ToString(), frm.Text); frm.MdiParent = this.MdiParent; frm.Show(); } else if (gstr == "Journal") { if (ansGridView5.Rows[ansGridView5.CurrentRow.Index].Cells["Vid"].Value.ToString() == "0") { return; } frmJournal frm = new frmJournal(); frm.LoadData(ansGridView5.Rows[ansGridView5.CurrentRow.Index].Cells["Vid"].Value.ToString(), "Journal Voucher"); frm.MdiParent = this.MdiParent; frm.Show(); } else if (gstr == "Dnote") { if (ansGridView5.Rows[ansGridView5.CurrentRow.Index].Cells["Vid"].Value.ToString() == "0") { return; } frmDebitCredit frm = new frmDebitCredit(); frm.dr_cr_note = "Debit Note"; frm.cmdnm = "edit"; frm.LoadData(ansGridView5.Rows[ansGridView5.CurrentRow.Index].Cells["Vid"].Value.ToString(), "Debit Note"); frm.MdiParent = this.MdiParent; frm.Show(); } else if (gstr == "Cnote") { if (ansGridView5.Rows[ansGridView5.CurrentRow.Index].Cells["Vid"].Value.ToString() == "0") { return; } frmDebitCredit frm = new frmDebitCredit(); frm.dr_cr_note = "Credit Note"; frm.cmdnm = "edit"; frm.LoadData(ansGridView5.Rows[ansGridView5.CurrentRow.Index].Cells["Vid"].Value.ToString(), "Credit Note"); frm.MdiParent = this.MdiParent; frm.Show(); } else if (gstr == "Purchase") { if (ansGridView5.Rows[ansGridView5.CurrentRow.Index].Cells["Vid"].Value.ToString() == "0") { return; } DataTable dtalter = new DataTable(); Database.GetSqlData("SELECT VOUCHERTYPE.Type, VOUCHERINFO.Tdtype, VOUCHERTYPE.ExState, VOUCHERTYPE.Unregistered FROM VOUCHERINFO,VOUCHERTYPE WHERE VOUCHERINFO.Vt_id = VOUCHERTYPE.Vt_id and VOUCHERINFO.Vi_id='" + ansGridView5.Rows[ansGridView5.CurrentRow.Index].Cells["Vid"].Value.ToString() + "' ", dtalter); frmTransaction frm = new frmTransaction(); frm.LoadData(ansGridView5.Rows[ansGridView5.CurrentRow.Index].Cells["Vid"].Value.ToString(), dtalter.Rows[0]["Type"].ToString(), bool.Parse(dtalter.Rows[0]["Tdtype"].ToString()), bool.Parse(dtalter.Rows[0]["ExState"].ToString()), bool.Parse(dtalter.Rows[0]["Unregistered"].ToString())); frm.MdiParent = this.MdiParent; frm.Show(); } else if (gstr == "RCM") { if (ansGridView5.Rows[ansGridView5.CurrentRow.Index].Cells["Vid"].Value.ToString() == "0") { return; } DataTable dtalter = new DataTable(); Database.GetSqlData("SELECT VOUCHERTYPE.Type, VOUCHERINFO.Tdtype, VOUCHERTYPE.ExState, VOUCHERTYPE.Unregistered FROM VOUCHERINFO,VOUCHERTYPE WHERE VOUCHERINFO.Vt_id = VOUCHERTYPE.Vt_id and VOUCHERINFO.Vi_id='" + ansGridView5.Rows[ansGridView5.CurrentRow.Index].Cells["Vid"].Value.ToString() + "' ", dtalter); frmTransaction frm = new frmTransaction(); frm.LoadData(ansGridView5.Rows[ansGridView5.CurrentRow.Index].Cells["Vid"].Value.ToString(), dtalter.Rows[0]["Type"].ToString(), bool.Parse(dtalter.Rows[0]["Tdtype"].ToString()), bool.Parse(dtalter.Rows[0]["ExState"].ToString()), bool.Parse(dtalter.Rows[0]["Unregistered"].ToString())); frm.MdiParent = this.MdiParent; frm.Show(); } else if (gstr == "Sale") { if (ansGridView5.Rows[ansGridView5.CurrentRow.Index].Cells["vid"].Value.ToString() == "0") { return; } DataTable dtalter = new DataTable(); Database.GetSqlData("SELECT VOUCHERTYPE.Type, VOUCHERINFO.Tdtype, VOUCHERTYPE.ExState, VOUCHERTYPE.Unregistered FROM VOUCHERINFO,VOUCHERTYPE WHERE VOUCHERINFO.Vt_id = VOUCHERTYPE.Vt_id and VOUCHERINFO.Vi_id='" + ansGridView5.Rows[ansGridView5.CurrentRow.Index].Cells["Vid"].Value.ToString() + "' ", dtalter); frmTransaction frm = new frmTransaction(); frm.LoadData(ansGridView5.Rows[ansGridView5.CurrentRow.Index].Cells["vid"].Value.ToString(), dtalter.Rows[0]["Type"].ToString(), bool.Parse(dtalter.Rows[0]["Tdtype"].ToString()), bool.Parse(dtalter.Rows[0]["ExState"].ToString()), bool.Parse(dtalter.Rows[0]["Unregistered"].ToString())); frm.MdiParent = this.MdiParent; frm.Show(); } else if (gstr == "P Return") { if (ansGridView5.Rows[ansGridView5.CurrentRow.Index].Cells["Vid"].Value.ToString() == "0") { return; } DataTable dtalter = new DataTable(); Database.GetSqlData("SELECT VOUCHERTYPE.Type, VOUCHERINFO.Tdtype, VOUCHERTYPE.ExState, VOUCHERTYPE.Unregistered FROM VOUCHERINFO,VOUCHERTYPE WHERE VOUCHERINFO.Vt_id = VOUCHERTYPE.Vt_id and VOUCHERINFO.Vi_id='" + ansGridView5.Rows[ansGridView5.CurrentRow.Index].Cells["Vid"].Value.ToString() + "' ", dtalter); frmTransaction frm = new frmTransaction(); frm.LoadData(ansGridView5.Rows[ansGridView5.CurrentRow.Index].Cells["Vid"].Value.ToString(), dtalter.Rows[0]["Type"].ToString(), bool.Parse(dtalter.Rows[0]["Tdtype"].ToString()), bool.Parse(dtalter.Rows[0]["ExState"].ToString()), bool.Parse(dtalter.Rows[0]["Unregistered"].ToString())); frm.MdiParent = this.MdiParent; frm.Show(); } else if (gstr == "Return") { if (ansGridView5.Rows[ansGridView5.CurrentRow.Index].Cells["Vid"].Value.ToString() == "0") { return; } DataTable dtalter = new DataTable(); Database.GetSqlData("SELECT VOUCHERTYPE.Type, VOUCHERINFO.Tdtype, VOUCHERTYPE.ExState, VOUCHERTYPE.Unregistered FROM VOUCHERINFO,VOUCHERTYPE WHERE VOUCHERINFO.Vt_id = VOUCHERTYPE.Vt_id and VOUCHERINFO.Vi_id=" + ansGridView5.Rows[ansGridView5.CurrentRow.Index].Cells["Vid"].Value.ToString() + "' ", dtalter); frmTransaction frm = new frmTransaction(); frm.LoadData(ansGridView5.Rows[ansGridView5.CurrentRow.Index].Cells["Vid"].Value.ToString(), dtalter.Rows[0]["Type"].ToString(), bool.Parse(dtalter.Rows[0]["Tdtype"].ToString()), bool.Parse(dtalter.Rows[0]["ExState"].ToString()), bool.Parse(dtalter.Rows[0]["Unregistered"].ToString())); frm.MdiParent = this.MdiParent; frm.Show(); } else if (gstr == "Transfer") { if (ansGridView5.Rows[ansGridView5.CurrentRow.Index].Cells["Vi_id"].Value.ToString() == "0") { return; } DataTable dtalter = new DataTable(); Database.GetSqlData("SELECT VOUCHERTYPE.Type, VOUCHERINFO.Tdtype, VOUCHERTYPE.ExState, VOUCHERTYPE.Unregistered FROM VOUCHERINFO,VOUCHERTYPE WHERE VOUCHERINFO.Vt_id = VOUCHERTYPE.Vt_id and VOUCHERINFO.Vi_id=" + int.Parse(ansGridView5.Rows[ansGridView5.CurrentRow.Index].Cells["Vi_id"].Value.ToString()), dtalter); frm_stkjournal frm = new frm_stkjournal(); frm.LoadData(ansGridView5.Rows[ansGridView5.CurrentRow.Index].Cells["Vi_id"].Value.ToString(), "Edit Stock Journal"); frm.MdiParent = this.MdiParent; frm.Show(); } else if (gstr == "Pending") { if (ansGridView5.Rows[ansGridView5.CurrentRow.Index].Cells["Vid"].Value.ToString() == "0") { return; } DataTable dtalter = new DataTable(); Database.GetSqlData("SELECT VOUCHERTYPE.Type, VOUCHERINFO.Tdtype, VOUCHERTYPE.ExState, VOUCHERTYPE.Unregistered FROM VOUCHERINFO,VOUCHERTYPE WHERE VOUCHERINFO.Vt_id = VOUCHERTYPE.Vt_id and VOUCHERINFO.Vi_id='" + ansGridView5.Rows[ansGridView5.CurrentRow.Index].Cells["Vid"].Value.ToString() + "' ", dtalter); frmTransaction frm = new frmTransaction(); frm.LoadData(ansGridView5.Rows[ansGridView5.CurrentRow.Index].Cells["Vid"].Value.ToString(), dtalter.Rows[0]["Type"].ToString(), bool.Parse(dtalter.Rows[0]["Tdtype"].ToString()), bool.Parse(dtalter.Rows[0]["ExState"].ToString()), bool.Parse(dtalter.Rows[0]["Unregistered"].ToString())); frm.MdiParent = this.MdiParent; frm.Show(); } } }