//-------------------- Update Payment Information ---------------------------------------------- public void UpdatePaymentInformation(DBSite site, SalePurchaseEntity salePurchase, string ledgerIdNumber) { string ledger_id = util.GetLedgerId(ledgerIdNumber); string ledger_number = util.GetLedgerNumber(ledgerIdNumber); // 444 int party = Int32.Parse(util.GetLOVId(salePurchase.party)); int mode = Int32.Parse(util.GetLOVId(salePurchase.mode)); if (salePurchase.transactionType == TransactionType.PaymentMade) { int tmp; tmp = Int32.Parse(util.GetLOVId(salePurchase.mode)); mode = Int32.Parse(util.GetLOVId(salePurchase.party)); party = tmp; } // sales - party string party_qry = " UPDATE tblLedger SET " + " LDate = '" + salePurchase.BillDate + "' " + ", AccountMasterId= " + mode + ", modeid= " + party + ", BillNumber= '" + util.GetLOVName(salePurchase.BillNumber) + "' " + ", Particulars= '" + salePurchase.particulars + "' " + ", debit = " + salePurchase.SalePurchaseAmount + ", CheckNumber= '" + salePurchase.CheckNumber + "' " + ", subUserId = " + Util_BLL.User.Subusers[0].SubuserId + Util_BLL.GetUserWhereCondition(Util_BLL.User) // + " AND LedgerId=" + ledger_id + " AND LedgerNumber=" + ledger_number + " AND drcr = 'D'"; // sales - mode string mode_qry = " UPDATE tblLedger SET " + " LDate = '" + salePurchase.BillDate + "' " + ", AccountMasterId= " + party + ", modeId = " + mode + ", BillNumber= '" + util.GetLOVName(salePurchase.BillNumber) + "' " + ", Particulars= '" + salePurchase.particulars + "' " + ", credit = " + salePurchase.SalePurchaseAmount + ", CheckNumber= '" + salePurchase.CheckNumber + "' " + ", subUserId = " + Util_BLL.User.Subusers[0].SubuserId + Util_BLL.GetUserWhereCondition(Util_BLL.User) + " AND LedgerNumber=" + ledger_number + " AND drcr = 'C'"; site.Execute(party_qry); site.Execute(mode_qry); }
public void SaveSalePurchase(DBSite site, SalePurchaseEntity salePurchase, bool isOpeningBalance) { Util_BLL util = new Util_BLL(); /** * * // payment made If GM.isFees = 2 Then * Dim tmp As String * tmp = mode * mode = party * party = tmp * End If * **/ int party = Int32.Parse(util.GetLOVId(salePurchase.party)); int mode = Int32.Parse(util.GetLOVId(salePurchase.mode)); if (salePurchase.transactionType == TransactionType.PaymentMade) { int tmp; tmp = Int32.Parse(util.GetLOVId(salePurchase.mode)); mode = Int32.Parse(util.GetLOVId(salePurchase.party)); party = tmp; } if (salePurchase.transactionType == TransactionType.Sales) { mode = Modes.SaleAccount; } int ledgerNumber = util.GetAutoNumber(site, "LedgerNumber"); // opening balance string opening_qry = ""; if (isOpeningBalance) { string credit_debit = "Debit"; if (salePurchase.drcr == DrCr.Debit) { credit_debit = "Debit"; } else if (salePurchase.drcr == DrCr.Credit) { credit_debit = "Credit"; } opening_qry = " INSERT INTO tblLedger (" + " LedgerNumber, Ldate, AccountMasterId, modeId, Particulars, " + credit_debit + ", sourceId, UserId, SubUserId, FYear )" + " VALUES ( " + ledgerNumber + ", '" + salePurchase.BillDate + "' " + ", " + party + ", " + mode + ", '" + salePurchase.particulars + "' " + ", " + salePurchase.SalePurchaseAmount + ", " + salePurchase.transactionType + ", " + util.GetUserInsertQry(Util_BLL.User) + " ) "; site.Execute(opening_qry); } // sales - party string party_qry = " INSERT INTO tblLedger (" + " LedgerNumber, drcr, Ldate, AccountMasterId, modeId, BillNumber, Particulars, credit, Discount, sourceId, UserId, SubuserId, FYear )" + " VALUES ( " + ledgerNumber + ", 'C' " + ", '" + salePurchase.BillDate + "' " + ", " + party + ", " + mode + ", '" + util.GetLOVName(salePurchase.BillNumber) + "' " + ", '" + salePurchase.particulars + "' " + ", " + salePurchase.SalePurchaseAmount + ", '" + salePurchase.discount + "'" + ", " + salePurchase.transactionType + ", " + util.GetUserInsertQry(Util_BLL.User) + " ) "; // sales - party string mode_qry = " INSERT INTO tblLedger (" + " LedgerNumber, drcr, Ldate, AccountMasterId, modeId, BillNumber, Particulars, debit, Discount, sourceId, UserId, SubuserId, FYear )" + " VALUES ( " + ledgerNumber + ", 'D' " + ", '" + salePurchase.BillDate + "' " + ", " + mode + ", " + party + ", '" + util.GetLOVName(salePurchase.BillNumber) + "' " + ", '" + salePurchase.particulars + "' " + ", " + salePurchase.SalePurchaseAmount + ", '" + salePurchase.discount + "'" + ", " + salePurchase.transactionType + ", " + util.GetUserInsertQry(Util_BLL.User) + " ) "; site.Execute(party_qry); site.Execute(mode_qry); if (salePurchase.transactionType != TransactionType.PaymentMade && salePurchase.transactionType != TransactionType.PaymentRcd) { string tax_qry = ""; for (int i = 0; i < salePurchase.SalePurchaseTaxes.Count; i++) { tax_qry = " INSERT INTO tblTax(LedgerNumber, TaxMasterId, TaxAmount, UserID, SubuserId, FYear) " + " VALUES ( " + ledgerNumber + ", " + salePurchase.SalePurchaseTaxes[i].TaxId + ", " + salePurchase.SalePurchaseTaxes[i].TaxAmount + ", " + util.GetUserInsertQry(Util_BLL.User) + " ) "; site.Execute(tax_qry); } SaveProductLedger(site, salePurchase, ledgerNumber); } }