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));
}
