/// <summary>
/// Retrieve the checkout object with a specified member_id, item_id, and item_type
/// </summary>
/// <param name="member_id">The id of the member that checked out the item</param>
/// <param name="item_id">The id of the item that was checked out</param>
/// <param name="item_type">The type of item that was checked out [book|dvd|technology]</param>
public Checkout Get(int member_id, int item_id, string item_type)
{
CheckoutPersistence checkp = new CheckoutPersistence();
checkp.addCallField("item_id", item_id, System.Data.SqlDbType.Int, 4);
checkp.addCallField("member_id", member_id, System.Data.SqlDbType.Int, 4);
checkp.addCallField("item_type", item_type, System.Data.SqlDbType.VarChar, 50);
return((Checkout)checkp.Get());
}
/// <summary>
/// Retrieve a list of checkout objects that match your criteria (All fields are optional. If no fields are given all items will be retrieved)
/// </summary>
/// <param name="item_id">The id of the item that was checked out</param>
/// <param name="member_id">The id of the member that checked out the item</param>
/// <param name="item_type">The type of item that was checked out [book|dvd|technology]</param>
/// <param name="resolved">'true' if the item has been returned. 'false' if the item is still checked out</param>
public ArrayList Get(int?item_id = null, int?member_id = null, string item_type = null, bool?resolved = null)
{
CheckoutPersistence checkp = new CheckoutPersistence();
checkp.addCallField("item_id", item_id, System.Data.SqlDbType.Int, 4);
checkp.addCallField("member_id", member_id, System.Data.SqlDbType.Int, 4);
checkp.addCallField("item_type", item_type, System.Data.SqlDbType.VarChar, 50);
checkp.addCallField("resolved", resolved, System.Data.SqlDbType.Bit, 1);
return(checkp.GetAll());
}
/// <summary>
/// Create a new checkout object
/// </summary>
public HttpResponseMessage Post([FromBody] Checkout value)
{
CheckoutPersistence checkp = new CheckoutPersistence();
int item_id = checkp.Save(value, "member_id");
if (item_id != -1)
{
value.item_id = item_id;
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created);
response.Headers.Location = new Uri(Request.RequestUri, String.Format("checkout?member_id={0}", item_id));
return(response);
}
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
/// <summary>
/// Update an existing checkout object with a specified item_id, member_id, and item_type
/// </summary>
/// <param name="member_id">The id of the member that checked out the item</param>
/// <param name="item_id">The id of the item that was checked out</param>
/// <param name="item_type">The type of item that was checked out [book|dvd|technology]</param>
public HttpResponseMessage Put(int item_id, int member_id, String item_type, [FromBody] Checkout value)
{
CheckoutPersistence checkp = new CheckoutPersistence();
checkp.addCallField("item_id", item_id, System.Data.SqlDbType.Int, 4);
checkp.addCallField("member_id", member_id, System.Data.SqlDbType.Int, 4);
checkp.addCallField("item_type", item_type, System.Data.SqlDbType.VarChar, 50);
bool recordExisted = checkp.Update(value);
HttpResponseMessage response;
if (recordExisted)
{
response = Request.CreateResponse(HttpStatusCode.NoContent);
}
else
{
response = Request.CreateResponse(HttpStatusCode.NotFound);
}
return(response);
}
