public JsonResult addProduct(Product addProduct, NutritonalValue_for_product[] nutritionals) { using (recipes = new recipeEntities()) { try { recipes.SaveChanges(); } catch (DbEntityValidationException ex) { catch_errors(ex); } product p = addProduct.getEntity(); var pr = recipes.Entry(p); pr.State = EntityState.Added; List <products_in_nutritional_value> nutritionalsVal = nutritionals.Select(n => n.getEntity()).ToList(); pr.Entity.products_in_nutritional_value = nutritionalsVal; try { recipes.SaveChanges(); } catch (DbEntityValidationException ex) { catch_errors(ex); } return(Json(new { success = true, p = p.getSerialize() })); } }
public JsonResult addUser(user user) { using (re = new recipeEntities()) { var success = true; if (TryUpdateModel(user)) { re.users.Add(user); //Membership.CreateUser(user.name, user.password); try { //Membership.CreateUser(user.name, user.password, user.email); re.SaveChanges(); } catch (DbEntityValidationException ex) { // Retrieve the error messages as a list of strings. var errorMessages = ex.EntityValidationErrors .SelectMany(x => x.ValidationErrors) .Select(x => x.ErrorMessage); // Join the list to a single string. var fullErrorMessage = string.Join("; ", errorMessages); // Combine the original exception message with the new one. var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage); // Throw a new DbEntityValidationException with the improved exception message. throw new DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors); } } else { success = false; } return(Json(new { success = success, id = user.id, user = user.getSerialize() }, JsonRequestBehavior.AllowGet)); } }
public JsonResult addRecipe(recipe recipe, equipment_in_recipe[] equipments, products_in_recipe[] products_in_recipe) { using (recipes = new recipeEntities()) { try { recipes.SaveChanges(); } catch (DbEntityValidationException ex) { catch_errors(ex); // Retrieve the error messages as a list of strings. } var r = recipes.Entry(recipe); r.State = EntityState.Added; r.Entity.equipment_in_recipe = equipments; r.Entity.isApproved(); r.Entity.products_in_recipe = products_in_recipe; try { recipes.SaveChanges(); } catch (DbEntityValidationException ex) { catch_errors(ex); // Retrieve the error messages as a list of strings. } return(Json(new { success = true, recipe = recipe.getSerialize() })); } }
static DataController() { recipes = new recipeEntities(); //nutritional_value n = recipes.nutritional_value.Where(nt => nt.name == "sugar").First(); //n.mustable = false; //recipes.SaveChanges(); }
public JsonResult existUser(string name, string password, string email) { using (re = new recipeEntities()) { bool can = true; user user = null; string reason = "This User doen't exists"; var c = re.users.Where(u => u.name == name && u.password == password).Count(); if (c != 0) { can = false; reason = "This user already exist"; user = re.users.Where(u => u.name == name && u.password == password).First(); Session["user"] = user; } else if (email != null) { c = re.users.Where(u => u.email == email).Count(); if (c != 0) { can = false; reason = "This email address already exists"; } } if (user != null) { user = user.getSerialize(); } var ob = new { can = can, reason = reason, exist = !can, user = user }; return(Json(ob, JsonRequestBehavior.AllowGet)); } }
public JsonResult approvep(int id) { using (recipes = new recipeEntities()) { var pr = recipes.products.FirstOrDefault(p => p.id == id); pr.approved = true; recipes.SaveChanges(); return(Json(new { success = "success", product = pr.getSerialize() }, JsonRequestBehavior.AllowGet)); } }
public JsonResult approver(int id) { using (recipes = new recipeEntities()) { var rec = recipes.recipes.FirstOrDefault(r => r.id == id); rec.approved = true; recipes.SaveChanges(); return(Json(new { success = "success", recipe = rec.getSerialize() }, JsonRequestBehavior.AllowGet)); } }
public JsonResult recipe(int id) { using (recipes = new recipeEntities()) { bool ans = false; recipe recipe = recipes.recipes.FirstOrDefault(r => r.id == id); recipes.recipes.Remove(recipe); recipes.SaveChanges(); return(Json(new { success = ans }, JsonRequestBehavior.AllowGet)); } }
public JsonResult product(int id) { using (recipes = new recipeEntities()) { bool ans = false; product product = recipes.products.FirstOrDefault(p => p.id == id); recipes.products.Remove(product); recipes.SaveChanges(); return(Json(new { success = ans }, JsonRequestBehavior.AllowGet)); } }
public JsonResult user(int id) { using (recipes = new recipeEntities()) { bool ans = false; user user = recipes.users.FirstOrDefault(p => p.id == id); recipes.users.Remove(user); recipes.SaveChanges(); return(Json(new { success = ans }, JsonRequestBehavior.AllowGet)); } }
public JsonResult users() { using (recipes = new recipeEntities()) { user user = (Session["user"] as user); if (user != null && user.user_or_manager) { return(Json(new { success = true, users = recipes.users.Select(u => u.getSerialize()).ToList() }, JsonRequestBehavior.AllowGet)); } return(Json(new { success = false, reason = sentences.notAllowedData }, JsonRequestBehavior.AllowGet)); } }
public JsonResult product(product p) { using (recipes = new recipeEntities()) { bool ans = false; if (ModelState.IsValid) { //recipes.Entry(p).State = EntityState.Modified; recipes.SaveChanges(); ans = true; } return(Json(new { success = ans, product = p }, JsonRequestBehavior.AllowGet)); } }
public JsonResult recipe(recipe r) { using (recipes = new recipeEntities()) { bool ans = false; if (ModelState.IsValid) { var rec = recipes.Entry(r); //rec.State = EntityState.Modified; recipes.SaveChanges(); ans = true; } return(Json(new { success = ans, recipe = r }, JsonRequestBehavior.AllowGet)); } }
public JsonResult getDetails() { using (recipes = new recipeEntities()) { var nvv = recipes.nutritional_value.Where(nv => nv.mustable).ToList(); return(Json( new { measureTypes = recipes.measure_type.ToList().Select(t => t.getSerialize()).ToList(), measurements = recipes.measurement_with_type.ToList(), nutritionalValues = nvv.Select(nv => nv.getSerialize()).ToList(), // recipes = recipes.recipes, user = Session["user"] }, JsonRequestBehavior.AllowGet )); } }
public JsonResult getLists() { using (recipes = new recipeEntities()) { var cat = recipes.categories.ToList().Select(c => c.getSerialize()).ToList(); var pro = getProducts().Data; var det = getDetails().Data; var rec = getRecipes().Data; var ans = new { success = true, categories = cat, products = pro, details = det, recipes = rec }; return(Json(ans, JsonRequestBehavior.AllowGet)); } }
public JsonResult getRecipes() { using (recipes = new recipeEntities()) { int id; bool isManager = false; if (Session["user"] is user) { id = (Session["user"] as user).id; isManager = (Session["user"] as user).user_or_manager; } else { id = 0; } List <recipe> recipe = recipes.recipes.Where(r => isManager || r.approved == true || r.user_id == id).ToList(); recipe = recipe.Select(r => r.getSerialize()).ToList(); return(Json(recipe, JsonRequestBehavior.AllowGet)); } }
public JsonResult getProducts(string where = "") { using (recipes = new recipeEntities()) { int id; bool isManager = false; if (Session["user"] is user) { id = (Session["user"] as user).id; isManager = (Session["user"] as user).user_or_manager; } else { id = 0; } List <nutritional_value_details> nutritionalDetails = recipes.nutritional_value_details.ToList(); List <product> products = recipes.products.Where(p => isManager || p.approved == true || p.user_id == id).ToList(); products = products.Select(p => p.getSerialize()).ToList(); var prod = products.Select(p => new { product = p, nutritional = nutritionalDetails.Where(nv => nv.product_id == p.id).ToList() }).ToList(); return(Json(prod, JsonRequestBehavior.AllowGet)); } }
public ActionResult Index(user objcheck, string ReturnUrl) { if (ModelState.IsValid) { using (recipeEntities db = new recipeEntities()) { var obj = db.users.Where(a => a.username.Equals(objcheck.username) && a.password.Equals(objcheck.password)).FirstOrDefault(); if (obj != null) { Session["UserID"] = obj.id.ToString(); Session["Username"] = obj.username.ToString(); return(RedirectToAction("Index", "Home")); } else { ModelState.AddModelError("", "The Username or Password Incorrect!"); } } } return(View(objcheck)); }
static LoginController() { re = new recipeEntities(); }
static RecipeController() { recipes = new recipeEntities(); }