public TimelineTarefasItens BuscarItem(int iditem, int idusuario)
{
try
{
TimelineTarefasItens tarefa = null;
DBSession session = new DBSession();
Query quey = session.CreateQuery("SELECT idevento, iditem, txitem, fldashboard FROM timeline_eventos_itens WHERE iditem = @iditem");
quey.SetParameter("iditem", iditem);
IDataReader reader = quey.ExecuteQuery();
if (reader.Read())
{
tarefa = new TimelineTarefasItens(Convert.ToInt32(reader["idevento"]), Convert.ToInt32(reader["iditem"]), Convert.ToString(reader["txitem"]), idusuario, Convert.ToInt32(reader["fldashboard"]));
}
reader.Close();
session.Close();
return(tarefa);
}
catch (Exception error)
{
throw error;
}
}
public void SalvarItem(TimelineTarefasItens variavel)
{
try
{
DBSession session = new DBSession();
Query query = session.CreateQuery("INSERT INTO timeline_eventos_itens (idevento, txitem, fldashboard) VALUES (@idevento, @txitem, @fldashboard) ");
query.SetParameter("idevento", variavel.idevento);
query.SetParameter("txitem", variavel.txitem);
query.SetParameter("fldashboard", variavel.fldashboard);
query.ExecuteUpdate();
session.Close();
}
catch (Exception erro)
{
throw erro;
}
}
public void AlterarItem(TimelineTarefasItens variavel)
{
try
{
DBSession session = new DBSession();
Query query = session.CreateQuery("UPDATE timeline_eventos_itens SET txitem = @txitem, fldashboard = @fldashboard WHERE idevento = @idevento and iditem = @iditem");
query.SetParameter("iditem", variavel.iditem);
query.SetParameter("idevento", variavel.idevento);
query.SetParameter("txitem", variavel.txitem);
query.SetParameter("fldashboard", variavel.fldashboard);
query.ExecuteUpdate();
session.Close();
}
catch (Exception erro)
{
throw erro;
}
}
