/// <summary>
/// Populate DB with retailers.
/// </summary>
/// <param name="context">
/// The context.
/// </param>
/// <param name="fileStorage">
/// The file storage.
/// </param>
public static void Populate(ShopAnyWareSql context, IFileStorage fileStorage)
{
var path = fileStorage.MapPath("~/App_Data/retailers.xls");
var retailersExcel = ExcelHelper.LoadRetailersFromExcelFile(path);
var retailers = retailersExcel.Select(r => new Retailer(r.Url)).ToList();
var retailers2 = retailers.Where(r => string.IsNullOrWhiteSpace(r.Url) == false).ToList();
retailers2.ForEach(r => context.Retailers.Add(r));
context.SaveChanges();
}
