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