/// <summary>
/// Takes the specified general ledger entity.
/// </summary>
/// <param name="inventoryLedgerEntity">The general ledger entity.</param>
/// <returns>System.Object[].</returns>
private object[] Take(InventoryLedgerEntity inventoryLedgerEntity)
{
return(new object[]
{
"@InventoryLedgerID", inventoryLedgerEntity.InventoryLedgerId,
"@RefID", inventoryLedgerEntity.RefId,
"@RefType", inventoryLedgerEntity.RefType,
"@RefNo", inventoryLedgerEntity.RefNo,
"@RefDate", inventoryLedgerEntity.RefDate,
"@PostedDate", inventoryLedgerEntity.PostedDate,
"@AccountNumber", inventoryLedgerEntity.AccountNumber,
"@CorrespondingAccountNumber", inventoryLedgerEntity.CorrespondingAccountNumber,
"@BudgetSourceID", inventoryLedgerEntity.BudgetSourceId,
"@StockID", inventoryLedgerEntity.StockId,
"@InventoryItemID", inventoryLedgerEntity.InventoryItemId,
"@Unit", inventoryLedgerEntity.Unit,
"@UnitPrice", inventoryLedgerEntity.UnitPrice,
"@InwardQuantity", inventoryLedgerEntity.InwardQuantity,
"@OutwardQuantity", inventoryLedgerEntity.OutwardQuantity,
"@InwardAmount", inventoryLedgerEntity.InwardAmount,
"@OutwardAmount", inventoryLedgerEntity.OutwardAmount,
"@InwardQuantityBalance", inventoryLedgerEntity.InwardQuantityBalance,
"@InwardAmountBalance", inventoryLedgerEntity.InwardAmountBalance,
"@JournalMemo", inventoryLedgerEntity.JournalMemo,
"@Description", inventoryLedgerEntity.Description,
"@OutwardPurpose", inventoryLedgerEntity.OutwardPurpose,
"@ExpiryDate", inventoryLedgerEntity.ExpiryDate,
"@LotNo", inventoryLedgerEntity.LotNo,
"@RefOrder", inventoryLedgerEntity.RefOrder,
"@RefDetailID", inventoryLedgerEntity.RefDetailId,
"@SortOrder", inventoryLedgerEntity.SortOrder,
"@ConfrontingRefID", inventoryLedgerEntity.ConfrontingRefId,
"@InwardRefDetailID", inventoryLedgerEntity.InwardRefDetailId,
"@UnitPriceBalance", inventoryLedgerEntity.UnitPriceBalance,
"@InwardAmountBalanceAfter", inventoryLedgerEntity.InwardAmountBalanceAfter,
"@BudgetProvideCode", inventoryLedgerEntity.BudgetProvideCode,
"@InwardAmountOC", inventoryLedgerEntity.InwardAmountOC,
"@OutwardAmountOC", inventoryLedgerEntity.OutwardAmountOC,
"@CurrencyCode", inventoryLedgerEntity.CurrencyCode,
});
}
/// <summary>
/// Inserts the general ledger.
/// </summary>
/// <param name="inventoryLedgerEntity">The general ledger entity.</param>
/// <returns>System.Int32.</returns>
public string InsertInventoryLedger(InventoryLedgerEntity inventoryLedgerEntity)
{
const string procedures = @"uspInsert_InventoryLedger";
return(Db.Insert(procedures, true, Take(inventoryLedgerEntity)));
}
