public void Should_create_a_repository_with_default_constructor()
{
//Arrange
//Act
var repo = new BookPersistence();
//Assert
Assert.IsNotNull(repo);
}
// 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());
}
// 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());
}
public void Should_properly_dispose_of_sessions()
{
//Arrange
ISession s;
//Act
using (var repo = new BookPersistence())
{
s = repo.CurrentSession;
}
//Assert
Assert.IsFalse(s.IsConnected);
}
// POST: api/Book
/// <summary>
/// Create a new book item
/// </summary>
public HttpResponseMessage Post([FromBody] Book value)
{
BookPersistence bookp = new BookPersistence();
int id = bookp.Save(value, "item_id");
if (id != -1)
{
value.item_id = id;
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created);
response.Headers.Location = new Uri(Request.RequestUri, String.Format("book?item_id={0}", id));
return(response);
}
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
// 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);
}
public static void TestSetup(TestContext context)
{
Utilities.CreateSchema();
_repo = new BookPersistence();
_repo.Create(new Book { Title = "The Hobbit", Condition = 1, BookGuid = new Guid("11111111-1111-1111-1111-111111111111") });
_repo.Create(new Book { Title = "Fellowship of the Ring", Condition = 2 });
_repo.Create(new Book { Title = "The Two Towers", Condition = 1, BookGuid = new Guid("22222222-2222-2222-2222-222222222222") });
_repo.Create(new Book { Title = "Return of the King", Condition = null, BookGuid = new Guid("33333333-3333-3333-3333-333333333333") });
}
