public HttpResponseMessage Get(string firstName) { try { // The commented code moved to EmployeeDataAccess.cs //connection.Open(); //var result = // connection.Query<EmployeeListResult>("Select * From Employee where FirstName = @firstname", // new { firstName }).FirstOrDefault();] var employeeData = new EmployeeDataAccess(); var result = employeeData.Get(firstName); if (result == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, $"Employee with the Name {firstName} was not found")); } return(Request.CreateResponse(HttpStatusCode.OK, result)); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex)); } }
public HttpResponseMessage Get(int id) { // using (var connection = //new SqlConnection(ConfigurationManager.ConnectionStrings["Chinook"].ConnectionString)) // { try { // connection.Open() // var result = // connection.Query<EmployeeListResult>("Select * From Employee where EmployeeId = @id", //new {id = id}).FirstOrDefault(); var repo = new EmployeeDataAccess(); //repo is an instance of the EmployeeDataAccess class so it can use it's functions var result = repo.Get(id); if (result == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, $"Employee with the Id {id} was not found")); } return(Request.CreateResponse(HttpStatusCode.OK, result)); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex)); } // } }
public HttpResponseMessage Get(int id) { try { var repo = new EmployeeDataAccess(); var result = repo.Get(id); if (result == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Couldn't find that employee")); } return(Request.CreateResponse(HttpStatusCode.OK, result)); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex)); } }
//api/employees/id public HttpResponseMessage Get(int id) { try { var employeeData = new EmployeeDataAccess(); var employee = employeeData.Get(id); if (employee == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, $"Employee with the Id {id} was not found")); } return(Request.CreateResponse(HttpStatusCode.OK, employee)); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex)); } }