private void insertUpdatedVoucherDetails()
{
if (cmdSubmit.CommandName.ToLower() == "SAVE".ToLower())
{
core_petty_cash_settlement pcvsObj = new core_petty_cash_settlement();
core_petty_cash_settlement_Objects objPCVS = new core_petty_cash_settlement_Objects();
objPCVS.Id_Petty_Cash_Voucher = Convert.ToInt32(idPrePV.Text);
//objPCVS.Id_Petty_Cash_Book = Convert.ToInt32(ddlPCBName.Text);
objPCVS.Id_Petty_Cash_Book = Convert.ToInt32(hfPCBID.Value);
//objPCVS.Id_Petty_Cash_Category = Convert.ToInt32(ddlPCCName.Text);
objPCVS.Id_Petty_Cash_Category = Convert.ToInt32(hfPCCID.Value);
objPCVS.Cash_Out_Amount = Convert.ToDouble(cashOutAmount.Text);
objPCVS.Cash_In_Amount = Convert.ToDouble(cashInAmount.Text);
objPCVS.Net_Cash_Out_Amount = Convert.ToDouble(hfnetcashOutAmount.Value);
objPCVS.Petty_Cash_Voucher_Remark = PCV_Remark.Text;
objPCVS.Created_Date = DateTime.Now;
pcvsObj.Insert(objPCVS);
//Inserting Ledger Entry & Updating Ledger Account BCF
core_ledger_entry leObj = new core_ledger_entry();
core_ledger_entry_Objects objLE = new core_ledger_entry_Objects();
objLE.Id_Petty_Cash_Book = Convert.ToInt32(hfPCBID.Value);
objLE.Id_Petty_Cash_Category = Convert.ToInt32(hfPCCID.Value);
objLE.Id_Ledger_Account = Convert.ToInt32(hfIDLedgerAccount.Value);
objLE.Id_Petty_Cash_Voucher = Convert.ToInt32(idPrePV.Text);
double x = Convert.ToDouble(hfIDLedgerAccountBCF.Value);
double y = Convert.ToDouble(cashInAmount.Text);
objLE.Credit_Amount = Convert.ToDouble(cashInAmount.Text);
objLE.Balance_Carried_Forward = (x - y);
double z = (x - y);
objLE.Created_Date = DateTime.Now;
objLE.Post_Payment = 1;
leObj.Insert(objLE);
core_ledger_account laObj = new core_ledger_account();
laObj.UpdateMethod(@"UPDATE `core_ledger_account`
SET
`Balance_Carried_Forward` = '" + z + @"'
WHERE `Id_Ledger_Account` = '" + Convert.ToInt32(hfIDLedgerAccount.Value) + @"';");
}
clearFields();
loadGrid();
}
// private void insertLedgerEntry()
// {
// if (cmdSubmit.CommandName.ToLower() == "SAVE".ToLower())
// {
// core_ledger_entry leObj = new core_ledger_entry();
// core_ledger_entry_Objects objLE = new core_ledger_entry_Objects();
// objLE.Id_Petty_Cash_Book = Convert.ToInt32(hfPCBID.Value);
// objLE.Id_Petty_Cash_Category = Convert.ToInt32(hfPCCID.Value);
// objLE.Id_Ledger_Account = Convert.ToInt32(hfIDLedgerAccount.Value);
// objLE.Id_Petty_Cash_Voucher = Convert.ToInt32(idPrePV.Text);
// double x = Convert.ToDouble(hfIDLedgerAccountBCF.Value);
// double y = Convert.ToDouble(cashInAmount.Text);
// objLE.Credit_Amount = Convert.ToDouble(cashInAmount.Text);
// objLE.Balance_Carried_Forward = (x - y);
// double z = (x - y);
// objLE.Created_Date = DateTime.Now;
// objLE.Post_Payment = 1;
// leObj.Insert(objLE);
// core_ledger_account laObj = new core_ledger_account();
// laObj.UpdateMethod(@"UPDATE `core_ledger_account`
// SET
// `Balance_Carried_Forward` = '" + z + @"'
// WHERE `Id_Ledger_Account` = '" + Convert.ToInt32(hfIDLedgerAccount.Value) + @"';");
// }
// }
private void loadGrid()
{
core_petty_cash_settlement pcvsObj = new core_petty_cash_settlement();
DataSet ds = pcvsObj.SelectMethod(@"SELECT
pcvs.Id_Petty_Cash_Settlement,
pcvs.Id_Petty_Cash_Voucher,
pcvs.Id_Petty_Cash_Book,
pcb.Petty_Cash_Book_Name,
pcb.Petty_Cash_Book_Code,
pcvs.Id_Petty_Cash_Category,
pcc.Petty_Cash_Category_Name,
pcc.Petty_Cash_Category_Code,
pcvs.Cash_Out_Amount,
pcvs.Cash_In_Amount,
pcvs.Net_Cash_Out_Amount,
pcvs.Petty_Cash_Voucher_Remark,
pcvs.Created_Date,
pcvs.Created_User,
pcvs.Edited_Date,
pcvs.Edited_User
FROM core_petty_cash_settlement AS pcvs
INNER JOIN core_petty_cash_book AS pcb ON pcvs.Id_Petty_Cash_Book=pcb.Id_Petty_Cash_Book
INNER JOIN core_petty_cash_category AS pcc ON pcvs.Id_Petty_Cash_Category=pcc.Id_Petty_Cash_Category
WHERE pcvs.Is_Active='0';", "core_petty_cash_settlement");
if (ds.Tables["core_petty_cash_settlement"] != null)
{
pcvsGrid.DataSource = ds.Tables["core_petty_cash_settlement"];
pcvsGrid.DataBind();
}
else
{
pcvsGrid.DataSource = new int[] { };
pcvsGrid.DataBind();
}
}
