Inheritance: nHydrate.Generator.Common.GeneratorFramework.BaseModelObject, ICodeFacadeObject, INamedObject
 public SQLStoredProcedureViewAllTemplate(ModelRoot model, CustomView view, bool singleFile, StringBuilder grantSB)
     : base(model)
 {
     _view = view;
     _singleFile = singleFile;
     _grantSB = grantSB;
 }
		public SQLSelectViewTemplate(ModelRoot model, CustomView currentView, StringBuilder grantSB)
		{
			_model = model;
			_currentView = currentView;
			_grantSB = grantSB;
		}
 public ViewEntityGeneratedTemplate(ModelRoot model, CustomView currentTable)
     : base(model)
 {
     _item = currentTable;
 }
		public ViewEntityGeneratedTemplate(ModelRoot model, CustomView view)
			: base(model)
		{
			_item = view;
		}
示例#5
0
		private void AppendMappingFragment(CustomView view)
		{
			sb.AppendFormat("				<MappingFragment StoreEntitySet=\"{0}\">", view.PascalName).AppendLine();
			sb.AppendLine("					<ScalarProperty Name=\"pk\" ColumnName=\"__pk\" />");
			foreach (var currentColumn in view.GetColumns().Where(x => x.Generated).OrderBy(x => x.Name))
			{
				sb.AppendFormat("					<ScalarProperty Name=\"{0}\" ColumnName=\"{1}\" />", currentColumn.PascalName, currentColumn.DatabaseName).AppendLine();
			}
			sb.AppendFormat("				</MappingFragment>").AppendLine();
		}
		public ViewEntityExtenderTemplate(ModelRoot model, CustomView table)
			: base(model)
		{
			_currentView = table;
		}
示例#7
0
 public static string GetSqlCreateView(CustomView view, bool isInternal)
 {
     var sb = new StringBuilder();
     sb.AppendLine("if exists(select * from sys.objects where name = '" + view.DatabaseName + "' and type = 'V' and type_desc = 'VIEW')");
     sb.AppendLine("drop view [" + view.GetSQLSchema() + "].[" + view.DatabaseName + "]");
     if (isInternal)
     {
         sb.AppendLine("--MODELID: " + view.Key);
     }
     sb.AppendLine("GO");
     sb.AppendLine();
     sb.AppendLine("CREATE VIEW [" + view.GetSQLSchema() + "].[" + view.DatabaseName + "]");
     sb.AppendLine("AS");
     sb.AppendLine();
     sb.AppendLine(view.SQL);
     if (isInternal)
     {
         sb.AppendLine("--MODELID,BODY: " + view.Key);
     }
     sb.AppendLine("GO");
     sb.AppendLine("exec sp_refreshview N'[" + view.GetSQLSchema() + "].[" + view.DatabaseName + "]';");
     if (isInternal)
     {
         sb.AppendLine("--MODELID: " + view.Key);
     }
     sb.AppendLine("GO");
     sb.AppendLine();
     return sb.ToString();
 }
		public ViewEntityExtenderTemplate(ModelRoot model, CustomView view)
			: base(model)
		{
			_currentView = view;
		}
		public DatasiteViewItemTemplate(ModelRoot model, CustomView item, string templateLocation)
			: base(model)
		{
			_item = item;
			_templateLocation = templateLocation;
		}
