public List <Score> HistoryOfScoreByUserId(int userId)
{
using (PechkaContext work = new PechkaContext())
{
return(work.Scores.Where(u => u.UserId == userId).ToList());
}
}
public Order GetUserOrderByDateAndUserId(DateTime date, int userId)
{
using (var work = new PechkaContext())
{
return
(work.Orders.Include(u => u.Menu)
.Include(u => u.User)
.FirstOrDefault(u => u.UserId == userId && u.Menu.Date == date));
}
}
public OrdersDTO GetOrdersForAdmin(DateTime date)
{
using (var work = new PechkaContext())
{
var result = new OrdersDTO();
result.Orders = work.Orders.Include(u => u.User).Where(u => u.Menu.Date == date).ToList();
result.Date = date;
result.CountOrdersWithFirst = result.Orders.Count(u => u.WithFirst == true);
result.CountOrdersWithoutFirst = result.Orders.Count(u => u.WithoutFirst == true);
return(result);
}
}
public bool UpdateUserOrder(MenuForUserDTO model, int userId)
{
using (var work = new PechkaContext())
{
var orderForUpdate = work.Orders.FirstOrDefault(u => u.MenuId == model.MenuId && u.UserId == userId);
orderForUpdate.WithFirst = model.OrderWithFirst != 0;
orderForUpdate.WithoutFirst = model.OrderWithoutFirst != 0;
work.Orders.AddOrUpdate(orderForUpdate);
work.SaveChanges();
return(true);
}
}
public List <MenuDTO> GetAllMenuForAdmin()
{
using (var work = new PechkaContext())
{
var intermediateResult = work.Meny;
var result = intermediateResult.ToList().Select(item => item.ToMenuDTO()).ToList();
result.Sort();
result.Reverse();
result.Add(new MenuDTO());
return(result);
}
}
public int?ChangeScoreByUserId(int userId, decimal newMoney)
{
var newScore = newMoney.ToScore(userId);
using (PechkaContext work = new PechkaContext())
{
work.Scores.Add(newScore);
work.SaveChanges();
var temp = work.Scores.Where(u => u.UserId == userId).ToArray();
return(temp[temp.Length - 1].Id);
}
}
public void AddNewScore(int id)
{
Score newScore = new Score();
newScore.Date = DateTime.Now;
newScore.Money = 0;
newScore.UserId = id;
using (PechkaContext work = new PechkaContext())
{
work.Scores.Add(newScore);
}
}
public bool AddNewOrder(MenuForUserDTO model, int userId)
{
using (var work = new PechkaContext())
{
var orderToAdd = new Order();
orderToAdd.UserId = userId;
orderToAdd.MenuId = model.MenuId;
orderToAdd.WithoutFirst = model.OrderWithoutFirst != 0;
orderToAdd.WithFirst = model.OrderWithFirst != 0;
work.Orders.Add(orderToAdd);
work.SaveChanges();
return(true);
}
}
public MenuDTO GetMenu(int id)
{
using (var work = new PechkaContext())
{
var item = work.Meny.FirstOrDefault(u => u.Id == id);
if (item != null)
{
return(item.ToMenuDTO());
}
else
{
return(null);
}
}
}
public bool UpdateMenu(MenuDTO model)
{
using (var work = new PechkaContext())
{
try
{
var thismenu = work.Meny.FirstOrDefault(u => u.Id == model.Id);
thismenu.IsCompleted = model.ToMenu().IsCompleted;
work.Meny.AddOrUpdate(thismenu);
work.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public List <MenuForUserDTO> GetMenuForUser(string email)
{
using (var work = new PechkaContext())
{
var userId = work.Users.FirstOrDefault(u => u.Email == email).Id;
var menu = work.Meny.ToList();
foreach (var item in menu)
{
var elem = work.Reviews.Include(u => u.User).Where(u => u.MenuId == item.Id);
item.Reviews = elem.Count() != 0 ? elem.ToList() : null;
var order = work.Orders.FirstOrDefault(u => u.UserId == userId && u.MenuId == item.Id);
if (order != null)
{
item.Order.Add(order);
}
}
return(menu.ToUserMenuDto());
}
}
public bool AddNewMenu(MenuDTO model)
{
using (var work = new PechkaContext())
{
try
{
if (work.Meny.FirstOrDefault(u => u.Date == model.Date) == null)
{
work.Meny.Add(model.ToMenu());
work.SaveChanges();
return(true);
}
return(false);
}
catch
{
return(false);
}
}
}
public bool AddNewReview(int userId, int menuId, string body)
{
var reviewToAdd = new Review();
reviewToAdd.UserId = userId;
reviewToAdd.MenuId = menuId;
reviewToAdd.Body = body;
using (var work = new PechkaContext())
{
try
{
work.Reviews.Add(reviewToAdd);
work.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
