public TransactionList GetTransactionsForBudget(int budgetId)
{
try
{
TransactionList transactionList = new TransactionList();
using (EntityContext context = new EntityContext())
{
// DateTime d = DateTime.Now.AddDays(100);
var query = from i in context.Transaction
.Include(i => i.TransactionType).Where(k => !k.IsDeleted)
.Include(i => i.TransactionReasonType).Where(k => !k.IsDeleted)
.Include(i => i.Category).Where(k => !k.IsDeleted)
//.Include(i => i.CreatedUser)
//.Include(i => i.ModifiedUser)
where i.CreatedDate >= context.Budget.Where(b => b.BudgetId == budgetId).Select(b => b.FromDate).FirstOrDefault()
&& i.CreatedDate <= context.Budget.Where(b => b.BudgetId == budgetId).Select(b => b.ToDate).FirstOrDefault()
&& !i.IsDeleted
orderby i.CreatedDate descending
select i;
foreach (var item in query)
transactionList.Add(item);
transactionList.AcceptChanges();
return transactionList;
}
}
catch (Exception)
{
throw;
}
}
public TransactionList GetAllTransactions(int userId)
{
return null;
try
{
TransactionList transList = new TransactionList();
using (EntityContext context = new EntityContext())
{
var query = (from i in context.Transaction
.Include(i => i.Category)
.Include(i => i.CreatedUser)
.Include(i => i.ModifiedUser)
.Include(i => i.TransactionReasonType)
.Include(i => i.TransactionType)
where !i.IsDeleted && i.ModifiedUser.UserId == userId
select new
{
transaction = i,
category = i.Category.IsDeleted ? null : i.Category,
categoryOther = context.Category.FirstOrDefault(x => x.Name.Equals("other", StringComparison.InvariantCultureIgnoreCase)),
transReason = i.TransactionReasonType.IsDeleted ? null : i.TransactionReasonType,
transReasonOther = context.TransactionReason.FirstOrDefault(x => x.Name.Equals("other", StringComparison.InvariantCultureIgnoreCase))
}).ToList();
foreach (var item in query)
{
var trans = item.transaction;
if (item.category == null)
{
trans.Category = item.categoryOther;
trans.TransactionReasonType = item.transReasonOther;
}
if (item.transReason == null)
{
trans.TransactionReasonType = item.transReasonOther;
}
transList.Add(trans);
}
transList.AcceptChanges();
return transList;
}
}
catch (Exception)
{
throw;
}
}