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