// [CustomAuthorization_Admin(LoginPage = "/admin/signin")] public ActionResult Index() { Model_video_page mdlvideo = new Model_video_page(); mdlvideo.tbcomment = db.tbl_comments.ToList(); return(View(mdlvideo)); }
public ActionResult Test(Model_video_page obj) { tbl_comment tbl = new tbl_comment(); tbl.login_id = SessionData.UserId; tbl.video_id = obj.mdcomment.video_id; tbl.comment_des = obj.mdcomment.comment_des; tbl.comment_date = DateTime.Today; db.tbl_comments.InsertOnSubmit(tbl); db.SubmitChanges(); return(RedirectToAction("Test")); }
public ActionResult Test(Int16 id) { tbl_view tbl = new tbl_view(); tbl.view_date = DateTime.Now; tbl.video_id = id; tbl.login_id = SessionData.UserId; db.tbl_views.InsertOnSubmit(tbl); db.SubmitChanges(); Model_video mdvideo = db.tbl_videos.Where(x => x.video_id == id).Select(x => new Model_video() { video_id = x.video_id, login_id = x.login_id, video_name = x.video_name, video_des = x.video_des, video_path = x.video_path, video_thumb = x.video_thumb, video_date = x.video_date }).SingleOrDefault(); ViewBag.totalview = db.tbl_views.Where(x => x.video_id == id).Count(); ViewBag.videodate = mdvideo.video_date.ToShortDateString(); List <Model_video> mv = new List <Model_video>(); var query = (from v in db.tbl_videos join a in db.tbl_views on v.video_id equals a.video_id into a_join from a in a_join.DefaultIfEmpty() group new { v, a } by new { v.video_name, v.video_thumb, v.video_date, v.video_id } into g orderby g.Count(p => p.a.video_id != null) descending select new { TotalView = g.Count(p => p.a.video_id != null), g.Key.video_id, g.Key.video_name, g.Key.video_thumb, g.Key.video_date }).Take(4); foreach (var data in query) { Model_video obj = new Model_video(); obj.totalview = data.TotalView; obj.video_name = data.video_name; obj.video_id = data.video_id; obj.video_thumb = data.video_thumb; obj.login_id = (DateTime.Today - data.video_date).Days; mv.Add(obj); } Model_comment md = new Model_comment(); md.login_id = SessionData.UserId; md.video_id = id; Model_video_page mdlvideo = new Model_video_page(); mdlvideo.lsvideo = mv; mdlvideo.tbcomment = db.tbl_comments.Where(x => x.video_id == id).ToList(); mdlvideo.mdvideo = mdvideo; mdlvideo.mdcomment = md; return(View(mdlvideo)); }