public List <CAPaymentDetailFixedAssetEntity> CAPaymentDetailFixedAssets(List <CAPaymentDetailFixedAsset> details, string refid) { List <CAPaymentDetailFixedAssetEntity> lstDetailEntities = new List <CAPaymentDetailFixedAssetEntity>(); foreach (var result in details) { var newresult = new CAPaymentDetailFixedAssetEntity(); newresult.RefDetailId = result.RefDetailID.ToString(); newresult.RefId = refid; newresult.FixedAssetId = result.FixedAsset == null ? null : result.FixedAsset.FixedAssetID.ToString(); newresult.Description = result.Description; newresult.DepartmentId = result.Department == null ? null : result.Department.DepartmentID.ToString(); newresult.DebitAccount = result.DebitAccount; newresult.CreditAccount = result.CreditAccount; newresult.Amount = result.Amount; newresult.TaxRate = result.TaxRate; newresult.TaxAmount = result.TaxAmount; newresult.TaxAccount = result.TaxAccount; newresult.InvType = result.InvType; newresult.InvDate = result.InvDate; newresult.InvSeries = result.InvSeries; newresult.InvNo = result.InvNo; newresult.PurchasePurposeId = result.PurchasePurpose == null ? null : result.PurchasePurpose.PurchasePurposeID.ToString(); newresult.FreightAmount = result.FreightAmount; newresult.OrgPrice = result.OrgPrice; 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.FundId = result.Fund == null ? null : result.Fund.FundID.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.Approved = result.Approved; newresult.SortOrder = result.SortOrder; newresult.BudgetDetailItemCode = result.BudgetDetailItemCode; newresult.InvoiceTypeCode = result.InvoiceTypeCode; 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.ProjectExpenseEAId = result.ProjectExpense1 == null ? null : result.ProjectExpense1.ProjectExpenseID.ToString(); newresult.ProjectActivityEAId = result.Project2 == null ? null : result.Project2.ProjectID.ToString(); //newresult.BudgetExpenseId = result.Budgete; lstDetailEntities.Add(newresult); } return(lstDetailEntities); }
/// <summary> /// Takes the specified c a payment detail fixed asset entity. /// </summary> /// <param name="cAPaymentDetailFixedAssetEntity">The c a payment detail fixed asset entity.</param> /// <returns>System.Object[].</returns> private static object[] Take(CAPaymentDetailFixedAssetEntity cAPaymentDetailFixedAssetEntity) { return(new object[] { "@RefDetailID", cAPaymentDetailFixedAssetEntity.RefDetailId, "@RefID", cAPaymentDetailFixedAssetEntity.RefId, "@FixedAssetID", cAPaymentDetailFixedAssetEntity.FixedAssetId, "@Description", cAPaymentDetailFixedAssetEntity.Description, "@DepartmentID", cAPaymentDetailFixedAssetEntity.DepartmentId, "@DebitAccount", cAPaymentDetailFixedAssetEntity.DebitAccount, "@CreditAccount", cAPaymentDetailFixedAssetEntity.CreditAccount, "@Amount", cAPaymentDetailFixedAssetEntity.Amount, "@TaxRate", cAPaymentDetailFixedAssetEntity.TaxRate, "@TaxAmount", cAPaymentDetailFixedAssetEntity.TaxAmount, "@TaxAccount", cAPaymentDetailFixedAssetEntity.TaxAccount, "@InvType", cAPaymentDetailFixedAssetEntity.InvType, "@InvDate", cAPaymentDetailFixedAssetEntity.InvDate, "@InvSeries", cAPaymentDetailFixedAssetEntity.InvSeries, "@InvNo", cAPaymentDetailFixedAssetEntity.InvNo, "@PurchasePurposeID", cAPaymentDetailFixedAssetEntity.PurchasePurposeId, "@FreightAmount", cAPaymentDetailFixedAssetEntity.FreightAmount, "@OrgPrice", cAPaymentDetailFixedAssetEntity.OrgPrice, "@BudgetSourceID", cAPaymentDetailFixedAssetEntity.BudgetSourceId, "@BudgetChapterCode", cAPaymentDetailFixedAssetEntity.BudgetChapterCode, "@BudgetKindItemCode", cAPaymentDetailFixedAssetEntity.BudgetKindItemCode, "@BudgetSubKindItemCode", cAPaymentDetailFixedAssetEntity.BudgetSubKindItemCode, "@BudgetItemCode", cAPaymentDetailFixedAssetEntity.BudgetItemCode, "@BudgetSubItemCode", cAPaymentDetailFixedAssetEntity.BudgetSubItemCode, "@MethodDistributeID", cAPaymentDetailFixedAssetEntity.MethodDistributeId, "@CashWithdrawTypeID", cAPaymentDetailFixedAssetEntity.CashWithdrawTypeId, "@AccountingObjectID", cAPaymentDetailFixedAssetEntity.AccountingObjectId, "@ActivityID", cAPaymentDetailFixedAssetEntity.ActivityId, "@ProjectID", cAPaymentDetailFixedAssetEntity.ProjectId, "@FundID", cAPaymentDetailFixedAssetEntity.FundId, "@ProjectActivityID", cAPaymentDetailFixedAssetEntity.ProjectActivityId, "@ProjectExpenseID", cAPaymentDetailFixedAssetEntity.ProjectExpenseId, "@ListItemID", cAPaymentDetailFixedAssetEntity.ListItemId, "@Approved", cAPaymentDetailFixedAssetEntity.Approved, "@SortOrder", cAPaymentDetailFixedAssetEntity.SortOrder, "@BudgetDetailItemCode", cAPaymentDetailFixedAssetEntity.BudgetDetailItemCode, "@InvoiceTypeCode", cAPaymentDetailFixedAssetEntity.InvoiceTypeCode, "@OrgRefNo", cAPaymentDetailFixedAssetEntity.OrgRefNo, "@OrgRefDate", cAPaymentDetailFixedAssetEntity.OrgRefDate, "@FundStructureID", cAPaymentDetailFixedAssetEntity.FundStructureId, "@BankID", cAPaymentDetailFixedAssetEntity.BankId, "@ProjectExpenseEAID", cAPaymentDetailFixedAssetEntity.ProjectExpenseEAId, "@ProjectActivityEAID", cAPaymentDetailFixedAssetEntity.ProjectActivityEAId, "@BudgetExpenseID", cAPaymentDetailFixedAssetEntity.BudgetExpenseId, "@ContractID", cAPaymentDetailFixedAssetEntity.ContractId, "@CapitalPlanID", cAPaymentDetailFixedAssetEntity.CapitalPlanId, "@Quantity", cAPaymentDetailFixedAssetEntity.Quantity, "@AmountOC", cAPaymentDetailFixedAssetEntity.AmountOC }); }
/// <summary> /// Inserts the ca payment detail fixed asset. /// </summary> /// <param name="cAPaymentDetailFixedAsset">The c a payment detail fixed asset.</param> /// <returns>System.String.</returns> public string InsertCAPaymentDetailFixedAsset(CAPaymentDetailFixedAssetEntity cAPaymentDetailFixedAsset) { const string procedures = @"uspInsert_CAPaymentDetailFixedAsset"; return(Db.Insert(procedures, true, Take(cAPaymentDetailFixedAsset))); }