/// <summary>
        /// Handles the specified command.
        /// </summary>
        /// <param name="command">The command.</param>
        public void Handle(HmrcProcessUploadedFilesCommand command)
        {
            InfoAccumulator info = Validate(command);

            if (info.HasErrors)
            {
                SendReply(info, command);
                return;
            }

            var vatReturns = ParseVatReturns(command.Files, info);

            if (info.HasErrors)
            {
                SendReply(info, command);
                return;
            }

            int      customerId = int.Parse(EncryptionUtils.SafeDecrypt(command.CustomerId));
            Customer customer   = CustomerQueries.GetCustomerById(customerId);

            info = MarketPlaceQueries.ValidateCustomerMarketPlace(HmrcInternalId, customer.Name);
            if (info.HasErrors)
            {
                SendReply(info, command);
                return;
            }

            AccountModel hmrcAccountModel = new AccountModel {
            };                                                   //TODO check it out what to put here


            byte[] securityData = SerializationUtils.SerializeToBinaryXml(hmrcAccountModel);
            securityData = EncryptionUtils.Encrypt(securityData);

            int marketplaceId = (int)MarketPlaceQueries.CreateNewMarketPlace(customerId, customer.Name, securityData, HmrcInternalId);

            if (marketplaceId < 1)
            {
                string msg = string.Format("could not create marketplace for customer {0}", command.CustomerId); //writes encrypted customer id
                Log.Error(msg);
                throw new Exception(msg);
            }

            var updateHistory = new CustomerMarketPlaceUpdateHistory()
            {
                CustomerMarketPlaceId = marketplaceId,
                UpdatingStart         = DateTime.UtcNow
            };

            int marketPlaceHistoryId = (int)MarketPlaceQueries.UpsertMarketPlaceUpdatingHistory(updateHistory);

            if (marketPlaceHistoryId < 1)
            {
                string message = string.Format("could not upsert marketplace history for customer: {0}", command.CustomerId);
                Log.Error(message);
                throw new Exception(message);
            }


            bool res = HmrcQueries.SaveVatReturns(vatReturns, null, marketplaceId, marketPlaceHistoryId);

            if (!res)
            {
                throw new Exception("could not save vat returns");
            }

            updateHistory = new CustomerMarketPlaceUpdateHistory()
            {
                CustomerMarketPlaceId = marketplaceId,
                UpdatingEnd           = DateTime.UtcNow
            };

            marketPlaceHistoryId = (int)MarketPlaceQueries.UpsertMarketPlaceUpdatingHistory(updateHistory);
            if (marketPlaceHistoryId < 1)
            {
                throw new Exception("could not save marketplace history");
            }

            SendReply(info, command);
        }