private static object[] Take(BABankTransferDetailEntity bABankTransferDetailEntity)
{
return(new object[]
{
"@RefDetailID", bABankTransferDetailEntity.RefDetailId,
"@RefID", bABankTransferDetailEntity.RefId,
"@Description", bABankTransferDetailEntity.Description,
"@DebitAccount", bABankTransferDetailEntity.DebitAccount,
"@CreditAccount", bABankTransferDetailEntity.CreditAccount,
"@FromBankID", bABankTransferDetailEntity.FromBankId,
"@ToBankID", bABankTransferDetailEntity.ToBankId,
"@Amount", bABankTransferDetailEntity.Amount,
"@BudgetSourceID", bABankTransferDetailEntity.BudgetSourceId,
"@BudgetChapterCode", bABankTransferDetailEntity.BudgetChapterCode,
"@BudgetKindItemCode", bABankTransferDetailEntity.BudgetKindItemCode,
"@BudgetSubKindItemCode", bABankTransferDetailEntity.BudgetSubKindItemCode,
"@BudgetItemCode", bABankTransferDetailEntity.BudgetItemCode,
"@BudgetSubItemCode", bABankTransferDetailEntity.BudgetSubItemCode,
"@MethodDistributeID", bABankTransferDetailEntity.MethodDistributeId,
"@CashWithDrawTypeID", bABankTransferDetailEntity.CashWithDrawTypeId,
"@AccountingObjectID", bABankTransferDetailEntity.AccountingObjectId,
"@ActivityID", bABankTransferDetailEntity.ActivityId,
"@ProjectID", bABankTransferDetailEntity.ProjectId,
"@ProjectActivityID", bABankTransferDetailEntity.ProjectActivityId,
"@ListItemID", bABankTransferDetailEntity.ListItemId,
"@SortOrder", bABankTransferDetailEntity.SortOrder,
"@BudgetDetailItemCode", bABankTransferDetailEntity.BudgetDetailItemCode,
"@AmountOC", bABankTransferDetailEntity.AmountOC,
"@FundStructureID", bABankTransferDetailEntity.FundStructureId,
"@ProjectActivityEAID", bABankTransferDetailEntity.ProjectActivityEAId,
"@BudgetExpenseID", bABankTransferDetailEntity.BudgetExpenseId,
});
}
public List <BABankTransferDetailEntity> BABankTransferDetails(List <BABankTransferDetail> details, string refid)
{
List <BABankTransferDetailEntity> lstDetailEntities = new List <BABankTransferDetailEntity>();
foreach (var result in details)
{
var newresult = new BABankTransferDetailEntity();
newresult.RefDetailId = result.RefDetailID.ToString();
newresult.RefId = refid;
newresult.Description = result.Description;
newresult.DebitAccount = result.DebitAccount;
newresult.CreditAccount = result.CreditAccount;
newresult.FromBankId = result.FromBankAccount == null && banks == null ? null : banks.FirstOrDefault(x => x.BankAccount == result.FromBankAccount).BankInfoID.ToString();
newresult.ToBankId = result.ToBankAccount == null && banks == null ? null : banks.FirstOrDefault(x => x.BankAccount == result.ToBankAccount).BankInfoID.ToString();
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.AccountingObjectId = result.AccountingObjectID.ToString();
newresult.ActivityId = result.ActivityID.ToString();
newresult.ProjectId = result.ProjectID.ToString();
newresult.ProjectActivityId = result.ProjectActivityID.ToString();
newresult.ListItemId = result.ListItemID.ToString();
newresult.SortOrder = result.SortOrder;
newresult.BudgetDetailItemCode = result.BudgetDetailItemCode;
newresult.AmountOC = result.AmountOC;
newresult.FundStructureId = result.FundStructure == null ? null : result.FundStructure.FundStructureID.ToString();
newresult.ProjectActivityEAId = result.Project == null ? null : result.Project.ProjectID.ToString();
//newresult.BudgetExpenseId = result.Budgete;
lstDetailEntities.Add(newresult);
}
return(lstDetailEntities);
}
public string InsertBABankTransferDetail(BABankTransferDetailEntity bABankTransferDetailEntity)
{
const string sql = @"uspInsert_BABankTransferDetail";
return(Db.Insert(sql, true, Take(bABankTransferDetailEntity)));
}