public Que_questionarios Select(int codigo) { try { Que_questionarios objQuestinario = null; IDbConnection objConexao; IDbCommand objcommand; IDataReader objDatareader; objConexao = Mapped.Connection(); objcommand = Mapped.Command("select * from que_questionarios where que_codigo = ?que_codigo", objConexao); objcommand.Parameters.Add(Mapped.Parameter("?que_codigo", codigo)); objDatareader = objcommand.ExecuteReader(); while (objDatareader.Read()) { objQuestinario = new Que_questionarios(); objQuestinario.CodigoQuestionario = Convert.ToInt32(objDatareader["que_codigo"]); objQuestinario.PontoQuestionario = Convert.ToDouble(objDatareader["que_pontos"]); objQuestinario.InicioQuestionario = objDatareader["que_inicio"].ToString(); objQuestinario.FimQuestionario = objDatareader["que_fim"].ToString(); // objQuestinario.ModCla = objDatareader[""].ToString(); ?? } objDatareader.Close(); objConexao.Close(); objcommand.Dispose(); objConexao.Dispose(); objDatareader.Dispose(); return(objQuestinario); } catch (Exception e) { return(null); } }
public static int Insert(Que_questionarios questionarios) { int retorno = 0; try { IDbConnection objConexao; IDbCommand objcommand; String sql = "insert into Que_questionarios "; sql += " _que_pontos, _que_inicio, _que_fim, _que_codigo, _modCla"; sql += "values (?que_pontos, ?que_inicio, ?que_fim, ?que_codigo, ?modCla)"; objConexao = Mapped.Connection(); objcommand = Mapped.Command(sql, objConexao); objcommand.Parameters.Add(Mapped.Parameter("?que_codigo", questionarios.CodigoQuestionario)); objcommand.Parameters.Add(Mapped.Parameter("?que_pontos", questionarios.PontoQuestionario)); objcommand.Parameters.Add(Mapped.Parameter("?modCla", questionarios.ModCla)); objcommand.Parameters.Add(Mapped.Parameter("?que_inicio", questionarios.InicioQuestionario)); objcommand.Parameters.Add(Mapped.Parameter("?que_fim", questionarios.FimQuestionario)); objcommand.ExecuteNonQuery(); objConexao.Close(); objcommand.Dispose(); objConexao.Dispose(); } catch (Exception e) { retorno = -2; } return(retorno); }
public int Update(Que_questionarios questionarios) { int retorno = 0; try { IDbConnection objConexao; IDbCommand objcommand; String sql = "update que_questionarios set"; sql += "que_pontos= ?que_pontos"; sql += "que_inicio= ?que_inicio"; sql += "que_fim= ?que_fim"; sql += "modCla= ?_modCla";//? sql += "where que_codigo = ?que_codigo"; objConexao = Mapped.Connection(); objcommand = Mapped.Command(sql, objConexao); objcommand.Parameters.Add(Mapped.Parameter("?que_pontos", questionarios.PontoQuestionario)); objcommand.Parameters.Add(Mapped.Parameter("?que_inicio", questionarios.InicioQuestionario)); objcommand.Parameters.Add(Mapped.Parameter("?que_fim", questionarios.FimQuestionario)); objcommand.Parameters.Add(Mapped.Parameter("?que_codigo", questionarios.CodigoQuestionario)); objcommand.Parameters.Add(Mapped.Parameter("?_modCla", questionarios.ModCla));//? objcommand.ExecuteNonQuery(); objConexao.Close(); objcommand.Dispose(); objConexao.Dispose(); } catch (Exception e) { retorno = -2; } return(retorno); }