public static int Insert(Tpu tpu) { int retorno = 0; try { IDbConnection objConexao; IDbCommand objCommand; objConexao = Mapped.Connection(); string query = "insert into tpu_Tipo_Usuario(tpu_descricao) values (?tpu_descricao)"; objCommand = Mapped.Command(query, objConexao); objCommand.Parameters.Add(Mapped.Parameter("?tpu_descricao", tpu.Tpu_descricao)); objCommand.ExecuteNonQuery(); objConexao.Close(); objConexao.Dispose(); objCommand.Dispose(); } catch (Exception ex) { retorno = -2; } return(retorno); }
public static int Update(Tpu tpu) { int retorno = 0; try { IDbConnection objConexao; IDbCommand objCommand; objConexao = Mapped.Connection(); string query = "update tpu_Tipo_Usuario SET tpu_descricao = ?tpu_descricao WHERE tpu_pk = ?tpu_pk"; objCommand = Mapped.Command(query, objConexao); objCommand.Parameters.Add(Mapped.Parameter("?tpu_descricao", tpu.Tpu_descricao)); objCommand.Parameters.Add(Mapped.Parameter("?tpu_pk", tpu.Tpu_pk)); objCommand.ExecuteNonQuery(); objConexao.Close(); objConexao.Dispose(); objCommand.Dispose(); } catch (Exception ex) { retorno = -2; } return(retorno); }
protected void btn_Click(object sender, EventArgs e) { Tpu tpu = new Tpu(); tpu.Tpu_descricao = txbTpu.Text; switch (TpuDB.Insert(tpu)) { case 0: ltlMSG.Text = "<div class='alert alert-success btn-block'> >>>> OK <<<< </div>"; txbTpu.Text = ""; break; case -2: ltlMSG.Text = "<div class='alert alert-danger form-control'> >>>> ERRO <<<< </div>"; txbTpu.Text = ""; break; } }