private void PasteTable(CustomStoredProcedureCollection customStoredProcedureCollection,
XmlNode customStoredProcedureNode,
XmlNode columnListNode,
XmlNode parameterListNode)
{
try
{
var customStoredProcedure = customStoredProcedureCollection.Add();
var id = customStoredProcedure.Id;
customStoredProcedure.XmlLoad(customStoredProcedureNode);
customStoredProcedure.SetId(id);
customStoredProcedure.SetKey(Guid.NewGuid().ToString());
customStoredProcedure.Name = "[" + customStoredProcedure.Name + "]";
customStoredProcedure.Columns.Clear();
customStoredProcedure.Parameters.Clear();
foreach (XmlNode child in columnListNode)
{
var column = ((ModelRoot)this.Object.Root).Database.CustomStoredProcedureColumns.Add();
id = column.Id;
column.XmlLoad(child);
column.SetId(id);
column.SetKey(Guid.NewGuid().ToString());
customStoredProcedure.Columns.Add(column.CreateRef());
column.ParentRef = customStoredProcedure.CreateRef();
}
//Parameters
foreach (XmlNode node in parameterListNode)
{
var parameter = ((ModelRoot)this.Object.Root).Database.CustomRetrieveRuleParameters.Add();
id = parameter.Id;
parameter.XmlLoad(node);
parameter.SetId(id);
parameter.SetKey(Guid.NewGuid().ToString());
customStoredProcedure.Parameters.Add(parameter.CreateRef());
parameter.ParentTableRef = customStoredProcedure.CreateRef();
}
}
catch (Exception ex)
{
throw;
}
}
//private DateTime _createdDate = DateTime.Now;
#endregion
#region Constructor
public Database(INHydrateModelObject root)
: base(root)
{
_tables = new TableCollection(root);
_tables.ResetKey(Guid.Empty.ToString());
_columns = new ColumnCollection(root);
_columns.ResetKey(Guid.Empty.ToString());
_relations = new RelationCollection(root);
_relations.ResetKey(Guid.Empty.ToString());
_viewRelations = new ViewRelationCollection(root);
_viewRelations.ResetKey(Guid.Empty.ToString());
_customViews = new CustomViewCollection(root);
_customViews.ResetKey(Guid.Empty.ToString());
_customAggregates = new CustomAggregateCollection(root);
_customAggregates.ResetKey(Guid.Empty.ToString());
_customStoredProcedures = new CustomStoredProcedureCollection(root);
_customStoredProcedures.ResetKey(Guid.Empty.ToString());
_customViewColumns = new CustomViewColumnCollection(root);
_customViewColumns.ResetKey(Guid.Empty.ToString());
_customAggregateColumns = new CustomAggregateColumnCollection(root);
_customAggregateColumns.ResetKey(Guid.Empty.ToString());
_customStoredProcedureColumns = new CustomStoredProcedureColumnCollection(root);
_customStoredProcedureColumns.ResetKey(Guid.Empty.ToString());
_customRetrieveRules = new CustomRetrieveRuleCollection(root);
_customRetrieveRules.ResetKey(Guid.Empty.ToString());
_customRetrieveRuleParameters = new ParameterCollection(root);
_customRetrieveRuleParameters.ResetKey(Guid.Empty.ToString());
_functionParameters = new ParameterCollection(root);
_functionParameters.ResetKey(Guid.Empty.ToString());
_functions = new FunctionCollection(root);
_functions.ResetKey(Guid.Empty.ToString());
_functionColumns = new FunctionColumnCollection(root);
_functionColumns.ResetKey(Guid.Empty.ToString());
this.PrecedenceOrderList = new List <Guid>();
}
