/// <summary> /// /// </summary> /// <param name="_config"></param> /// <param name="_cache"></param> public ImportService(SDSComContext _db, IMemoryCache _cache) : base(_db, _cache) { db = _db; cache = _cache; sSvc = new SchemaService(db, cache); tSvc = new TemplateService(db, cache); }
/// <summary> /// /// </summary> public void CreateDBObjects() { List <Facet> facets = new List <Facet>(); List <Facet> facetsDE = new List <Facet>(); List <FacetRestriction> facetsRest = new List <FacetRestriction>(); List <FacetRestriction> facetsRestDE = new List <FacetRestriction>(); var allAS = db.Set <ApplicationSetting>(); db.AppSettings.RemoveRange(allAS); var allE = db.Set <Entity>(); db.Entities.RemoveRange(allE); var allET = db.Set <EntityType>(); db.EntityTypes.RemoveRange(allET); var allDSFI = db.Set <DataSheetFeedImport>(); db.Imports.RemoveRange(allDSFI); var allF = db.Set <Facet>(); db.Facets.RemoveRange(allF); var allFR = db.Set <FacetRestriction>(); db.FacetRestrictions.RemoveRange(allFR); var allV = db.Set <ValidationMessage>(); db.ValidationMessages.RemoveRange(allV); var allU = db.Set <User>(); db.Users.RemoveRange(allU); db.SaveChanges(); SchemaService sSvc = new SchemaService(db, cache); //========================================================================================================= facets = sSvc.GetSchemas(); facetsRest = sSvc.GetDataTypes(facets, "SDSComXMLDT.xsd"); //========================================================================================================= facetsDE = sSvc.GetExtensions(); facetsRestDE = sSvc.GetDataTypes(facetsDE, "SDSComXMLNE_DE.xsd"); //========================================================================================================= sSvc.CreateFacets(facets); sSvc.CreateFacets(facetsDE); sSvc.CreateFacetRestrictionss(facetsRest); sSvc.CreateFacetRestrictionss(facetsRestDE); //========================================================================================================= db.Entities.Add(new Entity { Active = true, DateStamp = DateTime.Now, UserId = 1, EntityName = "TestProduct 1", EntityType = 1, OtherId = "TestProd1" }); db.Entities.Add(new Entity { Active = true, DateStamp = DateTime.Now, UserId = 1, EntityName = "TestProduct 2", EntityType = 1, OtherId = "TestProd2" }); db.Entities.Add(new Entity { Active = true, DateStamp = DateTime.Now, UserId = 1, EntityName = "TestComponent 1", EntityType = 2, OtherId = "TestComp1" }); db.Entities.Add(new Entity { Active = true, DateStamp = DateTime.Now, UserId = 1, EntityName = "TestComponent 2", EntityType = 2, OtherId = "TestComp2" }); //=========================================================================================== db.EntityTypes.Add(new EntityType { EntityTypeName = "Product" }); db.EntityTypes.Add(new EntityType { EntityTypeName = "Component" }); db.EntityTypes.Add(new EntityType { EntityTypeName = "Company" }); //=========================================================================================== db.AppSettings.Add(new ApplicationSetting { Area = "DEFAULT", Setting = "XmlStandardVersionNo", DataValue = "4.2.0" }); db.AppSettings.Add(new ApplicationSetting { Area = "ADMIN", Setting = "CompanyName", DataValue = "Test Company" }); db.AppSettings.Add(new ApplicationSetting { Area = "ADMIN", Setting = "StartDate", DataValue = "12/1/2017" }); //=========================================================================================== db.Users.AddRange(new User { Active = true, CreateDate = DateTime.Now, FirstName = "First 1", LastName = "Last 1", Password = "******", UpdateDate = DateTime.Now, UserName = "******", Email = "*****@*****.**", IsAdmin = true }, new User { Active = true, CreateDate = DateTime.Now, FirstName = "First 2", LastName = "Last 2", Password = "******", UpdateDate = DateTime.Now, UserName = "******", Email = "*****@*****.**", IsAdmin = false } , new User { Active = true, CreateDate = DateTime.Now, FirstName = "First 3", LastName = "Last 3", Password = "******", UpdateDate = DateTime.Now, UserName = "******", Email = "*****@*****.**", IsAdmin = false }); db.SaveChanges(); //=========================================================================================== }