public IMeal FindMealById(long pId)
{
using (var context = new dbmealsEntities())
{
var mealDb = context.MEALS.FirstOrDefault(pMeal => pMeal.ID == pId);
return(mealDb == null ? null : Convertes.ConverterEntityDbToObject.ConvertMealDbToMeal(mealDb));
}
}
public IMealGroup FindGroupById(long pId)
{
using (var context = new dbmealsEntities())
{
var mealGroupDb = context.MEAL_GROUPS.FirstOrDefault(pMealGroup => pMealGroup.ID == pId);
return(mealGroupDb == null
? null
: Convertes.ConverterEntityDbToObject.ConvertMealGroupDbToMealGroup(mealGroupDb));
}
}
public List <IMeal> FindAllMealByGroupName(string pGroupName)
{
using (var context = new dbmealsEntities())
{
var meals = new List <IMeal>();
var mealsDb = context.MEALS.Where(pMeal => pMeal.MEAL_GROUPS != null && pMeal.MEAL_GROUPS.NAME == pGroupName).ToList();
foreach (var mealDb in mealsDb)
{
meals.Add(Convertes.ConverterEntityDbToObject.ConvertMealDbToMeal(mealDb));
}
return(meals);
}
}
public List <IMealGroup> FindAllMainMealGroups()
{
using (dbmealsEntities context = new dbmealsEntities())
{
var mealGroupsDb = context.MEAL_GROUPS.Where(pMealGroup => pMealGroup.MEAL_GROUPS2 == null).ToList();
var mealGroups = new List <IMealGroup>();
foreach (var mealGroupDb in mealGroupsDb)
{
mealGroups.Add(Convertes.ConverterEntityDbToObject.ConvertMealGroupDbToMealGroup(mealGroupDb));
}
return(mealGroups);
}
}
public List <IMeal> FindAllOrderItemByOrderId(long pOrderId)
{
using (var context = new dbmealsEntities())
{
var orders = new List <IMeal>();
var orderItemsDb =
context.ORDER_ITEMS.Where(pOrderItem => pOrderItem.ORDER.ID == pOrderId && pOrderItem.ORDER_ITEMS2 == null).ToList();
foreach (var orderItemDb in orderItemsDb)
{
orders.Add(GetOrderItem(orderItemDb));
}
return(orders);
}
}
public List <IMealGroup> FindSubGroupByMainGroupName(string pMealGroupName)
{
using (var context = new dbmealsEntities())
{
var mealGroupsDb =
context.MEAL_GROUPS.Where(
pMealGroup => pMealGroup.MEAL_GROUPS2 != null && pMealGroup.MEAL_GROUPS2.NAME == pMealGroupName)
.ToList();
var mealGroups = new List <IMealGroup>();
foreach (var mealGroupDb in mealGroupsDb)
{
mealGroups.Add(Convertes.ConverterEntityDbToObject.ConvertMealGroupDbToMealGroup(mealGroupDb));
}
return(mealGroups);
}
}
public List <IOrder> FindAllOrdersByDateTimes(DateTime pFromDateTime, DateTime pToDateTime)
{
using (var context = new dbmealsEntities())
{
var from = new DateTime(pFromDateTime.Year, pFromDateTime.Month, pFromDateTime.Day);
var to = new DateTime(pToDateTime.Year, pToDateTime.Month, pToDateTime.Day).AddDays(1).AddSeconds(-1);
var orders = new List <IOrder>();
var ordersDb =
context.ORDERS.Where(pOrders => pOrders.ORDER_DATE >= from && pOrders.ORDER_DATE <= to).ToList();
foreach (var orderDb in ordersDb)
{
orders.Add(new Order(orderDb));
}
return(orders);
}
}
public bool SaveOrder(IOrder pOrder)
{
if (pOrder == null)
{
return(false);
}
try
{
using (var context = new dbmealsEntities())
{
var order = new ORDER
{
ORDER_DATE = pOrder.OrderDate,
COMMENT = pOrder.Comment,
DELIVERY_EMAIL = pOrder.EmailDelivery
};
foreach (var pOrderMeal in pOrder.Meals)
{
order.ORDER_ITEMS.Add(Convertes.ConverterObjectToEntityDb.ConvertMealToOrderItemDb(pOrderMeal));
order.PRICE += (double)(pOrderMeal.CalculateAddOnsPrice() + pOrderMeal.MealPrice);
}
context.ORDERS.Add(order);
context.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
//todo: logowanie bledow
}
return(false);
}
