public Videos GetVideoQuestaoSimulado(int QuestaoID, int idAplicacao = 0, string versaoApp = "") { string versao = versaoApp != "" ? versaoApp : ConfigurationProvider.Get("Settings:ChaveamentoVersaoMinimaMsPro"); using (var ctx = new AcademicoContext()) { var lst = new Videos(); var consulta = (from v in ctx.tblVideo join qv in ctx.tblVideo_Questao_Simulado on v.intVideoID equals qv.intVideoID where qv.intQuestaoID == QuestaoID select new { v.intVideoID, v.txtFileName, v.txtPath, v.guidVideoID, v.txtVideoInfo }).FirstOrDefault(); if (consulta != null) { VideoBusiness videoBusiness = new VideoBusiness(new VideoEntity()); var url = GetUrlVideoPorVideoID(consulta.intVideoID, new ChaveamentoVimeoSimulado(), idAplicacao, versao); lst.Add(new Video { ID = consulta.intVideoID, Url = url, Thumb = videoBusiness.ObterURLThumb(consulta.intVideoID, ""), Nome = consulta.txtFileName.Replace(".xml", "").Trim(), Links = GetLinksVideoVariasQualidades(consulta.txtVideoInfo, url) }); } else { lst.Add(new Video { Url = "http://iosstream.s3.amazonaws.com/videosemcomentario.mp4", Nome = string.Empty }); } return(lst); } }
public List <Video> GetVideoQuestaoConcurso(int idQuestao, int idAplicacao = 5, string appVersion = "") { using (var ctx = new AcademicoContext()) { using (var ctxMatDir = new DesenvContext()) { var lst = new Videos(); int VideoId = (from qv in ctxMatDir.tblVideo_Questao_Concurso where qv.intQuestaoID == idQuestao select qv.intVideoID).FirstOrDefault(); var consulta = (from v in ctx.tblVideo where v.intVideoID == VideoId select v).FirstOrDefault(); if (consulta != null) { //TODO: Refatorar para a classe de business VideoBusiness videoBusiness = new VideoBusiness(this); string url = videoBusiness.ObterUrlVideo(idAplicacao, consulta, new ChaveamentoQuestaoConcurso(), appVersion); lst.Add(new Video { ID = consulta.intVideoID, Url = url, Thumb = !string.IsNullOrEmpty(consulta.txtUrlThumbVimeo) ? consulta.txtUrlThumbVimeo : videoBusiness.ObterURLThumb(consulta.intVideoID, consulta.txtUrlThumbVimeo), Nome = consulta.txtName.Trim(), ExisteAmazon = videoBusiness.UrlVideoValida(url), Links = GetLinksVideoVariasQualidades(consulta.txtVideoInfo, url) });; } else { lst.Add(new Video { Url = "http://iosstream.s3.amazonaws.com/videosemcomentario.mp4", Nome = string.Empty }); } return(lst); } } }