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; }