/// <summary> /// Takes the specified bADeposit. /// </summary> /// <param name="bADepositDetailFixedAsset">The bADeposit.</param> /// <returns></returns> private static object[] Take(BADepositDetailFixedAssetEntity bADepositDetailFixedAssetEntity) { return(new object[] { "@RefDetailID", bADepositDetailFixedAssetEntity.RefDetailId, "@RefID", bADepositDetailFixedAssetEntity.RefId, "@FixedAssetID", bADepositDetailFixedAssetEntity.FixedAssetId, "@Description", bADepositDetailFixedAssetEntity.Description, "@DebitAccount", bADepositDetailFixedAssetEntity.DebitAccount, "@CreditAccount", bADepositDetailFixedAssetEntity.CreditAccount, "@Amount", bADepositDetailFixedAssetEntity.Amount, "@TaxRate", bADepositDetailFixedAssetEntity.TaxRate, "@TaxAmount", bADepositDetailFixedAssetEntity.TaxAmount, "@TaxAccount", bADepositDetailFixedAssetEntity.TaxAccount, "@BudgetSourceID", bADepositDetailFixedAssetEntity.BudgetSourceId, "@BudgetChapterCode", bADepositDetailFixedAssetEntity.BudgetChapterCode, "@BudgetKindItemCode", bADepositDetailFixedAssetEntity.BudgetKindItemCode, "@BudgetSubKindItemCode", bADepositDetailFixedAssetEntity.BudgetSubKindItemCode, "@BudgetItemCode", bADepositDetailFixedAssetEntity.BudgetItemCode, "@BudgetSubItemCode", bADepositDetailFixedAssetEntity.BudgetSubItemCode, "@MethodDistributeID", bADepositDetailFixedAssetEntity.MethodDistributeId, "@CashWithdrawTypeID", bADepositDetailFixedAssetEntity.CashWithdrawTypeId, "@AccountingObjectID", bADepositDetailFixedAssetEntity.AccountingObjectId, "@ActivityID", bADepositDetailFixedAssetEntity.ActivityId, "@ProjectID", bADepositDetailFixedAssetEntity.ProjectId, "@ProjectActivityID", bADepositDetailFixedAssetEntity.ProjectActivityId, "@ProjectExpenseID", bADepositDetailFixedAssetEntity.ProjectExpenseId, "@ListItemID", bADepositDetailFixedAssetEntity.ListItemId, "@SortOrder", bADepositDetailFixedAssetEntity.SortOrder, "@BudgetDetailItemCode", bADepositDetailFixedAssetEntity.BudgetDetailItemCode, "@FundStructureID", bADepositDetailFixedAssetEntity.FundStructureId, "@ProjectExpenseEAID", bADepositDetailFixedAssetEntity.ProjectExpenseEAId, "@ProjectActivityEAID", bADepositDetailFixedAssetEntity.ProjectActivityEAId }); }
public List <BADepositDetailFixedAssetEntity> BADepositDetailFixedAssets(List <BADepositDetailFixedAsset> details, string refid) { List <BADepositDetailFixedAssetEntity> lstDetailEntities = new List <BADepositDetailFixedAssetEntity>(); foreach (var result in details) { var newresult = new BADepositDetailFixedAssetEntity(); newresult.RefDetailId = result.RefDetailID.ToString(); newresult.RefId = refid; newresult.FixedAssetId = result.FixedAsset == null ? null : result.FixedAsset.FixedAssetID.ToString(); newresult.Description = result.Description; newresult.DebitAccount = result.DebitAccount; newresult.CreditAccount = result.CreditAccount; newresult.Amount = result.Amount; newresult.TaxRate = result.TaxRate ?? 0; newresult.TaxAmount = result.TaxAmount; newresult.TaxAccount = result.TaxAccount; 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.FundStructureId = result.FundStructure == null ? null : result.FundStructure.FundStructureID.ToString(); newresult.ProjectExpenseEAId = result.ProjectExpense1 == null ? null : result.ProjectExpense1.ProjectExpenseID.ToString(); newresult.ProjectActivityEAId = result.Project1 == null ? null : result.Project1.ProjectID.ToString(); lstDetailEntities.Add(newresult); } return(lstDetailEntities); }
/// <summary> /// Inserts the bADeposit detail. /// </summary> /// <param name="bADepositDetailFixedAsset">The bADeposit detail.</param> /// <returns></returns> public string InsertBADepositDetailFixedAsset(BADepositDetailFixedAssetEntity bADepositDetailFixedAsset) { const string sql = @"uspInsert_BADepositDetailFixedAsset"; return(Db.Insert(sql, true, Take(bADepositDetailFixedAsset))); }