public ActionResult DailyRecipeRemove(int recipeDayId) { var data = new object(); try { using (var db = new DIYFE.EF.DIYFEEntities()) { RecipeDay deltedRecipe = db.RecipeDays.Where(rd => rd.RecipeDayId == recipeDayId).FirstOrDefault(); if (deltedRecipe != null) { db.Entry(deltedRecipe).State = System.Data.EntityState.Deleted; db.SaveChanges(); } ; } data = new { success = true }; } catch (Exception ex) { if (ex.InnerException.Message != null) { data = new { success = false, message = ex.InnerException.Message }; } else { data = new { success = false, message = ex.Message + " Another reason why EF sucks" }; } return(Json(data)); } return(Json(data)); }
public ActionResult RemoveShoppingItem(int ingredientId) { var data = new object(); try { using (var db = new DIYFE.EF.DIYFEEntities()) { IngredientShopping deltedItem = db.IngredientShoppings.Where(i => i.IngredientId == ingredientId).FirstOrDefault(); if (deltedItem != null) { db.Entry(deltedItem).State = System.Data.EntityState.Deleted; db.SaveChanges(); } ; } data = new { success = true }; } catch (Exception ex) { if (ex.InnerException.Message != null) { data = new { success = false, message = ex.InnerException.Message }; } else { data = new { success = false, message = ex.Message + " Another reason why EF sucks" }; } return(Json(data)); } return(Json(data)); }
public ActionResult AddShoppingItem(int ingredientId) { var data = new object(); IngredientShopping rd = new IngredientShopping { IngredientId = ingredientId }; try { using (var db = new DIYFE.EF.DIYFEEntities()) { db.Entry(rd).State = System.Data.EntityState.Added; db.SaveChanges(); } data = new { success = true }; } catch (Exception ex) { if (ex.InnerException.Message != null) { data = new { success = false, message = ex.InnerException.Message }; } else { data = new { success = false, message = ex.Message + " Another reason why EF sucks" }; } return(Json(data)); } return(Json(data)); }
public ActionResult ClearWeek() { var data = new object(); try { using (var db = new DIYFE.EF.DIYFEEntities()) { db.ClearWeek(); db.SaveChanges(); } data = new { success = true }; } catch (Exception ex) { if (ex.InnerException.Message != null) { data = new { success = false, message = ex.InnerException.Message }; } else { data = new { success = false, message = ex.Message + " Another reason why EF sucks" }; } return(Json(data)); } return(Json(data)); }
public ActionResult SignUpNewLetter(string email) { var data = new object(); try { NewsLetter letter = new NewsLetter() { Email = email, DateCreated = DateTime.Now }; using (var db = new DIYFE.EF.DIYFEEntities()) { db.NewsLetters.Add(letter); db.SaveChanges(); } } catch (Exception ex) { data = new { success = false, message = "Failed to join news letter." }; return(Json(data)); } data = new { success = true }; return(Json(data)); }
public ActionResult AddArticle(Article article) { var data = new object(); article.CreatedDate = DateTime.Now; article.UpdateDate = DateTime.Now; try { using (var db = new DIYFE.EF.DIYFEEntities()) { db.Articles.Add(article); db.SaveChanges(); } AppStatic.LoadStaticCache(); data = new { success = true }; } catch (Exception ex) { if (ex.InnerException.Message != null) { data = new { success = false, message = ex.InnerException.Message }; } else { data = new { success = false, message = ex.Message + " Another reason why EF sucks" }; } return(Json(data)); } return(Json(data)); }
public ActionResult AddArticle(Article article) { var data = new object(); article.CreatedDate = DateTime.Now; article.UpdateDate = DateTime.Now; try { using (var db = new DIYFE.EF.DIYFEEntities()) { db.Articles.Add(article); db.SaveChanges(); } StaticConfig.LoadStaticCache(); data = new { success = true }; } catch (Exception ex) { if (ex.InnerException.Message != null) { data = new { success = false, message = ex.InnerException.Message }; } else { data = new { success = false, message = ex.Message + " Another reason why EF sucks" }; } return Json(data); } return Json(data); }
public ActionResult ArticleDetails(string articleType, string categoryUrl, string subCategoryUrl, string subSubCategoryUrl, string articleName) { int categoryRowId = 0; ArticleModel model = new ArticleModel(); Category cat = new Category(); using (var db = new DIYFE.EF.DIYFEEntities()) { model.Article = db.Articles.Include("ArticleComments").Where(a => a.URLLink == articleName + ".html").FirstOrDefault(); model.Article.ViewRequests++; db.Entry(model.Article).State = System.Data.EntityState.Modified; db.SaveChanges(); } if (model.Article != null) { cat = StaticConfig.GetCatigroy(model.Article.CategoryRowId); model.CrumbLinkList = StaticConfig.GenerateCrumbLinks(cat, articleType); model.RelatedTreeView = StaticConfig.GenerateRelatedTreeView(cat, articleType); PageModel.Title = model.Article.Title; PageModel.Description = model.Article.Description; PageModel.Author = model.Article.Author; PageModel.Keywords = model.Article.Keywords; } else { //JUST TO GET BY -- REPLACE WITH 404 SOULATION model.CrumbLinkList = StaticConfig.GenerateCrumbLinks(new Category(), articleType); model.Article = new Article(); model.Comments = new List <ArticleComment>(); //model.RelatedTreeView = DIYFEHelper.GenerateTreeViewThirdLev(model.Article.CategoryRowId, linkPrefix); PageModel.Title = ""; PageModel.Description = ""; PageModel.Author = ""; PageModel.Keywords = ""; } // model.Comments = la.ArticleComments(model.Article.ArticleId); //model.MostViewed = la.MostViewed(11, 20); // model.CrumbLinkList = DIYFEHelper.GenerateCrumbLinks(categoryRowId, linkPrefix); model.RelatedTreeView = StaticConfig.GenerateTreeViewThirdLev(cat, articleType); ////PageModel.Title = model.Article.Title; ////PageModel.Description = model.Article.Description; ////PageModel.Author = model.Article.Author; ////PageModel.Keywords = model.Article.Keywords; return(View(model)); }
public ActionResult ArticleDetails(string articleType, string categoryUrl, string subCategoryUrl, string subSubCategoryUrl, string articleName) { int categoryRowId = 0; ArticleModel model = new ArticleModel(); Category cat = new Category(); using (var db = new DIYFE.EF.DIYFEEntities()) { model.Article = db.Articles.Include("ArticleComments").Where(a => a.URLLink == articleName + ".html").FirstOrDefault(); model.Article.ViewRequests++; db.Entry(model.Article).State = System.Data.EntityState.Modified; db.SaveChanges(); } if (model.Article != null) { cat = StaticConfig.GetCatigroy(model.Article.CategoryRowId); model.CrumbLinkList = StaticConfig.GenerateCrumbLinks(cat, articleType); model.RelatedTreeView = StaticConfig.GenerateRelatedTreeView(cat, articleType); PageModel.Title = model.Article.Title; PageModel.Description = model.Article.Description; PageModel.Author = model.Article.Author; PageModel.Keywords = model.Article.Keywords; } else { //JUST TO GET BY -- REPLACE WITH 404 SOULATION model.CrumbLinkList = StaticConfig.GenerateCrumbLinks(new Category(), articleType); model.Article = new Article(); model.Comments = new List<ArticleComment>(); //model.RelatedTreeView = DIYFEHelper.GenerateTreeViewThirdLev(model.Article.CategoryRowId, linkPrefix); PageModel.Title = ""; PageModel.Description = ""; PageModel.Author = ""; PageModel.Keywords = ""; } // model.Comments = la.ArticleComments(model.Article.ArticleId); //model.MostViewed = la.MostViewed(11, 20); // model.CrumbLinkList = DIYFEHelper.GenerateCrumbLinks(categoryRowId, linkPrefix); model.RelatedTreeView = StaticConfig.GenerateTreeViewThirdLev(cat, articleType); ////PageModel.Title = model.Article.Title; ////PageModel.Description = model.Article.Description; ////PageModel.Author = model.Article.Author; ////PageModel.Keywords = model.Article.Keywords; return View(model); }
public ActionResult SendContactEmail(ContactMailModel model) { var data = new object(); try { var email = EmailMessageFactory.GetContactEmail(model); var result = EmailClient.SendEmail(email); if (!String.IsNullOrEmpty(model.NewsLetter)) { try { NewsLetter letter = new NewsLetter() { Email = model.Email, DateCreated = DateTime.Now }; using (var db = new DIYFE.EF.DIYFEEntities()) { db.NewsLetters.Add(letter); db.SaveChanges(); } } catch (Exception ex) { data = new { success = false, message = "Message Was Sent...but failed to join news letter." }; return(Json(data)); } } } catch (Exception ex) { data = new { success = false, message = "Failed to send comment. Please trying contacting us directly." }; return(Json(data)); } data = new { success = true }; return(Json(data)); }
public ActionResult AddCategory(DIYFE.EF.Category category) { var data = new object(); using (var db = new DIYFE.EF.DIYFEEntities()) { if (category.ThirdLevCategoryId == 0 && category.SecondLevCategoryId != 0) { category.ThirdLevCategoryId = db.Categories.Max(c => c.ThirdLevCategoryId).Value; } if (category.SecondLevCategoryId == 0) { category.SecondLevCategoryId = db.Categories.Max(c => c.SecondLevCategoryId).Value; } if (category.CategoryId == 0) { category.CategoryId = db.Categories.Max(c => c.CategoryId); } db.Categories.Add(category); db.SaveChanges(); data = new { success = true }; //allCats = db.Categories.ToList(); } AppStatic.LoadStaticCache(); //Category cat = new Category(); //if (cat.InsertCategory(category)) //{ // AppStatic.LoadStaticCache(); // data = new { success = true }; //} //else //{ // data = new { success = false, message = "Failed to insert new category." }; // return Json(data); //} return(Json(data)); }
public ActionResult AddCategory(DIYFE.EF.Category category) { var data = new object(); using (var db = new DIYFE.EF.DIYFEEntities()) { if (category.ThirdLevCategoryId == 0 && category.SecondLevCategoryId != 0) { category.ThirdLevCategoryId = db.Categories.Max(c => c.ThirdLevCategoryId).Value; } if (category.SecondLevCategoryId == 0) { category.SecondLevCategoryId = db.Categories.Max(c => c.SecondLevCategoryId).Value; } if (category.CategoryId == 0) { category.CategoryId = db.Categories.Max(c => c.CategoryId); } db.Categories.Add(category); db.SaveChanges(); data = new { success = true }; //allCats = db.Categories.ToList(); } AppStatic.LoadStaticCache(); //Category cat = new Category(); //if (cat.InsertCategory(category)) //{ // AppStatic.LoadStaticCache(); // data = new { success = true }; //} //else //{ // data = new { success = false, message = "Failed to insert new category." }; // return Json(data); //} return Json(data); }
protected override void OnResultExecuting(ResultExecutingContext ctx) { base.OnResultExecuting(ctx); string _ipAddress; string _sessionId; _ipAddress = ctx.HttpContext.Request.ServerVariables["HTTP_X_FORWARDED_FOR"]; if (string.IsNullOrEmpty(_ipAddress)) { _ipAddress = ctx.HttpContext.Request.ServerVariables["REMOTE_ADDR"]; } if (Request.Cookies["sessionKey"] != null) { _sessionId = Request.Cookies["sessionKey"].Value; } else { Response.Cookies.Add(new System.Web.HttpCookie("sessionKey", ctx.HttpContext.Session.SessionID)); Response.Cookies["sessionKey"].Expires = DateTime.Now.AddHours(12); _sessionId = ctx.HttpContext.Session.SessionID; } Tracking track = new Tracking(); track.IP = _ipAddress; track.Session = _sessionId; track.URL = ctx.HttpContext.Request.Url.PathAndQuery; track.CreatedDate = DateTime.Now; using (var db = new DIYFE.EF.DIYFEEntities()) { db.Trackings.Add(track); db.SaveChanges(); } ViewBag.PageModel = PageModel; }
// // GET: /Service/ public ActionResult PostComment(ArticleComment comment) { var data = new object(); try { using (var db = new DIYFE.EF.DIYFEEntities()) { db.ArticleComments.Add(comment); db.SaveChanges(); } } catch (Exception ex) { data = new { success = false, message = "Failed to insert new comment." }; return Json(data); } data = new { success = true, obj = comment }; return Json(data); }
// // GET: /Service/ public ActionResult PostComment(ArticleComment comment) { var data = new object(); try { using (var db = new DIYFE.EF.DIYFEEntities()) { db.ArticleComments.Add(comment); db.SaveChanges(); } } catch (Exception ex) { data = new { success = false, message = "Failed to insert new comment." }; return(Json(data)); } data = new { success = true, obj = comment }; return(Json(data)); }
public ActionResult AddToDay(int dayId, int recipeId) { var data = new object(); RecipeDay rd = new RecipeDay { DayId = dayId, RecipeId = recipeId, Active = true }; try { using (var db = new DIYFE.EF.DIYFEEntities()) { db.Entry(rd).State = System.Data.EntityState.Added; db.SaveChanges(); } data = new { success = true }; } catch (Exception ex) { if (ex.InnerException.Message != null) { data = new { success = false, message = ex.InnerException.Message }; } else { data = new { success = false, message = ex.Message + " Another reason why EF sucks" }; } return(Json(data)); } return(Json(data)); }
public ActionResult AddShoppingItem(int ingredientId) { var data = new object(); IngredientShopping rd = new IngredientShopping { IngredientId = ingredientId }; try { using (var db = new DIYFE.EF.DIYFEEntities()) { db.Entry(rd).State = System.Data.EntityState.Added; db.SaveChanges(); } data = new { success = true }; } catch (Exception ex) { if (ex.InnerException.Message != null) { data = new { success = false, message = ex.InnerException.Message }; } else { data = new { success = false, message = ex.Message + " Another reason why EF sucks" }; } return Json(data); } return Json(data); }
public ActionResult SendContactEmail(ContactMailModel model) { var data = new object(); try { var email = EmailMessageFactory.GetContactEmail(model); var result = EmailClient.SendEmail(email); if (!String.IsNullOrEmpty(model.NewsLetter)) { try { NewsLetter letter = new NewsLetter() { Email = model.Email, DateCreated = DateTime.Now }; using (var db = new DIYFE.EF.DIYFEEntities()) { db.NewsLetters.Add(letter); db.SaveChanges(); } } catch (Exception ex) { data = new { success = false, message = "Message Was Sent...but failed to join news letter." }; return Json(data); } } } catch (Exception ex) { data = new { success = false, message = "Failed to send comment. Please trying contacting us directly." }; return Json(data); } data = new { success = true }; return Json(data); }
public ActionResult SignUpNewLetter(string email) { var data = new object(); try { NewsLetter letter = new NewsLetter() { Email = email, DateCreated = DateTime.Now }; using (var db = new DIYFE.EF.DIYFEEntities()) { db.NewsLetters.Add(letter); db.SaveChanges(); } } catch (Exception ex) { data = new { success = false, message = "Failed to join news letter." }; return Json(data); } data = new { success = true }; return Json(data); }
public ActionResult ClearWeek() { var data = new object(); try { using (var db = new DIYFE.EF.DIYFEEntities()) { db.ClearWeek(); db.SaveChanges(); } data = new { success = true }; } catch (Exception ex) { if (ex.InnerException.Message != null) { data = new { success = false, message = ex.InnerException.Message }; } else { data = new { success = false, message = ex.Message + " Another reason why EF sucks" }; } return Json(data); } return Json(data); }
protected override void OnResultExecuting(ResultExecutingContext ctx) { base.OnResultExecuting(ctx); string _ipAddress; string _sessionId; _ipAddress = ctx.HttpContext.Request.ServerVariables["HTTP_X_FORWARDED_FOR"]; if (string.IsNullOrEmpty(_ipAddress)) { _ipAddress = ctx.HttpContext.Request.ServerVariables["REMOTE_ADDR"]; } if (Request.Cookies["sessionKey"] != null) { _sessionId = Request.Cookies["sessionKey"].Value; } else { Response.Cookies.Add(new System.Web.HttpCookie("sessionKey", ctx.HttpContext.Session.SessionID)); Response.Cookies["sessionKey"].Expires = DateTime.Now.AddHours(12); _sessionId = ctx.HttpContext.Session.SessionID; } Tracking track = new Tracking(); track.IP = _ipAddress; track.Session = _sessionId; track.URL = ctx.HttpContext.Request.Url.PathAndQuery; track.CreatedDate = DateTime.Now; using (var db = new DIYFE.EF.DIYFEEntities()) { db.Trackings.Add(track); db.SaveChanges(); } ViewBag.PageModel = PageModel; }
public ActionResult DailyRecipeRemove(int recipeDayId) { var data = new object(); try { using (var db = new DIYFE.EF.DIYFEEntities()) { RecipeDay deltedRecipe = db.RecipeDays.Where(rd => rd.RecipeDayId == recipeDayId).FirstOrDefault(); if (deltedRecipe != null) { db.Entry(deltedRecipe).State = System.Data.EntityState.Deleted; db.SaveChanges(); }; } data = new { success = true }; } catch (Exception ex) { if (ex.InnerException.Message != null) { data = new { success = false, message = ex.InnerException.Message }; } else { data = new { success = false, message = ex.Message + " Another reason why EF sucks" }; } return Json(data); } return Json(data); }
public ActionResult RemoveShoppingItem(int ingredientId) { var data = new object(); try { using (var db = new DIYFE.EF.DIYFEEntities()) { IngredientShopping deltedItem = db.IngredientShoppings.Where(i => i.IngredientId == ingredientId).FirstOrDefault(); if (deltedItem != null) { db.Entry(deltedItem).State = System.Data.EntityState.Deleted; db.SaveChanges(); }; } data = new { success = true }; } catch (Exception ex) { if (ex.InnerException.Message != null) { data = new { success = false, message = ex.InnerException.Message }; } else { data = new { success = false, message = ex.Message + " Another reason why EF sucks" }; } return Json(data); } return Json(data); }
public ActionResult AddToDay(int dayId, int recipeId) { var data = new object(); RecipeDay rd = new RecipeDay { DayId = dayId, RecipeId = recipeId, Active = true }; try { using (var db = new DIYFE.EF.DIYFEEntities()) { db.Entry(rd).State = System.Data.EntityState.Added; db.SaveChanges(); } data = new { success = true }; } catch (Exception ex) { if (ex.InnerException.Message != null) { data = new { success = false, message = ex.InnerException.Message }; } else { data = new { success = false, message = ex.Message + " Another reason why EF sucks" }; } return Json(data); } return Json(data); }