public HttpResponseMessage AddEmployee(EmployeeListResult employeeToAdd) { var employeeData = new EmployeeDataAccess(); var id = employeeData.Insert(employeeToAdd); return(Request.CreateResponse(HttpStatusCode.Created, new { Id = id, Message = $"EmployeeId {id} was created" })); }
public HttpResponseMessage Get() { // using (var connection = //new SqlConnection(ConfigurationManager.ConnectionStrings["Chinook"].ConnectionString)) //{ try { // connection.Open(); //var result = connection.Query<EmployeeListResult>("select * " + // "from Employee"); //return Request.CreateResponse(HttpStatusCode.OK, result); var employeeData = new EmployeeDataAccess(); //employeeData is an instance of the EmployeeDataAccess class so it can use it's functions var AllemployeeList = employeeData.GetAll(); return(Request.CreateResponse(HttpStatusCode.OK, AllemployeeList)); } catch (Exception ex) { Console.WriteLine(ex.Message); Console.WriteLine(ex.StackTrace); return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Query blew up")); } //} }
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)); } // } }
//api/employees (defined above in RoutePrefix) public HttpResponseMessage Get() { try { var employeeData = new EmployeeDataAccess(); var employees = employeeData.GetAll(); return(Request.CreateResponse(HttpStatusCode.OK, employees)); } catch (Exception) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Query blew up")); } // The commented code has been moved to EmployeeDataAccess.cs / no Console.WriteLines / only interacting w database // using (var connection = // new SqlConnection(ConfigurationManager.ConnectionStrings["Chinook"].ConnectionString)) // { // try // { // connection.Open(); // var result = connection.Query<EmployeeListResult>("select * " + // "from Employee"); // return Request.CreateResponse(HttpStatusCode.OK, result); // } // catch (Exception ex) // { // Console.WriteLine(ex.Message); // Console.WriteLine(ex.StackTrace); // return Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Query blew up"); // } // } }
public HttpResponseMessage Delete(int id) { var DataAccess = new EmployeeDataAccess(); //new instance try { DataAccess.Delete(id); return(Request.CreateResponse(HttpStatusCode.OK)); } catch (Exception Ex) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, Ex)); } //using (var Connection= new SqlConnection(ConfigurationManager.ConnectionStrings["Chinook"].ConnectionString)) //{ // try // { // Connection.Open(); // var Result = Connection.Execute("Delete From Employee where EmployeeId = @EmpId", new {EmpId = Id }); // return Request.CreateResponse(HttpStatusCode.OK,Result); // } // catch(Exception Ex) // { // return Request.CreateErrorResponse(HttpStatusCode.InternalServerError, Ex); // } //} }
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 Put(int id, EmployeeListResult employee) { try { // The commented code moved to EmployeeDataAccess.cs //connection.Open(); //connection.Execute("update Employee " + // "set LastName = @changedLastName " + // "where EmployeeId = @selectedID", // new { changedLastName = employee.LastName, selectedID = id }); var employeeData = new EmployeeDataAccess(); var affectedRows = employeeData.Update(id, employee); if (affectedRows == 0) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, $"Employee not found")); } return(Request.CreateResponse(HttpStatusCode.OK, $"{affectedRows} rows updated")); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex)); } }
// DELETE api/values/5 public HttpResponseMessage Delete(int id) { try { var employee = new EmployeeDataAccess(); var rowDelete = employee.Delete(id); return(Request.CreateResponse(HttpStatusCode.OK, $"Row deleted {rowDelete}")); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex)); } }
//api/employees public HttpResponseMessage Get() { try { var employeeData = new EmployeeDataAccess(); var employees = employeeData.GetAll(); return(Request.CreateResponse(HttpStatusCode.OK, employees)); } catch (Exception) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Query blew up")); } }
// POST api/values public HttpResponseMessage Post(EmployeeListResult employee) { try { var employeeAdd = new EmployeeDataAccess(); var rowsAdd = employeeAdd.Post(employee); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex)); } return(Request.CreateResponse(HttpStatusCode.Created)); }
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)); } }
public HttpResponseMessage Delete(int id) { try { //connection.Open(); //connection.Execute("delete from Employee where EmployeeId = @thisEmployee", // new { thisEmployee = id }); var employeeData = new EmployeeDataAccess(); var rowsDeleted = employeeData.Delete(id); return(Request.CreateResponse(HttpStatusCode.OK, $"{rowsDeleted} rows deleted")); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex)); } }
//PUT api/employees/5 public HttpResponseMessage Put(int id, EmployeeListResult employee) { try { var employeeData = new EmployeeDataAccess(); var rowsAffected = employeeData.Put(id, employee); if (rowsAffected == 0) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, $"Employee with the Id {id} was not found")); } return(Request.CreateResponse(HttpStatusCode.OK, $"Rows updated {rowsAffected}")); } 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)); } }
public HttpResponseMessage Put(EmployeeListResult Employee) { // using (var Connection = new SqlConnection(ConfigurationManager.ConnectionStrings["Chinook"].ConnectionString)) //{ var Updating = new EmployeeDataAccess(); try { // Connection.Open(); // var result = Connection.Execute("update Employee set LastName = @LastName where EmployeeId = @Id", // new { LastName = Employee.LastName, Id = Employee.EmployeeId }); //return Request.CreateResponse(HttpStatusCode.OK, result); Updating.Update(Employee); return(Request.CreateResponse(HttpStatusCode.OK)); } catch (Exception Ex) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, Ex)); } }
public HttpResponseMessage Post(EmployeeListResult employee) { try { // The commented code moved to EmployeeDataAccess.cs //connection.Open(); //connection.Execute("Insert into Employee(FirstName, LastName) " + // "Values(@firstName, @lastName)", // new { FirstName = employee.FirstName, LastName = employee.LastName }); var employeeData = new EmployeeDataAccess(); var rowsAdded = employeeData.AddEmployee(employee); return(Request.CreateResponse(HttpStatusCode.Created, $"{rowsAdded} rows added")); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex)); } }