public AvaliacaoVideoApostila GetAvaliacaoVideo(AvaliacaoVideoApostila avaliacao)
{
try
{
using (var ctx = new DesenvContext())
{
var contactID = Convert.ToInt32(avaliacao.Matricula);
var avaliacaoUsuario = (from a in ctx.tblVideoVote
where a.intContactID == contactID && a.intVideoID == avaliacao.VideoID && a.intBookID == avaliacao.MaterialID
select new AvaliacaoVideoApostila()
{
ID = a.intVideoVoteID,
VideoID = a.intVideoID.Value,
MaterialID = a.intBookID.Value,
Matricula = a.intContactID.Value,
TipoVote = a.intTipoInteracaoId.Value
}).FirstOrDefault();
return(avaliacaoUsuario);
}
}
catch
{
return(null);
}
}
public void SetAvaliacaoVideoMiolo_DownVote_MudouAvaliacao()
{
var videoEntity = new VideoEntity();
var avaliacao = new AvaliacaoVideoApostila()
{
Matricula = Convert.ToInt32(matricula),
TipoVote = (int)ETipoVideoVote.Downvote,
VideoID = videoId,
MaterialID = bookId
};
var ret = videoEntity.SetAvaliacaoVideo(avaliacao);
Assert.AreEqual(ret, 1);
}
public int SetAvaliacaoVideo(AvaliacaoVideoApostila avaliacao)
{
var avaliacaoAnterior = GetAvaliacaoVideo(avaliacao);
if (avaliacaoAnterior != null)
{
if (avaliacaoAnterior.TipoVote == avaliacao.TipoVote)
{
return(DeleteAvaliacaoApostila(avaliacaoAnterior));
}
else
{
DeleteAvaliacaoApostila(avaliacaoAnterior);
}
}
return(InsertAvaliacaoApostila(avaliacao));
}
public int InsertAvaliacaoApostila(AvaliacaoVideoApostila avaliacao)
{
using (var ctx = new DesenvContext())
{
try
{
var entity = new tblVideoVote
{
intContactID = avaliacao.Matricula,
intTipoInteracaoId = avaliacao.TipoVote,
dteDataCriacao = DateTime.Now,
intBookID = avaliacao.MaterialID,
intVideoID = avaliacao.VideoID
};
ctx.tblVideoVote.Add(entity);
return(ctx.SaveChanges());
}
catch
{
return(-1);
}
}
}
public int DeleteAvaliacaoApostila(AvaliacaoVideoApostila avaliacao)
{
using (var ctx = new DesenvContext())
{
try
{
var entity = new tblVideoVote
{
intVideoVoteID = avaliacao.ID,
intBookID = avaliacao.MaterialID,
intContactID = Convert.ToInt32(avaliacao.Matricula),
intTipoInteracaoId = avaliacao.TipoVote,
intVideoID = avaliacao.VideoID
};
ctx.Entry(entity).State = EntityState.Deleted;
return(ctx.SaveChanges());
}
catch
{
return(-1);
}
}
}
public int SetAvaliacaoVideo(AvaliacaoVideoApostila avaliacao)
{
return(new VideoEntity().SetAvaliacaoVideo(avaliacao));
}
