public IHttpActionResult Put(int id, [FromBody] DAO.Book book)
{
try
{
if (book == null)
{
return(BadRequest());
}
//map
var ad = _bookFactory.CreateBook(book);
var result = _repository.UpdateBook(ad);
if (result.Status == BookingRepositoryActionStatus.Updated)
{
// map to dao
var updatedBook = _bookFactory.CreateBook(result.Entity);
return(Ok(updatedBook));
}
else if (result.Status == BookingRepositoryActionStatus.NotFound)
{
return(NotFound());
}
return(BadRequest());
}
catch (Exception)
{
return(InternalServerError());
}
}
public object CreateDataShapedObject(DAO.Book book, List <string> lstOfFields)
{
if (!lstOfFields.Any())
{
return(book);
}
else
{
// create a new ExpandoObject & dynamically create the properties for this object
ExpandoObject objectToReturn = new ExpandoObject();
foreach (var field in lstOfFields)
{
// need to include public and instance, b/c specifying a binding flag overwrites the
// already-existing binding flags.
var fieldValue = book.GetType()
.GetProperty(field, BindingFlags.IgnoreCase | BindingFlags.Public | BindingFlags.Instance)
.GetValue(book, null);
// add the field to the ExpandoObject
((IDictionary <String, Object>)objectToReturn).Add(field, fieldValue);
}
return(objectToReturn);
}
}
public async Task Delete(string id)
{
DAO.Book item = await _query.GetAsync(new Guid(id));
DeleteDAOValidations();
await _persistence.BeginTransactionAsync();
await _persistence.DeleteAsync(item);
await _persistence.CommitAsync();
}
public bool SaveThisBook(DAO.Book aBook)
{
Connection.Open();
string query = "INSERT INTO t_book (book_id,book_name,author,quantity) VALUES ('" + aBook.BookID + "','" + aBook.BookName + "','" + aBook.Author + "','" + aBook.Quantity + "')";
SqlCommand command = new SqlCommand(query, Connection);
int affectedRow = command.ExecuteNonQuery();
Connection.Close();
if (affectedRow > 0)
{
return(true);
}
return(false);
}
public async Task <Book> Update(Book item)
{
DAO.Book dao = _mapper.Map <Book, DAO.Book>(item);
UpdateDAOValidations(dao);
await _persistence.BeginTransactionAsync();
await _persistence.UpdateAsync(dao);
await _persistence.CommitAsync();
return(_mapper.Map <DAO.Book, Book>(dao));
}
public Book CreateBook(DAO.Book book)
{
return(new Book()
{
Id = book.Id,
CustomerId = book.CustomerId,
EmpId = book.EmpId,
Description = book.Description,
DateCreated = book.DateCreated,
LastUpdated = book.LastUpdated
//BookingCancelations = book.BookingCancelations == null ? new List<BookingCancelation>() : book.BookingCancelations.Select(c => bookingCancelationFactory.CreateBookingCancelation(c)).ToList(),
//Payments = book.Payments == null ? new List<Payment>() : book.Payments.Select(a => paymentFactory.CreatePayment(a)).ToList(),
//Rebookings = book.Rebookings == null ? new List<Rebooking>() : book.Rebookings.Select(a => rebookingFactory.CreateRebooking(a)).ToList()
});
}
public bool CheckIfthisBookExist(DAO.Book aBook)
{
Connection.Open();
string query = "SELECT * FROM t_book WHERE book_id = '" + aBook.BookID + "'";
SqlCommand command = new SqlCommand(query, Connection);
SqlDataReader aReader = command.ExecuteReader();
while (aReader.Read())
{
Connection.Close();
return(true);
}
Connection.Close();
return(false);
}
public async Task <Book> Insert(Book item)
{
DAO.Book dao = _mapper.Map <Book, DAO.Book>(item);
dao.Author = null;
dao.SetNewId();
InsertDAOValidations(dao);
await _persistence.BeginTransactionAsync();
await _persistence.InsertAsync(dao);
await _persistence.CommitAsync();
return(_mapper.Map <DAO.Book, Book>(dao));
}
public IHttpActionResult Post([FromBody] DAO.Book book)
{
try
{
if (book == null)
{
return(BadRequest());
}
var b = _bookFactory.CreateBook(book);
var result = _repository.InsertBook(b);
if (result.Status == BookingRepositoryActionStatus.Created)
{
var newBook = _bookFactory.CreateBook(result.Entity);
return(Created(Request.RequestUri + "/" + newBook.Id.ToString(), newBook));
}
return(BadRequest());
}
catch (Exception)
{
return(InternalServerError());
}
}
private void UpdateDAOValidations(DAO.Book item)
{
}
private void InsertDAOValidations(DAO.Book item)
{
}
