public bool SalvaVideoNelDatabase(string Filename, string ConnectedUser)
{
VideoDS ds = new VideoDS();
using (VideoBusiness bVideo = new VideoBusiness())
{
try
{
bVideo.FillRW_VIDEO(ds);
if (ds.RW_VIDEO.Where(x => x.NOMEVIDEO == Filename && x.PATHVIDEO == @"~\Video").Count() == 0)
{
VideoDS.RW_VIDEORow VideoB = ds.RW_VIDEO.NewRW_VIDEORow();
VideoB.NOMEVIDEO = Filename;
VideoB.PATHVIDEO = @"~\Video";
VideoB.UTENTE = ConnectedUser;
VideoB.DATAINSERIMENTO = DateTime.Now;
ds.RW_VIDEO.AddRW_VIDEORow(VideoB);
bVideo.UpdateVideoDS(ds.RW_VIDEO.TableName, ds);
}
return(true);
}
catch //(Exception ex)
{
bVideo.Rollback();
throw;
}
}
}
public List <VideoRepartoModel> CreaListaVideoRepartoModel()
{
VideoDS ds = new VideoDS();
List <VideoRepartoModel> model = new List <VideoRepartoModel>();
using (VideoBusiness bVideo = new VideoBusiness())
{
bVideo.FillRW_VIDEO_REPARTI(ds);
bVideo.FillRW_VIDEO(ds);
List <RWListItem> Reparti_List = Reparti.CreaListaReparti();
var VideoRepartoAbilitati = ds.RW_VIDEO_REPARTI.Where(x => x.DATAFINE >= System.DateTime.Today && x.DATAINIZIO <= System.DateTime.Today).ToList();
foreach (var item in VideoRepartoAbilitati.OrderBy(x => x.DATAINIZIO))
{
string NomeVideo = ds.RW_VIDEO.Where(x => x.IDVIDEO == item.IDVIDEO).Select(x => x.NOMEVIDEO).FirstOrDefault();
string NomeReparto = Reparti_List.Where(x => x.Value.Trim() == item.REPARTO).Select(x => x.Text).FirstOrDefault();
VideoRepartoModel vrm = new VideoRepartoModel();
vrm.Video = NomeVideo;
vrm.Reparto = NomeReparto;
vrm.IDVIDEOREPARTO = item.IDVIDEOREPARTO;
vrm.DataInizio = item.DATAINIZIO;
vrm.DataFine = item.DATAFINE;
model.Add(vrm);
}
}
return(model);
}
public string LeggiVideo(string reparto)
{
string Path = string.Empty;
using (VideoBusiness bVideo = new VideoBusiness())
{
VideoDS ds = new VideoDS();
bVideo.FillRW_VIDEO(ds);
bVideo.FillRW_VIDEO_REPARTI(ds);
//VideoDS.RW_VIDEO_REPARTIRow VideoR = ds.RW_VIDEO_REPARTI.NewRW_VIDEO_REPARTIRow();
VideoDS.RW_VIDEO_REPARTIRow VideoR = ds.RW_VIDEO_REPARTI.Where(x => x.REPARTO == reparto &&
x.DATAINIZIO <= System.DateTime.Today &&
x.DATAFINE >= System.DateTime.Today).FirstOrDefault();
if (VideoR != null)
{
//VideoDS.RW_VIDEORow Video = ds.RW_VIDEO.NewRW_VIDEORow();
VideoDS.RW_VIDEORow Video = ds.RW_VIDEO.Where(x => x.IDVIDEO == VideoR.IDVIDEO).FirstOrDefault();
if (Video != null)
{
Path = Video.PATHVIDEO + "\\" + Video.NOMEVIDEO;
}
}
}
return(Path);
}
public ResultViewModel <IList <VideoViewModel> > VideosApostila(VideoApostilaFiltroDTO filtro)
{
var result = Execute(() =>
{
var videos = new VideoBusiness(new VideoEntity()).ObterVideosApostila(filtro);
return(videos);
}, true);
return(GetResultViewModel <IList <VideoViewModel>, IList <VideoDTO> >(result));
}
public List <RWListItem> CreaListaVideo()
{
VideoDS ds = new VideoDS();
List <RWListItem> video = new List <RWListItem>();
using (VideoBusiness bVideo = new VideoBusiness())
{
bVideo.FillRW_VIDEO(ds);
video = ds.RW_VIDEO.Select(x => new RWListItem(x.NOMEVIDEO, x.IDVIDEO.ToString())).ToList();
}
return(video);
}
public void CancellaVideoReparto(decimal IDVIDEOREPARTO)
{
using (VideoBusiness bVideo = new VideoBusiness())
{
VideoDS ds = new VideoDS();
bVideo.FillRW_VIDEO_REPARTI(ds);
VideoDS.RW_VIDEO_REPARTIRow VideoB = ds.RW_VIDEO_REPARTI.NewRW_VIDEO_REPARTIRow();
VideoB = ds.RW_VIDEO_REPARTI.Where(x => x.IDVIDEOREPARTO == IDVIDEOREPARTO).FirstOrDefault();
if (VideoB != null)
{
VideoB.Delete();
bVideo.UpdateVideoDS(ds.RW_VIDEO_REPARTI.TableName, ds);
}
}
}
public void RetornaVideoVimeoThumbPorstringUrlInvalida()
{
VideoEntity entity = new VideoEntity();
VideoBusiness videoBusiness = new VideoBusiness(entity);
if (videoBusiness.ChaveamentoVimeo())
{
var idVideoValido = RetornaIntVideoIdComVimeoIdValido();
var result = videoBusiness.ObterURLThumbVimeo(idVideoValido);
bool videoVimeo = false;
if (result.IndexOf("https://i.vimeocdn.com") >= 0)
{
videoVimeo = true;
}
Assert.AreEqual(videoVimeo, true);
}
}
private void Dispose(bool dispose)
{
if (dispose)
{
if (_departmentBusiness != null)
{
//_connection.Dispose();
_departmentBusiness = null;
}
if (_archiveBusiness != null)
{
_archiveBusiness = null;
}
if (_eventBusiness != null)
{
_eventBusiness = null;
}
if (_imageBusiness != null)
{
_imageBusiness = null;
}
if (_imgPhotoGalleryBusiness != null)
{
_imgPhotoGalleryBusiness = null;
}
if (_photoGalleryBusiness != null)
{
_photoGalleryBusiness = null;
}
if (_videoBusiness != null)
{
_videoBusiness = null;
}
if (_repositoryContext != null)
{
_repositoryContext.Dispose();
_repositoryContext = null;
}
if (_instance != null)
{
_instance = null;
}
}
}
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);
}
}
}
public string GetUrlPlataformaVideo(tblVideo video, bool chaveamentoVimeo, int idAplicacao)
{
var url = string.Empty;
//Se o video não tiver no banco mas tem o VimeoID, ele busca no VIMEO, grava no banco e retorna a URL do video
if (chaveamentoVimeo && video.intVimeoID.HasValue)
{
url = new VideoBusiness(new VideoEntity()).ObterURLVimeoPorIntVimeoID(video.intVimeoID, idAplicacao, 0, video.txtName);
}
//Se o video ainda não existir no VIMEO ele verifica se é BitsOnTheRun ou AmazonAWS e retorna a URL
if (String.IsNullOrEmpty(url) && video.txtPath.ToLower().Contains("bitsontherun"))
{
url = Criptografia.GetSignedPlayer(String.Concat(video.txtFileName.Replace(".xml", string.Empty).Trim(), "-720"));
}
else if (String.IsNullOrEmpty(url) && video.txtPath.ToLower().Contains("amazonaws"))
{
url = Criptografia.GetS3SignedPlayer(String.Concat(_domainS3, video.txtName.Trim(), '.', Constants.FORMATOVIDEO));
}
return(url);
}
public bool SalvaAssociazioneVideoReparto(decimal video, string reparto, string DataInizio, string DataFine, string ConnectedUser)
{
VideoDS ds = new VideoDS();
using (VideoBusiness bVideo = new VideoBusiness())
{
try
{
bVideo.FillRW_VIDEO_REPARTI(ds);
VideoDS.RW_VIDEO_REPARTIRow VideoB = ds.RW_VIDEO_REPARTI.NewRW_VIDEO_REPARTIRow();
VideoB.IDVIDEO = video;
VideoB.REPARTO = reparto;
VideoB.DATAINSERIMENTO = DateTime.Now;
VideoB.UTENTE = ConnectedUser;
DateTime di = DateTime.ParseExact(DataInizio + " 00:00:00", "yyyy-MM-dd HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture);
DateTime df = DateTime.ParseExact(DataFine + " 23:59:59", "yyyy-MM-dd HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture);
VideoB.DATAINIZIO = di;
VideoB.DATAFINE = df;
ds.RW_VIDEO_REPARTI.AddRW_VIDEO_REPARTIRow(VideoB);
bVideo.UpdateVideoDS(ds.RW_VIDEO_REPARTI.TableName, ds);
return(true);
}
catch
{
bVideo.Rollback();
return(false);
}
}
}
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 DetailPage(VideosViewModel videoViewModel)
{
InitializeComponent();
BindingContext = videoViewModel;
NavigationPage.SetHasNavigationBar(this, true);
NavigationPage.SetHasBackButton(this, true);
foreach (string cast in videoViewModel.Cast)
{
castStack.Children.Add(
new Label
{
HorizontalOptions = LayoutOptions.FillAndExpand,
Text = cast,
TextColor = Color.Black,
FontSize = 16,
FontAttributes = FontAttributes.Italic,
}
);
}
foreach (string character in videoViewModel.Characters)
{
characterStack.Children.Add(
new Label
{
HorizontalOptions = LayoutOptions.FillAndExpand,
Text = character,
TextColor = Color.Black,
FontSize = 16,
FontAttributes = FontAttributes.Italic,
}
);
}
foreach (string keyword in videoViewModel.Keywords)
{
keywordStack.Children.Add(
new Label
{
HorizontalOptions = LayoutOptions.FillAndExpand,
Text = keyword,
TextColor = Color.Black,
FontSize = 16,
FontAttributes = FontAttributes.Italic,
}
);
}
try
{
Video video = TypeConvertHelper.ConvertVideoViewModelToVideo(videoViewModel);
VideoBusiness videoBusiness = new VideoBusiness();
if (videoBusiness.CreateVideo(video) > 0)
{
System.Diagnostics.Debug.WriteLine("Video Information added in table Successfully.");
}
}
catch (Exception pException)
{
System.Diagnostics.Debug.WriteLine("Error in Adding Video Information in Database : Message : " + pException.Message);
}
}
