/// <summary> /// Inserts the bu voucher list detail parallel. /// </summary> /// <param name="bUVoucherListDetailTransferEntity">The b u voucher list detail parallel entity.</param> /// <returns></returns> public string InsertBUVoucherListDetailTransfer( BUVoucherListDetailTransferEntity bUVoucherListDetailTransferEntity) { const string procedures = @"uspInsert_BUVoucherListDetailTransfer"; return(Db.Insert(procedures, true, Take(bUVoucherListDetailTransferEntity))); }
/// <summary> /// Updates the bu voucher list detail parallel. /// </summary> /// <param name="bUVoucherListDetailTransferEntity">The b u voucher list detail parallel entity.</param> /// <returns></returns> public string UpdateBUVoucherListDetailTransfer( BUVoucherListDetailTransferEntity bUVoucherListDetailTransferEntity) { const string procedures = @"uspUpdate_BUVoucherListDetailTransfer"; return(Db.Update(procedures, true, Take(bUVoucherListDetailTransferEntity))); }
public List <BUVoucherListDetailTransferEntity> BUVoucherListDetailTransfers(List <BUVoucherListDetailTransfer> details, string refid) { List <BUVoucherListDetailTransferEntity> lstDetailEntities = new List <BUVoucherListDetailTransferEntity>(); foreach (var result in details) { var newresult = new BUVoucherListDetailTransferEntity(); newresult.RefDetailId = result.RefDetailID.ToString(); newresult.RefId = refid; 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.Amount = result.Amount; newresult.DebitAccount = result.DebitAccount; newresult.CreditAccount = result.CreditAccount; newresult.Description = result.Description; newresult.ActivityId = result.ActivityID.ToString(); newresult.ProjectId = result.ProjectID.ToString(); newresult.SortOrder = result.SortOrder; newresult.BudgetDetailItemCode = result.BudgetDetailItemCode; newresult.AmountOC = result.AmountOC; newresult.CurrencyCode = result.CurrencyID; newresult.ExchangeRate = result.ExchangeRate; newresult.FundStructureId = result.FundStructure == null ? null : result.FundStructure.FundStructureID.ToString(); newresult.BankAccount = result.BankAccount; newresult.AccountingObjectId = result.AccountingObjectID.ToString(); newresult.ProjectActivityId = result.ProjectActivityID.ToString(); newresult.ProjectExpenseId = result.ProjectExpenseID.ToString(); newresult.ListItemId = result.ListItemID.ToString(); newresult.ProjectExpenseEAId = result.ProjectExpenseEAID.ToString(); newresult.ProjectActivityEAId = result.ProjectActivityEAID.ToString(); newresult.BudgetProvideCode = result.BudgetProvidence == null ? null : result.BudgetProvidence.BudgetProvideCode; //newresult.BudgetExpenseId = result.budgete; lstDetailEntities.Add(newresult); } return(lstDetailEntities); }
/// <summary> /// Takes the specified b u voucher list detail transfer entity. /// </summary> /// <param name="bUVoucherListDetailTransferEntity">The b u voucher list detail transfer entity.</param> /// <returns></returns> private static object[] Take(BUVoucherListDetailTransferEntity bUVoucherListDetailTransferEntity) { return(new object[] { "@RefDetailID", bUVoucherListDetailTransferEntity.RefDetailId, "@RefID", bUVoucherListDetailTransferEntity.RefId, "@BudgetSourceID", bUVoucherListDetailTransferEntity.BudgetSourceId, "@BudgetChapterCode", bUVoucherListDetailTransferEntity.BudgetChapterCode, "@BudgetKindItemCode", bUVoucherListDetailTransferEntity.BudgetKindItemCode, "@BudgetSubKindItemCode", bUVoucherListDetailTransferEntity.BudgetSubKindItemCode, "@BudgetItemCode", bUVoucherListDetailTransferEntity.BudgetItemCode, "@BudgetSubItemCode", bUVoucherListDetailTransferEntity.BudgetSubItemCode, "@MethodDistributeID", bUVoucherListDetailTransferEntity.MethodDistributeId, "@CashWithDrawTypeID", bUVoucherListDetailTransferEntity.CashWithDrawTypeId, "@Amount", bUVoucherListDetailTransferEntity.Amount, "@DebitAccount", bUVoucherListDetailTransferEntity.DebitAccount, "@CreditAccount", bUVoucherListDetailTransferEntity.CreditAccount, "@Description", bUVoucherListDetailTransferEntity.Description, "@ActivityID", bUVoucherListDetailTransferEntity.ActivityId, "@ProjectID", bUVoucherListDetailTransferEntity.ProjectId, "@SortOrder", bUVoucherListDetailTransferEntity.SortOrder, "@BudgetDetailItemCode", bUVoucherListDetailTransferEntity.BudgetDetailItemCode, "@AmountOC", bUVoucherListDetailTransferEntity.AmountOC, "@CurrencyCode", bUVoucherListDetailTransferEntity.CurrencyCode, "@ExchangeRate", bUVoucherListDetailTransferEntity.ExchangeRate, "@FundStructureID", bUVoucherListDetailTransferEntity.FundStructureId, "@BankAccount", bUVoucherListDetailTransferEntity.BankAccount, "@AccountingObjectID", bUVoucherListDetailTransferEntity.AccountingObjectId, "@ProjectActivityID", bUVoucherListDetailTransferEntity.ProjectActivityId, "@ProjectExpenseID", bUVoucherListDetailTransferEntity.ProjectExpenseId, "@ListItemID", bUVoucherListDetailTransferEntity.ListItemId, "@ProjectExpenseEAID", bUVoucherListDetailTransferEntity.ProjectExpenseEAId, "@ProjectActivityEAID", bUVoucherListDetailTransferEntity.ProjectActivityEAId, "@BudgetProvideCode", bUVoucherListDetailTransferEntity.BudgetProvideCode, "@BudgetExpenseID", bUVoucherListDetailTransferEntity.BudgetExpenseId, }); }