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