// BUSCAR
public BSC_Perspectivas BuscarPerspectiva(int idperspectiva)
{
try
{
BSC_Perspectivas bsc = null;
DBSession session = new DBSession();
Query quey = session.CreateQuery("SELECT * FROM BSC_Perspectivas WHERE idperspectiva = @idperspectiva");
quey.SetParameter("idperspectiva", idperspectiva);
IDataReader reader = quey.ExecuteQuery();
if (reader.Read())
{
bsc = new BSC_Perspectivas(Convert.ToInt32(reader["idperspectiva"]), Convert.ToString(reader["txperspectiva"]), Convert.ToInt32(reader["nrordem"]), Convert.ToString(reader["txcor"]), Convert.ToString(reader["txiniciativa"]));
}
reader.Close();
session.Close();
return(bsc);
}
catch (Exception error)
{
throw error;
}
}
// EXCLUIR
public void ExcluirPerspectiva(BSC_Perspectivas variavel)
{
try
{
DBSession session = new DBSession();
Query query = session.CreateQuery("DELETE FROM BSC_Perspectivas WHERE idperspectiva = @codigo");
query.SetParameter("codigo", variavel.idperspectiva);
query.ExecuteUpdate();
session.Close();
}
catch (Exception erro)
{
throw erro;
}
}
// ALTERAR
public void AlterarPerspectiva(BSC_Perspectivas variavel)
{
try
{
DBSession session = new DBSession();
Query query = session.CreateQuery("UPDATE BSC_Perspectivas SET txperspectiva = @txperspectiva, nrordem = @nrordem, txcor = @txcor, txiniciativa = @txiniciativa WHERE idperspectiva = @idperspectiva");
query.SetParameter("idperspectiva", variavel.idperspectiva);
query.SetParameter("txperspectiva", variavel.txperspectiva);
query.SetParameter("nrordem", variavel.nrordem);
query.SetParameter("txcor", variavel.txcor);
query.SetParameter("txiniciativa", variavel.txiniciativa);
query.ExecuteUpdate();
session.Close();
}
catch (Exception error)
{
throw error;
}
}
// SALVAR
public int SalvarPerspectivaRetornar(BSC_Perspectivas variavel)
{
try
{
int id = 0;
DBSession session = new DBSession();
Query query = session.CreateQuery("INSERT INTO BSC_Perspectivas (txperspectiva, nrordem, txcor, txiniciativa) output INSERTED.idperspectiva VALUES (@txperspectiva, @nrordem, @txcor, @txiniciativa)");
query.SetParameter("txperspectiva", variavel.txperspectiva);
query.SetParameter("nrordem", variavel.nrordem);
query.SetParameter("txcor", variavel.txcor);
query.SetParameter("txiniciativa", variavel.txiniciativa);
id = query.ExecuteScalar();
session.Close();
return(id);
}
catch (Exception erro)
{
throw erro;
}
}
