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