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