public List <BUVoucherListDetailEntity> BUVoucherListDetails(List <BUVoucherListDetail> details, string refid)
{
List <BUVoucherListDetailEntity> lstDetailEntities = new List <BUVoucherListDetailEntity>();
foreach (var result in details)
{
var newresult = new BUVoucherListDetailEntity();
newresult.RefDetailId = result.RefDetailID.ToString();
newresult.RefId = refid;
newresult.VoucherRefType = result.VoucherRefType;
newresult.VoucherRefDetailId = result.VoucherRefDetailID.ToString();
newresult.RefDate = result.RefDate;
newresult.PostedDate = result.PostedDate;
newresult.RefNo = result.RefNo;
newresult.Description = result.Description;
newresult.DebitAccount = result.DebitAccount;
newresult.CreditAccount = result.CreditAccount;
newresult.Amount = result.Amount;
newresult.BudgetSourceId = result.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.ProjectId = result.ProjectID.ToString();
newresult.ActivityId = result.ActivityID.ToString();
newresult.SortOrder = result.SortOrder;
newresult.Approved = result.Approved;
newresult.BudgetDetailItemCode = result.BudgetDetailItemCode;
newresult.OrgRefNo = result.OrgRefNo;
newresult.OrgRefDate = result.OrgRefDate;
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.VoucherRefId = result.VoucherRefDetailID.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 entity.
/// </summary>
/// <param name="bUVoucherListDetailEntity">The b u voucher list detail entity.</param>
/// <returns></returns>
private static object[] Take(BUVoucherListDetailEntity bUVoucherListDetailEntity)
{
return(new object[]
{
"@RefDetailID", bUVoucherListDetailEntity.RefDetailId,
"@RefID", bUVoucherListDetailEntity.RefId,
"@VoucherRefType", bUVoucherListDetailEntity.VoucherRefType,
"@VoucherRefID", bUVoucherListDetailEntity.VoucherRefId,
"@VoucherRefDetailID", bUVoucherListDetailEntity.VoucherRefDetailId,
"@RefDate", bUVoucherListDetailEntity.RefDate,
"@PostedDate", bUVoucherListDetailEntity.PostedDate,
"@RefNo", bUVoucherListDetailEntity.RefNo,
"@Description", bUVoucherListDetailEntity.Description,
"@DebitAccount", bUVoucherListDetailEntity.DebitAccount,
"@CreditAccount", bUVoucherListDetailEntity.CreditAccount,
"@Amount", bUVoucherListDetailEntity.Amount,
"@BudgetSourceID", bUVoucherListDetailEntity.BudgetSourceId,
"@BudgetChapterCode", bUVoucherListDetailEntity.BudgetChapterCode,
"@BudgetKindItemCode", bUVoucherListDetailEntity.BudgetKindItemCode,
"@BudgetSubKindItemCode", bUVoucherListDetailEntity.BudgetSubKindItemCode,
"@BudgetItemCode", bUVoucherListDetailEntity.BudgetItemCode,
"@BudgetSubItemCode", bUVoucherListDetailEntity.BudgetSubItemCode,
"@MethodDistributeID", bUVoucherListDetailEntity.MethodDistributeId,
"@CashWithdrawTypeID", bUVoucherListDetailEntity.CashWithdrawTypeId,
"@ProjectID", bUVoucherListDetailEntity.ProjectId,
"@ActivityID", bUVoucherListDetailEntity.ActivityId,
"@SortOrder", bUVoucherListDetailEntity.SortOrder,
"@Approved", bUVoucherListDetailEntity.Approved,
"@BudgetDetailItemCode", bUVoucherListDetailEntity.BudgetDetailItemCode,
"@OrgRefNo", bUVoucherListDetailEntity.OrgRefNo,
"@OrgRefDate", bUVoucherListDetailEntity.OrgRefDate,
"@AmountOC", bUVoucherListDetailEntity.AmountOC,
"@CurrencyCode", bUVoucherListDetailEntity.CurrencyCode,
"@ExchangeRate", bUVoucherListDetailEntity.ExchangeRate,
"@FundStructureID", bUVoucherListDetailEntity.FundStructureId,
"@BankAccount", bUVoucherListDetailEntity.BankAccount,
"@AccountingObjectID", bUVoucherListDetailEntity.AccountingObjectId,
"@ProjectActivityID", bUVoucherListDetailEntity.ProjectActivityId,
"@ProjectExpenseID", bUVoucherListDetailEntity.ProjectExpenseId,
"@ListItemID", bUVoucherListDetailEntity.ListItemId,
"@ProjectExpenseEAID", bUVoucherListDetailEntity.ProjectExpenseEAId,
"@ProjectActivityEAID", bUVoucherListDetailEntity.ProjectActivityEAId,
"@BudgetProvideCode", bUVoucherListDetailEntity.BudgetProvideCode,
"@BudgetExpenseID", bUVoucherListDetailEntity.BudgetExpenseId,
});
}
/// <summary>
/// Inserts the bu voucher list detail.
/// </summary>
/// <param name="bUVoucherListDetailEntity">The b u voucher list detail entity.</param>
/// <returns></returns>
public string InsertBUVoucherListDetail(BUVoucherListDetailEntity bUVoucherListDetailEntity)
{
const string procedures = @"uspInsert_BUVoucherListDetail";
return(Db.Insert(procedures, true, Take(bUVoucherListDetailEntity)));
}
