public List <BUTransferDetailEntity> BUTransferDetails(List <BUTransferDetail> details, string refid) { List <BUTransferDetailEntity> lstDetailEntities = new List <BUTransferDetailEntity>(); foreach (var result in details) { var newresult = new BUTransferDetailEntity(); 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.TaskId = result.Task == null ? null : result.Task.TaskID.ToString(); newresult.ListItemId = result.ListItem == null ? null : result.ListItem.ListItemID.ToString(); newresult.Approved = result.Approved; newresult.SortOrder = result.SortOrder; newresult.BudgetDetailItemCode = result.BudgetDetailItemCode; newresult.FundId = result.Fund == null ? null : result.Fund.FundID.ToString(); newresult.OrgRefNo = result.OrgRefNo; newresult.OrgRefDate = result.OrgRefDate; newresult.FundStructureId = result.FundStructure == null ? null : result.FundStructure.FundStructureID.ToString(); newresult.ProjectExpenseEAId = result.ProjectExpense1 == null ? null : result.ProjectExpense1.ProjectExpenseID.ToString(); newresult.ProjectActivityEAId = result.Project2 == null ? null : result.Project2.ProjectID.ToString(); newresult.WithdrawRefDetailId = result.WithdrawRefDetailID.ToString(); newresult.BudgetProvideCode = result.BudgetProvidence == null ? null : result.BudgetProvidence.BudgetProvideCode; newresult.TopicId = result.Topic == null ? null : result.Topic.TopicID.ToString(); //newresult.BudgetExpenseId = result.budget; //newresult.BankId = result.; lstDetailEntities.Add(newresult); } return(lstDetailEntities); }
/// <summary> /// Takes the specified b u transfer detail entity. /// </summary> /// <param name="bUTransferDetailEntity">The b u transfer detail entity.</param> /// <returns>System.Object[].</returns> private static object[] Take(BUTransferDetailEntity bUTransferDetailEntity) { return(new object[] { "@RefDetailID", bUTransferDetailEntity.RefDetailId, "@RefID", bUTransferDetailEntity.RefId, "@Description", bUTransferDetailEntity.Description, "@DebitAccount", bUTransferDetailEntity.DebitAccount, "@CreditAccount", bUTransferDetailEntity.CreditAccount, "@Amount", bUTransferDetailEntity.Amount, "@AmountOC", bUTransferDetailEntity.AmountOC, "@BudgetSourceID", bUTransferDetailEntity.BudgetSourceId, "@BudgetChapterCode", bUTransferDetailEntity.BudgetChapterCode, "@BudgetKindItemCode", bUTransferDetailEntity.BudgetKindItemCode, "@BudgetSubKindItemCode", bUTransferDetailEntity.BudgetSubKindItemCode, "@BudgetItemCode", bUTransferDetailEntity.BudgetItemCode, "@BudgetSubItemCode", bUTransferDetailEntity.BudgetSubItemCode, "@MethodDistributeID", bUTransferDetailEntity.MethodDistributeId, "@CashWithDrawTypeID", bUTransferDetailEntity.CashWithDrawTypeId, "@AccountingObjectID", bUTransferDetailEntity.AccountingObjectId, "@ActivityID", bUTransferDetailEntity.ActivityId, "@ProjectID", bUTransferDetailEntity.ProjectId, "@ProjectActivityID", bUTransferDetailEntity.ProjectActivityId, "@ProjectExpenseID", bUTransferDetailEntity.ProjectExpenseId, "@TaskID", bUTransferDetailEntity.TaskId, "@ListItemID", bUTransferDetailEntity.ListItemId, "@Approved", bUTransferDetailEntity.Approved, "@SortOrder", bUTransferDetailEntity.SortOrder, "@BudgetDetailItemCode", bUTransferDetailEntity.BudgetDetailItemCode, "@FundID", bUTransferDetailEntity.FundId, "@OrgRefNo", bUTransferDetailEntity.OrgRefNo, "@OrgRefDate", bUTransferDetailEntity.OrgRefDate, "@FundStructureID", bUTransferDetailEntity.FundStructureId, "@ProjectExpenseEAID", bUTransferDetailEntity.ProjectExpenseEAId, "@ProjectActivityEAID", bUTransferDetailEntity.ProjectActivityEAId, "@WithdrawRefDetailID", bUTransferDetailEntity.WithdrawRefDetailId, "@BudgetProvideCode", bUTransferDetailEntity.BudgetProvideCode, "@TopicID", bUTransferDetailEntity.TopicId, "@BudgetExpenseID", bUTransferDetailEntity.BudgetExpenseId, "@BankID", bUTransferDetailEntity.BankId, "@ContractID", bUTransferDetailEntity.ContractId, "@CapitalPlanID", bUTransferDetailEntity.CapitalPlanId, "@OldAdvanceRecovery", bUTransferDetailEntity.OldAdvanceRecovery, "@AdvanceRecovery", bUTransferDetailEntity.AdvanceRecovery, "@AutoBusinessID", bUTransferDetailEntity.AutoBusinessID, }); }
/// <summary> /// Inserts the bu plan receipt detail. /// </summary> /// <param name="bUTransferDetail">The b u commitment adjustment detail.</param> /// <returns>System.String.</returns> public string InsertBUTransferDetail(BUTransferDetailEntity bUTransferDetail) { const string procedures = @"uspInsert_BUTransferDetail"; return(Db.Insert(procedures, true, Take(bUTransferDetail))); }