// Gravar as preferencias do usuário
public void Gravar(Usuarios_Widgets rs)
{
try
{
string qry = "";
qry += "INSERT INTO Usuarios_Widgets (idusuario, idaplicativo_widget, nrxpos, nrypos, nrheight, nrwidth, txcolor, flminimize, nrrefreshtime, fldashboard, flremove) ";
qry += "VALUES (" + rs.idusuario.value + ", " + rs.idaplicativo_widget.value + ", " + rs.nrxpos.value + ", " + rs.nrypos.value + ", " + rs.nrheight.value + ",";
qry += rs.nrwidth.value + ", '" + rs.txcolor.value + "', " + rs.flminimize.value + ", " + rs.nrrefreshtime.value + ", " + rs.fldashboard.value + ", " + rs.flremove.value + ")";
Connection session = new Connection();
Query query = session.CreateQuery(qry);
query.ExecuteUpdate();
session.Close();
}
catch (Exception erro)
{
throw erro;
}
}
// Alterar
public void Alterar(Usuarios_Widgets rs)
{
try
{
string qry = "";
qry += "UPDATE Usuarios_Widgets ";
qry += "SET nrxpos = " + rs.nrxpos.value + ", nrypos = " + rs.nrypos.value + ", nrheight = " + rs.nrheight.value + ", nrwidth = " + rs.nrwidth.value + ", ";
qry += "txcolor = '" + rs.txcolor.value + "', flminimize = " + rs.flminimize.value + ", nrrefreshtime = " + rs.nrrefreshtime.value + ", ";
qry += "fldashboard = " + rs.fldashboard.value + ", flremove = " + rs.flremove.value + " ";
qry += "WHERE idusuario = " + rs.idusuario.value + " AND idaplicativo_widget = " + rs.idaplicativo_widget.value;
Connection session = new Connection();
Query query = session.CreateQuery(qry);
query.ExecuteUpdate();
session.Close();
}
catch (Exception erro)
{
throw erro;
}
}
// Pega as configurações do widget da dashboard do usuário
public Usuarios_Widgets Buscar(int idusuario, int idwidget)
{
try
{
Usuarios_Widgets config = null;
Connection session = new Connection();
Query query = session.CreateQuery(@"SELECT * FROM Usuarios_Widgets WHERE idusuario = " + idusuario + " AND idaplicativo_widget = " + idwidget);
IDataReader reader = query.ExecuteQuery();
if (reader.Read())
{
config = new Usuarios_Widgets()
{
idusuario = new Variable(value: Convert.ToInt32(reader["idusuario"])),
idaplicativo_widget = new Variable(value: Convert.ToInt32(reader["idaplicativo_widget"])),
nrxpos = new Variable(value: Convert.ToInt32(reader["nrxpos"])),
nrypos = new Variable(value: Convert.ToInt32(reader["nrypos"])),
nrheight = new Variable(value: Convert.ToInt32(reader["nrheight"])),
nrwidth = new Variable(value: Convert.ToInt32(reader["nrwidth"])),
txcolor = new Variable(value: Convert.ToString(reader["txcolor"])),
flminimize = new Variable(value: Convert.ToInt32(reader["flminimize"])),
nrrefreshtime = new Variable(value: Convert.ToInt32(reader["nrrefreshtime"])),
fldashboard = new Variable(value: Convert.ToInt32(reader["fldashboard"])),
flremove = new Variable(value: Convert.ToInt32(reader["flremove"]))
};
}
reader.Close();
session.Close();
return(config);
}
catch (Exception error)
{
throw error;
}
}
