public List <CAReceiptDetailEntity> CAReceiptDetails(List <CAReceiptDetail> details, string refid)
{
List <CAReceiptDetailEntity> lstDetailEntities = new List <CAReceiptDetailEntity>();
foreach (var result in details)
{
var newresult = new CAReceiptDetailEntity();
newresult.RefDetailId = result.RefDetailID.ToString();
newresult.RefId = refid;
newresult.Description = result.Description;
newresult.DebitAccount = result.DebitAccount;
newresult.CreditAccount = result.CreditAccount;
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.MethodDistributeId = result.MethodDistributeID;
newresult.CashWithdrawTypeId = ConvertCash.ConvertCash(result.CashWithdrawTypeID);
newresult.AccountingObjectId = result.AccountingObject == null ? null : result.AccountingObject.AccountingObjectID.ToString();
newresult.ActivityId = result.Activity == null ? null : result.Activity.ActivityID.ToString();
newresult.ProjectId = result.Project == null ? null : result.Project.ProjectID.ToString();
newresult.ProjectActivityId = result.Project1 == null ? null : result.Project1.ProjectID.ToString();
newresult.ProjectExpenseId = result.ProjectExpense == null ? null : result.ProjectExpense.ProjectExpenseID.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.Project2 == null ? null : result.Project2.ProjectID.ToString();
newresult.WithdrawDetailId = result.WithdrawDetailID.ToString();
newresult.BudgetExpenseId = result.BudgetExpenseID.ToString();
lstDetailEntities.Add(newresult);
}
return(lstDetailEntities);
}
/// <summary>
/// Takes the specified information.
/// </summary>
/// <param name="cAReceiptDetailEntity">The c a receipt detail entity.</param>
/// <returns>System.Object[].</returns>
private object[] Take(CAReceiptDetailEntity cAReceiptDetailEntity)
{
return(new object[]
{
"@RefDetailId", cAReceiptDetailEntity.RefDetailId,
"@RefId", cAReceiptDetailEntity.RefId,
"@Description", cAReceiptDetailEntity.Description,
"@DebitAccount", cAReceiptDetailEntity.DebitAccount,
"@CreditAccount", cAReceiptDetailEntity.CreditAccount,
"@Amount", cAReceiptDetailEntity.Amount,
"@AmountOC", cAReceiptDetailEntity.AmountOC,
"@BudgetSourceId", cAReceiptDetailEntity.BudgetSourceId,
"@BudgetChapterCode", cAReceiptDetailEntity.BudgetChapterCode,
"@BudgetKindItemCode", cAReceiptDetailEntity.BudgetKindItemCode,
"@BudgetSubKindItemCode", cAReceiptDetailEntity.BudgetSubKindItemCode,
"@BudgetItemCode", cAReceiptDetailEntity.BudgetItemCode,
"@BudgetSubItemCode", cAReceiptDetailEntity.BudgetSubItemCode,
"@MethodDistributeId", cAReceiptDetailEntity.MethodDistributeId,
"@CashWithdrawTypeId", cAReceiptDetailEntity.CashWithdrawTypeId,
"@AccountingObjectId", cAReceiptDetailEntity.AccountingObjectId,
"@ActivityId", cAReceiptDetailEntity.ActivityId,
"@ProjectId", cAReceiptDetailEntity.ProjectId,
"@ProjectActivityId", cAReceiptDetailEntity.ProjectActivityId,
"@ProjectExpenseId", cAReceiptDetailEntity.ProjectExpenseId,
"@ListItemId", cAReceiptDetailEntity.ListItemId,
"@SortOrder", cAReceiptDetailEntity.SortOrder,
"@BudgetDetailItemCode", cAReceiptDetailEntity.BudgetDetailItemCode,
"@OrgRefNo", cAReceiptDetailEntity.OrgRefNo,
"@OrgRefDate", cAReceiptDetailEntity.OrgRefDate,
"@FundStructureId", cAReceiptDetailEntity.FundStructureId,
"@BankId", cAReceiptDetailEntity.BankId,
"@ProjectActivityEAId", cAReceiptDetailEntity.ProjectActivityEAId,
"@WithdrawDetailId", cAReceiptDetailEntity.WithdrawDetailId,
"@BudgetExpenseID", cAReceiptDetailEntity.BudgetExpenseId,
"@ContractID", cAReceiptDetailEntity.ContractId,
"@CapitalPlanID", cAReceiptDetailEntity.CapitalPlanId,
"@AutoBusinessID", cAReceiptDetailEntity.AutoBusinessId,
});
}
/// <summary>
/// Inserts the ca receipt detail.
/// </summary>
/// <param name="receiptDetailEntity">The receipt detail entity.</param>
/// <returns>System.String.</returns>
public string InsertCAReceiptDetail(CAReceiptDetailEntity receiptDetailEntity)
{
const string procedures = @"uspInsert_CAReceiptDetail";
return(Db.Insert(procedures, true, Take(receiptDetailEntity)));
}
