public IActionResult MvaVideo(int p = 1)
{
int pageSize = 12;
var videos = _context.MvaVideos
.Where(m => m.LanguageCode.Equals("zh-cn"))
.OrderByDescending(m => m.UpdatedTime)
.Skip((p - 1) * pageSize).Take(pageSize)
.ToList();
int totalNumber = _context.MvaVideos.Count();
ViewBag.ListData = videos;
var pageOption = new MyPagerOption()
{
CurrentPage = p,
PageSize = pageSize,
RouteUrl = "/Video/MvaVideo",
Total = totalNumber
};
ViewBag.Pager = pageOption;
return(View(videos));
}
/// <summary>
/// 设置分页
/// </summary>
/// <param name="p"></param>
/// <param name="pageSize"></param>
/// <param name="totalNumber"></param>
protected void SetPage(int p = 1, int pageSize = 12, int totalNumber = 0)
{
var pageOption = new MyPagerOption()
{
CurrentPage = p,
PageSize = pageSize,
RouteUrl = HttpContext.Request.Path,
Total = totalNumber
};
ViewBag.Pager = pageOption;
}
public IActionResult DevBlogs(int p = 1)
{
int pageSize = 15;
var blogs = _context.RssNews
.OrderByDescending(m => m.LastUpdateTime)
.Skip((p - 1) * pageSize).Take(pageSize)
.ToList();
int totalNumber = _context.RssNews.Count();
ViewBag.ListData = blogs;
var pageOption = new MyPagerOption()
{
CurrentPage = p,
PageSize = pageSize,
RouteUrl = "/News/DevBlogs",
Total = totalNumber
};
ViewBag.Pager = pageOption;
return(View());
}
public IActionResult BingNews(int p = 1)
{
int pageSize = 15;
var newsList = _context.BingNews
.OrderByDescending(m => m.CreatedTime)
.Skip((p - 1) * pageSize).Take(pageSize)
.ToList();
int totalNumber = _context.BingNews.Count();
ViewBag.ListData = newsList;
var pageOption = new MyPagerOption()
{
CurrentPage = p,
PageSize = pageSize,
RouteUrl = "/News/BingNews",
Total = totalNumber
};
ViewBag.Pager = pageOption;
return(View());
}
public async Task <IActionResult> Index(string tech, string type = "mva", int p = 1)
{
return(NotFound());
#region deprecated
int pageSize = 6;
int totalNumber = 1;
if (p < 1)
{
p = 1;
}
var mvaVideos = new List <MvaVideos>();
var c9Videos = new List <C9Videos>();
var language = TempData["language"] ?? "";
TempData.Keep();
//判断视频类型
if (type.Equals("mva"))
{
var query = _context.MvaVideos
.OrderByDescending(m => m.UpdatedTime)
.AsQueryable();
if (!string.IsNullOrEmpty(tech))
{
query = query.Where(m => m.Tags.Contains(tech.ToLower()) || m.Title.Contains(tech.ToLower()));
}
if (language.Equals("zh-cn"))
{
query = query.Where(m => m.LanguageCode.Equals("zh-cn"));
}
mvaVideos = query
.Skip((p - 1) * pageSize)
.Take(pageSize)
.ToList();
totalNumber = query
.Count();
}
else if (type.Equals("c9"))
{
var query = _context.C9videos
.OrderByDescending(m => m.UpdatedTime)
.AsQueryable();
if (!string.IsNullOrEmpty(tech))
{
query = query.Where(m => m.Tags.Contains(tech.ToLower()) || m.Title.Contains(tech.ToLower()));
}
if (language.Equals("zh-cn"))
{
query = query.Where(m => m.Language.Equals("zh-cn"));
}
c9Videos = query
.Skip((p - 1) * pageSize)
.Take(pageSize)
.ToList();
totalNumber = query
.Count();
}
var catalog = await _context.CataLog
.Where(m => m.Type == "视频" && m.IsTop == 1)
.Include(m => m.InverseTopCatalog)
.ToArrayAsync();
var pageOption = new MyPagerOption()
{
CurrentPage = p,
PageSize = pageSize,
RouteUrl = "/Video/Index" + "?tech=" + WebUtility.UrlEncode(tech) + "&type=" + WebUtility.UrlEncode(type),
Total = totalNumber
};
var videoList = new VideoViewModels
{
Catalog = catalog,
MvaVideos = mvaVideos,
C9Videos = c9Videos,
Pager = pageOption
};
return(View(videoList));
#endregion
}
public IActionResult Index(string topCatalogId = "", string navId = "", string eventId = "", int p = 1)
{
var language = TempData["language"]?.ToString() ?? "";
var configsString = TempData["configs"]?.ToString();
var configs = new List <Config>();
if (configsString == null)
{
configs = _context.Config.Where(m => m.Type.Equals("默认值"))
.ToList();
TempData["configs"] = JsonConvert.SerializeObject(configs);
}
else
{
configs = JsonConvert.DeserializeObject <List <Config> >(configsString);
}
TempData.Keep();
int pageSize = 12;
var pageOption = new MyPagerOption
{
CurrentPage = p,
PageSize = pageSize,
RouteUrl = Request.Path + $"?navId={navId}&topCatalogId={topCatalogId}&eventId={eventId}"
};
// 视频一级目录
var videoCatalogs = _context.CataLog.Where(m => m.Type.Equals("视频") && m.IsTop == 1).ToList();
//var articleCatalogs = _context.CataLog.Where(m => m.Type.Equals("文章") && m.IsTop == 1).ToList();
var topCatalog = new Catalog();
var secondaryNav = new List <Catalog>(); //左侧二级目录
//var blogList = new List<Blog>();
var videoList = new List <Video>();
var eventList = new List <C9Event>();//大会视频主题
//默认主页显示视频教程内容
if (String.IsNullOrWhiteSpace(topCatalogId))
{
topCatalog = _context.CataLog.Where(m => m.IsTop == 1 && m.Value.Equals("CourseVideo"))
.Include(m => m.InverseTopCatalog)
.First();
topCatalogId = topCatalog.Id.ToString();
secondaryNav = topCatalog
.InverseTopCatalog?
.ToList();
}
else
{
topCatalog = _context.CataLog.Where(m => m.Id == Guid.Parse(topCatalogId))
.Include(m => m.InverseTopCatalog)
.FirstOrDefault();
secondaryNav = topCatalog
.InverseTopCatalog?
.ToList();
}
//选择了一级目录，没有选择二级目录
if (string.IsNullOrEmpty(navId))
{
if (topCatalog.Value.Equals("CourseVideo"))
{
var value = configs.Where(m => m.Name.Equals("defaultVideoSeries")).First()?.Value;
navId = _context.CataLog.Where(m => m.Value.Equals(value))
.Where(m => m.Type.Equals("视频"))
.FirstOrDefault()?.Id.ToString();
}
else if (topCatalog.Value.Equals("ArticleCourse"))
{
var value = configs.Where(m => m.Name.Equals("defaultBlogSeries")).First()?.Value;
navId = _context.CataLog.Where(m => m.Value.Equals(value))
.Where(m => m.Type.Equals("文章"))
.FirstOrDefault()?.Id.ToString();
}
else
{
navId = secondaryNav.FirstOrDefault()?.Id.ToString();
}
}
//根据navId显示内容
var catalog = _context.CataLog.Where(m => m.Id.ToString().Equals(navId)).First();
if (catalog.Type.Equals("视频"))
{
string searchKey = ""; //搜索的关键词
string languageWhere = language + "%"; //语言条件
switch (catalog.TopCatalog.Value.ToLower())
{
case "event":
TempData["DetailPage"] = "EventDetail";
//大会类型
string catalogValue = catalog.Value.Replace("Event", "");
//查询大会目录
eventList = _context.C9Event
.Where(m => m.EventName.Equals(catalogValue))
.ToList();
//默认选择项
if (string.IsNullOrEmpty(eventId))
{
eventId = eventList.FirstOrDefault()?.Id.ToString();
}
videoList = _context.EventVideo
.Where(m => m.C9EventId.ToString().Equals(eventId))
.OrderByDescending(m => m.CreatedTime)
.Select(s =>
new Video
{
Id = s.Id,
Description = s.Description,
Author = s.Author,
CreatedTime = s.CreatedTime,
Duration = s.Duration,
IsRecommend = false,
Name = s.Title,
Tags = s.Tags,
ThumbnailUrl = s.ThumbnailUrl,
Url = s.SourceUrl,
Views = s.Views
})
.Skip((p - 1) * pageSize)
.Take(pageSize)
.ToList();
pageOption.Total = _context.EventVideo
.Where(m => m.C9EventId.ToString().Equals(eventId))
.Count();
break;
case "mva":
TempData["DetailPage"] = "MvaDetail";
searchKey = $"\"{catalog.Name}\"";
var mvaVideos = _context.MvaVideos
.FromSql($@"
SELECT * FROM MvaVideos WHERE contains(Title, {searchKey})
AND LanguageCode LIKE {languageWhere}
ORDER BY UpdatedTime DESC
OFFSET {(p - 1) * pageSize} ROWS FETCH NEXT {pageSize} ROWS ONLY
")
.ToList();
videoList = mvaVideos.Select(s =>
new Video
{
Id = s.Id,
Description = s.Description,
Author = s.Author,
CreatedTime = s.CreatedTime,
Duration = s.CourseDuration,
IsRecommend = false,
Name = s.Title,
Tags = s.Tags,
ThumbnailUrl = s.CourseImage,
Url = s.SourceUrl,
Views = s.Views
}).ToList();
pageOption.Total = _context.MvaVideos
.FromSql($@"
SELECT * FROM MvaVideos WHERE contains(Title, {searchKey})
AND LanguageCode LIKE {languageWhere}
")
.Count();
break;
case "c9":
TempData["DetailPage"] = "C9Detail";
searchKey = $"\"{catalog.Name}\"";
var c9videos = _context.C9videos
.FromSql($@"
SELECT * FROM C9Videos WHERE contains(Title, {searchKey})
AND Language LIKE {languageWhere}
ORDER BY UpdatedTime DESC
OFFSET {(p - 1) * pageSize} ROWS FETCH NEXT {pageSize} ROWS ONLY
")
.ToList();
videoList = c9videos
.Select(s => new Video
{
Id = s.Id,
Description = s.Description,
Author = s.Author,
CreatedTime = s.CreatedTime,
Duration = s.Duration,
IsRecommend = false,
Name = s.Title,
Tags = s.Tags,
ThumbnailUrl = s.ThumbnailUrl,
Url = s.SourceUrl,
Views = s.Views
}).ToList();
pageOption.Total = _context.C9videos
.FromSql($@"
SELECT * FROM C9Videos WHERE contains(Title, {searchKey})
AND Language LIKE {languageWhere}
")
.Count();
_logger.LogDebug(pageOption.Total.ToString());
break;
default:
TempData["DetailPage"] = "Detail";
videoList = _context.Video.Where(m => m.Catalog == catalog)
.Where(m => m.Status == StatusType.Publish)
.OrderByDescending(m => m.CreatedTime)
.Skip((p - 1) * pageSize)
.Take(pageSize)
.ToList();
pageOption.Total = _context.Video.Where(m => m.Catalog == catalog)
.Where(m => m.Status == StatusType.Publish)
.Count();
break;
}
}
//if (catalog.Type.Equals("文章"))
//{
// blogList = _context.Blog
// .Where(m => m.Catalog.Id.ToString().Equals(navId))
// .Where(m => m.Status.Equals(StatusType.Publish))
// .OrderByDescending(m => m.CreatedTime)
// .ToList();
// pageOption.Total = blogList
// .Where(m => m.Status.Equals(StatusType.Publish))
// .Count();
//}
ViewBag.NavId = navId.Trim();
return(View(new LearnViewModels
{
VideoCatalogs = videoCatalogs,
//ArticleCatalogs = articleCatalogs,
SecondaryNavs = secondaryNav,
//BlogList = blogList,
VideoList = videoList,
Pager = pageOption,
EventList = eventList
}));
}