public string GetRecipes() { using (var db = new DBConnection.TastyRecipesEntities()) { var recipes = db.tbRecipes.ToList(); return(JsonConvert.SerializeObject(recipes)); } }
public int DeleteRecipe(int id) { using (var db = new DBConnection.TastyRecipesEntities()) { var recipe = db.tbRecipes.Where(i => i.id == id).FirstOrDefault(); db.tbRecipes.Remove(recipe); db.SaveChanges(); return(recipe.id); } }
protected void login_click(object sender, EventArgs e) { using (var db = new DBConnection.TastyRecipesEntities()) { var user = db.tbUsers.Where(u => u.UserEmail == txtBoxMailLogin.Text && u.UserPassword == txtBoxPasswordLogin.Text).FirstOrDefault(); if (null == user) { lblErrorLogin.Text = "email or password is incorrect"; } else { enterUserToSession(user.UserName, user.UserEmail); } } }
/* ------------------------ Registration ------------------------ */ protected void submit_registration_click(object sender, EventArgs e) { using (var db = new DBConnection.TastyRecipesEntities()) { var user = db.tbUsers.Where(u => u.UserEmail == txtBoxMailRegister.Text).FirstOrDefault(); if (null == user) { //tbUser t = new db.tbUsers.Add(new tbUser { UserName = txtBoxUserNameRegister.Text, UserEmail = txtBoxMailRegister.Text, UserPassword = txtBoxPasswordRegister.Text }); db.SaveChanges(); enterUserToSession(txtBoxUserNameRegister.Text, txtBoxMailRegister.Text); } else { lblErrorRegister.Text = "User with that email is already exist"; ShowLogin(false); } } }
public int SaveRecipe() { using (var stream = new MemoryStream()) { var request = HttpContext.Current.Request; request.InputStream.Seek(0, SeekOrigin.Begin); request.InputStream.CopyTo(stream); var dataStr = Encoding.UTF8.GetString(stream.ToArray()); var data = (dynamic)JsonConvert.DeserializeObject(dataStr); using (var db = new DBConnection.TastyRecipesEntities()) { var d = data.data; int id = Convert.ToInt32(d["id"]); var recipe = id == 0 ? new tbRecipe() : db.tbRecipes.Where(i => i.id == id).FirstOrDefault(); recipe.RecipeName = Convert.ToString(d["RecipeName"]); recipe.RecipeDescription = Convert.ToString(d["RecipeDescription"]); recipe.RecipeMealType = Convert.ToString(d["RecipeMealType"]); recipe.RecipeCategory = Convert.ToString(d["RecipeCategory"]); recipe.RecipeIngredients = Convert.ToString(d["RecipeIngredients"]); recipe.RecipeTime = Convert.ToInt32(d["RecipeTime"]); recipe.RecipeDifficulty = Convert.ToString(d["RecipeDifficulty"]); recipe.RecipeInstructions = Convert.ToString(d["RecipeInstructions"]); recipe.RecipeImg = (byte[])(d["RecipeImg"]); recipe.UserName = Convert.ToString(d["UserName"]); recipe.UserEmail = Convert.ToString(d["UserEmail"]); if (id == 0) { db.tbRecipes.Add(recipe); } db.SaveChanges(); return(recipe.id); } } }