public Aluno_confirmacao Buscar(int idconfirmacao = 0)
{
try
{
Aluno_confirmacao conf = new Aluno_confirmacao();
DBSession session = new DBSession();
Query quey = session.CreateQuery("select * from alunos_confirmacao where idconfirmacao = @idconfirmacao");
quey.SetParameter("idconfirmacao", idconfirmacao);
IDataReader reader = quey.ExecuteQuery();
while (reader.Read())
{
conf = new Aluno_confirmacao(Convert.ToInt32(reader["idconfirmacao"]), Convert.ToInt32(reader["idaluno_curso"]), Convert.ToDateTime(reader["dtconfirmacao"]), Convert.ToString(reader["txobs"]));
}
reader.Close();
session.Close();
return(conf);
}
catch (Exception error)
{
throw error;
}
}
public void Excluir(Aluno_confirmacao variavel)
{
try
{
DBSession session = new DBSession();
Query query = session.CreateQuery("DELETE FROM alunos_confirmacao WHERE idconfirmacao = @idconfirmacao");
query.SetParameter("idconfirmacao", variavel.idconfirmacao);
query.ExecuteUpdate();
session.Close();
}
catch (Exception error)
{
throw error;
}
}
public void Salvar(Aluno_confirmacao variavel)
{
try
{
DBSession session = new DBSession();
Query query = session.CreateQuery("INSERT INTO alunos_confirmacao (idaluno_curso, dtconfirmacao, txobs) VALUES (@idaluno_curso, @dtconfirmacao, @txobs) ");
query.SetParameter("idaluno_curso", variavel.idaluno_curso)
.SetParameter("dtconfirmacao", variavel.dtconfirmacao)
.SetParameter("txobs", variavel.txobs);
query.ExecuteUpdate();
session.Close();
}
catch (Exception error)
{
throw error;
}
}
public void Alterar(Aluno_confirmacao variavel)
{
try
{
DBSession session = new DBSession();
Query query = session.CreateQuery("UPDATE alunos_confirmacao SET idaluno_curso = @idaluno_curso, dtconfirmacao = @dtconfirmacao, txobs = @txobs WHERE idconfirmacao = @idconfirmacao");
query.SetParameter("idconfirmacao", variavel.idconfirmacao)
.SetParameter("idaluno_curso", variavel.idaluno_curso)
.SetParameter("dtconfirmacao", variavel.dtconfirmacao)
.SetParameter("txobs", variavel.txobs);
query.ExecuteUpdate();
session.Close();
}
catch (Exception error)
{
throw error;
}
}
