/// <summary>
/// Takes the specified b u commitment request detail entity.
/// </summary>
/// <param name="bUCommitmentRequestDetailEntity">The b u commitment request detail entity.</param>
/// <returns>System.Object[].</returns>
private static object[] Take(BUCommitmentRequestDetailEntity bUCommitmentRequestDetailEntity)
{
return(new object[]
{
"@RefDetailID", bUCommitmentRequestDetailEntity.RefDetailId,
"@RefID", bUCommitmentRequestDetailEntity.RefId,
"@Description", bUCommitmentRequestDetailEntity.Description,
"@CurrencyCode", bUCommitmentRequestDetailEntity.CurrencyCode,
"@ExchangeRate", bUCommitmentRequestDetailEntity.ExchangeRate,
"@Amount", bUCommitmentRequestDetailEntity.Amount,
"@AmountOC", bUCommitmentRequestDetailEntity.AmountOC,
"@BudgetSourceID", bUCommitmentRequestDetailEntity.BudgetSourceId,
"@BudgetChapterCode", bUCommitmentRequestDetailEntity.BudgetChapterCode,
"@BudgetKindItemCode", bUCommitmentRequestDetailEntity.BudgetKindItemCode,
"@BudgetSubKindItemCode", bUCommitmentRequestDetailEntity.BudgetSubKindItemCode,
"@BudgetItemCode", bUCommitmentRequestDetailEntity.BudgetItemCode,
"@BudgetSubItemCode", bUCommitmentRequestDetailEntity.BudgetSubItemCode,
"@BudgetDetailItemCode", bUCommitmentRequestDetailEntity.BudgetDetailItemCode,
"@MethodDistributeID", bUCommitmentRequestDetailEntity.MethodDistributeId,
"@CashWithDrawTypeID", bUCommitmentRequestDetailEntity.CashWithDrawTypeId,
"@ActivityID", bUCommitmentRequestDetailEntity.ActivityId,
"@ProjectID", bUCommitmentRequestDetailEntity.ProjectId,
"@ProjectActivityID", bUCommitmentRequestDetailEntity.ProjectActivityId,
"@ProjectExpenseID", bUCommitmentRequestDetailEntity.ProjectExpenseId,
"@TaskID", bUCommitmentRequestDetailEntity.TaskId,
"@ListItemID", bUCommitmentRequestDetailEntity.ListItemId,
"@Approved", bUCommitmentRequestDetailEntity.Approved,
"@FundStructureID", bUCommitmentRequestDetailEntity.FundStructureId,
"@SortOrder", bUCommitmentRequestDetailEntity.SortOrder,
"@BankAccount", bUCommitmentRequestDetailEntity.BankAccount,
"@BudgetProvideCode", bUCommitmentRequestDetailEntity.BudgetProvideCode,
"@ContractID", bUCommitmentRequestDetailEntity.ContractId,
"@CapitalPlanID", bUCommitmentRequestDetailEntity.CapitalPlanId,
});
}
public List <BUCommitmentRequestDetailEntity> BUCommitmentRequestDetails(List <BUCommitmentRequestDetail> details, string refid)
{
List <BUCommitmentRequestDetailEntity> lstDetailEntities = new List <BUCommitmentRequestDetailEntity>();
foreach (var result in details)
{
var newresult = new BUCommitmentRequestDetailEntity();
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;
lstDetailEntities.Add(newresult);
}
return(lstDetailEntities);
}
/// <summary>
/// Inserts the bu plan receipt detail.
/// </summary>
/// <param name="bUCommitmentRequestDetail">The b u commitment request detail.</param>
/// <returns>System.String.</returns>
public string InsertBUPlanReceiptDetail(BUCommitmentRequestDetailEntity bUCommitmentRequestDetail)
{
const string procedures = @"uspInsert_BUCommitmentRequestDetail";
return(Db.Insert(procedures, true, Take(bUCommitmentRequestDetail)));
}
