public void UpdateStagingEbayLoadBatch(StagingEbayBatchImport batch, bool commit = false)
{
istgEbayBatchImportsRepository.Update(batch);
if (commit)
{
istgEbayBatchImportsRepository.SaveChanges();
}
}
private void SetBatchDefaults(StagingEbayBatchImport stagingEbayBatchImport)
{
if (stagingEbayBatchImport != null)
{
stagingEbayBatchImport.StartedOn = DateTime.Now;
stagingEbayBatchImport.InProcess = true;
stagingEbayBatchImport.TotalKeywordMatched = 0;
stagingEbayBatchImport.ToBeProcessed = 0;
stagingEbayBatchImport.Auctions = 0;
stagingEbayBatchImport.AuctionsWithBIN = 0;
stagingEbayBatchImport.Classified = 0;
stagingEbayBatchImport.FixedPrice = 0;
stagingEbayBatchImport.StoreInventory = 0;
stagingEbayBatchImport.Failed = 0;
stagingEbayBatchImport.Duplicates = 0;
stagingEbayBatchImport.Imported = 0;
stagingEbayBatchImport.NoListingType = 0;
}
}
private void UpdateCounts(StagingEbayItem stagingEbayItem, StagingEbayBatchImport stagingEbayBatchImport)
{
/***ebay Listing Type values
**AdFormat
* Advertisement to solicit inquiries on listings such as real estate. Permits no bidding on that item, service, or property. To express interest, a buyer fills out a contact form that eBay forwards to the seller as a lead. This format does not enable buyers and sellers to transact online through eBay and eBay Feedback is not available for ad format listings.
**Auction
* Competitive-bid on-line auction format. Buyers engage in competitive bidding, although Buy It Now may be offered as long as no valid bids have been placed. Online auctions are listed on eBay.com; they can also be listed in a seller's eBay Store if the seller is a Store owner.
**AuctionsWithBIN
* Same as Auction format, but Buy It Now is enabled. AuctionsWithBIN changes to Auction if a valid bid has been placed on the item. Valid bids include bids that are equal to or above any specified reserve price.
**Classified
* Classified Ads connect buyers and sellers, who then complete the sale outside of eBay. This format does not enable buyers and sellers to transact online through eBay and eBay Feedback is not available for these listing types.
**FixedPrice
* A fixed-price listing. Auction-style bidding is not allowed. On some sites, this auction format is also known as "Buy It Now Only" (not to be confused with the Buy It Now option available with competitive- bidding auctions). Fixed-price listings appear on eBay.com; they can also be listed in a seller's eBay Store if the seller is a Store owner.
***/
switch (stagingEbayItem.ListingInfoListingType.ToLower())
{
case EbayListingTypeAuctionInLower:
stagingEbayBatchImport.Auctions++;
break;
case EbayListingTypeAuctionWithBinInLower:
stagingEbayBatchImport.AuctionsWithBIN++;
break;
case EbayListingTypeClassifiedInLower:
stagingEbayBatchImport.Classified++;
break;
case EbayListingTypeFixedPriceInLower:
stagingEbayBatchImport.FixedPrice++;
break;
case EbayListingTypeStoreInventory:
stagingEbayBatchImport.StoreInventory++;
break;
}
stagingEbayBatchImport.Imported++;
}
public static StagingEbayBatchImportModel CreateFrom(this StagingEbayBatchImport source)
{
var hostURL = "http://" + HttpContext.Current.Request.Url.Host.ToLower() + "/";//ConfigurationManager.AppSettings["HostURL"];
var oModel = new StagingEbayBatchImportModel
{
Auctions = source.Auctions,
CompletedOn = source.CompletedOn != null?source.CompletedOn.Value.ToShortDateString() : "",
CreatedOn = source.CreatedOn != null?source.CreatedOn.Value.ToShortDateString() : "",
EbayBatchImportId = @"<a title='Click to open items imported for this batch' href='" + hostURL + "Admin/EbayItemImportLV?vpek=" + source.EbayBatchImportId + "' target='_blank'> " + source.EbayBatchImportId + "</a>",
EbayTimestamp = source.EbayTimestamp != null?source.EbayTimestamp.Value.ToShortDateString() : "",
EbayVersion = source.EbayVersion,
Failed = source.Failed,
FixedPrice = source.FixedPrice,
Imported = source.Imported,
InProcess = source.InProcess ?"Yes":"No",
StartedOn = source.StartedOn != null?source.StartedOn.Value.ToShortDateString() : "",
Deleted = source.Deleted,
DeletedBy = source.DeletedBy,
DeletedOn = source.DeletedOn
};
return(oModel);
}
private void ProcessEbayLoad(ILogger logger, string userId)
{
logger.Write(String.Format("Starting the ebay load for user Id = {0}", userId),
LoggerCategories.Information, 0, 0,
TraceEventType.Information,
startEbayLoadMessage,
new Dictionary <string, object>());
using (
var stagingEbayLoadService =
UnityConfig.GetConfiguredContainer().Resolve <IStagingEbayLoadService>())
{
logger.Write(String.Format("ebay load service instantiated for user Id = {0}", userId),
LoggerCategories.Information, 0, 0,
TraceEventType.Information,
startEbayLoadMessage,
new Dictionary <string, object>());
#region 'Check if an ebay load can run'
//Check if a new ebay batch load can run (valid only where there is no ebay load currently running)
if (!stagingEbayLoadService.CanExecuteEbayLoad())
{
//Cannot execute a new ebay batch load
//Log the error
logger.Write(EbayLoadProcessingFault.FaultMessageBatchAlreadyRunning,
LoggerCategories.Error, 0, 0,
TraceEventType.Error,
startEbayLoadMessage,
new Dictionary <string, object>());
//User does not have an administrator role
throw new FaultException <EbayLoadProcessingFault>(
new EbayLoadProcessingFault {
ErrorDetails = EbayLoadProcessingFault.FaultCodeBatchAlreadyRunning, ErrorMessage = EbayLoadProcessingFault.FaultMessageBatchAlreadyRunning, Result = false
},
new FaultReason(new FaultReasonText(EbayLoadProcessingFault.FaultMessageBatchAlreadyRunning)), new FaultCode(EbayLoadProcessingFault.FaultCodeBatchAlreadyRunning));
}
#endregion 'Check if an ebay load can run'
//Create a new ebay load batch record
StagingEbayBatchImport stagingEbayBatchImport = stagingEbayLoadService.CreateStagingEbayLoadBatch(userId);
//Check if a ebay load batch has been created
if (stagingEbayBatchImport == null)
{
logger.Write(EbayLoadProcessingFault.FaultMessageBatchWasNotCreated,
LoggerCategories.Error, 0, 0,
TraceEventType.Critical,
startEbayLoadMessage,
new Dictionary <string, object>());
//User does not have an administrator role
throw new FaultException <EbayLoadProcessingFault>(
new EbayLoadProcessingFault {
ErrorDetails = EbayLoadProcessingFault.FaultCodeBatchWasNotCreated, ErrorMessage = EbayLoadProcessingFault.FaultMessageBatchWasNotCreated, Result = false
},
new FaultReason(new FaultReasonText(EbayLoadProcessingFault.FaultMessageBatchWasNotCreated)), new FaultCode(EbayLoadProcessingFault.FaultCodeBatchWasNotCreated));
}
//Set ebay batch load records default values
SetBatchDefaults(stagingEbayBatchImport);
//Update the ebay batch load record with respective data
stagingEbayLoadService.UpdateStagingEbayLoadBatch(stagingEbayBatchImport, true);
//ebay Finding API client configuration
var config = new ClientConfig
{
// Finding API service end-point configuration
EndPointAddress = ConfigurationManager.AppSettings["EbayFindingAPIEndPointAddress"],
// eBay developer account AppID
ApplicationId = ConfigurationManager.AppSettings["EbayFindindAPIApplicationId"],
// timeout value for this call
HttpTimeout = 1500000 //25 minutes
};
//ebay Finding API client service
FindingServicePortTypeClient findingServicePortTypeClient = FindingServiceClientFactory.getServiceClient(config);
//ebay finding API request
var request = new FindItemsByKeywordsRequest
{
keywords = ConfigurationManager.AppSettings["EbayFindingApiKeywords"]
};
#region 'ebay Finding API Request Filters'
var itemFilters = new List <ItemFilter>
{
new ItemFilter
{
name = ItemFilterType.AvailableTo,
value = new[] { ConfigurationManager.AppSettings["EbayAvailableToItemFilter"] }
}
};
//Get the ebay ISO8601 datetime format from web.config settings
string iso8601DatetimeFormat = ConfigurationManager.AppSettings["EbayISO8601DateTimeFormat"];
//Get the start time filter from database for when this ebay batch load was run last
string ebayLoadStartTimeFromConfiguration = stagingEbayLoadService.GetEbayLoadStartTimeFrom();
if (!String.IsNullOrWhiteSpace(ebayLoadStartTimeFromConfiguration))
{
itemFilters.Add(new ItemFilter
{
name = ItemFilterType.StartTimeFrom,
value =
new[]
{
//TODO: have to remove this filter below
(Convert.ToDateTime(ebayLoadStartTimeFromConfiguration)).AddMinutes(-20).ToString(iso8601DatetimeFormat)
//DateTime.Now.AddDays(-1).AddMinutes(-20).ToString(iso8601DatetimeFormat)
}
});
}
request.itemFilter = itemFilters.ToArray();
#endregion 'ebay Finding API Request Filters'
//Call the Finding service's Find Items By Keyword method
FindItemsByKeywordsResponse check = findingServicePortTypeClient.findItemsByKeywords(request);
DateTime ebayCheckTime = DateTime.UtcNow;
if (check == null)
{
logger.Write(EbayLoadProcessingFault.FaultMessageFindItemBykeywordResposeIsNull,
LoggerCategories.Error, 1, 0,
TraceEventType.Critical,
startEbayLoadMessage,
new Dictionary <string, object>());
//Find item response is ready
throw new FaultException <EbayLoadProcessingFault>(
new EbayLoadProcessingFault {
ErrorDetails = EbayLoadProcessingFault.FaultCodeFindItemBykeywordResposeIsNull, ErrorMessage = EbayLoadProcessingFault.FaultMessageFindItemBykeywordResposeIsNull, Result = false
},
new FaultReason(new FaultReasonText(EbayLoadProcessingFault.FaultMessageFindItemBykeywordResposeIsNull)), new FaultCode(EbayLoadProcessingFault.FaultCodeFindItemBykeywordResposeIsNull));
}
if (check.ack == AckValue.Failure || check.ack == AckValue.PartialFailure)
{
logger.Write(EbayLoadProcessingFault.FaultMessageFindItemBykeywordReturnedFailure + "Failure details: " + check.errorMessage,
LoggerCategories.Error, 1, 0,
TraceEventType.Critical,
startEbayLoadMessage,
new Dictionary <string, object>());
//Find item response has a failure
throw new FaultException <EbayLoadProcessingFault>(
new EbayLoadProcessingFault {
ErrorDetails = EbayLoadProcessingFault.FaultCodeFindItemBykeywordReturnedFailure, ErrorMessage = EbayLoadProcessingFault.FaultMessageFindItemBykeywordReturnedFailure, Result = false
},
new FaultReason(new FaultReasonText(EbayLoadProcessingFault.FaultMessageFindItemBykeywordReturnedFailure)), new FaultCode(EbayLoadProcessingFault.FaultCodeFindItemBykeywordReturnedFailure));
}
int totalKeywordMatchedItems = check.paginationOutput.totalEntries;
var totalPages = (int)Math.Ceiling(totalKeywordMatchedItems / 100.00);
stagingEbayBatchImport.TotalKeywordMatched = totalKeywordMatchedItems;
stagingEbayBatchImport.EbayVersion = findingServicePortTypeClient.getVersion(new GetVersionRequest()).version;
logger.Write(
String.Format(
"ebay Finding Service - findItemsByKeywords call (user id = {0}, batch id = {1}) for selected filters has Total={2} items, Total Pages (ebay default 100 items each)={3}",
userId, stagingEbayBatchImport.EbayBatchImportId, totalKeywordMatchedItems, totalPages),
LoggerCategories.Information, 0, 0,
TraceEventType.Information,
startEbayLoadMessage,
new Dictionary <string, object>());
for (int curPage = 1; curPage <= totalPages; curPage++)
{
request.paginationInput = new PaginationInput
{
entriesPerPageSpecified = true,
entriesPerPage = 100,
pageNumberSpecified = true,
pageNumber = curPage,
};
FindItemsByKeywordsResponse response =
findingServicePortTypeClient.findItemsByKeywords(request);
if (response != null &&
(response.searchResult.item != null && response.searchResult.item.Length > 0))
{
IEnumerable <SearchItem> searchItems =
response.searchResult.item.Where(EBayGlobalIdUsStore).DistinctBy(i => i.itemId);
foreach (SearchItem ebaySearchItem in searchItems)
{
stagingEbayBatchImport.ToBeProcessed++;
StagingEbayItem stagingEbayItem;
if (stagingEbayLoadService.EbayItemExists(ebaySearchItem.itemId, out stagingEbayItem))
{
stagingEbayBatchImport.Duplicates++;
stagingEbayBatchImport.Failed++;
logger.Write(
String.Format(
"ebay Finding Service - item (ebay item id = {2}) already exists (user id = {0}, batch id = {1})",
userId, stagingEbayBatchImport.EbayBatchImportId, ebaySearchItem.itemId),
LoggerCategories.Warning, 0, 0,
TraceEventType.Warning,
startEbayLoadMessage,
new Dictionary <string, object>());
continue;
}
if ((ebaySearchItem.listingInfo == null ||
String.IsNullOrWhiteSpace(ebaySearchItem.listingInfo.listingType)))
{
stagingEbayBatchImport.NoListingType++;
stagingEbayBatchImport.Failed++;
logger.Write(
String.Format(
"ebay Finding Service - item (ebay item id = {2}) has no listing type (user id = {0}, batch id = {1})",
userId, stagingEbayBatchImport.EbayBatchImportId, ebaySearchItem.itemId),
LoggerCategories.Error, 0, 0,
TraceEventType.Error,
startEbayLoadMessage,
new Dictionary <string, object>());
continue;
}
stagingEbayItem = CreateStagingEbayItem(stagingEbayLoadService, ebaySearchItem,
stagingEbayBatchImport.EbayBatchImportId, ebayCheckTime, userId);
UpdateCounts(stagingEbayItem, stagingEbayBatchImport);
}
}
//Page processed log entry
logger.Write(
String.Format("Items page {2} completed (user id = {0}, batch id = {1})", userId,
stagingEbayBatchImport.EbayBatchImportId, curPage),
LoggerCategories.Information, 0, 0,
TraceEventType.Information,
startEbayLoadMessage,
new Dictionary <string, object>());
}
stagingEbayLoadService.UpsertEbayLoadStartTimeFromConfiguration(ebayCheckTime);
//Set ebay batch completion data
stagingEbayBatchImport.CompletedOn = DateTime.Now;
stagingEbayBatchImport.InProcess = false;
stagingEbayLoadService.UpdateStagingEbayLoadBatch(stagingEbayBatchImport, true);
//Page processed log entry
logger.Write(String.Format("ebay batch load completed (user id = {0}, batch id = {1}), Summary: TotalKeywordMatched={2}, ToBeProcessed={3}, Failed={4}, Duplicated={11}, Imported={5}, " +
"Auctions={6}, AuctionsWithBIN={7}, Classified={8}, FixedPrice={9}, StoreInventory={10}",
userId, stagingEbayBatchImport.EbayBatchImportId, stagingEbayBatchImport.TotalKeywordMatched, stagingEbayBatchImport.ToBeProcessed,
stagingEbayBatchImport.Failed, stagingEbayBatchImport.Imported, stagingEbayBatchImport.Auctions, stagingEbayBatchImport.AuctionsWithBIN,
stagingEbayBatchImport.Classified, stagingEbayBatchImport.FixedPrice, stagingEbayBatchImport.StoreInventory, stagingEbayBatchImport.Duplicates),
LoggerCategories.Information, 0, 0,
TraceEventType.Information,
startEbayLoadMessage,
new Dictionary <string, object>());
}
}
