private void HandleViewCheckedoutRequest(SendMessage send, ViewCheckedoutRequest m)
{
using (SqlConnection conn = new SqlConnection(_connection))
{
conn.Open();
SqlCommand comm = conn.CreateCommand();
SqlTransaction trans = conn.BeginTransaction();
comm.Connection = conn;
comm.Transaction = trans;
try
{
InitializeViewCheckedoutCommand(ref comm, m);
List <CheckedoutBook> l = new List <CheckedoutBook>();
GrabViewCheckedout(comm, ref l);
_logger("Successfully found " + l.Count + " checked out books for user " + m.Payload.Email);
send(new ViewCheckedoutResponse(l));
}
catch (Exception ex)
{
_logger(ex.ToString());
}
}
}
private void InitializeViewCheckedoutCommand(ref SqlCommand c, ViewCheckedoutRequest m)
{
c.CommandType = System.Data.CommandType.StoredProcedure;
c.CommandText = "Book.GetUserCheckedOutBooks";
c.Parameters.AddWithValue("@Email", m.Payload.Email);
}
