public int AddBook(BookAddRequest model)
{
using (var conn = DbConnection())
{
int id = 0;
if (conn.State == ConnectionState.Open)
{
using (var cmd = new SqlCommand("Book_Create", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Title", model.Title);
cmd.Parameters.AddWithValue("@Genre", model.Genre);
cmd.Parameters.AddWithValue("@Publication_Date", model.Publication_Date);
cmd.Parameters.AddWithValue("@Price", model.Price);
cmd.Parameters.AddWithValue("@Description", model.Description);
cmd.Parameters.AddWithValue("@Author_Id", model.Author_Id);
cmd.Parameters.AddWithValue("@Book_Id", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
id = (int)cmd.Parameters["@Book_Id"].Value;
}
}
else
{
BadConnection();
}
return(id);
}
}
public IHttpActionResult Post(BookAddRequest model)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
else
{
return(Ok("Book number " + svc.AddBook(model) + " has been added to the directory"));
}
}
public FubuContinuation AddBook(BookAddRequest model)
{
Guid id = Guid.NewGuid();
return FubuContinuation.RedirectTo<BookController>(x => x.ViewBook(new BookViewRequestModel(id)));
}
