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