private void AddCatalogTypes(CatalogDBContext context) { var preconfiguredTypes = useCustomizationData ? GetCatalogTypesFromFile() : PreconfiguredData.GetPreconfiguredCatalogTypes(); int sequenceId = GetSequenceIdFromSelectedDBSequence(context, DBCatalogSequenceName); foreach (var type in preconfiguredTypes) { type.Id = sequenceId; context.CatalogTypes.Add(type); sequenceId++; } context.SaveChanges(); }
private IEnumerable <CatalogType> GetCatalogTypesFromFile() { var contentRootPath = HostingEnvironment.ApplicationPhysicalPath; string csvFileCatalogTypes = Path.Combine(contentRootPath, "Setup", "CatalogTypes.csv"); if (!File.Exists(csvFileCatalogTypes)) { return(PreconfiguredData.GetPreconfiguredCatalogTypes()); } string[] csvheaders; string[] requiredHeaders = { "catalogtype" }; csvheaders = GetHeaders(csvFileCatalogTypes, requiredHeaders); return(File.ReadAllLines(csvFileCatalogTypes) .Skip(1) // skip header row .Select(x => CreateCatalogType(x)) .Where(x => x != null)); }