private void FragancexSQLPreparer(ServiceTimeStamp service)
{
var upc = _context.UPC.ToDictionary(x => x.ItemID, y => y.Upc);
try
{
var listingApiClient = new FrgxListingApiClient("346c055aaefd", "a5574c546cbbc9c10509e3c277dd7c7039b24324");
// For testing purposes
//List<Product> allProducts = new List<Product>();
//var product = listingApiClient.GetProductById("412492");
//allProducts.Add(product);
var allProducts = listingApiClient.GetAllProducts();
DBModifierFragrancexAPI dBModifierFragrancexAPI = new DBModifierFragrancexAPI("", upc)
{
allProducts = allProducts
};
dBModifierFragrancexAPI.TableExecutor();
// delete everything from the db, then update
using (var tran = _context.Database.BeginTransaction())
{
_context.BulkDelete(_context.Wholesaler_Fragrancex.ToList());
tran.Commit();
}
using (var tran = _context.Database.BeginTransaction())
{
_context.BulkInsertOrUpdate(dBModifierFragrancexAPI.fragrancex);
tran.Commit();
}
service.TimeStamp = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow
, TimeZoneInfo.FindSystemTimeZoneById("Eastern Standard Time"));
service.Wholesalers = Wholesalers.Fragrancex.ToString();
service.type = "API";
_context.ServiceTimeStamp.Add(service);
_context.SaveChanges();
}
catch (Exception e)
{
throw e;
}
}
private void FragancexSQLPreparer(ServiceTimeStamp service)
{
var upc = _context.UPC.ToDictionary(x => x.ItemID, y => y.Upc);
// TODO: Test this functionality once Alex is done with his development!!
try
{
var listingApiClient = new FrgxListingApiClient("346c055aaefd", "a5574c546cbbc9c10509e3c277dd7c7039b24324");
// For testing purposes
//List<Product> allProducts = new List<Product>();
//var product = listingApiClient.GetProductById("412492");
//allProducts.Add(product);
var allProducts = listingApiClient.GetAllProducts();
DBModifierFragrancexAPI dBModifierFragrancexAPI = new DBModifierFragrancexAPI("", upc)
{
allProducts = allProducts
};
dBModifierFragrancexAPI.TableExecutor();
service.TimeStamp = DateTime.Today;
service.Wholesalers = Wholesalers.Fragrancex.ToString();
service.type = "API";
_context.ServiceTimeStamp.Add(service);
_context.SaveChanges();
}
catch (Exception e)
{
}
}
