//[HttpPost]
public ActionResult PostComment(int id, string id2)
{
if (Session["userId"] == null)
{
throw new Exception("uiuiui");
}
//return new ContentResult() { Content = "Not Logged in" };
string usernameString = Session["userId"].ToString();
//String text = comment.comment;
int discriminator = int.Parse(usernameString.Split('-')[0]);
string username = usernameString.Split('-')[1];
//int id = comment.video;
CommentBll commentBll = new CommentBll();
int CommentId = commentBll.CreateComment(id, usernameString, id2);
List <MVCPAP.Models.Comment> comments = commentBll.GetCommentsByVideoId(id);
VideoBll videoBll = new VideoBll();
//return View("Video", videoBll.GetVideoDataById(id));
return(new ContentResult()
{
Content = CommentId.ToString()
});
}
public ActionResult VideoPage(int id)
{
VideoBll videoBll = new VideoBll();
Models.Video video = videoBll.GetVideoById(id);
ViewBag.title = video.title;
return(View(video));
}
public ActionResult Video(int id)
{
ViewBag.id = id;
VideoBll videoBll = new VideoBll();
Models.VideoData video = videoBll.GetVideoDataById(id);
if (id == null || id < 0 || video is null)
{
return(RedirectToAction("NotFound", "Home", new { message = "Could not find that video" }));
}
ViewBag.loggedin = 0;
string usernameString = "0000-user";
if (Session["userId"] != null)
{
usernameString = Session["userId"].ToString();
ViewBag.loggedin = 1;
}
int discriminator = int.Parse(usernameString.Split('-')[0]);
string username = usernameString.Split('-')[1];
if (video.upvotes.Where(x => x.username == username && x.discriminator == discriminator).Count() >= 1)
{
video.Upvoted = true;
ViewBag.upvoted = 1;
}
else
{
video.Upvoted = false;
ViewBag.upvoted = 0;
}
//CommentBll commentBll = new CommentBll();
//List<Models.Comment> comments = commentBll.GetCommentsByVideoId(int.Parse(id));
//ViewBag.Comments = commentBll.GetCommentsByVideoId(int.Parse(id));
//Models.VideoComments videoComments = new Models.VideoComments();
//videoComments.video = video;
//videoComments.comments = comments;
return(View(video));
}
// GET: Account
public ActionResult Index()
{
if (Session["userId"] is null)
{
return(RedirectToAction("NotFound", "Home", new { id = "User not logged in" }));
}
UserBll userBll = new UserBll();
MVCPAP.Models.User user = userBll.GetUserById(Session["userId"].ToString());
VideoBll videoBll = new VideoBll();
ViewBag.videos = videoBll.GetVideosByUserId(Session["userId"].ToString());
return(View(user));
}
public ActionResult SearchPage(string id)
{
if (Request.QueryString.Get("page") != null)
{
ViewBag.page = int.Parse(Request.QueryString.Get("page"));
}
ViewBag.Search = id;
ViewBag.title = "Search Result";
VideoBll videoBll = new VideoBll();
//ViewBag.Videos = videoBll.GetVideosSearchByTitle(id);
if (id == null)
{
return(RedirectToAction("NotFound", "Home", new { message = "Search query not specified - Invalid URL" }));
}
return(View(videoBll.GetVideosSearchByTitle(id.ToLower())));
}
public ActionResult Index()
{
VideoBll videoBll = new VideoBll();
List <Models.Video> videos = new List <Models.Video>();
if (Session["userId"] != null)
{
string usernameString = Session["userId"].ToString();
User user = new User();
user.username = usernameString.Split('-')[1];
user.discriminator = int.Parse(usernameString.Split('-')[0]);
videos = videoBll.GetRecomendedVideos(user);
}
return(View(videos));
}
public ActionResult Search(FormCollection collection, string id)
{
if (Request.QueryString.Get("page") != null)
{
ViewBag.page = int.Parse(Request.QueryString.Get("page"));
}
ViewBag.Title = "Search for " + id;
ViewBag.Search = id;
id = id.ToLower();
// SqlConnection connection = new SqlConnection(@"Data Source=.\SQLEXPRESS;Initial Catalog=PAP1;Integrated Security=True");
// SqlDataAdapter dataAdapter = new SqlDataAdapter(
//"SELECT * FROM Video Where lower(title) Like '%" + id + "%'"
//+ "Order By (Case When lower(title)='" + id + "' Then 1 When lower(title)='" + id + "%' Then 2 Else 3 End)"
//, connection);
// DataSet dataSet = new DataSet();
// dataAdapter.Fill(dataSet);
// List<_Video> Videos = new List<_Video>();
// foreach (DataRow row in dataSet.Tables[0].Rows)
// {
// _Video V = new _Video();
// V.id = int.Parse(row["id"].ToString());
// V.title = row["title"].ToString();
// V.username = row["username"].ToString();
// V.discriminator = int.Parse(row["discriminator"].ToString());
// V.videoFile = row["videoFile"].ToString();
// V.thumbnail = row["thumbnail"].ToString();
// Videos.Add(V);
// }
VideoBll videoBll = new VideoBll();
ViewBag.Videos = videoBll.GetVideosSearchByTitle(id);
return(View());
}
public ActionResult DownvoteVideo(int id)
{
if (Session["userId"] is null)
{
return(new ContentResult()
{
Content = "Not logged in"
});
}
Models.User user = new Models.User();
string usernameString = Session["userId"].ToString();
user.discriminator = int.Parse(usernameString.Split('-')[0]);
user.username = usernameString.Split('-')[1];
Models.Video video = new Models.Video();
video.id = id;
VideoBll videoBll = new VideoBll();
if (videoBll.GetVideoUpvotesByVideoId(id).Where(x => x.username == user.username && x.discriminator == user.discriminator).Count() >= 1)
{
videoBll.DeleteVideoUpvote(user, video);
}
else
{
return new ContentResult()
{
Content = "false"
}
};
return(new ContentResult()
{
Content = "true"
});
}
public ActionResult PostVideo(HttpPostedFileBase file, Models.Video video, string tags)
{
Models.User user = new Models.User();
user.username = Session["userId"].ToString().Split('-')[1];
user.discriminator = int.Parse(Session["userId"].ToString().Split('-')[0]);
foreach (string tagtext in tags.Split(' ').ToList())
{
Models.Tag tag = new Tag();
tag.text = tagtext;
video.tags.Add(tag);
}
//video.title = Request.QueryString.Get("title");
//video.description = Request.QueryString.Get("description");
video.thumbnail = "defaultthumbnail.png";
if (file != null && file.ContentLength > 0)
{
try
{
string path = Path.Combine(Server.MapPath("../videos"),
Path.GetFileName(file.FileName));
file.SaveAs(path);
ViewBag.Message = "File uploaded successfully";
video.videoFile = file.FileName;
}
catch (Exception ex)
{
ViewBag.Message = "ERROR:" + ex.Message.ToString();
video.VideoUploadError = "ERROR:" + ex.Message.ToString();
return(new ContentResult()
{
Content = "ERROR:" + ex.Message.ToString()
});
}
}
else
{
ViewBag.Message = "You have not specified a file.";
video.VideoUploadError = "You have not specified a file.";
return(new ContentResult()
{
Content = "You have not specified a file."
});
}
VideoBll videoBll = new VideoBll();
video = videoBll.CreateVideo(user, video);
return(RedirectToAction("VideoPage", "Home", new { id = video.id }));
return(new ContentResult()
{
Content = "Video posted"
});
}
public ActionResult profile(string id)
{
if (!id.Contains("-"))
{
Response.Redirect("PageNotFound...");
}
int discriminator = int.Parse(id.Split('-')[0]);
string username = id.Split('-')[1];
// SqlConnection connection = new SqlConnection(@"Data Source=.\SQLEXPRESS;Initial Catalog=PAP1;Integrated Security=True");
// SqlDataAdapter dataAdapter = new SqlDataAdapter(
//"SELECT * FROM [User] Where username='******' And discriminator=" + discriminator, connection);
// DataSet dataSet = new DataSet();
// dataAdapter.Fill(dataSet);
// if(dataSet.Tables[0].Rows.Count<=0)
// {
// throw new Exception("User not found");
// }
// _User user = new _User();
// user.email = dataSet.Tables[0].Rows[0]["email"].ToString();
// user.username = username;
// user.discriminator = discriminator;
// user.profilePicture = dataSet.Tables[0].Rows[0]["profilePicture"].ToString();
// user.password = dataSet.Tables[0].Rows[0]["password"].ToString();
UserBll userBll = new UserBll();
try
{
ViewBag.user = userBll.GetUserById(id);
}
catch (Exception ex)
{
return(RedirectToAction("NotFound", "Home", new { message = ex.Message }));
}
// SqlDataAdapter dataAdapter2 = new SqlDataAdapter(
//"SELECT * FROM Video Where username='******' And discriminator='" + discriminator + "'", connection);
// DataSet dataSet2 = new DataSet();
// dataAdapter2.Fill(dataSet2);
// List<_Video> Videos = new List<_Video>();
// foreach (DataRow row in dataSet2.Tables[0].Rows)
// {
// _Video V = new _Video();
// V.id = int.Parse(row["id"].ToString());
// V.title = row["title"].ToString();
// V.username = row["username"].ToString();
// V.discriminator = int.Parse(row["discriminator"].ToString());
// V.videoFile = row["videoFile"].ToString();
// V.thumbnail = row["thumbnail"].ToString();
// Videos.Add(V);
// }
VideoBll videoBll = new VideoBll();
ViewBag.Videos = videoBll.GetVideosByUserId(id);
return(View());
}
