public void Excluir(Aluno_video variavel)
{
try
{
DBSession session = new DBSession();
Query query = session.CreateQuery("DELETE FROM aluno_video WHERE video_id = @video_id AND aluno = @aluno AND data = @data;");
query.SetParameter("video_id", variavel.video_id.video_id)
.SetParameter("aluno", variavel.aluno.codigo)
.SetParameter("data", variavel.data);
query.ExecuteUpdate();
session.Close();
}
catch (Exception error)
{
throw error;
}
}
public void Salvar(Aluno_video variavel)
{
try
{
DBSession session = new DBSession();
Query query = session.CreateQuery("INSERT INTO aluno_video (video_id, aluno, data, tempo) VALUES (@video_id, @aluno, @data, @tempo) ");
query.SetParameter("video_id", variavel.video_id.video_id)
.SetParameter("aluno", variavel.aluno.codigo)
.SetParameter("data", variavel.data)
.SetParameter("tempo", variavel.tempo);
query.ExecuteUpdate();
session.Close();
}
catch (Exception error)
{
throw error;
}
}
public void VerificaSeExiste(Aluno_video variavel)
{
try
{
DBSession session = new DBSession();
Query query = session.CreateQuery("select count(*) FROM aluno_video WHERE aluno = @aluno AND video = @video AND data >= @data")
.SetParameter("aluno", variavel.aluno.codigo)
.SetParameter("video", variavel.video_id.video_id)
.SetParameter("data", variavel.data.AddDays(-7));
IDataReader reader = query.ExecuteQuery();
if (!reader.Read())
{
Salvar(variavel);
}
reader.Close();
session.Close();
}
catch (Exception error)
{
throw error;
}
}
