public async static Task <RetCode> CadastraColaborador(ColaboradorModel colaborador) { string connecionString = Environment.GetEnvironmentVariable("DbConnectionString"); RetCode retorno = RetCode.Erro; using (SqlConnection connection = new SqlConnection(connecionString)) { using (SqlCommand command = new SqlCommand()) { connection.Open(); command.Connection = connection; command.CommandType = System.Data.CommandType.StoredProcedure; command.CommandText = "[sp_cadastraColaborador]"; command.CommandTimeout = 0; command.Parameters.Add("@NomeColaborador", System.Data.SqlDbType.VarChar).Value = colaborador.NomeColaborador; command.Parameters.Add("@DataNascimento", System.Data.SqlDbType.DateTime).Value = colaborador.DataNascimento; command.Parameters.Add("@IdDepartamento", System.Data.SqlDbType.Int).Value = colaborador.Departamento.IdDepartamento; command.Parameters.Add("@IdGenero", System.Data.SqlDbType.Int).Value = (int)colaborador.Genero; SqlDataReader reader = await command.ExecuteReaderAsync(); while (reader.Read()) { retorno = (RetCode)reader["ret_code"]; } } } return(retorno); }
public async static Task <List <ColaboradorModel> > ListaColaborador() { // Buscando CLiente em base List <ColaboradorModel> Listaclientes = new List <ColaboradorModel>(); string connecionString = Environment.GetEnvironmentVariable("DbConnectionString"); using (SqlConnection connection = new SqlConnection(connecionString)) { using (SqlCommand command = new SqlCommand()) { connection.Open(); command.Connection = connection; command.CommandType = System.Data.CommandType.StoredProcedure; command.CommandText = "[sp_buscaColaboradores]"; command.CommandTimeout = 0; SqlDataReader reader = await command.ExecuteReaderAsync(); while (reader.Read()) { var cliente = new ColaboradorModel { NomeColaborador = reader["NomeColaborador"].ToString(), IdColaborador = (int)reader["IdColaborador"], DataNascimento = (DateTime)reader["DataNascimento"], AtivoColaborador = (bool)reader["AtivoColaborador"], Idade = (int)reader["IdadeColaborador"], Genero = (Genero)reader["GeneroColaborador"], Departamento = new DepartamentoModel { IdDepartamento = (int)reader["IdDepartamento"], DescricaoDepartamento = reader["DescricaoDepartamento"].ToString(), AtivoDepartamento = (bool)reader["AtivoDepartamento"] } }; Listaclientes.Add(cliente); } } } return(Listaclientes); }