private void HandleUpdateBookConditionRequest(SendMessage send, UpdateBookConditionRequest m)
{
if (!IsAdmin(m.Payload.Email))
{
_logger("Did not update condition.");
send(new UpdateBookConditionResponse(false));
return;
}
using (SqlConnection conn = new SqlConnection(_connection))
{
conn.Open();
SqlCommand comm = conn.CreateCommand();
SqlTransaction trans = conn.BeginTransaction();
comm.Connection = conn;
comm.Transaction = trans;
try
{
InitializeUpdateBookConditionCommand(ref comm, m);
comm.ExecuteNonQuery();
trans.Commit();
_logger("Successfully updated description.");
send(new UpdateBookConditionResponse(true));
}
catch (Exception ex)
{
_logger(ex.ToString());
}
}
}
private void InitializeUpdateBookConditionCommand(ref SqlCommand c, UpdateBookConditionRequest m)
{
c.CommandType = System.Data.CommandType.StoredProcedure;
c.CommandText = "Book.UpdateBookQuality";
SqlParameter bookID = new SqlParameter("@BookID", System.Data.SqlDbType.Int);
bookID.Direction = System.Data.ParameterDirection.Input;
bookID.Value = m.Payload.BookID;
SqlParameter desc = new SqlParameter("@NewDescriptor", System.Data.SqlDbType.NVarChar, 32);
desc.Direction = System.Data.ParameterDirection.Input;
desc.Value = m.Payload.Condition;
c.Parameters.Add(bookID);
c.Parameters.Add(desc);
}
