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