public bool Create(IFoodlog foodlog)
{
var success = false;
var parameters = new Dictionary <string, object>
{
{ "Amount", foodlog.Amount },
{ "Unit", foodlog.Unit },
{ "DateTime", foodlog.DateTime },
{ "User_Id", foodlog.User.Id }
};
if (foodlog.Article != null)
{
parameters.Add("Article_Id", foodlog.Article.Id);
success = HelpFunctions.nonQuery("Foodlog_InsertArticle", parameters);
}
else
{
parameters.Add("Dish_Id", foodlog.Dish.Id);
success = HelpFunctions.nonQuery("Foodlog_InsertDish", parameters);
}
InstantiateContextSQL();
return(success);
}
/// <summary>
///
/// Update
///
/// Right = All
///
/// Exception = Foodlog.Article cant be null
///
/// </summary>
public bool Add(int userId, IFoodlog foodlog)
{
if (foodlog.Dish != null || foodlog.Article != null)
{
return(_repository.Add(foodlog));
}
return(false);
}
public bool Update(IFoodlog foodlog)
{
try
{
_foodlogs[foodlog.Id - 1] = Map(foodlog);
return(true);
}
catch (Exception e)
{
Console.WriteLine(e);
}
return(false);
}
private static FoodlogDto Map(IFoodlog foodlog)
{
var foodlogDto = new FoodlogDto
{
Id = _foodlogs.Max(u => u.Id) + 1,
Amount = foodlog.Amount,
Article = foodlog.Article,
DateTime = foodlog.DateTime,
Unit = foodlog.Unit,
User = foodlog.User
};
return(foodlogDto);
}
public bool Update(IFoodlog foodlog)
{
var parameters = new Dictionary <string, object>
{
{ "Id", foodlog.Id },
{ "Amount", foodlog.Amount },
{ "Unit", foodlog.Unit },
{ "DateTime", foodlog.DateTime },
{ "User_Id", foodlog.User.Id },
{ "Article_Id", foodlog.Article.Id },
{ "Dish_Id", foodlog.Dish.Id }
};
var success = HelpFunctions.nonQuery("Foodlog_Update", parameters);
InstantiateContextSQL();
return(success);
}
public bool Edit(IFoodlog foodlog) => _context.Update(foodlog);
public bool Add(IFoodlog foodlog) => _context.Create(foodlog);
public IFoodlog GetBy(IFoodlog foodlog) => _context.Read(foodlog);
public IFoodlog Read(IFoodlog foodlog)
{
var foodlogDto = Read(foodlog.Id);
return(foodlogDto);
}
public IFoodlog Read(IFoodlog foodlog)
{
return(_foodlogs.SingleOrDefault(f => f.Id == foodlog.Id));
}
public bool Create(IFoodlog foodlog)
{
_foodlogs.Add(Map(foodlog));
return(true);
}
