public static bool AssignToObjModelInt(ref SCAPI.ModelObject model, string property, int value)
{
VBCon VBcon = new VBCon();
if (VBcon.AssignToObjModelInt(ref model, property, value))
{
return(true);
}
else
{
return(false);
}
}
public SCAPI.ModelObject CreateAttributePassOne(AttributeT entity, string db)
{
SCAPI.ModelObject ret = null;
if (string.IsNullOrWhiteSpace(db))
{
Logger.PrintLC("There was no DB associated to " + entity.NomeTabellaLegacy, 3);
return(ret);
}
if (erRootObjCol != null)
{
OpenTransaction();
erObjectCollection = scSession.ModelObjects.Collect(scSession.ModelObjects.Root, "Entity");
VBCon con = new VBCon();
erEntityObjectPE = null;
if (string.IsNullOrWhiteSpace(entity.NomeTabellaLegacy))
{
Logger.PrintLC("'Nome Tabella Legacy' at row " + entity.Row + " not found. Skipping the Attribute.", 3);
CommitAndSave(trID);
return(ret = null);
}
if (con.RetriveEntity(ref erEntityObjectPE, erObjectCollection, entity.NomeTabellaLegacy))
{
Logger.PrintLC("Table entity " + entity.NomeTabellaLegacy + " retrived correctly", 3);
}
else
{
Logger.PrintLC("Table entity " + entity.NomeTabellaLegacy + " not found. Skipping the Attribute.", 3);
CommitAndSave(trID);
return(ret = null);
}
//Area
if (!string.IsNullOrWhiteSpace(entity.Area))
{
if (con.AssignToObjModel(ref erEntityObjectPE, ConfigFile._ATT_NAME["Area"], entity.Area))
{
Logger.PrintLC("Added Area to " + erEntityObjectPE.Name, 3);
}
else
{
Logger.PrintLC("Error adding Area to " + erEntityObjectPE.Name, 3);
}
}
//Tipologia Tabella
if (!string.IsNullOrWhiteSpace(entity.TipologiaTabella))
{
if (con.AssignToObjModel(ref erEntityObjectPE, ConfigFile._ATT_NAME["Tipologia Tabella"], entity.TipologiaTabella))
{
Logger.PrintLC("Added Tipologia Tabella to " + erEntityObjectPE.Name, 3);
}
else
{
Logger.PrintLC("Error adding Tipologia Tabella to " + erEntityObjectPE.Name, 3);
}
}
//Storica
if (!string.IsNullOrWhiteSpace(entity.Storica))
{
if (con.AssignToObjModel(ref erEntityObjectPE, ConfigFile._ATT_NAME["Storica"], entity.Storica))
{
Logger.PrintLC("Added Storica to " + erEntityObjectPE.Name, 3);
}
else
{
Logger.PrintLC("Error adding Storica to " + erEntityObjectPE.Name, 3);
}
}
erAttributeObjCol = scSession.ModelObjects.Collect(erEntityObjectPE, "Attribute");
if (!string.IsNullOrWhiteSpace(entity.NomeCampoLegacy))
{
if (con.RetriveAttribute(ref erAttributeObjectPE, erAttributeObjCol, entity.NomeCampoLegacy))
{
Logger.PrintLC("Attribute entity " + entity.NomeCampoLegacy + " already present.", 3);
}
else
{
erAttributeObjectPE = erAttributeObjCol.Add("Attribute");
//Name
if (!string.IsNullOrWhiteSpace(entity.NomeCampoLegacy))
{
if (con.AssignToObjModel(ref erAttributeObjectPE, ConfigFile._ATT_NAME["Nome Campo Legacy Name"], entity.NomeCampoLegacy))
{
Logger.PrintLC("Added Nome Campo Legacy to " + erAttributeObjectPE.Name + "'s name.", 4);
}
else
{
Logger.PrintLC("Error adding Nome Campo Legacy to " + erAttributeObjectPE.Name, 4);
}
//Physical Name
if (con.AssignToObjModel(ref erAttributeObjectPE, ConfigFile._ATT_NAME["Nome Campo Legacy"], entity.NomeCampoLegacy))
{
Logger.PrintLC("Added Nome Campo Legacy to " + erAttributeObjectPE.Name, 4);
}
else
{
Logger.PrintLC("Error adding Nome Campo Legacy to " + erAttributeObjectPE.Name, 4);
}
}
//Datatype
if (!string.IsNullOrWhiteSpace(entity.DataType))
{
if (con.AssignToObjModel(ref erAttributeObjectPE, ConfigFile._ATT_NAME["Datatype"], entity.DataType))
{
Logger.PrintLC("Added Datatype to " + erAttributeObjectPE.Name, 4);
}
else
{
Logger.PrintLC("Error adding Datatype to " + erAttributeObjectPE.Name, 4);
}
}
//Chiave
if (entity.Chiave == 0 || entity.Chiave == 100)
{
if (con.AssignToObjModelInt(ref erAttributeObjectPE, ConfigFile._ATT_NAME["Chiave"], (int)entity.Chiave))
{
Logger.PrintLC("Added Chiave to " + erAttributeObjectPE.Name, 4);
}
else
{
Logger.PrintLC("Error adding Chiave to " + erAttributeObjectPE.Name, 4);
}
}
//Mandatory Flag
if (entity.MandatoryFlag == 1 || entity.MandatoryFlag == 0)
{
if (con.AssignToObjModelInt(ref erAttributeObjectPE, ConfigFile._ATT_NAME["Mandatory Flag"], (int)entity.MandatoryFlag))
{
Logger.PrintLC("Added Mandatory Flag to " + erAttributeObjectPE.Name, 4);
}
else
{
Logger.PrintLC("Error adding Mandatory Flag to " + erAttributeObjectPE.Name, 4);
}
}
}
}
CommitAndSave(trID);
}
return(erEntityObjectPE);
}
public SCAPI.ModelObject CreateAttributePassTwo(AttributeT entity, string db)
{
SCAPI.ModelObject ret = null;
if (string.IsNullOrWhiteSpace(db))
{
Logger.PrintLC("There was no DB associated to " + entity.NomeTabellaLegacy, 3);
return(ret);
}
if (erRootObjCol != null)
{
OpenTransaction();
erObjectCollection = scSession.ModelObjects.Collect(scSession.ModelObjects.Root, "Entity");
VBCon con = new VBCon();
erEntityObjectPE = null;
if (string.IsNullOrWhiteSpace(entity.NomeTabellaLegacy))
{
Logger.PrintLC("'Nome Tabella Legacy' at row " + entity.Row + " not found. Skipping the Attribute.", 3);
CommitAndSave(trID);
return(ret = null);
}
if (con.RetriveEntity(ref erEntityObjectPE, erObjectCollection, entity.NomeTabellaLegacy))
{
Logger.PrintLC("Table entity " + entity.NomeTabellaLegacy + " retrived correctly", 3);
}
else
{
Logger.PrintLC("Table entity " + entity.NomeTabellaLegacy + " not found. Skipping the Attribute.", 3);
CommitAndSave(trID);
return(ret = null);
}
erAttributeObjCol = scSession.ModelObjects.Collect(erEntityObjectPE, "Attribute");
if (!string.IsNullOrWhiteSpace(entity.NomeCampoLegacy))
{
if (con.RetriveAttribute(ref erAttributeObjectPE, erAttributeObjCol, entity.NomeCampoLegacy))
{
//Definizione Campo
if (!string.IsNullOrWhiteSpace(entity.DefinizioneCampo))
{
Logger.PrintLC("Attribute entity " + entity.NomeCampoLegacy + " already present.", 3);
//Definizione Campo (Comment)
if (con.AssignToObjModel(ref erAttributeObjectPE, ConfigFile._ATT_NAME["Definizione Campo"], entity.DefinizioneCampo))
{
Logger.PrintLC("Added Definizione Campo (Comment) to " + erAttributeObjectPE.Name, 4);
}
else
{
Logger.PrintLC("Error adding Definizione Campo (Comment) to " + erAttributeObjectPE.Name, 4);
}
//Definizione Campo (Definition)
if (con.AssignToObjModel(ref erAttributeObjectPE, ConfigFile._ATT_NAME["Definizione Campo Def"], entity.DefinizioneCampo))
{
Logger.PrintLC("Added Definizione Campo (Definition) to " + erAttributeObjectPE.Name, 4);
}
else
{
Logger.PrintLC("Error adding Definizione Campo (Definition) to " + erAttributeObjectPE.Name, 4);
}
}
//Unique
if (!string.IsNullOrWhiteSpace(entity.Unique))
{
if (con.AssignToObjModel(ref erAttributeObjectPE, ConfigFile._ATT_NAME["Unique"], entity.Unique))
{
Logger.PrintLC("Added Unique to " + erAttributeObjectPE.Name, 4);
}
else
{
Logger.PrintLC("Error adding Unique to " + erAttributeObjectPE.Name, 4);
}
}
//Chiave logica
if (!string.IsNullOrWhiteSpace(entity.ChiaveLogica))
{
if (con.AssignToObjModel(ref erAttributeObjectPE, ConfigFile._ATT_NAME["Chiave Logica"], entity.ChiaveLogica))
{
Logger.PrintLC("Added Chiave Logica to " + erAttributeObjectPE.Name, 4);
}
else
{
Logger.PrintLC("Error adding Chiave Logica to " + erAttributeObjectPE.Name, 4);
}
}
//Dominio
if (!string.IsNullOrWhiteSpace(entity.Dominio))
{
if (con.AssignToObjModel(ref erAttributeObjectPE, ConfigFile._ATT_NAME["Dominio"], entity.Dominio))
{
Logger.PrintLC("Added Dominio to " + erAttributeObjectPE.Name, 4);
}
else
{
Logger.PrintLC("Error adding Dominio to " + erAttributeObjectPE.Name, 4);
}
}
//Provenienza Dominio
if (!string.IsNullOrWhiteSpace(entity.ProvenienzaDominio))
{
if (con.AssignToObjModel(ref erAttributeObjectPE, ConfigFile._ATT_NAME["Provenienza Dominio"], entity.ProvenienzaDominio))
{
Logger.PrintLC("Added Provenienza Dominio to " + erAttributeObjectPE.Name, 4);
}
else
{
Logger.PrintLC("Error adding Provenienza Dominio to " + erAttributeObjectPE.Name, 4);
}
}
//Note
if (!string.IsNullOrWhiteSpace(entity.Note))
{
if (con.AssignToObjModel(ref erAttributeObjectPE, ConfigFile._ATT_NAME["Note"], entity.Note))
{
Logger.PrintLC("Added Note to " + erAttributeObjectPE.Name, 4);
}
else
{
Logger.PrintLC("Error adding Note to " + erAttributeObjectPE.Name, 4);
}
}
}
else
{
//ExcelOps.XLSXWriteErrorInCell()
Logger.PrintLC("Unexpected Error: searching for " + entity.NomeCampoLegacy + " finding none.", 4);
}
}
CommitAndSave(trID);
}
return(erEntityObjectPE);
}
public SCAPI.ModelObject CreateEntity(EntityT entity, string db)
{
SCAPI.ModelObject ret = null;
if (string.IsNullOrWhiteSpace(db))
{
Logger.PrintLC("There was no DB associated to " + entity.TableName, 3);
return(ret);
}
if (!((entity.FlagBFD == "S") || (entity.FlagBFD == "N")))
{
Logger.PrintLC("Property FlagBFD of " + entity.TableName + " is not valid. Table will be skipped.", 3);
return(ret);
}
if (erRootObjCol != null)
{
OpenTransaction();
scItem = erRootObjCol.Add("Entity");
VBCon con = new VBCon();
//Controlli proprietà essenziali
//Nome tabella
if (!string.IsNullOrWhiteSpace(entity.TableName))
{
if (con.AssignToObjModel(ref scItem, ConfigFile._TAB_NAME["Nome Tabella"], entity.TableName))
{
Logger.PrintLC("Added Table Physical Name (" + entity.TableName + ") to " + scItem.ObjectId, 3);
}
else
{
Logger.PrintLC("Error adding Table Physical Name (" + entity.TableName + ") to " + scItem.ObjectId, 3);
CommitAndSave(trID);
return(scItem);
}
if (con.AssignToObjModel(ref scItem, "Name", entity.TableName))
{
Logger.PrintLC("Added Table Name to " + scItem.Name, 3);
}
else
{
Logger.PrintLC("Error adding Table Name to " + scItem.Name, 3);
CommitAndSave(trID);
return(scItem);
}
}
//SSA
if (!string.IsNullOrWhiteSpace(entity.SSA))
{
if (con.AssignToObjModel(ref scItem, ConfigFile._TAB_NAME["SSA"], entity.SSA))
{
Logger.PrintLC("Added SSA to " + scItem.Name, 3);
}
else
{
Logger.PrintLC("Error adding SSA to " + scItem.Name, 3);
}
}
//Table Description
if (!string.IsNullOrWhiteSpace(entity.TableDescr))
{
if (con.AssignToObjModel(ref scItem, ConfigFile._TAB_NAME["Descrizione Tabella"], entity.TableDescr))
{
Logger.PrintLC("Added Table Description to " + scItem.Name, 3);
}
else
{
Logger.PrintLC("Error adding Table Description to " + scItem.Name, 3);
}
}
if (!string.IsNullOrWhiteSpace(entity.TableDescr))
{
if (con.AssignToObjModel(ref scItem, "Definition", entity.TableDescr))
{
Logger.PrintLC("Added Table Definition to " + scItem.Name, 3);
}
else
{
Logger.PrintLC("Error adding Table Definition to " + scItem.Name, 3);
}
}
//Info Type
if (!string.IsNullOrWhiteSpace(entity.InfoType))
{
if (con.AssignToObjModel(ref scItem, ConfigFile._TAB_NAME["Tipologia Informazione"], entity.InfoType))
{
Logger.PrintLC("Added Information Type to " + scItem.Name, 3);
}
else
{
Logger.PrintLC("Error adding Information Type to " + scItem.Name, 3);
}
}
//Table Limit
if (!string.IsNullOrWhiteSpace(entity.TableLimit))
{
if (con.AssignToObjModel(ref scItem, ConfigFile._TAB_NAME["Perimetro Tabella"], entity.TableLimit))
{
Logger.PrintLC("Added Table Limit to " + scItem.Name, 3);
}
else
{
Logger.PrintLC("Error adding Table Limit to " + scItem.Name, 3);
}
}
//Table Granularity
if (!string.IsNullOrWhiteSpace(entity.TableGranularity))
{
if (con.AssignToObjModel(ref scItem, ConfigFile._TAB_NAME["Granularità Tabella"], entity.TableGranularity))
{
Logger.PrintLC("Added Table Granularity to " + scItem.Name, 3);
}
else
{
Logger.PrintLC("Error adding Table Granularity to " + scItem.Name, 3);
}
}
//Flag BFD
if (!string.IsNullOrWhiteSpace(entity.FlagBFD))
{
if (con.AssignToObjModel(ref scItem, ConfigFile._TAB_NAME["Flag BFD"], entity.FlagBFD))
{
Logger.PrintLC("Added Flag BFD to " + scItem.Name, 3);
}
else
{
Logger.PrintLC("Error adding Flag BFD to " + scItem.Name, 3);
}
}
//##################################################
//## Controllo esistenza DB ed eventuale aggiunta ##
if (!string.IsNullOrWhiteSpace(entity.DatabaseName))
{
if (!DatabaseN.Contains(entity.DatabaseName))
{
scDB = erRootObjCol.Add("DB2_Database");
if (con.AssignToObjModel(ref scDB, ConfigFile._TAB_NAME["Nome Database"], entity.DatabaseName))
{
Logger.PrintLC("Added Database Name to " + scDB.Name, 3);
}
else
{
Logger.PrintLC("Error adding Database Name to " + scDB.Name, 3);
}
if (!string.IsNullOrWhiteSpace(entity.HostName))
{
if (con.AssignToObjModel(ref scDB, ConfigFile._TAB_NAME["Nome host"], entity.HostName))
{
Logger.PrintLC("Added Host Name to " + scDB.Name, 3);
}
else
{
Logger.PrintLC("Error adding Host Name to " + scDB.Name, 3);
}
}
DatabaseN.Add(entity.DatabaseName);
}
}
//##################################################
//##################################################
//## Controllo esistenza SCHEMA ed eventuale aggiunta ##
if (!string.IsNullOrWhiteSpace(entity.Schema))
{
if (!SchemaN.Contains(entity.Schema))
{
scSchema = erRootObjCol.Add("Schema");
if (con.AssignToObjModel(ref scSchema, "Name", entity.Schema))
{
Logger.PrintLC("Created Schema Name to " + scSchema.Name, 3);
}
else
{
Logger.PrintLC("Error creating Schema Name to " + scSchema.Name, 3);
}
SchemaN.Add(entity.Schema);
}
//Schema
if (!string.IsNullOrWhiteSpace(entity.Schema))
{
if (con.AssignToObjModel(ref scItem, ConfigFile._TAB_NAME["Schema"], entity.Schema))
{
Logger.PrintLC("Added Schema to " + scItem.Name, 3);
}
else
{
Logger.PrintLC("Error adding Schema to " + scItem.Name, 3);
}
}
}
//##################################################
CommitAndSave(trID);
}
return(scItem);
}
