public ActionResult Filter(Fan Fan)
{
using (var context = new ShauliBlogContext())
{
var _results = context.Fans.Select(a => a);
if (Fan.FirstName != null)
{
_results = _results.Where(a => a.FirstName.Contains(Fan.FirstName));
}
if (Fan.LastName != null)
{
_results = _results.Where(a => a.LastName.Contains(Fan.LastName));
}
if (Fan.Gender != "All")
{
_results = _results.Where(a => a.Gender == Fan.Gender);
}
if (Fan.YearsInClub != 0)
{
_results = _results.Where(a => a.YearsInClub == Fan.YearsInClub);
}
return(CheckLoggedIn("Fans/FanList", _results.ToList()));
// return View("Fans/FanList", _results.ToList());
}
}
public ActionResult Map()
{
using (var context = new ShauliBlogContext())
{
var _fans = context.Fans.ToList();
var _grouped_fans = context.Fans.GroupBy(a => new { a.FanLocation.Country, a.FanLocation.City })
.ToList();
var _dict = new Dictionary <string, List <Fan> >();
foreach (var item in _grouped_fans)
{
var _list = new List <Fan>();
_list.AddRange(item.ToList());
_dict.Add(item.Key.Country + ", " + item.Key.City, _list);
}
var _json_arr = new JArray();
foreach (var fan in _fans)
{
var _obj = new JObject();
_obj.Add("FanName", fan.FirstName + " " + fan.LastName);
_obj.Add("PlaceId", fan.FanLocation.PlaceId);
_json_arr.Add(_obj);
}
var _tuple = new Tuple <string, Dictionary <string, List <Fan> > >(_json_arr.ToString(Newtonsoft.Json.Formatting.None),
_dict);
return(CheckLoggedIn("Fans/Map", _tuple));
//return View("Fans/Map", _tuple);
}
}
public ActionResult Filter(FilterParams FilterParams)
{
//filtering blog entrees by the field below:
using (var context = new ShauliBlogContext())
{
var _results = context.Posts.Select(a => a);
if (FilterParams.DateFrom != null)
{
_results = _results.Where(a => a.PostDate >= FilterParams.DateFrom && a.PostDate <= FilterParams.DateTo);
}
if (FilterParams.Author != null)
{
_results = _results.Where(a => a.Author.Contains(FilterParams.Author));
}
if (FilterParams.Content != null)
{
_results = _results.Where(a => a.PostContent.Contains(FilterParams.Content));
}
if (FilterParams.CommentContent != null)
{
_results = _results.Where(a => a.Comments
.Any(b => b.CommentContent.Contains(FilterParams.CommentContent)))
.Include(a => a.Comments);
}
return(View("Blog", _results.Include(a => a.Comments).ToList()));
}
}
public ActionResult AddNewPost(Post Post)
{
using (var context = new ShauliBlogContext())
{
context.Posts.Add(Post);
context.SaveChanges();
return(RedirectToAction("ManagePosts"));
}
}
public ActionResult Create(Fan Fan)
{
using (var context = new ShauliBlogContext())
{
context.Fans.Add(Fan);
context.SaveChanges();
return(RedirectToAction("ThankYou"));
}
}
//
// GET: /Blog/
public ActionResult Index()
{
using (var context = new ShauliBlogContext())
{
//including comments list (Join in sql) in the post object
var _posts = context.Posts.Include(a => a.Comments).ToList();
return(View("Blog", _posts.OrderByDescending(a => a.PostDate).ToList()));
}
}
public ActionResult EditPost(int Id)
{
using (var context = new ShauliBlogContext())
{
var _post = context.Posts.SingleOrDefault(a => a.PostId == Id);
return(CheckLoggedIn("Blog/Posts/EditPost", _post));
// return View("Blog/Posts/EditPost", _post);
}
}
public ActionResult ShowComments(int Id)
{
using (var context = new ShauliBlogContext())
{
var _post = context.Posts.Include(a => a.Comments).SingleOrDefault(a => a.PostId == Id);
return(CheckLoggedIn("Blog/Posts/DisplayComments", _post));
// return View("Blog/Posts/DisplayComments", _post);
}
}
public ActionResult Delete(int Id, Fan Fan)
{
using (var context = new ShauliBlogContext())
{
var _fan = context.Fans.Where(a => a.Id == Id).SingleOrDefault();
context.Fans.Remove(_fan);
context.SaveChanges();
return(RedirectToAction("FansList"));
}
}
public ActionResult AddNewComment(int Id, Comment Comment)
{
using (var context = new ShauliBlogContext())
{
var _post = context.Posts.Where(a => a.PostId == Id).SingleOrDefault();
// Comment.Post = _post;
_post.Comments.Add(Comment);
context.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult DeleteComment(int PostId, int CommentId)
{
using (var context = new ShauliBlogContext())
{
var _post = context.Posts.SingleOrDefault(a => (a.PostId == PostId));
var _comment = _post.Comments.SingleOrDefault(a => a.CommentId == CommentId);
_post.Comments.Remove(_comment);
context.SaveChanges();
return(RedirectToAction(String.Format("Blog/Posts/{0}/comments", PostId)));
}
}
public ActionResult ManagePosts()
{
using (var context = new ShauliBlogContext())
{
return(CheckLoggedIn("Blog/Posts", context.Posts.OrderByDescending(a => a.PostDate)
.Include(b => b.Comments)
.ToList()));
//return View("Blog/Posts", context.Posts.OrderByDescending(a => a.PostDate)
// .Include(b => b.Comments)
// .ToList());
}
}
public ActionResult Delete(int Id)
{
using (var context = new ShauliBlogContext())
{
var _fan = context.Fans.Where(a => a.Id == Id).SingleOrDefault();
if (_fan == null)
{
return(HttpNotFound("Id does not exist"));
}
return(CheckLoggedIn("Fans/DeleteFan", _fan));
// return View("Fans/DeleteFan", _fan);
}
}
public ActionResult Update(int Id, Fan Fan)
{
using (var context = new ShauliBlogContext())
{
var _fan = context.Fans.Where(a => a.Id == Id).SingleOrDefault();
_fan.FirstName = Fan.FirstName;
_fan.LastName = Fan.LastName;
_fan.Birthday = Fan.Birthday;
_fan.Gender = Fan.Gender;
_fan.YearsInClub = Fan.YearsInClub;
_fan.FanLocation = Fan.FanLocation;
context.SaveChanges();
return(RedirectToAction("FansList"));
}
}
public ActionResult DeletePost(int Id, Post Post)
{
using (var context = new ShauliBlogContext())
{
var _post = context.Posts.SingleOrDefault(a => a.PostId == Id);
//first remove comments of the selected post
_post.Comments.RemoveRange(0, _post.Comments.Count);
//then remove post it self
context.Posts.Remove(_post);
context.SaveChanges();
return(RedirectToAction("ManagePosts"));
}
}
public ActionResult EditPost(int Id, Post Post)
{
using (var context = new ShauliBlogContext())
{
var _post = context.Posts.SingleOrDefault(a => a.PostId == Id);
_post.ImageUrl = Post.ImageUrl;
_post.VideoUrl = Post.VideoUrl;
_post.Author = Post.Author;
_post.AuthorSiteAddress = Post.AuthorSiteAddress;
_post.PostContent = Post.PostContent;
_post.PostTitle = Post.PostTitle;
context.SaveChanges();
return(RedirectToAction("ManagePosts"));
}
}
public ActionResult FansList()
{
try
{
using (var context = new ShauliBlogContext())
{
List <Fan> _list = context.Fans.ToList();
return(CheckLoggedIn("Fans/FanList", _list));
// return View("Fans/FanList", _list);
}
}
catch (Exception e)
{
throw;
}
// return View("FanList", GenerateDummyFans());
}
