/// <summary>
/// Takes the specified information.
/// </summary>
/// <param name="bUPlanWithdrawDetailEntity">The b u plan withdraw detail entity.</param>
/// <returns>System.Object[].</returns>
private object[] Take(BUPlanWithdrawDetailEntity bUPlanWithdrawDetailEntity)
{
return(new object[]
{
"@RefDetailID", bUPlanWithdrawDetailEntity.RefDetailId,
"@RefID", bUPlanWithdrawDetailEntity.RefId,
"@Description", bUPlanWithdrawDetailEntity.Description,
"@BudgetSourceID", bUPlanWithdrawDetailEntity.BudgetSourceId,
"@BudgetChapterCode", bUPlanWithdrawDetailEntity.BudgetChapterCode,
"@BudgetKindItemCode", bUPlanWithdrawDetailEntity.BudgetKindItemCode,
"@BudgetSubKindItemCode", bUPlanWithdrawDetailEntity.BudgetSubKindItemCode,
"@BudgetItemCode", bUPlanWithdrawDetailEntity.BudgetItemCode,
"@BudgetSubItemCode", bUPlanWithdrawDetailEntity.BudgetSubItemCode,
"@CreditAccount", bUPlanWithdrawDetailEntity.CreditAccount,
"@Amount", bUPlanWithdrawDetailEntity.Amount,
"@AmountOC", bUPlanWithdrawDetailEntity.AmountOC,
"@ProjectID", bUPlanWithdrawDetailEntity.ProjectId,
"@ListItemID", bUPlanWithdrawDetailEntity.ListItemId,
"@SortOrder", bUPlanWithdrawDetailEntity.SortOrder,
"@BudgetDetailItemCode", bUPlanWithdrawDetailEntity.BudgetDetailItemCode,
"@OrgRefNo", bUPlanWithdrawDetailEntity.OrgRefNo,
"@OrgRefDate", bUPlanWithdrawDetailEntity.OrgRefDate,
"@FundStructureID", bUPlanWithdrawDetailEntity.FundStructureId,
"@BankID", bUPlanWithdrawDetailEntity.BankId,
"@ProjectActivityEAID", bUPlanWithdrawDetailEntity.ProjectActivityEAId,
"@BudgetProvideCode", bUPlanWithdrawDetailEntity.BudgetProvideCode,
"@BudgetExpenseID", bUPlanWithdrawDetailEntity.BudgetExpenseId
});
}
public List <BUPlanWithdrawDetailEntity> BuPlanWithDrawDetails(List <BUPlanWithdrawDetail> details, string refid)
{
List <BUPlanWithdrawDetailEntity> lstBuPlanReceiptDetailEntities = new List <BUPlanWithdrawDetailEntity>();
foreach (var result in details)
{
var newresult = new BUPlanWithdrawDetailEntity();
newresult.RefDetailId = result.RefDetailID.ToString();
newresult.RefId = refid;
newresult.Description = result.Description;
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.CreditAccount = result.CreditAccount;
newresult.Amount = result.Amount;
newresult.AmountOC = result.AmountOC;
newresult.ProjectId = result.Project == null ? null : result.Project.ProjectID.ToString();
newresult.ListItemId = result.ListItem == null ? null : result.ListItem.ListItemID.ToString();
newresult.SortOrder = result.SortOrder;
newresult.BudgetDetailItemCode = result.BudgetDetailItemCode;
newresult.OrgRefNo = result.OrgRefNo;
newresult.OrgRefDate = result.OrgRefDate;
newresult.FundStructureId = result.FundStructure == null ? null : result.FundStructure.FundStructureID.ToString();
newresult.BankId = result.BankAccount == null ? null : banks.FirstOrDefault(x => x.BankAccount == result.BankAccount).BankInfoID.ToString();
newresult.ProjectActivityEAId = result.Project1 == null ? null : result.Project1.ProjectID.ToString();
newresult.BudgetProvideCode = result.BudgetProvidence == null ? null : result.BudgetProvidence.BudgetProvideCode;
//newresult.BudgetExpenseId = result.buget
lstBuPlanReceiptDetailEntities.Add(newresult);
}
return(lstBuPlanReceiptDetailEntities);
}
/// <summary>
/// Inserts the bu plan withdraw detail.
/// </summary>
/// <param name="planWithdrawDetailEntity">The plan withdraw detail entity.</param>
/// <returns>System.String.</returns>
public string InsertBUPlanWithdrawDetail(BUPlanWithdrawDetailEntity planWithdrawDetailEntity)
{
const string procedures = @"uspInsert_BUPlanWithdrawDetail";
return(Db.Insert(procedures, true, Take(planWithdrawDetailEntity)));
}
