/// <summary> /// Takes the specified bADeposit. /// </summary> /// <param name="bADepositDetail">The bADeposit.</param> /// <returns></returns> private object[] Take(BADepositDetailEntity bADepositDetail) { return(new object[] { "@RefDetailID", bADepositDetail.RefDetailId, "@RefID", bADepositDetail.RefId, "@Description", bADepositDetail.Description, "@DebitAccount", bADepositDetail.DebitAccount, "@CreditAccount", bADepositDetail.CreditAccount, "@Amount", bADepositDetail.Amount, "@AmountOC", bADepositDetail.AmountOC, "@BudgetSourceID", bADepositDetail.BudgetSourceId, "@BudgetChapterCode", bADepositDetail.BudgetChapterCode, "@BudgetKindItemCode", bADepositDetail.BudgetKindItemCode, "@BudgetSubKindItemCode", bADepositDetail.BudgetSubKindItemCode, "@BudgetItemCode", bADepositDetail.BudgetItemCode, "@BudgetSubItemCode", bADepositDetail.BudgetSubItemCode, "@MethodDistributeID", bADepositDetail.MethodDistributeId, "@CashWithDrawTypeID", bADepositDetail.CashWithDrawTypeId, "@AccountingObjectID", bADepositDetail.AccountingObjectId, "@ActivityID", bADepositDetail.ActivityId, "@ProjectID", bADepositDetail.ProjectId, "@ProjectActivityID", bADepositDetail.ProjectActivityId, "@ProjectExpenseID", bADepositDetail.ProjectExpenseId, "@ListItemID", bADepositDetail.ListItemId, "@SortOrder", bADepositDetail.SortOrder, "@BudgetDetailItemCode", bADepositDetail.BudgetDetailItemCode, "@FundStructureID", bADepositDetail.FundStructureId, "@BudgetExpenseID", bADepositDetail.BudgetExpenseId, "@BankID", bADepositDetail.BankId, "@ContractID", bADepositDetail.ContractId, "@CapitalPlanId", bADepositDetail.CapitalPlanId, "@AutoBusinessID", bADepositDetail.AutoBusinessId, }); }
public List <BADepositDetailEntity> BADepositDetails(List <BADepositDetail> details, string refid) { List <BADepositDetailEntity> lstDetailEntities = new List <BADepositDetailEntity>(); foreach (var result in details) { var newresult = new BADepositDetailEntity(); 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.FundStructureId = result.FundStructure == null ? null : result.FundStructure.FundStructureID.ToString(); newresult.BudgetExpenseId = result.BudgetExpenseID.ToString(); //newresult.BankId = result.b; lstDetailEntities.Add(newresult); } return(lstDetailEntities); }
/// <summary> /// Inserts the bADeposit detail. /// </summary> /// <param name="bADepositDetail">The bADeposit detail.</param> /// <returns></returns> public string InsertBADepositDetail(BADepositDetailEntity bADepositDetail) { const string sql = @"uspInsert_BADepositDetail"; return(Db.Insert(sql, true, Take(bADepositDetail))); }