public void SaveProductLedger(DBSite site, SalePurchaseEntity salePurchase, int ledgerNumber)
{
string qry = "";
for (int i = 0; i < salePurchase.SalePurchaseDetails.Count; i++)
{
int productLedgerNumber = util.GetAutoNumber(site, "ProductLedgerNumber");
int theLocation = -1;
if (salePurchase.transactionType == TransactionType.Sales)
{
theLocation = GetLocationId(site, "OUT");
}
else
{
theLocation = GetLocationId(site, "IN");
}
qry = " INSERT INTO tblProductLedger(LedgerNumber, ProductLedgerNumber, drcr, BillDate, BillNumber, AccountId, ProductID, BoughtQty, Discount, rate, SourceId, LocationID, UserID, subuserId, FYear) "
+ " VALUES ( "
+ ledgerNumber
+ ", " + productLedgerNumber
+ ", 'C'"
+ ", '" + salePurchase.BillDate + "'"
+ ", '" + salePurchase.BillNumber + "'"
+ ", '" + util.GetLOVId(salePurchase.party) + "'"
+ ", " + salePurchase.SalePurchaseDetails[i].productAutoId
+ ", " + salePurchase.SalePurchaseDetails[i].qty
+ ", '" + salePurchase.SalePurchaseDetails[i].discount + " '"
+ ", " + salePurchase.SalePurchaseDetails[i].rate
+ ", " + salePurchase.SaleType
+ ", " + theLocation
//+ ", " + salePurchase.SalePurchaseDetails[i].locationId
+ ", " + util.GetUserInsertQry(Util_BLL.User)
+ " ) ";
site.Execute(qry);
qry = " INSERT INTO tblProductLedger(LedgerNumber, ProductLedgerNumber, drcr, BillDate, BillNumber, AccountId, ProductID, SoldQty, Discount, rate, SourceId, LocationID, UserID, subuserId, FYear) "
+ " VALUES ( "
+ ledgerNumber
+ ", " + productLedgerNumber
+ ", 'D'"
+ ", '" + salePurchase.BillDate + "'"
+ ", '" + salePurchase.BillNumber + "'"
+ ", '" + Modes.SaleAccount + "'"
+ ", " + salePurchase.SalePurchaseDetails[i].productAutoId
+ ", " + salePurchase.SalePurchaseDetails[i].qty
+ ", '" + salePurchase.SalePurchaseDetails[i].discount + " '"
+ ", " + salePurchase.SalePurchaseDetails[i].rate
+ ", " + salePurchase.SaleType
+ ", " + theLocation
//+ ", " + salePurchase.SalePurchaseDetails[i].locationId
+ ", " + util.GetUserInsertQry(Util_BLL.User)
+ " ) ";
site.Execute(qry);
string tax_qry = "";
for (int j = 0; j < salePurchase.SalePurchaseDetails[i].SalePurchaseDetailsTaxes.Count; j++)
{
tax_qry = " INSERT INTO tblTax(LedgerNumber, ProductLedgerNumber, TaxMasterId, TaxAmount, UserID, subUserId, FYear) "
+ " VALUES ( "
+ ledgerNumber
+ ", " + productLedgerNumber
+ ", " + salePurchase.SalePurchaseDetails[i].SalePurchaseDetailsTaxes[j].TaxId
+ ", " + salePurchase.SalePurchaseDetails[i].SalePurchaseDetailsTaxes[j].TaxAmount
+ ", " + util.GetUserInsertQry(Util_BLL.User)
+ " ) ";
site.Execute(tax_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);
}
}
