private nHydrate.Generator.Common.Models.ModelRoot CreatePOCOModel(nHydrateModel model, Microsoft.VisualStudio.Modeling.Diagrams.Diagram diagram)
{
try
{
var root = new nHydrate.Generator.Common.Models.ModelRoot(null);
root.EnableCustomChangeEvents = model.EmitChangeScripts;
root.CompanyName = model.CompanyName;
root.EmitSafetyScripts = model.EmitSafetyScripts;
root.DefaultNamespace = model.DefaultNamespace;
root.ProjectName = model.ProjectName;
root.SupportLegacySearchObject = false;
root.UseUTCTime = model.UseUTCTime;
root.Version = model.Version;
root.Database.ResetKey(model.Id.ToString());
root.OutputTarget = string.Empty; //model.OutputTarget;
//These have the same mapping values flags so we need convert to int and then convert to the other enumeration
root.TenantColumnName = model.TenantColumnName;
root.Database.CreatedByColumnName = model.CreatedByColumnName;
root.Database.CreatedDateColumnName = model.CreatedDateColumnName;
root.Database.ModifiedByColumnName = model.ModifiedByColumnName;
root.Database.ModifiedDateColumnName = model.ModifiedDateColumnName;
root.Database.ConcurrencyCheckColumnName = model.ConcurrencyCheckColumnName;
root.Database.GrantExecUser = model.GrantUser;
#region Load the entities
foreach (var entity in model.Entities)
{
#region Table Info
var newTable = root.Database.Tables.Add();
newTable.ResetKey(entity.Id.ToString());
newTable.ResetId(HashString(newTable.Key));
newTable.AllowCreateAudit = entity.AllowCreateAudit;
newTable.AllowModifiedAudit = entity.AllowModifyAudit;
newTable.AllowConcurrencyCheck = entity.AllowTimestamp;
newTable.AssociativeTable = entity.IsAssociative;
newTable.CodeFacade = entity.CodeFacade;
newTable.DBSchema = entity.Schema;
newTable.Description = entity.Summary;
newTable.Immutable = entity.Immutable;
newTable.TypedTable = (nHydrate.Generator.Common.Models.TypedTableConstants)Enum.Parse(typeof(nHydrate.Generator.Common.Models.TypedTableConstants), entity.TypedEntity.ToString(), true);
newTable.Name = entity.Name;
newTable.GeneratesDoubleDerived = entity.GeneratesDoubleDerived;
newTable.IsTenant = entity.IsTenant;
#endregion
#region Load the fields for this entity
var fieldList = entity.Fields.ToList();
foreach (var field in fieldList.OrderBy(x => x.SortOrder))
{
var newColumn = root.Database.Columns.Add();
newColumn.ResetKey(field.Id.ToString());
newColumn.ResetId(HashString(newColumn.Key));
newColumn.AllowNull = field.Nullable;
newColumn.CodeFacade = field.CodeFacade;
newColumn.ComputedColumn = field.IsCalculated;
newColumn.DataType = (System.Data.SqlDbType)Enum.Parse(typeof(System.Data.SqlDbType), field.DataType.ToString());
newColumn.Default = field.Default;
newColumn.DefaultIsFunc = field.DefaultIsFunc;
newColumn.Description = field.Summary;
newColumn.Formula = field.Formula;
newColumn.Identity = (nHydrate.Generator.Common.Models.IdentityTypeConstants)Enum.Parse(typeof(nHydrate.Generator.Common.Models.IdentityTypeConstants), field.Identity.ToString());
newColumn.IsIndexed = field.IsIndexed;
newColumn.IsReadOnly = field.IsReadOnly;
newColumn.IsUnique = field.IsUnique;
newColumn.Length = field.Length;
newColumn.Name = field.Name;
newColumn.ParentTableRef = newTable.CreateRef(newTable.Key);
newColumn.PrimaryKey = field.IsPrimaryKey;
newColumn.Scale = field.Scale;
newColumn.SortOrder = field.SortOrder;
newColumn.Obsolete = field.Obsolete;
newTable.Columns.Add(newColumn.CreateRef(newColumn.Key));
}
#endregion
#region Indexes
var indexList = entity.Indexes.ToList();
foreach (var index in indexList)
{
var indexColumns = index.IndexColumns.Where(x => x.GetField() != null).ToList();
if (indexColumns.Count > 0)
{
var newIndex = new nHydrate.Generator.Common.Models.TableIndex(newTable.Root)
{
Description = index.Summary,
IsUnique = index.IsUnique,
Clustered = index.Clustered,
PrimaryKey = (index.IndexType == IndexTypeConstants.PrimaryKey)
};
newTable.TableIndexList.Add(newIndex);
newIndex.ResetKey(index.Id.ToString());
newIndex.ResetId(HashString(newIndex.Key));
newIndex.ImportedName = index.ImportedName;
//Add index columns
foreach (var ic in indexColumns.OrderBy(x => x.SortOrder).ThenBy(x => x.GetField().Name))
{
var field = ic.GetField();
var newColumn = new nHydrate.Generator.Common.Models.TableIndexColumn(newTable.Root)
{
Ascending = ic.Ascending, FieldID = field.Id
};
newIndex.IndexColumnList.Add(newColumn);
}
}
}
#endregion
#region Static Data
//Determine how many rows there are
var orderKeyList = entity.StaticDatum.Select(x => x.OrderKey).Distinct().ToList();
var rowCount = orderKeyList.Count;
//Create a OLD static data row for each one
for (var ii = 0; ii < rowCount; ii++)
{
//For each row create N cells one for each column
var rowEntry = new nHydrate.Generator.Common.Models.RowEntry(newTable.Root);
var staticDataFieldList = fieldList.Where(x => !x.DataType.IsBinaryType() && x.DataType != DataTypeConstants.Timestamp).ToList();
for (var jj = 0; jj < staticDataFieldList.Count; jj++)
{
var cellEntry = new nHydrate.Generator.Common.Models.CellEntry(newTable.Root);
var column = newTable.GetColumns().ToList()[jj];
cellEntry.ColumnRef = column.CreateRef(column.Key);
var currentColumn = fieldList.FirstOrDefault(x => x.Id == new Guid(column.Key));
if (currentColumn != null)
{
var dataum = entity.StaticDatum.FirstOrDefault(x =>
x.ColumnKey == currentColumn.Id &&
x.OrderKey == orderKeyList[ii]);
if (dataum != null)
{
cellEntry.Value = dataum.Value;
cellEntry.ResetKey(dataum.Id.ToString());
}
//Add the cell to the row
rowEntry.CellEntries.Add(cellEntry);
}
}
newTable.StaticData.Add(rowEntry);
}
#endregion
}
#endregion
#region Relations
{
var relationConnectors = diagram.NestedChildShapes.Where(x => x is EntityAssociationConnector).Cast <EntityAssociationConnector>().ToList();
foreach (var shape in relationConnectors)
{
if (shape is EntityAssociationConnector)
{
var connector = shape as EntityAssociationConnector;
var parent = connector.FromShape.ModelElement as Entity;
var child = connector.ToShape.ModelElement as Entity;
var relation = connector.ModelElement as EntityHasEntities;
var fieldList = model.RelationFields.Where(x => x.RelationID == relation.Id);
var parentTable = root.Database.Tables.FirstOrDefault(x => x.Name == parent.Name);
var childTable = root.Database.Tables.FirstOrDefault(x => x.Name == child.Name);
//If we found both parent and child tables...
if (parentTable != null && childTable != null && !childTable.IsInheritedFrom(parentTable))
{
var isValidRelation = true;
if (isValidRelation)
{
var newRelation = root.Database.Relations.Add();
newRelation.ResetKey((connector.ModelElement as nHydrate.Dsl.EntityHasEntities).InternalId.ToString());
newRelation.ResetId(HashString(newRelation.Key));
newRelation.ParentTableRef = parentTable.CreateRef(parentTable.Key);
newRelation.ChildTableRef = childTable.CreateRef(childTable.Key);
newRelation.RoleName = ((EntityHasEntities)connector.ModelElement).RoleName;
switch (relation.DeleteAction)
{
case DeleteActionConstants.Cascade:
newRelation.DeleteAction = Relation.DeleteActionConstants.Cascade;
break;
case DeleteActionConstants.NoAction:
newRelation.DeleteAction = Relation.DeleteActionConstants.NoAction;
break;
case DeleteActionConstants.SetNull:
newRelation.DeleteAction = Relation.DeleteActionConstants.SetNull;
break;
}
newRelation.Enforce = relation.IsEnforced;
//Create the column links
foreach (var columnSet in fieldList)
{
var field1 = parent.Fields.FirstOrDefault(x => x.Id == columnSet.SourceFieldId);
var field2 = child.Fields.FirstOrDefault(x => x.Id == columnSet.TargetFieldId);
var column1 = parentTable.GetColumnsFullHierarchy().FirstOrDefault(x => x.Name == field1.Name);
var column2 = childTable.GetColumnsFullHierarchy().FirstOrDefault(x => x.Name == field2.Name);
newRelation.ColumnRelationships.Add(new nHydrate.Generator.Common.Models.ColumnRelationship(root)
{
ParentColumnRef = column1.CreateRef(column1.Key),
ChildColumnRef = column2.CreateRef(column2.Key),
}
);
}
//Actually add the relation to the collection
if (newRelation.ColumnRelationships.Count > 0)
{
parentTable.Relationships.Add(newRelation.CreateRef(newRelation.Key));
}
}
}
}
}
} //inner block
#endregion
#region Views
foreach (var view in model.Views)
{
var newView = root.Database.CustomViews.Add();
newView.ResetKey(view.Id.ToString());
newView.ResetId(HashString(newView.Key));
newView.CodeFacade = view.CodeFacade;
newView.DBSchema = view.Schema;
newView.Description = view.Summary;
newView.Name = view.Name;
newView.SQL = view.SQL;
newView.GeneratesDoubleDerived = view.GeneratesDoubleDerived;
foreach (var field in view.Fields)
{
var newField = root.Database.CustomViewColumns.Add();
newField.ResetKey(field.Id.ToString());
newField.ResetId(HashString(newField.Key));
newField.AllowNull = field.Nullable;
newField.CodeFacade = field.CodeFacade;
newField.DataType = (System.Data.SqlDbType)Enum.Parse(typeof(System.Data.SqlDbType), field.DataType.ToString());
newField.Default = field.Default;
newField.Description = field.Summary;
newField.IsPrimaryKey = field.IsPrimaryKey;
newField.Length = field.Length;
newField.Name = field.Name;
newField.Scale = field.Scale;
newView.Columns.Add(newField.CreateRef(newField.Key));
newField.ParentViewRef = newView.CreateRef(newView.Key);
}
}
#endregion
return(root);
}
catch (Exception ex)
{
throw;
}
}
public static nHydrate.Generator.Common.Models.ModelRoot CreatePOCOModel(string modelFile)
{
var fi = new FileInfo(modelFile);
if (!fi.Exists)
{
throw new ModelException("The model file does not exist.");
}
bool wasLoaded;
var diskModel = FileManagement.Load(fi.DirectoryName, fi.Name, out wasLoaded);
if (!wasLoaded)
{
throw new ModelException("The model file does not exist.");
}
try
{
var root = new nHydrate.Generator.Common.Models.ModelRoot(null);
root.EnableCustomChangeEvents = diskModel.ModelProperties.EmitChangeScripts;
root.CompanyName = diskModel.ModelProperties.CompanyName;
root.EmitSafetyScripts = diskModel.ModelProperties.EmitSafetyScripts;
root.DefaultNamespace = diskModel.ModelProperties.DefaultNamespace;
root.ProjectName = diskModel.ModelProperties.ProjectName;
root.SupportLegacySearchObject = false;
root.UseUTCTime = diskModel.ModelProperties.UseUTCTime;
root.Version = diskModel.ModelProperties.Version;
root.Database.ResetKey(diskModel.ModelProperties.Id);
root.OutputTarget = string.Empty;
root.TenantColumnName = diskModel.ModelProperties.TenantColumnName;
root.Database.CreatedByColumnName = diskModel.ModelProperties.CreatedByColumnName;
root.Database.CreatedDateColumnName = diskModel.ModelProperties.CreatedDateColumnName;
root.Database.ModifiedByColumnName = diskModel.ModelProperties.ModifiedByColumnName;
root.Database.ModifiedDateColumnName = diskModel.ModelProperties.ModifiedDateColumnName;
root.Database.ConcurrencyCheckColumnName = diskModel.ModelProperties.ConcurrencyCheckColumnName;
root.Database.GrantExecUser = diskModel.ModelProperties.GrantExecUser;
#region Load the entities
foreach (var entity in diskModel.Entities)
{
#region Table Info
var newTable = root.Database.Tables.Add();
newTable.ResetKey(entity.id.ToString());
newTable.ResetId(HashString(newTable.Key));
newTable.AllowCreateAudit = entity.allowcreateaudit.ToBool();
newTable.AllowModifiedAudit = entity.allowmodifyaudit.ToBool();
newTable.AllowConcurrencyCheck = entity.allowtimestamp.ToBool();
newTable.AssociativeTable = entity.isassociative.ToBool();
newTable.CodeFacade = entity.codefacade;
newTable.DBSchema = entity.schema;
newTable.Description = entity.summary;
newTable.Immutable = entity.immutable.ToBool();
newTable.TypedTable = (nHydrate.Generator.Common.Models.TypedTableConstants)Enum.Parse(typeof(nHydrate.Generator.Common.Models.TypedTableConstants), entity.typedentity.ToString(), true);
newTable.Name = entity.name;
newTable.GeneratesDoubleDerived = entity.generatesdoublederived.ToBool();
newTable.IsTenant = entity.isTenant.ToBool();
#endregion
#region Load the fields for this entity
var fieldList = entity.fieldset.ToList();
foreach (var field in fieldList.OrderBy(x => x.sortorder))
{
var newColumn = root.Database.Columns.Add();
newColumn.ResetKey(field.id.ToString());
newColumn.ResetId(HashString(newColumn.Key));
newColumn.AllowNull = field.nullable.ToBool();
newColumn.CodeFacade = field.codefacade;
newColumn.ComputedColumn = field.Iscalculated.ToBool();
newColumn.DataType = (System.Data.SqlDbType)Enum.Parse(typeof(System.Data.SqlDbType), field.datatype.ToString());
newColumn.Default = field.@default;
newColumn.DefaultIsFunc = field.defaultisfunc.ToBool();
newColumn.Description = field.summary;
newColumn.Formula = field.formula;
newColumn.Identity = (nHydrate.Generator.Common.Models.IdentityTypeConstants)Enum.Parse(typeof(nHydrate.Generator.Common.Models.IdentityTypeConstants), field.identity.ToString());
newColumn.IsIndexed = field.isindexed.ToBool();
newColumn.IsReadOnly = field.isreadonly.ToBool();
newColumn.IsUnique = field.isunique.ToBool();
newColumn.Length = field.length;
newColumn.Name = field.name;
newColumn.ParentTableRef = newTable.CreateRef(newTable.Key);
newColumn.PrimaryKey = field.isprimarykey.ToBool();
newColumn.Scale = field.scale;
newColumn.SortOrder = field.sortorder;
newColumn.Obsolete = field.obsolete.ToBool();
newTable.Columns.Add(newColumn.CreateRef(newColumn.Key));
}
#endregion
}
#endregion
#region Indexes
foreach (var outter in diskModel.Indexes)
{
var newTable = root.Database.Tables.First(x => x.Key == outter.id);
foreach (var index in outter.index)
{
var newIndex = new nHydrate.Generator.Common.Models.TableIndex(newTable.Root)
{
Description = index.summary,
IsUnique = index.isunique.ToBool(),
Clustered = index.clustered.ToBool(),
PrimaryKey = (index.indextype == (byte)IndexTypeConstants.PrimaryKey)
};
newTable.TableIndexList.Add(newIndex);
newIndex.ResetKey(index.id.ToString());
newIndex.ResetId(HashString(newIndex.Key));
newIndex.ImportedName = index.importedname;
//Add index columns
foreach (var ic in index.indexcolumnset.OrderBy(x => x.sortorder))
{
var newColumn = new nHydrate.Generator.Common.Models.TableIndexColumn(newTable.Root)
{
Ascending = ic.ascending.ToBool(),
FieldID = new Guid(ic.fieldid)
};
newIndex.IndexColumnList.Add(newColumn);
}
}
}
#endregion
#region Static Data
foreach (var entity in diskModel.Entities)
{
//Determine how many rows there are
var dataList = diskModel.StaticData.Where(x => x.id == entity.id).SelectMany(x => x.data).ToList();
var orderKeyList = dataList.Select(x => x.orderkey).Distinct().ToList();
var rowCount = orderKeyList.Count;
var newTable = root.Database.Tables.First(x => x.Key == entity.id);
//Create a OLD static data row for each one
for (var ii = 0; ii < rowCount; ii++)
{
//For each row create N cells one for each column
var rowEntry = new nHydrate.Generator.Common.Models.RowEntry(newTable.Root);
var staticDataFieldList = entity.fieldset.Where(x => !(GetDataType(x.datatype).IsBinaryType()) && GetDataType(x.datatype) != DataTypeConstants.Timestamp).ToList();
for (var jj = 0; jj < staticDataFieldList.Count; jj++)
{
var cellEntry = new nHydrate.Generator.Common.Models.CellEntry(newTable.Root);
var column = newTable.GetColumns().ToList()[jj];
cellEntry.ColumnRef = column.CreateRef(column.Key);
var currentColumn = entity.fieldset.FirstOrDefault(x => x.id == column.Key);
if (currentColumn != null)
{
var dataum = dataList.FirstOrDefault(x =>
x.columnkey == currentColumn.id &&
x.orderkey == orderKeyList[ii]);
if (dataum != null)
{
cellEntry.Value = dataum.value;
cellEntry.ResetKey(dataum.columnkey);
}
//Add the cell to the row
rowEntry.CellEntries.Add(cellEntry);
}
}
newTable.StaticData.Add(rowEntry);
}
}
#endregion
#region Relations
foreach (var entity in diskModel.Entities)
{
foreach (var relationNode in diskModel.Relations.Where(x => x.id == entity.id).ToList())
{
//var relationConnectors = diagram.NestedChildShapes.Where(x => x is EntityAssociationConnector).Cast<EntityAssociationConnector>().ToList();
foreach (var shape in relationNode.relation)
{
//var connector = shape as EntityAssociationConnector;
//var parent = connector.FromShape.ModelElement as Entity;
//var child = connector.ToShape.ModelElement as Entity;
//var relation = connector.ModelElement as EntityHasEntities;
//var fieldList = model.RelationFields.Where(x => x.RelationID == relation.Id);
var parentTable = root.Database.Tables.FirstOrDefault(x => x.Key == shape.id);
var childTable = root.Database.Tables.FirstOrDefault(x => x.Key == shape.childid);
//If we found both parent and child tables...
if (parentTable != null && childTable != null)
{
var isValidRelation = true;
if (isValidRelation)
{
var newRelation = root.Database.Relations.Add();
newRelation.ResetKey(shape.id);
newRelation.ResetId(HashString(newRelation.Key));
newRelation.ParentTableRef = parentTable.CreateRef(parentTable.Key);
newRelation.ChildTableRef = childTable.CreateRef(childTable.Key);
newRelation.RoleName = shape.rolename;
var da = (DeleteActionConstants)Enum.Parse(typeof(DeleteActionConstants), shape.deleteaction);
switch (da)
{
case DeleteActionConstants.Cascade:
newRelation.DeleteAction = Relation.DeleteActionConstants.Cascade;
break;
case DeleteActionConstants.NoAction:
newRelation.DeleteAction = Relation.DeleteActionConstants.NoAction;
break;
case DeleteActionConstants.SetNull:
newRelation.DeleteAction = Relation.DeleteActionConstants.SetNull;
break;
}
newRelation.Enforce = shape.isenforced.ToBool();
//Create the column links
foreach (var columnSet in shape.relationfieldset)
{
var field1 = parentTable.GetColumns().FirstOrDefault(x => x.Key == columnSet.sourcefieldid);
var field2 = childTable.GetColumns().FirstOrDefault(x => x.Key == columnSet.targetfieldid);
var column1 = parentTable.GetColumnsFullHierarchy().FirstOrDefault(x => x.Name == field1.Name);
var column2 = childTable.GetColumnsFullHierarchy().FirstOrDefault(x => x.Name == field2.Name);
newRelation.ColumnRelationships.Add(new nHydrate.Generator.Common.Models.ColumnRelationship(root)
{
ParentColumnRef = column1.CreateRef(column1.Key),
ChildColumnRef = column2.CreateRef(column2.Key),
}
);
}
//Actually add the relation to the collection
if (newRelation.ColumnRelationships.Count > 0)
{
parentTable.Relationships.Add(newRelation.CreateRef(newRelation.Key));
}
}
}
}
} //inner block
}
#endregion
#region Views
foreach (var view in diskModel.Views)
{
var newView = root.Database.CustomViews.Add();
newView.ResetKey(view.id);
newView.ResetId(HashString(newView.Key));
newView.CodeFacade = view.codefacade;
newView.DBSchema = view.schema;
newView.Description = view.summary;
newView.Name = view.name;
newView.SQL = view.sql;
newView.GeneratesDoubleDerived = view.generatesdoublederived.ToBool();
foreach (var field in view.fieldset)
{
var newField = root.Database.CustomViewColumns.Add();
newField.ResetKey(field.id);
newField.ResetId(HashString(newField.Key));
newField.AllowNull = field.nullable.ToBool();
newField.CodeFacade = field.codefacade;
newField.DataType = (System.Data.SqlDbType)Enum.Parse(typeof(System.Data.SqlDbType), field.datatype.ToString());
newField.Default = field.@default;
newField.Description = field.summary;
newField.IsPrimaryKey = field.isprimarykey.ToBool();
newField.Length = field.length;
newField.Name = field.name;
newField.Scale = field.scale;
newView.Columns.Add(newField.CreateRef(newField.Key));
newField.ParentViewRef = newView.CreateRef(newView.Key);
}
}
#endregion
return(root);
}
catch (Exception ex)
{
throw new ModelException("The model file could not be loaded.");
}
}