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; } }