private static void CreateStandardStates(IConfiguration configuration, IQuiltContextFactory quiltContextFactory) { var text = AzureUtility.LoadAzureStringBlob(configuration, "database-load", "states.csv"); var lines = text.Split(new char[] { '\n', '\r' }, StringSplitOptions.RemoveEmptyEntries); using var ctx = quiltContextFactory.Create(); var dbCountry = ctx.Countries.Where(r => r.CountryCode == "US").SingleOrDefault(); if (dbCountry == null) { dbCountry = new Country() { CountryCode = "US", Name = "United States" }; _ = ctx.Countries.Add(dbCountry); } foreach (var line in lines) { var fields = line.Split(new char[] { ',' }); var stateCode = fields[0]; var name = fields[1]; var countryCode = fields[2]; CreateState(ctx, stateCode, name, countryCode); } _ = ctx.SaveChanges(); }
public static JToken AzureLoad(IConfiguration configuration, string name) { var text = AzureUtility.LoadAzureStringBlob(configuration, "libraries", string.Format("{0}.json", name)); var json = JToken.Parse(text); return(json); }
private static async Task CreateTestInventoryItemsAsync(IConfiguration configuration, IQuiltContextFactory quiltContextFactory, DateTime utcNow) { var unitOfMeasureCodes = new List <string> { UnitOfMeasureCodes.FatQuarter, UnitOfMeasureCodes.HalfYardage, UnitOfMeasureCodes.Yardage, UnitOfMeasureCodes.TwoYards, UnitOfMeasureCodes.ThreeYards }; var text = AzureUtility.LoadAzureStringBlob(configuration, "fabrics-default", "index.csv"); var lines = text.Split(new char[] { '\n', '\r' }, StringSplitOptions.RemoveEmptyEntries); foreach (var line in lines) { var fields = line.Split(new char[] { ',' }); var sku = fields[0]; var name = fields[1]; //var entry = library.GetEntry(sku); //if (entry == null) //{ var image = (Bitmap)AzureUtility.LoadAzureImageBlob(configuration, "fabrics-default", sku + ".jpg"); var averageColor = GetAverageColor(image); _ = await CreateEntryAsync( quiltContextFactory, sku, InventoryItemTypeCodes.Fabric, name, "Kona Cotton Solid", // Collection "Robert Kaufman", // Manufacturer (int)averageColor.GetHue(), (int)(averageColor.GetSaturation() * 100), (int)(averageColor.GetBrightness() * 100), unitOfMeasureCodes, TestPricingScheduleName, utcNow).ConfigureAwait(false); //} } }