public List <BUTransferDetailParallelEntity> BUTransferDetailParallels(List <BUTransferDetailParallel> details, string refid)
{
List <BUTransferDetailParallelEntity> lstDetailEntities = new List <BUTransferDetailParallelEntity>();
foreach (var result in details)
{
var newresult = new BUTransferDetailParallelEntity();
newresult.RefDetailId = result.RefDetailID.ToString();
newresult.ParentRefDetailId = result.ParentRefDetailID.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.BudgetDetailItemCode = result.BudgetDetailItemCode;
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.FundId = result.Fund == null ? null : result.Fund.FundID.ToString();
newresult.TaskId = result.Task == null ? null : result.Task.TaskID.ToString();
newresult.ListItemId = result.ListItem == null ? null : result.ListItem.ListItemID.ToString();
newresult.SortOrder = result.SortOrder;
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.BudgetProvideCode = result.BudgetProvidence == null ? null : result.BudgetProvidence.BudgetProvideCode;
newresult.TopicId = result.Topic == null ? null : result.Topic.TopicID.ToString();
newresult.BudgetExpenseId = result.BudgetExpenseID.ToString();
newresult.Approved = result.Approved;
lstDetailEntities.Add(newresult);
}
return(lstDetailEntities);
}
/// <summary>
/// Takes the specified c a payment detail parallel entity.
/// </summary>
/// <param name="BUTransferDetailParallelEntity">The b a with draw detail parallel entity.</param>
/// <returns>System.Object[].</returns>
private static object[] Take(BUTransferDetailParallelEntity BUTransferDetailParallelEntity)
{
return(new object[]
{
"@RefDetailID", BUTransferDetailParallelEntity.RefDetailId,
"@ParentRefDetailID", BUTransferDetailParallelEntity.ParentRefDetailId,
"@RefID", BUTransferDetailParallelEntity.RefId,
"@Description", BUTransferDetailParallelEntity.Description,
"@DebitAccount", BUTransferDetailParallelEntity.DebitAccount,
"@CreditAccount", BUTransferDetailParallelEntity.CreditAccount,
"@Amount", BUTransferDetailParallelEntity.Amount,
"@AmountOC", BUTransferDetailParallelEntity.AmountOC,
"@BudgetSourceID", BUTransferDetailParallelEntity.BudgetSourceId,
"@BudgetChapterCode", BUTransferDetailParallelEntity.BudgetChapterCode,
"@BudgetKindItemCode", BUTransferDetailParallelEntity.BudgetKindItemCode,
"@BudgetSubKindItemCode", BUTransferDetailParallelEntity.BudgetSubKindItemCode,
"@BudgetItemCode", BUTransferDetailParallelEntity.BudgetItemCode,
"@BudgetSubItemCode", BUTransferDetailParallelEntity.BudgetSubItemCode,
"@BudgetDetailItemCode", BUTransferDetailParallelEntity.BudgetDetailItemCode,
"@MethodDistributeID", BUTransferDetailParallelEntity.MethodDistributeId,
"@CashWithdrawTypeID", BUTransferDetailParallelEntity.CashWithdrawTypeId,
"@AccountingObjectID", BUTransferDetailParallelEntity.AccountingObjectId,
"@ActivityID", BUTransferDetailParallelEntity.ActivityId,
"@ProjectID", BUTransferDetailParallelEntity.ProjectId,
"@FundID", BUTransferDetailParallelEntity.FundId,
"@TaskID", BUTransferDetailParallelEntity.TaskId,
"@ListItemID", BUTransferDetailParallelEntity.ListItemId,
"@SortOrder", BUTransferDetailParallelEntity.SortOrder,
"@OrgRefNo", BUTransferDetailParallelEntity.OrgRefNo,
"@OrgRefDate", BUTransferDetailParallelEntity.OrgRefDate,
"@FundStructureID", BUTransferDetailParallelEntity.FundStructureId,
"@BankID", BUTransferDetailParallelEntity.BankId,
"@BudgetProvideCode", BUTransferDetailParallelEntity.BudgetProvideCode,
"@TopicID", BUTransferDetailParallelEntity.TopicId,
"@BudgetExpenseID", BUTransferDetailParallelEntity.BudgetExpenseId,
"@Approved", BUTransferDetailParallelEntity.Approved,
"@ContractID", BUTransferDetailParallelEntity.ContractId,
"@CapitalPlanID", BUTransferDetailParallelEntity.CapitalPlanId,
"@AdvanceRecovery", BUTransferDetailParallelEntity.AdvanceRecovery,
});
}
/// <summary>
/// Updates the ba with draw detail parallel.
/// </summary>
/// <param name="withDrawDetail">The with draw detail.</param>
/// <returns>System.String.</returns>
public string UpdateBUTransferDetailParallel(BUTransferDetailParallelEntity withDrawDetail)
{
const string procedures = @"uspUpdate_BUTransferDetailParallel";
return(Db.Update(procedures, true, Take(withDrawDetail)));
}
/// <summary>
/// Inserts the ba with draw detail parallel.
/// </summary>
/// <param name="withDrawDetail">The with draw detail.</param>
/// <returns>System.String.</returns>
public string InsertBUTransferDetailParallel(BUTransferDetailParallelEntity withDrawDetail)
{
const string procedures = @"uspInsert_BUTransferDetailParallel";
return(Db.Insert(procedures, true, Take(withDrawDetail)));
}
