public TimelineMenus Buscar(int idmenu)
{
try
{
TimelineMenus menu = null;
DBSession session = new DBSession();
Query quey = session.CreateQuery("SELECT * FROM timeline_menus WHERE idmenu = @idmenu");
quey.SetParameter("idmenu", idmenu);
IDataReader reader = quey.ExecuteQuery();
if (reader.Read())
{
menu = new TimelineMenus(Convert.ToInt32(reader["idmenu"]), Convert.ToInt32(reader["idmenupai"]), Convert.ToString(reader["txicone"]), Convert.ToString(reader["txlink"]), Convert.ToString(reader["txmenu"]), Convert.ToInt32(reader["nrordem"]));
}
reader.Close();
session.Close();
return(menu);
}
catch (Exception error)
{
throw error;
}
}
public void Excluir(TimelineMenus variavel)
{
try
{
DBSession session = new DBSession();
Query query = session.CreateQuery("DELETE FROM timeline_menus WHERE idmenu = @idmenu");
query.SetParameter("idmenu", variavel.idmenu);
query.ExecuteUpdate();
session.Close();
}
catch (Exception error)
{
throw error;
}
}
public void Salvar(TimelineMenus variavel)
{
try
{
DBSession session = new DBSession();
Query query = session.CreateQuery("INSERT INTO timeline_menus (idmenupai, txicone, txlink, txmenu, nrordem) VALUES (@idmenupai, @txicone, @txlink, @txmenu, @nrordem) ");
query.SetParameter("idmenupai", variavel.idmenupai);
query.SetParameter("txicone", variavel.txicone);
query.SetParameter("txlink", variavel.txlink);
query.SetParameter("txmenu", variavel.txmenu);
query.SetParameter("nrordem", variavel.nrordem);
query.ExecuteUpdate();
session.Close();
}
catch (Exception error)
{
throw error;
}
}
public void Alterar(TimelineMenus variavel)
{
try
{
DBSession session = new DBSession();
Query query = session.CreateQuery("UPDATE timeline_menus set idmenupai = @idmenupai, txicone = @txicone, txlink = @txlink, txmenu = @txmenu, nrordem = @nrordem where idmenu = @idmenu ");
query.SetParameter("idmenu", variavel.idmenu);
query.SetParameter("idmenupai", variavel.idmenupai);
query.SetParameter("txicone", variavel.txicone);
query.SetParameter("txlink", variavel.txlink);
query.SetParameter("txmenu", variavel.txmenu);
query.SetParameter("nrordem", variavel.nrordem);
query.ExecuteUpdate();
session.Close();
}
catch (Exception error)
{
throw error;
}
}
