public virtual void PopulateEntities() { FAASModel _context = new FAASModel(); log.Log("Extract Entities to DB - start"); try { foreach (Entity item in _entity) { _context.Entities.Add(item); } _context.SaveChanges(); log.Log("Extract Entities to DB - complete"); } catch (Exception e) { log.Log(string.Format("Erorr extracting Entities to DB: {0}", e.Message)); } }
private void UpdateUnmappedEntities() { FAASModel _context = new FAASModel(); log.Log("Persist unmapped entity units to DB - start"); _entities = _context.Entities.ToList(); foreach (Entity entity in _entities) { if (entity.NormalisedUnit.ToString().Equals("N/A")) { entity.NormalisedUnit = "LONELY"; } } //need to persist to DB _context.SaveChanges(); log.Log("Persist unmapped entity units to DB - complete"); var count = (from x in _context.Entities where x.NormalisedUnit == "LONELY" select x).Count(); log.Log(string.Format("{0} entities Unallocated", count)); }
private void UpdateMappedEntities() { FAASModel _context = new FAASModel(); log.Log("Persist mapped entity units to DB - start"); _entities = _context.Entities.ToList(); foreach (EntityMap mappedEntity in _mappedEntities) { foreach (Entity entity in _entities) { foreach (string type in _types) { if (mappedEntity.Name.Equals(entity.Name) && mappedEntity.Type.Equals(type)) { entity.NormalisedUnit = mappedEntity.NormalisedUnit; } } } } _context.SaveChanges(); log.Log("Persist mapped entity units to DB - complete"); var count = (from x in _context.Entities where x.NormalisedUnit != "N/A" && x.NormalisedUnit != "LONELY" select x).Count(); log.Log(string.Format("{0} entities Normalised", count)); }
private void PopulateInterfaces() { FAASModel _context = new FAASModel(); log.Log("Persits Interfaces to DB - start"); try { foreach (Interface item in _interfaces) { _context.Interfaces.Add(item); } _context.SaveChanges(); log.Log("Persist Interfaces to DB - complete"); log.Log(string.Format("{0} interfaces created", _interfaces.Count())); } catch (Exception e) { log.Log(string.Format("Error persisting Intefaces to DB: {0}: ", e.Message)); } }
private void PopulateBuckets() { FAASModel _context = new FAASModel(); log.Log("Persits Buckets to DB - start"); try { foreach (Bucket item in _buckets) { _context.Buckets.Add(item); } _context.SaveChanges(); log.Log("Persist Buckets to DB - complete"); log.Log(string.Format("{0} buckets created", _buckets.Count())); } catch (Exception e) { log.Log(string.Format("Error persisting Buckets to DB: {0}: ", e.Message)); } }
private void PopulateEntityRelationships() { FAASModel _context = new FAASModel(); log.Log("Persist Entity Relationship to DB - start"); try { foreach (EntityRelationship item in _entityRelations) { _context.EntityRelationships.Add(item); } _context.SaveChanges(); log.Log("Persist Entity Relationship to DB - complete"); log.Log(string.Format("{0} entity relationships created", _entityRelations.Count())); } catch (Exception e) { log.Log(string.Format("Error persisting Entity Relationship to DB: {0}", e.Message)); } }
private void PopulateFunctions() { FAASModel _context = new FAASModel(); log.Log("Persist Function Definitions to DB - start"); try { foreach (FunctionDefinition item in _functions) { _context.FunctionDefinitions.Add(item); } _context.SaveChanges(); log.Log("Persist Function Definitions to DB - complete"); } catch (DbEntityValidationException e) { log.Log(string.Format("Error persisting Function Definitions to DB: {0}", e.Message)); foreach (var eve in e.EntityValidationErrors) { log.Log(string.Format("Entity of type \"{0}\" in state \"{1}\" has the following validations errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State)); foreach (var xxx in eve.ValidationErrors) { log.Log(string.Format(" - Property: \"{0}\", Error: \"{1}\"", xxx.PropertyName, xxx.ErrorMessage)); } } } }
private void PopulatePackages() { FAASModel _context = new FAASModel(); log.Log("Persist Package Definitions to DB - start"); try { foreach (PackageDefinition item in _packages) { _context.PackageDefinitions.Add(item); } _context.SaveChanges(); log.Log("Persist Package Definitions to DB - complete"); } catch (DbEntityValidationException e) { log.Log(string.Format("Error persisting Package Definitions to DB: {0}", e.Message)); foreach (var validationErrors in e.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } } }
private void PopulateRules() { FAASModel _context = new FAASModel(); log.Log("Persist Rule Definitions to DB - start"); try { foreach (RuleDefinition item in _rules) { _context.RuleDefinitions.Add(item); } _context.SaveChanges(); log.Log("Persist Rule Definitions to DB - complete"); } catch (Exception e) { log.Log(string.Format("Error persisting Rule Definitions to DB: {0}", e.Message)); } }
public void ClearTable(string table) { FAASModel _context = new FAASModel(); try { _context.Database.ExecuteSqlCommand(string.Format("truncate table {0}", table)); _context.SaveChanges(); log.Log(string.Format("{0} table cleared", table)); } catch (Exception e) { log.Log(string.Format("Error clearing {0} table in DB: {1}", table, e.Message)); } }
private void PopulateTables() { FAASModel _context = new FAASModel(); log.Log("Persist Table Definitions to DB - start"); try { foreach (TableDefinition item in _tables) //Parallel.ForEach(_tables, item => { _context.TableDefinitions.Add(item); } // ); _context.SaveChanges(); log.Log("Persist Table Definitions to DB - complete"); } catch (Exception e) { log.Log(string.Format("Error persisting Table Definitions to DB: {0}: ", e.Message)); } }
private void PopulateTriggers() { FAASModel _context = new FAASModel(); log.Log("Persist Triggers to DB - start"); try { foreach (TriggerDefinition item in _triggers) { _context.TriggerDefinitions.Add(item); _context.SaveChanges(); } log.Log("Persist Triggers to DB - complete"); } catch (Exception e) { log.Log(string.Format("Error persisting Triggers Definitions to DB: {0}: ", e.Message)); } }
private void PopulateInterfaceReporting(ConsoleLog log) { FAASModel _context = new FAASModel(); log.Log("Persist Interface Reports to DB - start"); try { foreach (InterfaceReporting item in _interfaceReports) { _context.InterfaceReportings.Add(item); } _context.SaveChanges(); log.Log("Persist Interface Reports to DB - complete"); log.Log(string.Format("{0} Interfaces assessed", _interfaceReports.Count)); } catch (Exception e) { log.Log(string.Format("Error persisting Interface Reports to DB: {0}: ", e.Message)); } }
private void PopulateEntityResidence(ConsoleLog log) { FAASModel _context = new FAASModel(); log.Log("Persist entity ownership strength to DB - start"); try { foreach (EntityResidence item in _entStr) { _context.EntityResidences.Add(item); } _context.SaveChanges(); log.Log("Persist entity ownership strength to DB - complete"); log.Log(string.Format("{0} entities assessed", _entities.Count)); } catch (Exception e) { log.Log(string.Format("Error persisting entity ownership strength to DB: {0}: ", e.Message)); } }
private void PopulateBucketConnections(ConsoleLog log) { FAASModel _context = new FAASModel(); log.Log("Persist Bucket Connections to DB - start"); try { foreach (BucketConnection item in _bucketConnections) { _context.BucketConnections.Add(item); } _context.SaveChanges(); log.Log("Persist Bucket Connections to DB - complete"); log.Log(string.Format("{0} bucket to bucket connections assessed", _bucketConnections.Count)); } catch (Exception e) { log.Log(string.Format("Error persisting Bucket Connections to DB: {0}: ", e.Message)); } }