public WidgetsUsuario BuscarWidgetUsuario(int id, int id2)
{
try
{
WidgetsUsuario wdg = null;
DBSession session = new DBSession();
Query quey = session.CreateQuery("SELECT * FROM timeline_usuarios_widgets WHERE idwidget = @idwidget and idusuario = @idusuario");
quey.SetParameter("idwidget", id);
quey.SetParameter("idusuario", id2);
IDataReader reader = quey.ExecuteQuery();
if (reader.Read())
{
wdg = new WidgetsUsuario(Convert.ToInt32(reader["idwidget"]), Convert.ToInt32(reader["idusuario"]), Convert.ToInt32(reader["nrheight"]), Convert.ToInt32(reader["nrwidth"]), Convert.ToInt32(reader["nrtop"]), Convert.ToInt32(reader["nrleft"]), Convert.ToString(reader["txclass"]), Convert.ToString(reader["txcor"]));
}
reader.Close();
session.Close();
return(wdg);
}
catch (Exception error)
{
throw error;
}
}
public void ExcluirWidgetUsuario(WidgetsUsuario variavel)
{
try
{
DBSession session = new DBSession();
Query query = session.CreateQuery("DELETE FROM timeline_usuarios_widgets WHERE idwidget = @idwidget and idusuario = @idusuario");
query.SetParameter("idwidget", variavel.idwidget);
query.SetParameter("idusuario", variavel.idusuario);
query.ExecuteUpdate();
session.Close();
}
catch (Exception error)
{
throw error;
}
}
public void AlterarWidgetUsuario(WidgetsUsuario variavel)
{
try
{
DBSession session = new DBSession();
Query query = session.CreateQuery("UPDATE timeline_usuarios_widgets SET nrheight = @nrheight, nrwidth = @nrwidth, nrtop = @nrtop, nrleft = @nrleft, txclass = @txclass, txcor = @txcor WHERE idwidget = @idwidget and idusuario = @idusuario");
query.SetParameter("idwidget", variavel.idwidget)
.SetParameter("idusuario", variavel.idusuario)
.SetParameter("nrheight", variavel.nrheight)
.SetParameter("nrwidth", variavel.nrwidth)
.SetParameter("nrtop", variavel.nrtop)
.SetParameter("nrleft", variavel.nrleft)
.SetParameter("txclass", variavel.txclass)
.SetParameter("txcor", variavel.txcor);
query.ExecuteUpdate();
session.Close();
}
catch (Exception error)
{
throw error;
}
}
public void SalvarWidgetUsuario(WidgetsUsuario variavel)
{
try
{
DBSession session = new DBSession();
Query query = session.CreateQuery("INSERT INTO timeline_usuarios_widgets (idwidget, idusuario, nrheight, nrwidth, nrtop, nrleft, txclass, txcor) VALUES (@idwidget, @idusuario, @nrheight, @nrwidth, @nrtop, @nrleft, @txclass, @txcor) ");
query.SetParameter("idwidget", variavel.idwidget)
.SetParameter("idusuario", variavel.idusuario)
.SetParameter("nrheight", variavel.nrheight)
.SetParameter("nrwidth", variavel.nrwidth)
.SetParameter("nrtop", variavel.nrtop)
.SetParameter("nrleft", variavel.nrleft)
.SetParameter("txclass", variavel.txclass)
.SetParameter("txcor", variavel.txcor);
query.ExecuteUpdate();
session.Close();
}
catch (Exception error)
{
throw error;
}
}