示例#10
0
		//private void PopulateRelationships(TreeNode parentNode)
		//{
		//  try
		//  {
		//    Random rnd = new Random();
		//    SortedList<string, DataTreeItem> relationList = new SortedList<string, DataTreeItem>();

		//    //Current Tables
		//    foreach (Table t in this.CurrentDatabase.Tables)
		//    {
		//      //Remove invalid links. Something is very wrong
		//      RelationCollection relationCollection = t.GetRelations();
		//      for (int ii = relationCollection.Count - 1; ii >= 0; ii--)
		//      {
		//        Relation relationshipItem = relationCollection[ii];
		//        int errorCount = 0;
		//        foreach (ColumnRelationship relationshipLinkItem in relationshipItem.ColumnRelationships)
		//        {
		//          if ((relationshipLinkItem.ChildColumnRef == null) || (relationshipLinkItem.ParentColumnRef == null))
		//            errorCount++;
		//        }
		//        if (errorCount > 0) t.Relationships.RemoveAt(ii);
		//      }
		//      //Remove Errors

		//      //If the table exists in the new graph...
		//      foreach (Relation relation in relationCollection)
		//      {
		//        Table t2 = this.NewDatabase.Tables[t.Name];
		//        DataTreeItem dti = new DataTreeItem(relation.RoleName);
		//        dti.Name = relation.ToLongString();
		//        if (t2 == null)
		//        {
		//          //The table was removed so the relationship was removed
		//          dti.State = DataTreeItem.DataTreeItemStateConstants.Delete;
		//        }
		//        else
		//        {
		//          //If the name changed then it was modified
		//          Relation[] r2List = t2.GetRelations().GetFromMatch(relation);
		//          if (r2List.Length == 0)
		//          {
		//            dti.State = DataTreeItem.DataTreeItemStateConstants.Delete;
		//          }
		//          else if (r2List.Length == 1)
		//          {
		//            if (r2List[0].RoleName != relation.RoleName)
		//              dti.State = DataTreeItem.DataTreeItemStateConstants.Modified;
		//          }
		//          else if (r2List.Length > 1)
		//          {
		//            //There are multiple relationships for this table/column combination
		//            bool found = false;
		//            foreach (Relation r2 in r2List)
		//            {
		//              #region OLD CODE
		//              //if (r2.RoleName == relation.RoleName) found = true;
		//              //string parentTableName1 = ((Table)r2.ParentTableRef.Object).Name;
		//              //string parentTableName2 = ((Table)relation.ParentTableRef.Object).Name;

		//              //SortedDictionary<string, ColumnRelationship> list1 = new SortedDictionary<string,ColumnRelationship>();
		//              //foreach (ColumnRelationship cr in r2.ColumnRelationships)
		//              //{
		//              //  list1.Add(((Column)cr.ChildColumnRef.Object).Name, cr);
		//              //}

		//              //SortedDictionary<string, ColumnRelationship> list2 = new SortedDictionary<string, ColumnRelationship>();
		//              //foreach (ColumnRelationship cr in relation.ColumnRelationships)
		//              //{
		//              //  list2.Add(((Column)cr.ChildColumnRef.Object).Name, cr);
		//              //}

		//              //string parentColName1 = string.Empty;
		//              //foreach (string key in list1.Keys)
		//              //{
		//              //  parentColName1 += key;
		//              //}

		//              //string parentColName2 = string.Empty;
		//              //foreach (string key in list2.Keys)
		//              //{
		//              //  parentColName2 += key;
		//              //}

		//              ////string parentCol
		//              //if ((parentTableName1 == parentTableName2) && (parentColName1 == parentColName2))
		//              //  found = true;
		//              #endregion

		//              if (r2.Equals(relation)) found = true;

		//            }
		//            if (!found)
		//              dti.State = DataTreeItem.DataTreeItemStateConstants.Modified;
		//          }

		//        }

		//        //If there is a duplicate then add a FAKE ROLE to it
		//        if (relationList.ContainsKey(relation.ToLongString().ToLower()))
		//        {
		//          relation.RoleName = "ROLE" + rnd.Next(10000, 100000);
		//          relationList.Add(relation.ToLongString().ToLower(), dti);
		//        }
		//        else
		//        {
		//          relationList.Add(relation.ToLongString().ToLower(), dti);
		//        }

		//      }
		//    }

		//    //Added Relationships
		//    foreach (Table t in this.NewDatabase.Tables)
		//    {
		//      foreach (Reference reference in t.Relationships)
		//      {
		//        Relation r = (Relation)reference.Object;
		//        string relationName = r.ToLongString();
		//        if (this.CurrentDatabase.Tables.Contains(t.Name))
		//        {
		//          //If the old model has this table
		//          Table t2 = this.CurrentDatabase.Tables[t.Name];
		//          if ((t2 != null) && (t2.GetRelations().GetFromMatch(r).Length == 0))
		//            relationList.Add(relationName.ToLower(), new DataTreeItem(relationName, DataTreeItem.DataTreeItemStateConstants.Added));
		//        }
		//        else
		//        {
		//          //Table and Relation not in old model
		//          if (!relationList.ContainsKey(relationName.ToLower()))
		//          {
		//            relationList.Add(relationName.ToLower(), new DataTreeItem(relationName, DataTreeItem.DataTreeItemStateConstants.Added));
		//          }
		//          else
		//          {
		//            int loop = 1;
		//            while (relationList.ContainsKey((relationName + "_RELATION" + loop).ToLower()))
		//            {
		//              loop++;
		//            }
		//            relationName += "_RELATION" + loop;
		//            relationList.Add(relationName.ToLower(), new DataTreeItem(relationName, DataTreeItem.DataTreeItemStateConstants.Added));
		//          }
		//        }
		//      }
		//    }

		//    //Now add to tree
		//    foreach (string relationKey in relationList.Keys)
		//    {
		//      var relationNode = new TreeNode(relationList[relationKey].Name);
		//      relationNode.Tag = relationList[relationKey];
		//      if (relationList[relationKey].State == DataTreeItem.DataTreeItemStateConstants.Added)
		//        relationNode.ForeColor = Color.Green;
		//      if (relationList[relationKey].State == DataTreeItem.DataTreeItemStateConstants.Delete)
		//        relationNode.ForeColor = Color.Red;
		//      if (relationList[relationKey].State == DataTreeItem.DataTreeItemStateConstants.Modified)
		//        relationNode.ForeColor = Color.Blue;

		//      parentNode.Nodes.Add(relationNode);
		//    }

		//    this.BrandNodes(parentNode.Nodes);

		//  }
		//  catch (Exception ex)
		//  {
		//    throw;
		//  }
		//}
		#endregion

		#region PopulateStoredProcedures
		//private void PopulateStoredProcedures(TreeNode parentNode)
		//{
		//  try
		//  {
		//    SortedList<string, DataTreeItem> itemCache = new SortedList<string, DataTreeItem>();

		//    //Current Items
		//    foreach (CustomStoredProcedure storedProcedure in this.CurrentDatabase.CustomStoredProcedures)
		//    {
		//      DataTreeItem dti = new DataTreeItem(storedProcedure.Name);
		//      if (this.NewDatabase.CustomStoredProcedures.Contains(storedProcedure.Name))
		//        dti.Name = this.NewDatabase.CustomStoredProcedures[storedProcedure.Name].Name;

		//      //Check for deleted status
		//      if (!this.NewDatabase.CustomStoredProcedures.Contains(storedProcedure.Name))
		//        dti.State = DataTreeItem.DataTreeItemStateConstants.Delete;
		//      else if (this.NewDatabase.CustomStoredProcedures[storedProcedure.Name].Name != storedProcedure.Name)
		//        dti.State = DataTreeItem.DataTreeItemStateConstants.Modified;
		//      else if (this.NewDatabase.CustomStoredProcedures[storedProcedure.Name].GetColumns().GetCorePropertiesHash() != storedProcedure.GetColumns().GetCorePropertiesHash())
		//        dti.State = DataTreeItem.DataTreeItemStateConstants.Modified;

		//      itemCache.Add(storedProcedure.Name.ToLower(), dti);
		//    }

		//    //Added Items
		//    foreach (CustomStoredProcedure t in this.NewDatabase.CustomStoredProcedures)
		//    {
		//      if (!this.CurrentDatabase.CustomStoredProcedures.Contains(t.Name))
		//        itemCache.Add(t.Name.ToLower(), new DataTreeItem(t.Name, DataTreeItem.DataTreeItemStateConstants.Added));
		//    }

		//    //Now add to tree
		//    foreach (string storedProcedureKey in itemCache.Keys)
		//    {
		//      var newNode = new TreeNode(itemCache[storedProcedureKey].Name);
		//      newNode.Tag = itemCache[storedProcedureKey];
		//      if (itemCache[storedProcedureKey].State == DataTreeItem.DataTreeItemStateConstants.Added)
		//        newNode.ForeColor = Color.Green;
		//      if (itemCache[storedProcedureKey].State == DataTreeItem.DataTreeItemStateConstants.Delete)
		//        newNode.ForeColor = Color.Red;
		//      if (itemCache[storedProcedureKey].State == DataTreeItem.DataTreeItemStateConstants.Modified)
		//        newNode.ForeColor = Color.Blue;

		//      parentNode.Nodes.Add(newNode);

		//      CustomStoredProcedure oldStoredProcedure = this.CurrentDatabase.CustomStoredProcedures[storedProcedureKey];
		//      CustomStoredProcedure newStoredProcedure = this.NewDatabase.CustomStoredProcedures[storedProcedureKey];
		//      if (oldStoredProcedure == null) oldStoredProcedure = new CustomStoredProcedure(this.CurrentDatabase.Root);
		//      if (newStoredProcedure == null) newStoredProcedure = new CustomStoredProcedure(this.NewDatabase.Root);

		//      //Create list of all columns (new and old)
		//      SortedList<string, DataTreeItem> columns = new SortedList<string, DataTreeItem>();
		//      foreach (Reference r in oldStoredProcedure.Columns)
		//      {
		//        CustomStoredProcedureColumn column = (CustomStoredProcedureColumn)r.Object;
		//        DataTreeItem dti = new DataTreeItem(column.Name);

		//        //Check for deleted status
		//        if (this.NewDatabase.CustomStoredProcedures.Contains(itemCache[oldStoredProcedure.Name.ToLower()].Name))
		//        {
		//          CustomStoredProcedureColumn statusColumn = this.NewDatabase.CustomStoredProcedures[itemCache[oldStoredProcedure.Name.ToLower()].Name].GetColumns().FirstOrDefault(x => x.Name == column.Name);
		//          if (statusColumn == null)
		//            dti.State = DataTreeItem.DataTreeItemStateConstants.Delete;
		//          else if (column.CorePropertiesHash != statusColumn.CorePropertiesHash)
		//            dti.State = DataTreeItem.DataTreeItemStateConstants.Modified;
		//        }

		//        columns.Add(column.Name.ToLower(), dti);

		//      }

		//      //Added Columns
		//      if (oldStoredProcedure.Name == string.Empty)
		//      {
		//        foreach (CustomStoredProcedureColumn column in this.NewDatabase.CustomStoredProcedures[storedProcedureKey].GetColumns())
		//        {
		//          columns.Add(column.Name.ToLower(), new DataTreeItem(column.Name, DataTreeItem.DataTreeItemStateConstants.Added));
		//        }
		//      }
		//      else
		//      {
		//        if (this.NewDatabase.CustomStoredProcedures.Contains(itemCache[oldStoredProcedure.Name.ToLower()].Name))
		//        {
		//          foreach (CustomStoredProcedureColumn column in this.NewDatabase.CustomStoredProcedures[itemCache[oldStoredProcedure.Name.ToLower()].Name].GetColumns())
		//          {
		//            CustomStoredProcedureColumn statusColumn = this.CurrentDatabase.CustomStoredProcedures[itemCache[oldStoredProcedure.Name.ToLower()].Name].GetColumns().FirstOrDefault(x => x.Name == column.Name);
		//            if (statusColumn == null)
		//              columns.Add(column.Name.ToLower(), new DataTreeItem(column.Name, DataTreeItem.DataTreeItemStateConstants.Added));
		//          }
		//        }
		//      }

		//      //Now load columns into tree
		//      if (this.NewDatabase.CustomStoredProcedures.Contains(oldStoredProcedure.Name))
		//      {
		//        foreach (string columnKey in columns.Keys)
		//        {
		//          var columnNode = new TreeNode(columns[columnKey].Name);
		//          if (columns[columnKey].State == DataTreeItem.DataTreeItemStateConstants.Added)
		//            columnNode.ForeColor = Color.Green;
		//          if (columns[columnKey].State == DataTreeItem.DataTreeItemStateConstants.Delete)
		//            columnNode.ForeColor = Color.Red;
		//          if (columns[columnKey].State == DataTreeItem.DataTreeItemStateConstants.Modified)
		//            columnNode.ForeColor = Color.Blue;

		//          columnNode.Tag = columns[columnKey];
		//          newNode.Nodes.Add(columnNode);
		//        }
		//      }

		//    }

		//    this.BrandNodes(parentNode.Nodes);

		//  }
		//  catch (Exception ex)
		//  {
		//    throw;
		//  }
		//}
		#endregion

		private void PopulateViews(TreeNode parentNode)
		{
			try
			{
				var itemCache = new SortedList<string, DataTreeItem>();

				//Current Items
				foreach (CustomView view in this.CurrentDatabase.CustomViews)
				{
					var dti = new DataTreeItem(view.Name);
					if (this.NewDatabase.CustomViews.Contains(view.Name))
						dti.Name = this.NewDatabase.CustomViews[view.Name].Name;

					//Check for deleted status
					if (!this.NewDatabase.CustomViews.Contains(view.Name))
						dti.State = DataTreeItem.DataTreeItemStateConstants.Delete;
					else if (this.NewDatabase.CustomViews[view.Name].Name != view.Name)
						dti.State = DataTreeItem.DataTreeItemStateConstants.Modified;
					else if (this.NewDatabase.CustomViews[view.Name].GetColumns().GetCorePropertiesHash() != view.GetColumns().GetCorePropertiesHash())
						dti.State = DataTreeItem.DataTreeItemStateConstants.Modified;

					itemCache.Add(view.Name.ToLower(), dti);
				}

				//Added Items
				foreach (CustomView t in this.NewDatabase.CustomViews)
				{
					if (!this.CurrentDatabase.CustomViews.Contains(t.Name))
						itemCache.Add(t.Name.ToLower(), new DataTreeItem(t.Name, DataTreeItem.DataTreeItemStateConstants.Added));
				}

				//Now add to tree
				foreach (var viewKey in itemCache.Keys)
				{
					var viewNode = new TreeNode(itemCache[viewKey].Name);
					viewNode.Checked = true;
					viewNode.ImageIndex = 4;
					viewNode.Tag = itemCache[viewKey];
					//if (itemCache[viewKey].State == DataTreeItem.DataTreeItemStateConstants.Added)
					//  viewNode.ForeColor = Color.Green;
					//if (itemCache[viewKey].State == DataTreeItem.DataTreeItemStateConstants.Delete)
					//  viewNode.ForeColor = Color.Red;
					//if (itemCache[viewKey].State == DataTreeItem.DataTreeItemStateConstants.Modified)
					//  viewNode.ForeColor = Color.Blue;

					parentNode.Nodes.Add(viewNode);

					var oldView = this.CurrentDatabase.CustomViews[viewKey];
					var newView = this.NewDatabase.CustomViews[viewKey];
					if (oldView == null) oldView = new CustomView(this.CurrentDatabase.Root);
					if (newView == null) newView = new CustomView(this.NewDatabase.Root);

					//Create list of all columns (new and old)
					var columns = new SortedList<string, DataTreeItem>();
					foreach (Reference r in oldView.Columns)
					{
						var column = (CustomViewColumn)r.Object;
						var dti = new DataTreeItem(column.Name);

						//Check for deleted status
						if (this.NewDatabase.CustomViews.Contains(itemCache[oldView.Name.ToLower()].Name))
						{
							var statusColumn = this.NewDatabase.CustomViews[itemCache[oldView.Name.ToLower()].Name].GetColumns().FirstOrDefault(x => x.Name == column.Name);
							if (statusColumn == null)
								dti.State = DataTreeItem.DataTreeItemStateConstants.Delete;
							else if (column.CorePropertiesHash != statusColumn.CorePropertiesHash)
								dti.State = DataTreeItem.DataTreeItemStateConstants.Modified;
						}

						columns.Add(column.Name.ToLower(), dti);

					}

					#region Added Columns
					//if (oldView.Name == string.Empty)
					//{
					//  foreach (CustomViewColumn column in this.NewDatabase.CustomViews[viewKey].GetColumns())
					//  {
					//    columns.Add(column.Name.ToLower(), new DataTreeItem(column.Name, DataTreeItem.DataTreeItemStateConstants.Added));
					//  }
					//}
					//else
					//{
					//  if (this.NewDatabase.CustomViews.Contains(itemCache[oldView.Name.ToLower()].Name))
					//  {
					//    foreach (CustomViewColumn column in this.NewDatabase.CustomViews[itemCache[oldView.Name.ToLower()].Name].GetColumns())
					//    {
					//      CustomViewColumn statusColumn = this.CurrentDatabase.CustomViews[itemCache[oldView.Name.ToLower()].Name].GetColumns().FirstOrDefault(x => x.Name == column.Name);
					//      if (statusColumn == null)
					//        columns.Add(column.Name.ToLower(), new DataTreeItem(column.Name, DataTreeItem.DataTreeItemStateConstants.Added));
					//    }
					//  }
					//}

					////Now load columns into tree
					//if (this.NewDatabase.CustomViews.Contains(oldView.Name))
					//{
					//  foreach (string columnKey in columns.Keys)
					//  {
					//    var columnNode = new TreeNode(columns[columnKey].Name);
					//    if (columns[columnKey].State == DataTreeItem.DataTreeItemStateConstants.Added)
					//      columnNode.ForeColor = Color.Green;
					//    if (columns[columnKey].State == DataTreeItem.DataTreeItemStateConstants.Delete)
					//      columnNode.ForeColor = Color.Red;
					//    if (columns[columnKey].State == DataTreeItem.DataTreeItemStateConstants.Modified)
					//      columnNode.ForeColor = Color.Blue;

					//    columnNode.Tag = columns[columnKey];
					//    viewNode.Nodes.Add(columnNode);
					//  }
					//}
					#endregion

				}

			}
			catch (Exception ex)
			{
				throw;
			}
		}
示例#11
0
		public ImportColumns(CustomView view, ReferenceCollection columnList)
			: this()
		{
			_view = view;
			_columnList = columnList;
		}