private void loadDDL() { core_ledger_account laObj = new core_ledger_account(); DataSet ds = laObj.SelectMethod(@"SELECT LA.Id_Ledger_Account,LA.Ledger_Account_Name FROM core_ledger_account AS LA WHERE LA.Is_Active='0';", "core_ledger_account"); DataRow dr = ds.Tables["core_ledger_account"].NewRow(); dr[0] = "0"; dr[1] = "Select"; ds.Tables["core_ledger_account"].Rows.InsertAt(dr, 0); ddlLAName.DataSource = ds.Tables["core_ledger_account"]; ddlLAName.DataValueField = "Id_Ledger_Account"; ddlLAName.DataTextField = "Ledger_Account_Name"; ddlLAName.DataBind(); }
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(); }