public bool ValidateData(USER user)
{
using (var context = new DietDbContext())
{
//CALL DB PROCEDURE
}
return(false);
}
public void CreateUserData(USER_DATA data)
{
using (var context = new DietDbContext())
{
context.CREATEUSERDATA(data.HEIGHT, data.WEIGHT, data.USER_ID);
context.SaveChanges();
}
}
public void CreateUserLog(int userId, string deviceInfo)
{
using (var ctx = new DietDbContext())
{
ctx.ADDUSERLOG(userId, deviceInfo);
ctx.SaveChanges();
}
}
public void SetNewPassword(int userId, string password)
{
using (var ctx = new DietDbContext())
{
ctx.CHANGEPASSWORD(password, userId);
ctx.SaveChanges();
}
}
/*public void AddDiet(DIET diet)
* {
* using (var ctx = new DietDbContext())
* {
* ctx.DIETS.Add(diet);
* ctx.SaveChanges();
* }
* }*/
public void AddProductToDiet(int dietId, int productId, int quantity)
{
using (var ctx = new DietDbContext())
{
ctx.ADDPRODUCTODIET(productId, dietId, quantity);
ctx.SaveChanges();
}
}
public void AddUserDietsEntry(USER_DIETS entry)
{
using (var ctx = new DietDbContext())
{
ctx.USER_DIETS.Add(entry);
ctx.SaveChanges();
}
}
public void AddProductToDb(PRODUCT product)
{
using (var ctx = new DietDbContext())
{
ctx.CREATEPRODUCT(product.PRODUCT_DESCRIPTION, product.KCAL_100, product.PROTEIN_100, product.FAT_100,
product.CARBS_100);
ctx.SaveChanges();
}
}
public void DeleteAllDietProductsEntries(int dietId)
{
using (var ctx = new DietDbContext())
{
var items = ctx.DIET_PRODUCTS.Where(x => x.DIET_ID == dietId).ToList();
ctx.DIET_PRODUCTS.RemoveRange(items);
ctx.SaveChanges();
}
}
public void UpdateDate(int dietId, DateTime date)
{
using (var ctx = new DietDbContext())
{
var item = ctx.DIETS.Where(x => x.DIET_ID == dietId).FirstOrDefault();
item.ENTRY_DATE = date;
ctx.SaveChanges();
}
}
static void Main(string[] args)
{
using (var context = new DietDbContext())
{
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
Console.WriteLine("Hello World!");
Console.ReadKey();
}
}
public void DeletUserData(int id)
{
using (var context = new DietDbContext())
{
var itemToRemove = context.USER_DATA.FirstOrDefault(x => x.USER_DATA_ID == id);
if (itemToRemove != null)
{
context.USER_DATA.Remove(itemToRemove);
}
context.SaveChanges();
}
}
public int GetUserIdByName(string name)
{
int id = -1;
using (var context = new DietDbContext())
{
var result = context.USERS.Where(x => x.USER_NAME == name).FirstOrDefault();
if (result != null)
{
id = result.USER_ID;
}
}
return(id);
}
public void DeleteDiet(int dietId)
{
using (var ctx = new DietDbContext())
{
var item = ctx.DIETS.FirstOrDefault(x => x.DIET_ID == dietId);
if (item != null)
{
var userDiets = item.USER_DIETS;
ctx.USER_DIETS.RemoveRange(userDiets);
ctx.DIETS.Remove(item);
ctx.SaveChanges();
}
}
}
public EntriesController(DietDbContext context)
{
_context = context;
}
public UserProfileController(DietDbContext context)
{
_context = context;
}
public RecipeController(DietDbContext context)
{
_context = context;
}
