public void CreateBookLender(BookLender bookLender)
{
try
{
using (var trans = _iAdoNetContext.CreateTransaction())
{
try
{
using (var cmd = _iAdoNetContext.CreateCommand(trans))
{
_iBookRepositoryQuery.CreateBookLender(bookLender, cmd);
trans.Commit();
}
}
catch (Exception ex)
{
//TODO: Log this the exception information along with the method details to the database for Error tracing
//Allowing the exception be rethrown so that LOG4NET can log there is a problem on the api end point
trans.Rollback();
throw ex;
}
}
}
catch (Exception ex)
{
//TODO: Log this the exception information along with the method details to the database for Error tracing
//Allowing the exception be rethrown so that LOG4NET can log there is a problem on the api end point
throw ex;
}
}
//Broacasts to all clients
public void CheckOutBook(BookLender bookLender)
{
try
{
BookBorrowResult bookBorrowResult = new BookBorrowResult();
if (bookLender == null ||
string.IsNullOrWhiteSpace(bookLender.BookISBN) ||
string.IsNullOrWhiteSpace(bookLender.FriendName) ||
string.IsNullOrWhiteSpace(bookLender.BorrowDate))
{
bookBorrowResult.Status = "Validation Error";
}
else
{
_iBookService.CreateBookLender(bookLender);
bookBorrowResult.Status = "Success";
bookBorrowResult.BookISBN = bookLender.BookISBN;
}
Clients.All.CheckOutBookResult(bookBorrowResult);
}
catch (Exception ex)
{
//Log this error ex
//This is done to allow the exception to flow to client for error notification
throw new HubException();
}
}
public JsonResult CreateBookLender(BookLender bookLender)
{
_iBookService.CreateBookLender(bookLender);
return(new JsonResult()
{
Data = string.Format("{0} was successfully saved.", bookLender.FriendName)
});
}
public void CreateBookLender(BookLender bookLender)
{
try
{
_bookRepository.CreateBookLender(bookLender);
}
catch (Exception ex)
{
//TODO: Log this the exception information along with the method details to the database for Error tracing
//Allowing the exception be rethrown so that LOG4NET can log there is a problem on the api end point
throw ex;
}
}
public void CreateBookLender(BookLender bookLender, IDbCommand command)
{
//This proc will go find the book id by the isbn number and then use that when creating a new lender
command.CommandText = @"exec [dbo].[CreateBookLender]
@LenderName
,@BookISBN
,@DateLent
,@Comment";
var parameter = command.CreateParameter();
parameter.ParameterName = "@LenderName";
parameter.DbType = DbType.String;
parameter.Value = bookLender.FriendName;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@BookISBN";
parameter.DbType = DbType.String;
parameter.Value = bookLender.BookISBN;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@DateLent";
parameter.DbType = DbType.Date;
parameter.Value = bookLender.BorrowedDateTime;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@Comment";
parameter.DbType = DbType.String;
parameter.Value = bookLender.Comments;
command.Parameters.Add(parameter);
command.ExecuteNonQuery();
}
