public static int UpdateExistingDayEntry(DayEntry updateDayEntry)
{
using (var context = new VoedingsstoffenContext())
{
try
{
DayEntry dayEntry = context.DayEntrys.Include("Result").Include("SavedProducts").FindOne(w => w.DayEntryId == updateDayEntry.DayEntryId);
if (dayEntry != null)
{
dayEntry.SavedProducts.AddRange(updateDayEntry.SavedProducts);
dayEntry.Result = updateDayEntry.Result;
return(context.DayEntrys.Update(dayEntry) ? 1 : 0);
}
return(0);
}
catch (ArgumentNullException e)
{
Console.WriteLine(e);
throw;
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
}
public static int AddNewProduct(Product newProduct)
{
using (var context = new VoedingsstoffenContext())
{
try
{
return(context.Products.Insert(newProduct));
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
}
public static int AddNewDayEntry(DayEntry dayEntryNew)
{
using (var context = new VoedingsstoffenContext())
{
try
{
return(context.DayEntrys.Insert(dayEntryNew) != null ? 1 : 0);
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
}
public static int UpdateExistingProduct(Product updateProduct)
{
using (var context = new VoedingsstoffenContext())
{
try
{
return(context.Products.Update(updateProduct) ? 1 : 0);
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
}
public static List <Product> SearchProductContainsCharacters(string character)
{
using (var context = new VoedingsstoffenContext())
{
try
{
return(context.Products.Find(s => s.Naam.ToLower().Contains(character.ToLower())).ToList());
}
catch (ArgumentNullException e)
{
Console.WriteLine(e);
throw;
}
}
}
public static int DeleteExistingProduct(int id)
{
using (var context = new VoedingsstoffenContext())
{
try
{
return(context.Products.Delete(w => w.ProductId == id));
}
catch (ArgumentNullException e)
{
Console.WriteLine(e);
throw;
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
}
public static List <SavedProduct> GetSavedProductByIds(List <SavedProduct> productIds)
{
List <SavedProduct> products = new List <SavedProduct>();
using (var context = new VoedingsstoffenContext())
{
try
{
foreach (var id in productIds)
{
products.Add(context.SavedProducts.FindOne(s => s.SavedProductId == id.SavedProductId));
}
return(products);
}
catch (ArgumentNullException e)
{
Console.WriteLine(e);
throw;
}
}
}
public static DayEntry SearchDayEntryOnDate(DateTime date)
{
using (var context = new VoedingsstoffenContext())
{
try
{
foreach (var x in context.DayEntrys.FindAll())
{
if (x.CurentDate.Day == date.Day && x.CurentDate.Month == date.Month && x.CurentDate.Year == date.Year)
{
return(x);
}
}
return(null);
}
catch (ArgumentNullException e)
{
Console.WriteLine(e);
throw;
}
}
}
