public bool ExistEntry(int entrieid)
{
using (var ctx = new FoodCaloriesEntities())
{
return ctx.Entries.Any(b => b.IdEntry == entrieid);
}
}
public Food GetFoodById(int foodid)
{
using (var ctx = new FoodCaloriesEntities())
{
var query = ctx.Food.Include("TypeFood").Include("Seller").FirstOrDefault(b => b.IdFood == foodid);
return query;
}
}
public Entries GetDairiesEntriesById(int entrieid)
{
using (var ctx = new FoodCaloriesEntities())
{
var query = ctx.Entries.Include("Diary").FirstOrDefault(b => b.IdEntry == entrieid);
return query;
}
}
public Diary GetDairiesById(string username, DateTime dairyid)
{
using (var ctx = new FoodCaloriesEntities())
{
var query = ctx.Diary.FirstOrDefault(b => b.UserName == username && b.CurrentDate == dairyid);
return query;
}
}
public IEnumerable<Food> GetAllFoods()
{
using (var ctx = new FoodCaloriesEntities())
{
var query = ctx.Food.Include("TypeFood").Include("Seller").ToList();
return query;
}
}
public int EntrieCount(string username, DateTime dairyid)
{
using (var ctx = new FoodCaloriesEntities())
{
return ctx.Entries.Include("Diary")
.Where(b => b.Diary.CurrentDate == dairyid && b.Diary.UserName == username).Count();
}
}
public bool AddEntries(Entries entries)
{
using (var ctx = new FoodCaloriesEntities())
{
ctx.Entries.Add(entries);
ctx.SaveChanges();
}
return true;
}
public bool DeleteEntrie(DateTime dairyid, int entrieid)
{
using (var ctx = new FoodCaloriesEntities())
{
var entity = ctx.Entries.FirstOrDefault(b => b.IdEntry == entrieid);
ctx.Entries.Remove(entity);
ctx.SaveChanges();
}
return true;
}
public Seller GetSellerById(int foodid,int sellerid)
{
using (var ctx = new FoodCaloriesEntities())
{
var query = ctx.Seller.FirstOrDefault(b => b.IdSeller == sellerid && b.IdFood==foodid);
return query;
}
}
public IEnumerable<Seller> GetSellerByFood(int foodid)
{
using (var ctx = new FoodCaloriesEntities())
{
var query = ctx.Seller.Where(b => b.IdFood == foodid).ToList();
return query;
}
}
public void UpdateEntrie(Entries entity,DateTime dairyid, int entrieid )
{
using (var ctx = new FoodCaloriesEntities())
{
var entrie = ctx.Entries.Include("Diary").FirstOrDefault(b=>b.IdEntry==entrieid && b.Diary.CurrentDate==dairyid);
entrie.Quantity = entity.Quantity;
ctx.SaveChanges();
}
}
public bool IsDuplicatedEntrie(int idDiary)
{
using (var ctx = new FoodCaloriesEntities())
{
return ctx.Entries.Any(b => b.IdDairy == idDiary);
}
}
IEnumerable<Entries> IRepository.GetDairiesEntries(string username, DateTime dairyid, int page, int pagesize)
{
using (var ctx = new FoodCaloriesEntities())
{
var query = ctx.Entries.Include("Diary")
.Where(b=>b.Diary.CurrentDate==dairyid && b.Diary.UserName==username).ToList();
var result=query
.OrderBy(b=>b.Description)
.Skip(pagesize*page)
.Take(pagesize)
.ToList();
return result;
}
}
IEnumerable<Diary> IRepository.GetDairies(string username)
{
using (var ctx = new FoodCaloriesEntities())
{
var query = ctx.Diary.ToList();
return query;
}
}