public string GetList(GetListPostRequest req) { VideoAppPOCEntities2 db = new VideoAppPOCEntities2(); VideoModel vd = new VideoModel(); var reqUserId = Convert.ToInt32(req.UserId); var data = db.AppVideos.ToList(); var checkedData = (from r in db.AppVideoUsers where r.UserID == reqUserId select r).ToList(); vd.videos = data; var jsonObject = new List <GetListPostResult>(); foreach (var item in vd.videos) { foreach (var checkItem in checkedData) { if (item.VideoID == checkItem.VideoID) { item.isChecked = true; } } jsonObject.Add(new GetListPostResult { VideoId = item.VideoID, IsChecked = item.isChecked }); } System.Web.Script.Serialization.JavaScriptSerializer oSerializer = new System.Web.Script.Serialization.JavaScriptSerializer(); string sJSON = oSerializer.Serialize(jsonObject); return(sJSON); }
public ActionResult upload(AppVideo videoModel) { ViewBag.Message = "this page is for uploading"; string fileName = Path.GetFileNameWithoutExtension(videoModel.VideoFile.FileName); string extension = Path.GetExtension(videoModel.VideoFile.FileName); fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension; videoModel.VideoPath = "~/Video/" + fileName; fileName = Path.Combine(Server.MapPath("~/Video/"), fileName); videoModel.VideoFile.SaveAs(fileName); using (VideoAppPOCEntities2 db = new VideoAppPOCEntities2()) { db.AppVideos.Add(videoModel); try { db.SaveChanges(); } catch (DbUpdateException e) { Console.WriteLine(e); } } ModelState.Clear(); return(RedirectToAction("LandPage")); }
public ActionResult savevideo(int id, string propertyName, string value) { var status = false; var message = ""; //update data to database using (VideoAppPOCEntities2 dc = new VideoAppPOCEntities2()) { var user = dc.AppVideos.Find(id); if (user != null) { dc.Entry(user).Property(propertyName).CurrentValue = value;//MAKE CHANGE FOR THE AppVideos to AppUsers dc.SaveChanges(); status = true; } else { message = "error!"; } } var response = new { value = value, status = status, message = message }; JObject o = JObject.FromObject(response); return(Content(o.ToString())); }
//[ValidateAntiForgeryToken] public ActionResult AssignOnUser(VideoModel vm) { VideoAppPOCEntities2 db = new VideoAppPOCEntities2(); if (ModelState.IsValid) { db.AppVideoUsers.RemoveRange(db.AppVideoUsers.Where(x => x.UserID == vm.UserID)); db.SaveChanges(); foreach (var videoID in vm.videos.Where(x => x.isChecked).Select(x => x.VideoID)) { var appVideoUser = new AppVideoUser { UserID = vm.UserID, VideoID = videoID }; db.AppVideoUsers.Add(appVideoUser); } db.SaveChanges(); TempData["redirectedUserId"] = vm.UserID; return(RedirectToAction("AssignOnUser")); } return(View(vm)); }
public string GetUserListByVideoId(GetListVideosPostRequest req) { VideoAppPOCEntities2 db = new VideoAppPOCEntities2(); UserModel ud = new UserModel(); var reqVideoId = Convert.ToInt32(req.VideoId); var data = db.AppUsers.ToList(); var checkedData = (from r in db.AppVideoUsers where r.VideoID == reqVideoId select r).ToList(); ud.users = data.Where(user => user.RoleID == 2).ToList(); var jsonObject = new List <GetListVideosPostResult>(); foreach (var item in ud.users) { foreach (var checkItem in checkedData) { if (item.UserID == checkItem.UserID) { item.ischecked = true; } } jsonObject.Add(new GetListVideosPostResult { UserId = item.UserID, IsChecked = item.ischecked }); } System.Web.Script.Serialization.JavaScriptSerializer oSerializer = new System.Web.Script.Serialization.JavaScriptSerializer(); string sJSON = oSerializer.Serialize(jsonObject); return(sJSON); }
//[HttpGet] public ActionResult AssignOnUser() { List <dropDownView> getDoctorName = new List <dropDownView>(); VideoAppPOCEntities2 db = new VideoAppPOCEntities2(); VideoModel vd = new VideoModel(); var model = (from r in db.AppUsers where r.RoleID == 2 select new dropDownView { UserId = r.UserID, userName = r.userName, RoleId = r.RoleID }); getDoctorName = model.ToList(); var selectedUserId = 0; if (TempData["redirectedUserId"] != null && TempData["redirectedUserId"].ToString() != "") { selectedUserId = Convert.ToInt32(TempData["redirectedUserId"]); vd.UserID = Convert.ToInt32(TempData["redirectedUserId"]); } else { selectedUserId = getDoctorName[0].UserId; vd.UserID = getDoctorName[0].UserId; } var data = db.AppVideos.ToList(); var checkedData = (from r in db.AppVideoUsers where r.UserID == selectedUserId select r).ToList(); vd.videos = data; foreach (var item in vd.videos) { foreach (var checkItem in checkedData) { if (item.VideoID == checkItem.VideoID) { item.isChecked = true; } } } SelectList list = new SelectList(getDoctorName, "UserID", "userName"); ViewBag.getDoctor = list; return(View(vd)); }
public ActionResult ViewVideo(int id) { AppVideo videoModel = new AppVideo(); using (VideoAppPOCEntities2 db = new VideoAppPOCEntities2()) { videoModel = db.AppVideos.Where(x => x.VideoID == id).FirstOrDefault(); } return(View(videoModel)); }
public ActionResult upload() { VideoAppPOCEntities2 db = new VideoAppPOCEntities2(); var getDoctorName = db.AppUsers.ToList(); SelectList list = new SelectList(getDoctorName, "UserID", "userName"); ViewBag.getDoctor = list; return(View()); }
public ActionResult LandPage() { List <table> list = new List <table>(); using (VideoAppPOCEntities2 dc = new VideoAppPOCEntities2()) { if (User.Identity.IsAuthenticated) { if (User.IsInRole("adminstrator")) { var a = (from all in dc.AppVideos select new table { videoID = all.VideoID, title = all.VideoTitle, subject = all.VideoSubject, du = all.uploadDate ?? DateTime.Now }); list = a.ToList(); } else { var f = Convert.ToInt32(Session["ID"]); var v = (from a in dc.AppVideoUsers where a.UserID == f join b in dc.AppVideos on a.VideoID equals b.VideoID select new table { videoID = a.VideoID, userID = a.UserID, title = b.VideoTitle, subject = b.VideoSubject, du = b.uploadDate ?? DateTime.Now }); list = v.ToList(); } } } return(View(list)); }
public ActionResult AssignOnVideo(UserModel um) { VideoAppPOCEntities2 db = new VideoAppPOCEntities2(); if (ModelState.IsValid) { db.AppVideoUsers.RemoveRange(db.AppVideoUsers.Where(x => x.VideoID == um.VideoID)); db.SaveChanges(); foreach (var userID in um.users.Where(x => x.ischecked).Select(x => x.UserID)) { var appVideoUser = new AppVideoUser { UserID = userID, VideoID = um.VideoID }; db.AppVideoUsers.Add(appVideoUser); } db.SaveChanges(); TempData["redirectedVideoId"] = um.VideoID; return(RedirectToAction("AssignOnVideo")); } return(View(um)); }
public ActionResult AssignOnVideo() { VideoAppPOCEntities2 db = new VideoAppPOCEntities2(); UserModel ud = new UserModel(); var model = (from r in db.AppUsers where r.RoleID == 2 select new CheckBoxView { UserId = r.UserID, userName = r.userName, RoleId = r.RoleID, //VideoID = a.VideoID }); var data = model.ToList(); CheckBoxView cbv = new CheckBoxView(); cbv.users = data; var usersData = db.AppUsers.ToList(); var getVideoName = db.AppVideos.ToList(); if (getVideoName == null) { TempData["msg"] = "no video can be assign"; } else { try { var selectedVideoId = 0; if (TempData["redirectedVideoId"] != null && TempData["redirectedVideoId"].ToString() != "") { selectedVideoId = Convert.ToInt32(TempData["redirectedVideoId"]); ViewBag.curretSelectedVideoId = selectedVideoId; ud.VideoID = Convert.ToInt32(TempData["redirectedVideoId"]); } else { selectedVideoId = getVideoName[0].VideoID; ud.VideoID = getVideoName[0].VideoID; } var checkedData = (from r in db.AppVideoUsers where r.VideoID == selectedVideoId select r).ToList(); ud.users = usersData; foreach (var item in cbv.users) { foreach (var checkItem in checkedData) { if (item.UserId == checkItem.UserID) { item.isChecked = true; } } } } catch (ArgumentOutOfRangeException e) { Console.WriteLine(e); } } SelectList list = new SelectList(getVideoName, "VideoID", "VideoTitle"); ViewBag.getVideo = list; return(View(cbv)); }