public Res_respostas Select(int codigo) { try { Res_respostas objRespostas = null; IDbConnection objConexao; IDbCommand objcommand; IDataReader objDatareader; objConexao = Mapped.Connection(); objcommand = Mapped.Command("select * from res_respostas where res_codigo = ?res_codigo", objConexao); objcommand.Parameters.Add(Mapped.Parameter("?res_codigo", codigo)); objDatareader = objcommand.ExecuteReader(); while (objDatareader.Read()) { objRespostas = new Res_respostas(); objRespostas.CodigoResposta = Convert.ToInt32(objDatareader["res_codigo"]); //objRespostas.Questionario = (objDatareader[""]); que_codigo? //objRespostas.Alternativa = objDatareader[""]; alt_codigo? } objDatareader.Close(); objConexao.Close(); objcommand.Dispose(); objConexao.Dispose(); objDatareader.Dispose(); return(objRespostas); } catch (Exception e) { return(null); } }
public static int Insert(Res_respostas respostas) { int retorno = 0; try { IDbConnection objConexao; IDbCommand objcommand; String sql = "insert into res_respostas "; sql += "res_codigo, que_codigo,alt_codigo"; sql += "values (?res_codigo, ?que_codigo, ?alt_codigo)"; objConexao = Mapped.Connection(); objcommand = Mapped.Command(sql, objConexao); objcommand.Parameters.Add(Mapped.Parameter("?res_codigo", respostas.CodigoResposta)); objcommand.Parameters.Add(Mapped.Parameter("?que_codigo", respostas.Questionario)); objcommand.Parameters.Add(Mapped.Parameter("?alt_codigo", respostas.Alternativa)); objcommand.ExecuteNonQuery(); objConexao.Close(); objcommand.Dispose(); objConexao.Dispose(); } catch (Exception e) { retorno = -2; } return(retorno); }
public int Update(Res_respostas respostas) { int retorno = 0; try { IDbConnection objConexao; IDbCommand objcommand; String sql = "update res_respostas set"; sql += "que_codigo= ?que_codigo"; sql += "alt_codigo= ?alt_codigo"; sql += "where res_codigo = ?res_codigo"; objConexao = Mapped.Connection(); objcommand = Mapped.Command(sql, objConexao); objcommand.Parameters.Add(Mapped.Parameter("?resp_codigo", respostas.CodigoResposta)); objcommand.Parameters.Add(Mapped.Parameter("?que_codigo", respostas.Questionario)); objcommand.Parameters.Add(Mapped.Parameter("?alt_codigo", respostas.Alternativa)); objcommand.ExecuteNonQuery(); objConexao.Close(); objcommand.Dispose(); objConexao.Dispose(); } catch (Exception e) { retorno = -2; } return(retorno); }