public static void consultaUmFuncionario() { conecta(); strSQL = new SqlCommand("stpConsultarFuncionario", conn); strSQL.Parameters.AddWithValue("@codigo", CRUDCadastro.getCodigo()); strSQL.CommandType = System.Data.CommandType.StoredProcedure; try { strSQL.ExecuteNonQuery(); } catch (Exception e) { Erro.setMsg("Erro: " + e.ToString()); } finally { desconecta(); } }
public static void inserirUmFuncionario() { conecta(); strSQL = new SqlCommand("stpInserirFuncionario", conn); strSQL.Parameters.AddWithValue("@nome", CRUDCadastro.getNome()); strSQL.Parameters.AddWithValue("@telefone", CRUDCadastro.getTelefone()); strSQL.Parameters.AddWithValue("@endereco", CRUDCadastro.getEndereco()); strSQL.Parameters.AddWithValue("@funcao", CRUDCadastro.getFuncao()); strSQL.CommandType = System.Data.CommandType.StoredProcedure; try { strSQL.ExecuteNonQuery(); } catch (Exception e) { Erro.setMsg("Erro: " + e.ToString()); } finally { desconecta(); } }