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));
}
}
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" }));
}
// 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 Post(EmployeeListResult Employee)
{
using (var Connection = new SqlConnection(ConfigurationManager.ConnectionStrings["Chinook"].ConnectionString))
{
try
{
Connection.Open();
var result = Connection.Execute("Insert into Employee(FirstName, LastName) Values(@FirstName, @LastName)",
new { FirstName = Employee.FirstName, LastName = Employee.LastName });
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
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));
}
}
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));
}
}
public HttpResponseMessage Put(int id, EmployeeListResult employee)
{
Console.WriteLine($"{employee.FirstName} {employee.LastName}");
return(Request.CreateResponse(HttpStatusCode.Accepted));
}
