public void Update(Playlist item)
{
using (var db = new PlayerContext())
{
db.Entry(item).State = EntityState.Modified;
}
}
public void Update(User item)
{
try
{
using (var db = new PlayerContext())
{
db.Entry(item).State = EntityState.Modified;
db.SaveChanges();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public IEnumerable <Video> GetVideoByPlayList(int pageCount, int numberOfItems, int PlaylistID, out int count)
{
using (var db = new PlayerContext())
{
int skip = (pageCount - 1) * numberOfItems;
IEnumerable <Video> videos = null;
count = db.PlaylistVideos.AsNoTracking().Include(x => x.Video).Where(x => x.PlaylistId == PlaylistID).Count();
videos = db.PlaylistVideos.Where(x => x.PlaylistId == PlaylistID).OrderByDescending(x => x.Video.UploadDate)
.Skip(skip).Take(numberOfItems).Select(x => x.Video).ToList();
foreach (var item in videos)
{
db.Entry(item).Reference("User").Load();
}
return(videos);
}
}
public void Update(Mark item)
{
db.Entry(item).State = EntityState.Modified;
}
/// <summary>
/// Gets range of video start from (pageCount-1)*numberOfItems order by state, count Videos
/// </summary>
/// <param name="pageCount"></param>
/// <param name="numberOfItems"></param>
/// <param name="state"></param>
/// <param name="searchString"></param>
/// <param name="count"></param>
/// <returns></returns>
public IEnumerable <Video> GetVideoByRange(int pageCount, int numberOfItems, SortState state, string searchString, int UserId, out int count)
{
using (PlayerContext db = new PlayerContext())
{
int skip = (pageCount - 1) * numberOfItems;
IEnumerable <Video> videos = null;
count = db.WatchLaters.AsNoTracking().Include(x => x.Video).Where(x => x.Video.Name.Contains(searchString) && x.UserId == UserId).Count();
switch (state)
{
case SortState.New:
{
var temp = db.WatchLaters
.Where(x => x.Video.Name.Contains(searchString) && x.UserId == UserId)
.OrderByDescending(x => x.Video.UploadDate)
.Skip(skip).Take(numberOfItems).Select(x => x.Video).ToList();
foreach (var item in temp)
{
db.Entry(item).Reference("User").Load();
}
videos = temp;
break;
}
case SortState.Old:
{
var temp = db.WatchLaters
.Where(x => x.Video.Name.Contains(searchString) && x.UserId == UserId)
.OrderBy(x => x.Video.UploadDate)
.Skip(skip).Take(numberOfItems).Select(x => x.Video).ToList();
foreach (var item in temp)
{
db.Entry(item).Reference("User").Load();
}
videos = temp;
break;
}
case SortState.Long:
{
var temp = db.WatchLaters
.Where(x => x.Video.Name.Contains(searchString) && x.UserId == UserId)
.OrderByDescending(x => x.Video.MaxDuration)
.Skip(skip).Take(numberOfItems).Select(x => x.Video).ToList();
foreach (var item in temp)
{
db.Entry(item).Reference("User").Load();
}
videos = temp;
break;
}
case SortState.Short:
{
var temp = db.WatchLaters
.Where(x => x.Video.Name.Contains(searchString) && x.UserId == UserId)
.OrderBy(x => x.Video.MaxDuration)
.Skip(skip).Take(numberOfItems).Select(x => x.Video).ToList();
foreach (var item in temp)
{
db.Entry(item).Reference("User").Load();
}
videos = temp;
break;
}
}
return(videos);
}
}
