public ActionResult Comment(int Commentpost, int CommentUser, string description)
{
using (db = new GerardJennyEntities())
{
PostComment comment = new PostComment();
comment.Description = description;
comment.PostId = Convert.ToInt32(Commentpost);
comment.UserId = Convert.ToInt32(CommentUser);
db.PostComments.Add(comment);
db.SaveChanges();
var num = from p in db.Posts
join u in db.Users
on p.UserID equals u.ID into bases
from sb in bases.DefaultIfEmpty()
orderby p.PostID descending
select new PostUser
{
PostID = p.PostID,
PostedOn = p.PostedOn,
Likes = p.Likes,
Dislikes = p.Dislikes,
Photo = p.Photo,
video = p.video,
Description = p.Description,
UserID = p.UserID,
ID = sb.ID,
Name = sb.Name,
ProfilePicture = sb.ProfilePicture,
};
return(Json(num.ToList(), JsonRequestBehavior.AllowGet));
}
}
public ActionResult Index()
{
if (Session["Login"] != null)
{
using (db = new GerardJennyEntities())
{
var num = from p in db.Posts
join u in db.Users
on p.UserID equals u.ID into bases
from sb in bases.DefaultIfEmpty()
orderby p.PostID descending
select new PostUser
{
PostID = p.PostID,
PostedOn = p.PostedOn,
Likes = p.Likes,
Dislikes = p.Dislikes,
Photo = p.Photo,
video = p.video,
Description = p.Description,
UserID = p.UserID,
ID = sb.ID,
Name = sb.Name,
ProfilePicture = sb.ProfilePicture,
};
return(View(num.ToList()));
}
}
return(RedirectToAction("Index", "User"));
}
public ActionResult Introduction(FormCollection form)
{
int UserId = Convert.ToInt32(Session["Login"]);
using (db = new GerardJennyEntities())
{
Writing write = new Writing();
write.Description = form["texts"];
write.UserId = UserId;
db.Writings.Add(write);
db.SaveChanges();
var num = from w in db.Writings
join u in db.Users
on w.UserId equals u.ID into bases
from sb in bases.DefaultIfEmpty()
orderby w.ContentID descending
select new ContentUser
{
ContentID = w.ContentID,
Description = w.Description,
UserId = w.UserId,
ID = sb.ID,
Name = sb.Name,
ProfilePicture = sb.ProfilePicture,
};
return(View(num.ToList()));
}
}
public ActionResult Introduction()
{
if (Session["Login"] != null)
{
using (db = new GerardJennyEntities())
{
var num = from w in db.Writings
join u in db.Users
on w.UserId equals u.ID into bases
from sb in bases.DefaultIfEmpty()
orderby w.ContentID descending
select new ContentUser
{
ContentID = w.ContentID,
Description = w.Description,
UserId = w.UserId,
ID = sb.ID,
Name = sb.Name,
ProfilePicture = sb.ProfilePicture,
};
return(View(num.ToList()));
}
}
return(RedirectToAction("Index", "User"));
}
public ActionResult RecentPosts(int id)
{
IEnumerable <Post> post;
using (db = new GerardJennyEntities())
{
post = (from Post in db.Posts where Post.UserID == id orderby Post.PostID descending select Post).ToList();
}
return(View("_RecentAds", post));
}
public ActionResult DisLikes(int post, int user)
{
bool query;
int UserId = Convert.ToInt32(Session["Login"]);
using (db = new GerardJennyEntities())
{
query = (from PostDislike in db.PostDislikes where PostDislike.PostId == post && PostDislike.UserId == user select PostDislike).Any();
if (query == false)
{
PostDislike postdislike = new PostDislike();
postdislike.PostId = post;
postdislike.UserId = user;
db.PostDislikes.Add(postdislike);
db.SaveChanges();
UpdateDisLikes(post);
}
else
{
ViewData["Exists"] = "You Already liked this post!";
}
var num = from p in db.Posts
join u in db.Users
on p.UserID equals u.ID into bases
from sb in bases.DefaultIfEmpty()
where p.UserID == UserId
orderby p.PostID descending
select new PostUser
{
PostID = p.PostID,
PostedOn = p.PostedOn,
Likes = p.Likes,
Dislikes = p.Dislikes,
Photo = p.Photo,
Description = p.Description,
UserID = p.UserID,
ID = sb.ID,
Name = sb.Name,
ProfilePicture = sb.ProfilePicture,
video = p.video,
};
return(Json(num.ToList(), JsonRequestBehavior.AllowGet));
}
}
public ActionResult DisplayComment(int id)
{
using (db = new GerardJennyEntities())
{
var postComment = from c in db.PostComments
join u in db.Users
on c.UserId equals u.ID into bases
from sb in bases.DefaultIfEmpty()
where c.PostId == id
select new CommentUser
{
CommentID = c.ID,
Description = c.Description,
PostId = c.PostId,
UserId = c.UserId,
ID = sb.ID,
Name = sb.Name,
};
return(PartialView("_Comment", postComment.ToList()));
}
}
public ActionResult Index(FormCollection form)
{
using (db = new GerardJennyEntities())
{
User user = new User();
var Username = form["username"];
var Password = form["password"];
var queryId = (from User in db.Users where User.Email == Username && User.Password == Password select User.ID).FirstOrDefault();
var queryName = (from User in db.Users where User.Email == Username && User.Password == Password select User.Name).FirstOrDefault();
var queryImage = (from User in db.Users where User.Email == Username && User.Password == Password select User.ProfilePicture).FirstOrDefault();
if (queryId != 0)
{
Session["Login"] = queryId;
Session["Name"] = queryName;
Session["ProfileImage"] = queryImage;
return(RedirectToAction("Index", "Home"));
}
else
{
ViewData["LoginError"] = "Username or Password is incorrect!";
}
}
return(View());
}
public ActionResult Index(FormCollection form, HttpPostedFileBase videos)
{
Post timeline = new Post();
string fileName = "";
int UserId = Convert.ToInt32(Session["Login"]);
using (db = new GerardJennyEntities())
{
try
{
for (int i = 0; i < Request.Files.Count; i++)
{
var file = Request.Files[i];
if (file != null && file.ContentLength > 0)
{
fileName = Path.GetFileName(file.FileName);
var path = Path.Combine(Server.MapPath("/Uploads/Images/"), fileName);
timeline.Photo = timeline.Photo + fileName;
if (i == Request.Files.Count - 2)
{
file.SaveAs(path);
break;
}
else
{
timeline.Photo += ",";
}
file.SaveAs(path);
}
}
if (videos != null && videos.ContentLength > 0)
{
var vidName = Path.GetFileName(videos.FileName);
var path = Path.Combine(Server.MapPath("/Uploads/Videos/"), vidName);
videos.SaveAs(path);
if (timeline.Photo == vidName + ",")
{
timeline.Photo = null;
}
timeline.video = vidName;
}
if (ModelState.IsValid)
{
timeline.Description = form["texts"];
timeline.PostedOn = DateTime.Now;
timeline.UserID = UserId;
db.Posts.Add(timeline);
db.SaveChanges();
}
}
catch
{
ViewData["ERROR"] = "Something went wrong!";
}
var num = from p in db.Posts
join u in db.Users
on p.UserID equals u.ID into bases
from sb in bases.DefaultIfEmpty()
orderby p.PostID descending
select new PostUser
{
PostID = p.PostID,
PostedOn = p.PostedOn,
Likes = p.Likes,
Dislikes = p.Dislikes,
Photo = p.Photo,
video = p.video,
Description = p.Description,
UserID = p.UserID,
ID = sb.ID,
Name = sb.Name,
ProfilePicture = sb.ProfilePicture,
};
return(View(num.ToList()));
}
}
