public IEntry GetJournalEntry(int entryId, EntryType entryType)
{
IEntry entry = null;
using (var entities = new DietjournalEntities())
{
var entryCollection = GetEntryTypeEntries(entities, entryType);
entry = entryCollection.FirstOrDefault(e => e.Id == entryId);
}
return entry;
}
public IEnumerable<IEntry> GetJournalEntries(Guid userId, EntryType entryType, DateTime date)
{
var entries = new List<IEntry>();
date = date.Date;
using (var entities = new DietjournalEntities())
{
var results = from e in GetEntryTypeEntries(entities, entryType)
where e.UserId == userId && e.EntryDate >= date && e.EntryDate < date.AddDays(1)
select e;
entries = results.ToList();
}
return entries;
}
public void SaveJournalEntry(IEntry entry)
{
using (var entities = new DietjournalEntities())
{
if (entry is FoodEntry)
{
var foodEntry = (FoodEntry)entry;
if (entry.Id > 0)
entities.Attach(foodEntry);
else
{
entities.FoodEntries.AddObject(foodEntry);
}
}
entities.SaveChanges();
}
}
public Journal GetDailyJournal(Guid userId, DateTime date)
{
var journal = new Journal
{
UserId = userId,
Date = date,
};
date = date.Date;
using (var model = new DietjournalEntities())
{
journal.ExerciseEnteries = model.ExerciseEntries.Where(e => e.UserId == userId && e.EntryDate >= date && e.EntryDate < date.AddDays(1)).ToList();
journal.FoodEntries = model.FoodEntries.Where(e => e.UserId == userId && e.EntryDate >= date && e.EntryDate < date.AddDays(1)).ToList();
journal.SupplementEntries = model.SupplementEntries.Where(e => e.UserId == userId && e.EntryDate >= date && e.EntryDate < date.AddDays(1)).ToList();
journal.WaterEntries = model.WaterEntries.Where(e => e.UserId == userId && e.EntryDate >= date && e.EntryDate < date.AddDays(1)).ToList();
}
return journal;
}
private IEnumerable<IEntry> GetEntryTypeEntries(DietjournalEntities entities, EntryType entryType)
{
switch(entryType)
{
case EntryType.BloodPressure:
return entities.BloodPressureEntries;
case EntryType.Exercise:
return entities.ExerciseEntries;
case EntryType.Food:
return entities.FoodEntries;
case EntryType.Supplement:
return entities.SupplementEntries;
case EntryType.Water:
return entities.WaterEntries;
case EntryType.Weight:
return entities.WeightEntries;
default:
return null;
}
}