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