public List <BUCommitmentAdjustmentDetailEntity> BUCommitmentAdjustmentDetails(List <BUCommitmentAdjustmentDetail> details, string refid)
{
List <BUCommitmentAdjustmentDetailEntity> lstDetailEntities = new List <BUCommitmentAdjustmentDetailEntity>();
foreach (var result in details)
{
var newresult = new BUCommitmentAdjustmentDetailEntity();
newresult.RefDetailId = result.RefDetailID.ToString();
newresult.RefId = refid;
newresult.Description = result.Description;
newresult.CurrencyCode = result.CCY == null ? null : result.CCY.CurrencyID;
newresult.ExchangeRate = result.ExchangeRate;
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.BudgetDetailItemCode = result.BudgetDetailItemCode;
newresult.MethodDistributeId = result.MethodDistributeID;
newresult.CashWithDrawTypeId = ConvertCash.ConvertCash(result.CashWithDrawTypeID);
newresult.ActivityId = result.Activity == null ? null : result.Activity.ActivityID.ToString();
newresult.ProjectId = result.Project == null ? null : result.Project.ProjectID.ToString();
newresult.ProjectActivityId = result.ProjectActivityID.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.FundStructureId = result.FundStructure == null ? null : result.FundStructure.FundStructureID.ToString();
newresult.SortOrder = result.SortOrder;
newresult.BankAccount = result.BankAccount;
newresult.BudgetProvideCode = result.BudgetProvidence == null ? null : result.BudgetProvidence.BudgetProvideCode;
newresult.ToCurrencyCode = result.ToCurrencyID;
newresult.ToExchangeRate = result.ToExchangeRate;
newresult.ToAmountOC = result.ToAmountOC;
newresult.ToAmount = result.ToAmount;
newresult.ToBudgetSourceId = result.ToBudgetSourceID.ToString();
newresult.ToBudgetProvideCode = result.ToBudgetProvideCode;
newresult.ToBudgetChapterCode = result.ToBudgetChapterCode;
newresult.ToBudgetKindItemCode = result.ToBudgetKindItemCode;
newresult.ToBudgetSubKindItemCode = result.ToBudgetSubKindItemCode;
newresult.ToBudgetItemCode = result.ToBudgetItemCode;
newresult.ToBudgetSubItemCode = result.ToBudgetSubItemCode;
newresult.ToProjectId = result.ToProjectID.ToString();
newresult.RemainAmountOC = result.RemainAmountOC;
newresult.RemainAmount = result.RemainAmount;
newresult.RemainExchangeRate = result.RemainExchangeRate;
newresult.RemainCurrencyCode = result.RemainCurrencyID;
//newresult.BUCommitmentRequestDetailId = result.id;
lstDetailEntities.Add(newresult);
}
return(lstDetailEntities);
}
/// <summary>
/// Takes the specified b u commitment adjustment detail entity.
/// </summary>
/// <param name="bUCommitmentAdjustmentDetailEntity">The b u commitment adjustment detail entity.</param>
/// <returns>System.Object[].</returns>
private static object[] Take(BUCommitmentAdjustmentDetailEntity bUCommitmentAdjustmentDetailEntity)
{
return(new object[]
{
"@RefDetailID", bUCommitmentAdjustmentDetailEntity.RefDetailId,
"@RefID", bUCommitmentAdjustmentDetailEntity.RefId,
"@Description", bUCommitmentAdjustmentDetailEntity.Description,
"@CurrencyCode", bUCommitmentAdjustmentDetailEntity.CurrencyCode,
"@ExchangeRate", bUCommitmentAdjustmentDetailEntity.ExchangeRate,
"@Amount", bUCommitmentAdjustmentDetailEntity.Amount,
"@AmountOC", bUCommitmentAdjustmentDetailEntity.AmountOC,
"@BudgetSourceID", bUCommitmentAdjustmentDetailEntity.BudgetSourceId,
"@BudgetChapterCode", bUCommitmentAdjustmentDetailEntity.BudgetChapterCode,
"@BudgetKindItemCode", bUCommitmentAdjustmentDetailEntity.BudgetKindItemCode,
"@BudgetSubKindItemCode", bUCommitmentAdjustmentDetailEntity.BudgetSubKindItemCode,
"@BudgetItemCode", bUCommitmentAdjustmentDetailEntity.BudgetItemCode,
"@BudgetSubItemCode", bUCommitmentAdjustmentDetailEntity.BudgetSubItemCode,
"@BudgetDetailItemCode", bUCommitmentAdjustmentDetailEntity.BudgetDetailItemCode,
"@MethodDistributeID", bUCommitmentAdjustmentDetailEntity.MethodDistributeId,
"@CashWithDrawTypeID", bUCommitmentAdjustmentDetailEntity.CashWithDrawTypeId,
"@ActivityID", bUCommitmentAdjustmentDetailEntity.ActivityId,
"@ProjectID", bUCommitmentAdjustmentDetailEntity.ProjectId,
"@ProjectActivityID", bUCommitmentAdjustmentDetailEntity.ProjectActivityId,
"@ProjectExpenseID", bUCommitmentAdjustmentDetailEntity.ProjectExpenseId,
"@TaskID", bUCommitmentAdjustmentDetailEntity.TaskId,
"@ListItemID", bUCommitmentAdjustmentDetailEntity.ListItemId,
"@Approved", bUCommitmentAdjustmentDetailEntity.Approved,
"@FundStructureID", bUCommitmentAdjustmentDetailEntity.FundStructureId,
"@SortOrder", bUCommitmentAdjustmentDetailEntity.SortOrder,
"@BankAccount", bUCommitmentAdjustmentDetailEntity.BankAccount,
"@BudgetProvideCode", bUCommitmentAdjustmentDetailEntity.BudgetProvideCode,
"@ToCurrencyCode", bUCommitmentAdjustmentDetailEntity.ToCurrencyCode,
"@ToExchangeRate", bUCommitmentAdjustmentDetailEntity.ToExchangeRate,
"@ToAmountOC", bUCommitmentAdjustmentDetailEntity.ToAmountOC,
"@ToAmount", bUCommitmentAdjustmentDetailEntity.ToAmount,
"@ToBudgetSourceID", bUCommitmentAdjustmentDetailEntity.ToBudgetSourceId,
"@ToBudgetProvideCode", bUCommitmentAdjustmentDetailEntity.ToBudgetProvideCode,
"@ToBudgetChapterCode", bUCommitmentAdjustmentDetailEntity.ToBudgetChapterCode,
"@ToBudgetKindItemCode", bUCommitmentAdjustmentDetailEntity.ToBudgetKindItemCode,
"@ToBudgetSubKindItemCode", bUCommitmentAdjustmentDetailEntity.ToBudgetSubKindItemCode,
"@ToBudgetItemCode", bUCommitmentAdjustmentDetailEntity.ToBudgetItemCode,
"@ToBudgetSubItemCode", bUCommitmentAdjustmentDetailEntity.ToBudgetSubItemCode,
"@ToProjectID", bUCommitmentAdjustmentDetailEntity.ToProjectId,
"@RemainAmountOC", bUCommitmentAdjustmentDetailEntity.RemainAmountOC,
"@RemainAmount", bUCommitmentAdjustmentDetailEntity.RemainAmount,
"@RemainExchangeRate", bUCommitmentAdjustmentDetailEntity.RemainExchangeRate,
"@RemainCurrencyCode", bUCommitmentAdjustmentDetailEntity.RemainCurrencyCode,
"@BUCommitmentDetailId", bUCommitmentAdjustmentDetailEntity.BUCommitmentRequestDetailId,
"@ContractID", bUCommitmentAdjustmentDetailEntity.ContractId,
"@CapitalPlanID", bUCommitmentAdjustmentDetailEntity.CapitalPlanId,
});
}
/// <summary>
/// Inserts the bu plan receipt detail.
/// </summary>
/// <param name="bUCommitmentAdjustmentDetail">The b u commitment adjustment detail.</param>
/// <returns>System.String.</returns>
public string InsertBUCommitmentAdjustmenttDetail(BUCommitmentAdjustmentDetailEntity bUCommitmentAdjustmentDetail)
{
const string procedures = @"uspInsert_BUCommitmentAdjustmentDetail";
return(Db.Insert(procedures, true, Take(bUCommitmentAdjustmentDetail)));
}
