public List <CAReceiptDetailEntity> CAReceiptDetails(List <CAReceiptDetail> details, string refid) { List <CAReceiptDetailEntity> lstDetailEntities = new List <CAReceiptDetailEntity>(); foreach (var result in details) { var newresult = new CAReceiptDetailEntity(); newresult.RefDetailId = result.RefDetailID.ToString(); newresult.RefId = refid; newresult.Description = result.Description; newresult.DebitAccount = result.DebitAccount; newresult.CreditAccount = result.CreditAccount; newresult.Amount = result.Amount; newresult.AmountOC = result.AmountOC; newresult.BudgetSourceId = result.BudgetSource == null ? null : result.BudgetSource.BudgetSourceID.ToString(); newresult.BudgetChapterCode = result.BudgetChapterCode; newresult.BudgetKindItemCode = result.BudgetKindItemCode; newresult.BudgetSubKindItemCode = result.BudgetSubKindItemCode; newresult.BudgetItemCode = result.BudgetItemCode; newresult.BudgetSubItemCode = result.BudgetSubItemCode; newresult.MethodDistributeId = result.MethodDistributeID; newresult.CashWithdrawTypeId = ConvertCash.ConvertCash(result.CashWithdrawTypeID); newresult.AccountingObjectId = result.AccountingObject == null ? null : result.AccountingObject.AccountingObjectID.ToString(); newresult.ActivityId = result.Activity == null ? null : result.Activity.ActivityID.ToString(); newresult.ProjectId = result.Project == null ? null : result.Project.ProjectID.ToString(); newresult.ProjectActivityId = result.Project1 == null ? null : result.Project1.ProjectID.ToString(); newresult.ProjectExpenseId = result.ProjectExpense == null ? null : result.ProjectExpense.ProjectExpenseID.ToString(); newresult.ListItemId = result.ListItem == null ? null : result.ListItem.ListItemID.ToString(); newresult.SortOrder = result.SortOrder; newresult.BudgetDetailItemCode = result.BudgetDetailItemCode; newresult.OrgRefNo = result.OrgRefNo; newresult.OrgRefDate = result.OrgRefDate; newresult.FundStructureId = result.FundStructure == null ? null : result.FundStructure.FundStructureID.ToString(); newresult.BankId = result.BankAccount == null ? null : banks.FirstOrDefault(x => x.BankAccount == result.BankAccount).BankInfoID.ToString(); newresult.ProjectActivityEAId = result.Project2 == null ? null : result.Project2.ProjectID.ToString(); newresult.WithdrawDetailId = result.WithdrawDetailID.ToString(); newresult.BudgetExpenseId = result.BudgetExpenseID.ToString(); lstDetailEntities.Add(newresult); } return(lstDetailEntities); }
/// <summary> /// Takes the specified information. /// </summary> /// <param name="cAReceiptDetailEntity">The c a receipt detail entity.</param> /// <returns>System.Object[].</returns> private object[] Take(CAReceiptDetailEntity cAReceiptDetailEntity) { return(new object[] { "@RefDetailId", cAReceiptDetailEntity.RefDetailId, "@RefId", cAReceiptDetailEntity.RefId, "@Description", cAReceiptDetailEntity.Description, "@DebitAccount", cAReceiptDetailEntity.DebitAccount, "@CreditAccount", cAReceiptDetailEntity.CreditAccount, "@Amount", cAReceiptDetailEntity.Amount, "@AmountOC", cAReceiptDetailEntity.AmountOC, "@BudgetSourceId", cAReceiptDetailEntity.BudgetSourceId, "@BudgetChapterCode", cAReceiptDetailEntity.BudgetChapterCode, "@BudgetKindItemCode", cAReceiptDetailEntity.BudgetKindItemCode, "@BudgetSubKindItemCode", cAReceiptDetailEntity.BudgetSubKindItemCode, "@BudgetItemCode", cAReceiptDetailEntity.BudgetItemCode, "@BudgetSubItemCode", cAReceiptDetailEntity.BudgetSubItemCode, "@MethodDistributeId", cAReceiptDetailEntity.MethodDistributeId, "@CashWithdrawTypeId", cAReceiptDetailEntity.CashWithdrawTypeId, "@AccountingObjectId", cAReceiptDetailEntity.AccountingObjectId, "@ActivityId", cAReceiptDetailEntity.ActivityId, "@ProjectId", cAReceiptDetailEntity.ProjectId, "@ProjectActivityId", cAReceiptDetailEntity.ProjectActivityId, "@ProjectExpenseId", cAReceiptDetailEntity.ProjectExpenseId, "@ListItemId", cAReceiptDetailEntity.ListItemId, "@SortOrder", cAReceiptDetailEntity.SortOrder, "@BudgetDetailItemCode", cAReceiptDetailEntity.BudgetDetailItemCode, "@OrgRefNo", cAReceiptDetailEntity.OrgRefNo, "@OrgRefDate", cAReceiptDetailEntity.OrgRefDate, "@FundStructureId", cAReceiptDetailEntity.FundStructureId, "@BankId", cAReceiptDetailEntity.BankId, "@ProjectActivityEAId", cAReceiptDetailEntity.ProjectActivityEAId, "@WithdrawDetailId", cAReceiptDetailEntity.WithdrawDetailId, "@BudgetExpenseID", cAReceiptDetailEntity.BudgetExpenseId, "@ContractID", cAReceiptDetailEntity.ContractId, "@CapitalPlanID", cAReceiptDetailEntity.CapitalPlanId, "@AutoBusinessID", cAReceiptDetailEntity.AutoBusinessId, }); }
/// <summary> /// Inserts the ca receipt detail. /// </summary> /// <param name="receiptDetailEntity">The receipt detail entity.</param> /// <returns>System.String.</returns> public string InsertCAReceiptDetail(CAReceiptDetailEntity receiptDetailEntity) { const string procedures = @"uspInsert_CAReceiptDetail"; return(Db.Insert(procedures, true, Take(receiptDetailEntity))); }