/// <summary>
/// Takes the specified bADeposit.
/// </summary>
/// <param name="sUIncrementDecrementDetail">The bADeposit.</param>
/// <returns></returns>
private object[] Take(SUIncrementDecrementDetailEntity sUIncrementDecrementDetail)
{
return(new object[]
{
"@RefDetailID", sUIncrementDecrementDetail.RefDetailId,
"@RefID", sUIncrementDecrementDetail.RefId,
"@InventoryItemID", sUIncrementDecrementDetail.InventoryItemId,
"@Description", sUIncrementDecrementDetail.Description,
"@DepartmentID", sUIncrementDecrementDetail.DepartmentId,
"@DebitAccount", sUIncrementDecrementDetail.DebitAccount,
"@CreditAccount", sUIncrementDecrementDetail.CreditAccount,
"@Quantity", sUIncrementDecrementDetail.Quantity,
"@QuantityConvert", sUIncrementDecrementDetail.QuantityConvert,
"@UnitPrice", sUIncrementDecrementDetail.UnitPrice,
"@UnitPriceConvert", sUIncrementDecrementDetail.UnitPriceConvert,
"@Amount", sUIncrementDecrementDetail.Amount,
"@BudgetChapterCode", sUIncrementDecrementDetail.BudgetChapterCode,
"@AccountingObjectID", sUIncrementDecrementDetail.AccountingObjectId,
"@ListItemID", sUIncrementDecrementDetail.ListItemId,
"@SortOrder", sUIncrementDecrementDetail.SortOrder,
"@BudgetSourceID", sUIncrementDecrementDetail.BudgetSourceId,
"@BudgetKindItemCode", sUIncrementDecrementDetail.BudgetKindItemCode,
"@BudgetSubKindItemCode", sUIncrementDecrementDetail.BudgetSubKindItemCode,
"@BudgetProvideCode", sUIncrementDecrementDetail.BudgetProvideCode,
"@TopicID", sUIncrementDecrementDetail.TopicId
});
}
public List <SUIncrementDecrementDetailEntity> SUIncrementDecrementDetails(List <SUIncrementDecrementDetail> details, string refid)
{
List <SUIncrementDecrementDetailEntity> lstDetailEntities = new List <SUIncrementDecrementDetailEntity>();
foreach (var result in details)
{
var newresult = new SUIncrementDecrementDetailEntity();
newresult.RefDetailId = result.RefDetailID.ToString();
newresult.RefId = refid;
newresult.InventoryItemId = result.InventoryItem == null ? null : result.InventoryItem.InventoryItemID.ToString();
newresult.Description = result.Description;
newresult.DepartmentId = result.Department == null ? null : result.Department.DepartmentID.ToString();
newresult.DebitAccount = result.DebitAccount;
newresult.CreditAccount = result.CreditAccount;
newresult.Quantity = result.Quantity;
newresult.QuantityConvert = result.QuantityConvert;
newresult.UnitPrice = result.UnitPrice;
newresult.UnitPriceConvert = result.UnitPriceConvert;
newresult.Amount = result.Amount;
newresult.BudgetChapterCode = result.BudgetChapterCode;
newresult.AccountingObjectId = result.AccountingObject == null ? null : result.AccountingObject.AccountingObjectID.ToString();
newresult.ListItemId = result.ListItem == null ? null : result.ListItem.ListItemID.ToString();
newresult.SortOrder = result.SortOrder;
newresult.BudgetSourceId = result.BudgetSource == null ? null : result.BudgetSource.BudgetSourceID.ToString();
newresult.BudgetKindItemCode = result.BudgetKindItemCode;
newresult.BudgetSubKindItemCode = result.BudgetSubKindItemCode;
newresult.BudgetProvideCode = result.BudgetProvidence == null ? null : result.BudgetProvidence.BudgetProvideCode;
newresult.TopicId = result.Topic == null ? null : result.Topic.TopicID.ToString();
lstDetailEntities.Add(newresult);
}
return(lstDetailEntities);
}
private object[] Take(SUIncrementDecrementDetailEntity sUIncrementDecrementDetail)
{
return(new object[]
{
"@RefDetailID", sUIncrementDecrementDetail.RefDetailId,
"@RefID", sUIncrementDecrementDetail.RefId,
"@DebitAccount", sUIncrementDecrementDetail.DebitAccount,
"@CreditAccount", sUIncrementDecrementDetail.CreditAccount,
"@Description", sUIncrementDecrementDetail.Description,
"@InventoryItemID", sUIncrementDecrementDetail.InventoryItemId,
"@DepartmentID", sUIncrementDecrementDetail.DepartmentId,
"@Quantity", sUIncrementDecrementDetail.Quantity,
"@UnitPriceOc", sUIncrementDecrementDetail.UnitPriceOc,
"@UnitPriceExchange", sUIncrementDecrementDetail.UnitPriceExchange,
"@AmountOc", sUIncrementDecrementDetail.AmountOc,
"@AmountExchange", sUIncrementDecrementDetail.AmountExchange,
"@AccountingObjectID", sUIncrementDecrementDetail.AccountingObjectId,
"@CustomerID", sUIncrementDecrementDetail.CustomerId,
"@VendorID", sUIncrementDecrementDetail.VendorId,
"@EmployeeID", sUIncrementDecrementDetail.EmployeeId,
"@SortOrder", sUIncrementDecrementDetail.SortOrder,
"@BudgetSourceID", sUIncrementDecrementDetail.BudgetSourceId
});
}
internal static SUIncrementDecrementDetailModel FromDataTransferObject(SUIncrementDecrementDetailEntity entity)
{
return(entity == null ? null : AutoMapper.Mapper.Map <SUIncrementDecrementDetailEntity, SUIncrementDecrementDetailModel>(entity));
}
/// <summary>
/// Inserts the bADeposit detail.
/// </summary>
/// <param name="sUIncrementDecrementDetail">The bADeposit detail.</param>
/// <returns></returns>
public string InsertSUIncrementDecrementDetail(SUIncrementDecrementDetailEntity sUIncrementDecrementDetail)
{
const string sql = @"uspInsert_SUIncrementDecrementDetail";
return(Db.Insert(sql, true, Take(sUIncrementDecrementDetail)));
}
private SupplyLedgerEntity MakeSupplyLedger(SUIncrementDecrementEntity suIncrementDecrement, SUIncrementDecrementDetailEntity suIncrementDecrementDetail)
{
var result = new SupplyLedgerEntity();
result.SupplyLedgerId = 0;
result.RefId = suIncrementDecrement.RefId;
result.RefDetailId = suIncrementDecrementDetail.RefDetailId;
result.RefType = suIncrementDecrement.RefType;
result.RefNo = suIncrementDecrement.RefNo;
result.RefDate = suIncrementDecrement.RefDate;
result.PostedDate = suIncrementDecrement.PostedDate;
result.Description = suIncrementDecrementDetail.Description;
result.JournalMemo = suIncrementDecrement.JournalMemo;
result.InventoryItemId = suIncrementDecrementDetail.InventoryItemId;
result.DepartmentId = suIncrementDecrementDetail.DepartmentId;
result.CurrencyCode = suIncrementDecrement.CurrencyCode;
result.ExchangeRate = suIncrementDecrement.ExchangeRate;
result.Unit = InventoryItemDao.GetInventoryItem(suIncrementDecrementDetail.InventoryItemId)?.Unit ?? null;
result.Quantity = suIncrementDecrementDetail.Quantity;
result.UnitPriceOc = suIncrementDecrementDetail.UnitPriceOc;
result.UnitPriceExchange = suIncrementDecrementDetail.UnitPriceExchange;
result.AmountOc = suIncrementDecrementDetail.AmountOc;
result.AmountExchange = suIncrementDecrementDetail.AmountExchange;
return(result);
}
/// <summary>
/// Inserts the account balance.
/// </summary>
/// <param name="suIncrementDecrement">The su increment decrement.</param>
/// <param name="suIncrementDecrementDetail">The su increment decrement detail.</param>
public void InsertAccountBalance(SUIncrementDecrementEntity suIncrementDecrement, SUIncrementDecrementDetailEntity suIncrementDecrementDetail)
{
//insert AccountBalance for debit account
var accountBalanceForDebit = AddAccountBalanceForDebit(suIncrementDecrement, suIncrementDecrementDetail);
var accountBalanceForDebitExit = AccountBalanceDao.GetExitsAccountBalance(accountBalanceForDebit);
if (accountBalanceForDebitExit != null)
{
UpdateAccountBalance(accountBalanceForDebitExit, accountBalanceForDebit.MovementDebitAmountOC,
accountBalanceForDebit.MovementDebitAmount, true, 1);
}
else
{
AccountBalanceDao.InsertAccountBalance(accountBalanceForDebit);
}
//insert AccountBalance for credit account
var accountBalanceForCredit = AddAccountBalanceForCredit(suIncrementDecrement, suIncrementDecrementDetail);
var accountBalanceForCreditExit = AccountBalanceDao.GetExitsAccountBalance(accountBalanceForCredit);
if (accountBalanceForCreditExit != null)
{
UpdateAccountBalance(accountBalanceForCreditExit, accountBalanceForCredit.MovementCreditAmountOC,
accountBalanceForCredit.MovementCreditAmount, true, 2);
}
else
{
AccountBalanceDao.InsertAccountBalance(accountBalanceForCredit);
}
}
/// <summary>
/// Adds the account balance for credit.
/// </summary>
/// <param name="suIncrementDecrement">The su increment decrement.</param>
/// <param name="suIncrementDecrementDetail">The su increment decrement detail.</param>
/// <returns></returns>
public AccountBalanceEntity AddAccountBalanceForCredit(SUIncrementDecrementEntity suIncrementDecrement, SUIncrementDecrementDetailEntity suIncrementDecrementDetail)
{
//credit account
return(new AccountBalanceEntity
{
AccountBalanceId = Guid.NewGuid().ToString(),
AccountNumber = suIncrementDecrementDetail.CreditAccount,
CurrencyCode = "VND",
ExchangeRate = 1,
BalanceDate = suIncrementDecrement.PostedDate,
MovementDebitAmountOC = 0,
MovementDebitAmount = 0,
MovementCreditAmountOC = suIncrementDecrementDetail.Amount,
MovementCreditAmount = suIncrementDecrementDetail.Amount,
BudgetSourceId = suIncrementDecrementDetail.BudgetSourceId,
BudgetChapterCode = suIncrementDecrementDetail.BudgetChapterCode,
BudgetKindItemCode = suIncrementDecrementDetail.BudgetKindItemCode,
BudgetSubKindItemCode = suIncrementDecrementDetail.BudgetSubKindItemCode,
AccountingObjectId = suIncrementDecrementDetail.AccountingObjectId,
});
}
