// GET: api/Book
/// <summary>
/// Retrieve a list of book items that match your criteria (All fields are optional. If no fields are given all items will be retrieved)
/// </summary>
/// <param name="isbn10">A unique code that specifies a book</param>
/// <param name="isbn13">Another unique code that specifies a book</param>
/// <param name="category">sci-fi, fantasy, non-fiction, etc.</param>
/// <param name="publication_year">the year a book was published</param>
public ArrayList Get(string isbn10 = null, string isbn13 = null, string category = null, int?publication_year = null)
{
BookPersistence bookp = new BookPersistence();
bookp.addCallField("isbn_10", isbn10, SqlDbType.VarChar, 50);
bookp.addCallField("isbn_13", isbn13, SqlDbType.VarChar, 50);
bookp.addCallField("category", category, SqlDbType.VarChar, 50);
bookp.addCallField("publication_year", publication_year, SqlDbType.Int, 4);
return(bookp.GetAll());
}
// GET: api/Book/5
/// <summary>
/// Retrieve the book with a specified item_id
/// </summary>
/// <param name="item_id">ID generated by database upon its creation</param>
public Book Get(int item_id)
{
BookPersistence bookp = new BookPersistence();
bookp.addCallField("item_id", item_id, SqlDbType.Int, 4);
return((Book)bookp.Get());
}
// DELETE: api/Book/5
/// <summary>
/// Delete the book with a specified item_id
/// </summary>
/// <param name="item_id">ID generated by database upon its creation</param>
public HttpResponseMessage Delete(int item_id)
{
BookPersistence bookp = new BookPersistence();
bookp.addCallField("item_id", item_id, SqlDbType.Int, 4);
HttpResponseMessage ret;
if (bookp.Delete())
{
ret = Request.CreateResponse(HttpStatusCode.NoContent);
}
else
{
ret = Request.CreateResponse(HttpStatusCode.NotFound);
}
return(ret);
}
// PUT: api/Book/5
/// <summary>
/// Update an existing book with the specified item_id
/// </summary>
/// <param name="item_id">ID generated by database upon its creation</param>
public HttpResponseMessage Put(int item_id, [FromBody] Book value)
{
BookPersistence bookp = new BookPersistence();
bookp.addCallField("item_id", item_id, SqlDbType.Int, 4);
bool recordExisted = bookp.Update(value);
HttpResponseMessage response;
if (recordExisted)
{
response = Request.CreateResponse(HttpStatusCode.NoContent);
}
else
{
response = Request.CreateResponse(HttpStatusCode.NotFound);
}
return(response);
}
