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