// GET api/contacts
public HttpResponseMessage Get()
{
List <Contact> list = new List <Contact>();
try
{
var conn = WebApiConfig.GetMySqlConnection();
var command = conn.CreateCommand();
command.CommandText = "SELECT * FROM contacts";
conn.Open();
try
{
using (MySqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
var contact = ContactMapper.GetContactFromReader(reader);
list.Add(contact);
}
}
}
catch
{
throw;
}
}
catch
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError));
}
return(Request.CreateResponse(HttpStatusCode.OK, list));
}
// GET api/contacts/5
public HttpResponseMessage Get(int id)
{
Contact contact = new Contact();
try
{
var conn = WebApiConfig.GetMySqlConnection();
var command = conn.CreateCommand();
command.CommandText = "SELECT * FROM contacts WHERE id=@id";
command.Parameters.AddWithValue("@id", id);
conn.Open();
try
{
using (MySqlDataReader reader = command.ExecuteReader())
{
if (reader.Read())
{
contact = ContactMapper.GetContactFromReader(reader);
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
}
catch
{
throw;
}
}
catch
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError));
}
return(Request.CreateResponse(HttpStatusCode.OK, contact));
}