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