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