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