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