public List <BUCommitmentAdjustmentDetailEntity> BUCommitmentAdjustmentDetails(List <BUCommitmentAdjustmentDetail> details, string refid) { List <BUCommitmentAdjustmentDetailEntity> lstDetailEntities = new List <BUCommitmentAdjustmentDetailEntity>(); foreach (var result in details) { var newresult = new BUCommitmentAdjustmentDetailEntity(); newresult.RefDetailId = result.RefDetailID.ToString(); newresult.RefId = refid; newresult.Description = result.Description; newresult.CurrencyCode = result.CCY == null ? null : result.CCY.CurrencyID; newresult.ExchangeRate = result.ExchangeRate; 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.BudgetDetailItemCode = result.BudgetDetailItemCode; newresult.MethodDistributeId = result.MethodDistributeID; newresult.CashWithDrawTypeId = ConvertCash.ConvertCash(result.CashWithDrawTypeID); newresult.ActivityId = result.Activity == null ? null : result.Activity.ActivityID.ToString(); newresult.ProjectId = result.Project == null ? null : result.Project.ProjectID.ToString(); newresult.ProjectActivityId = result.ProjectActivityID.ToString(); newresult.ProjectExpenseId = result.ProjectExpense == null ? null : result.ProjectExpense.ProjectExpenseID.ToString(); newresult.TaskId = result.Task == null ? null : result.Task.TaskID.ToString(); newresult.ListItemId = result.ListItem == null ? null : result.ListItem.ListItemID.ToString(); newresult.Approved = result.Approved; newresult.FundStructureId = result.FundStructure == null ? null : result.FundStructure.FundStructureID.ToString(); newresult.SortOrder = result.SortOrder; newresult.BankAccount = result.BankAccount; newresult.BudgetProvideCode = result.BudgetProvidence == null ? null : result.BudgetProvidence.BudgetProvideCode; newresult.ToCurrencyCode = result.ToCurrencyID; newresult.ToExchangeRate = result.ToExchangeRate; newresult.ToAmountOC = result.ToAmountOC; newresult.ToAmount = result.ToAmount; newresult.ToBudgetSourceId = result.ToBudgetSourceID.ToString(); newresult.ToBudgetProvideCode = result.ToBudgetProvideCode; newresult.ToBudgetChapterCode = result.ToBudgetChapterCode; newresult.ToBudgetKindItemCode = result.ToBudgetKindItemCode; newresult.ToBudgetSubKindItemCode = result.ToBudgetSubKindItemCode; newresult.ToBudgetItemCode = result.ToBudgetItemCode; newresult.ToBudgetSubItemCode = result.ToBudgetSubItemCode; newresult.ToProjectId = result.ToProjectID.ToString(); newresult.RemainAmountOC = result.RemainAmountOC; newresult.RemainAmount = result.RemainAmount; newresult.RemainExchangeRate = result.RemainExchangeRate; newresult.RemainCurrencyCode = result.RemainCurrencyID; //newresult.BUCommitmentRequestDetailId = result.id; lstDetailEntities.Add(newresult); } return(lstDetailEntities); }
/// <summary> /// Takes the specified b u commitment adjustment detail entity. /// </summary> /// <param name="bUCommitmentAdjustmentDetailEntity">The b u commitment adjustment detail entity.</param> /// <returns>System.Object[].</returns> private static object[] Take(BUCommitmentAdjustmentDetailEntity bUCommitmentAdjustmentDetailEntity) { return(new object[] { "@RefDetailID", bUCommitmentAdjustmentDetailEntity.RefDetailId, "@RefID", bUCommitmentAdjustmentDetailEntity.RefId, "@Description", bUCommitmentAdjustmentDetailEntity.Description, "@CurrencyCode", bUCommitmentAdjustmentDetailEntity.CurrencyCode, "@ExchangeRate", bUCommitmentAdjustmentDetailEntity.ExchangeRate, "@Amount", bUCommitmentAdjustmentDetailEntity.Amount, "@AmountOC", bUCommitmentAdjustmentDetailEntity.AmountOC, "@BudgetSourceID", bUCommitmentAdjustmentDetailEntity.BudgetSourceId, "@BudgetChapterCode", bUCommitmentAdjustmentDetailEntity.BudgetChapterCode, "@BudgetKindItemCode", bUCommitmentAdjustmentDetailEntity.BudgetKindItemCode, "@BudgetSubKindItemCode", bUCommitmentAdjustmentDetailEntity.BudgetSubKindItemCode, "@BudgetItemCode", bUCommitmentAdjustmentDetailEntity.BudgetItemCode, "@BudgetSubItemCode", bUCommitmentAdjustmentDetailEntity.BudgetSubItemCode, "@BudgetDetailItemCode", bUCommitmentAdjustmentDetailEntity.BudgetDetailItemCode, "@MethodDistributeID", bUCommitmentAdjustmentDetailEntity.MethodDistributeId, "@CashWithDrawTypeID", bUCommitmentAdjustmentDetailEntity.CashWithDrawTypeId, "@ActivityID", bUCommitmentAdjustmentDetailEntity.ActivityId, "@ProjectID", bUCommitmentAdjustmentDetailEntity.ProjectId, "@ProjectActivityID", bUCommitmentAdjustmentDetailEntity.ProjectActivityId, "@ProjectExpenseID", bUCommitmentAdjustmentDetailEntity.ProjectExpenseId, "@TaskID", bUCommitmentAdjustmentDetailEntity.TaskId, "@ListItemID", bUCommitmentAdjustmentDetailEntity.ListItemId, "@Approved", bUCommitmentAdjustmentDetailEntity.Approved, "@FundStructureID", bUCommitmentAdjustmentDetailEntity.FundStructureId, "@SortOrder", bUCommitmentAdjustmentDetailEntity.SortOrder, "@BankAccount", bUCommitmentAdjustmentDetailEntity.BankAccount, "@BudgetProvideCode", bUCommitmentAdjustmentDetailEntity.BudgetProvideCode, "@ToCurrencyCode", bUCommitmentAdjustmentDetailEntity.ToCurrencyCode, "@ToExchangeRate", bUCommitmentAdjustmentDetailEntity.ToExchangeRate, "@ToAmountOC", bUCommitmentAdjustmentDetailEntity.ToAmountOC, "@ToAmount", bUCommitmentAdjustmentDetailEntity.ToAmount, "@ToBudgetSourceID", bUCommitmentAdjustmentDetailEntity.ToBudgetSourceId, "@ToBudgetProvideCode", bUCommitmentAdjustmentDetailEntity.ToBudgetProvideCode, "@ToBudgetChapterCode", bUCommitmentAdjustmentDetailEntity.ToBudgetChapterCode, "@ToBudgetKindItemCode", bUCommitmentAdjustmentDetailEntity.ToBudgetKindItemCode, "@ToBudgetSubKindItemCode", bUCommitmentAdjustmentDetailEntity.ToBudgetSubKindItemCode, "@ToBudgetItemCode", bUCommitmentAdjustmentDetailEntity.ToBudgetItemCode, "@ToBudgetSubItemCode", bUCommitmentAdjustmentDetailEntity.ToBudgetSubItemCode, "@ToProjectID", bUCommitmentAdjustmentDetailEntity.ToProjectId, "@RemainAmountOC", bUCommitmentAdjustmentDetailEntity.RemainAmountOC, "@RemainAmount", bUCommitmentAdjustmentDetailEntity.RemainAmount, "@RemainExchangeRate", bUCommitmentAdjustmentDetailEntity.RemainExchangeRate, "@RemainCurrencyCode", bUCommitmentAdjustmentDetailEntity.RemainCurrencyCode, "@BUCommitmentDetailId", bUCommitmentAdjustmentDetailEntity.BUCommitmentRequestDetailId, "@ContractID", bUCommitmentAdjustmentDetailEntity.ContractId, "@CapitalPlanID", bUCommitmentAdjustmentDetailEntity.CapitalPlanId, }); }
/// <summary> /// Inserts the bu plan receipt detail. /// </summary> /// <param name="bUCommitmentAdjustmentDetail">The b u commitment adjustment detail.</param> /// <returns>System.String.</returns> public string InsertBUCommitmentAdjustmenttDetail(BUCommitmentAdjustmentDetailEntity bUCommitmentAdjustmentDetail) { const string procedures = @"uspInsert_BUCommitmentAdjustmentDetail"; return(Db.Insert(procedures, true, Take(bUCommitmentAdjustmentDetail))); }