BusinessObjectLINQGeneratedTemplate.cs

/trunk/Source/nHydrate.Generator.EFDAL/Generators/LINQ/BusinessObjectLINQGeneratedTemplate.cs

#
C# | 277 lines | 202 code | 35 blank | 40 comment | 17 complexity | 68338d55849908d124d3c0db02289aaa MD5 | raw file
Possible License(s): JSON, CC-BY-SA-3.0

#region Copyright (c) 2006-2012 nHydrate.org, All Rights Reserved

//--------------------------------------------------------------------- *

//                          NHYDRATE.ORG                                *

//             Copyright (c) 2006-2012 All Rights reserved              *

//                                                                      *

//                                                                      *

//This file and its contents are protected by United States and         *

//International copyright laws.  Unauthorized reproduction and/or       *

//distribution of all or any portion of the code contained herein       *

//is strictly prohibited and will result in severe civil and criminal   *

//penalties.  Any violations of this copyright will be prosecuted       *

//to the fullest extent possible under law.                             *

//                                                                      *

//THE SOURCE CODE CONTAINED HEREIN AND IN RELATED FILES IS PROVIDED     *

//TO THE REGISTERED DEVELOPER FOR THE PURPOSES OF EDUCATION AND         *

//TROUBLESHOOTING. UNDER NO CIRCUMSTANCES MAY ANY PORTION OF THE SOURCE *

//CODE BE DISTRIBUTED, DISCLOSED OR OTHERWISE MADE AVAILABLE TO ANY     *

//THIRD PARTY WITHOUT THE EXPRESS WRITTEN CONSENT OF THE NHYDRATE GROUP *

//                                                                      *

//UNDER NO CIRCUMSTANCES MAY THE SOURCE CODE BE USED IN WHOLE OR IN     *

//PART, AS THE BASIS FOR CREATING A PRODUCT THAT PROVIDES THE SAME, OR  *

//SUBSTANTIALLY THE SAME, FUNCTIONALITY AS THIS PRODUCT                 *

//                                                                      *

//THE REGISTERED DEVELOPER ACKNOWLEDGES THAT THIS SOURCE CODE           *

//CONTAINS VALUABLE AND PROPRIETARY TRADE SECRETS OF NHYDRATE,          *

//THE REGISTERED DEVELOPER AGREES TO EXPEND EVERY EFFORT TO             *

//INSURE ITS CONFIDENTIALITY.                                           *

//                                                                      *

//THE END USER LICENSE AGREEMENT (EULA) ACCOMPANYING THE PRODUCT        *

//PERMITS THE REGISTERED DEVELOPER TO REDISTRIBUTE THE PRODUCT IN       *

//EXECUTABLE FORM ONLY IN SUPPORT OF APPLICATIONS WRITTEN USING         *

//THE PRODUCT.  IT DOES NOT PROVIDE ANY RIGHTS REGARDING THE            *

//SOURCE CODE CONTAINED HEREIN.                                         *

//                                                                      *

//THIS COPYRIGHT NOTICE MAY NOT BE REMOVED FROM THIS FILE.              *

//--------------------------------------------------------------------- *

#endregion



using System;

using System.Linq;

using System.Text;

using nHydrate.Generator.Models;



namespace nHydrate.Generator.EFDAL.Generators.LINQ

{

	class LINQGeneratedTemplate : EFDALBaseTemplate

	{

		private readonly StringBuilder sb = new StringBuilder();



		public LINQGeneratedTemplate(ModelRoot model)

		{

			_model = model;

		}



		#region BaseClassTemplate overrides

		public override string FileName

		{

			get { return _model.ProjectName + "EntitiesQueries.Generated.cs"; }

		}



		public string ParentItemName

		{

			get { return _model.ProjectName + "EntitiesQueries.cs"; }

		}



		public override string FileContent

		{

			get

			{

				GenerateContent();

				return sb.ToString();

			}

		}

		#endregion



		#region GenerateContent



		private void GenerateContent()

		{

			try

			{

				nHydrate.Generator.GenerationHelper.AppendCopyrightInCode(sb, _model);

				this.AppendUsingStatements();

				sb.AppendLine("namespace " + this.GetLocalNamespace());

				sb.AppendLine("{");

				foreach (var table in _model.Database.Tables.Where(x => x.Generated).OrderBy(x => x.Name))

				{

					this.AppendTableClass(table);

				}

				sb.AppendLine("}");

			}

			catch (Exception ex)

			{

				throw;

			}



		}



		#endregion



		#region namespace / objects



		public void AppendUsingStatements()

		{

			sb.AppendLine("using System;");

			sb.AppendLine("using System.Data;");

			sb.AppendLine("using System.Linq;");

			sb.AppendLine("using System.Data.Linq;");

			sb.AppendLine("using System.Linq.Expressions;");

			sb.AppendLine("using System.Data.Linq.Mapping;");

			sb.AppendLine("using System.Collections;");

			sb.AppendLine("using System.Collections.Generic;");

			sb.AppendLine("using " + this.GetLocalNamespace() + ";");

			sb.AppendLine("using nHydrate.EFCore.DataAccess;");

			sb.AppendLine();

		}



		private void AppendTableClass(Table table)

		{

			try

			{

				sb.AppendLine("	#region " + table.PascalName + "Query");

				sb.AppendLine();



				sb.AppendLine("	/// <summary>");

				sb.AppendLine("	/// This is a helper object for running LINQ queries on the " + table.PascalName + " collection.");

				sb.AppendLine("	/// </summary>");

				sb.AppendLine("	[Serializable()]");

				sb.AppendLine("	[Table(Name = \"" + table.DatabaseName + "\")]");

				sb.AppendLine("	[System.CodeDom.Compiler.GeneratedCode(\"nHydrateModelGenerator\", \"" + _model.ModelToolVersion + "\")]");

				sb.AppendLine("	public partial class " + table.PascalName + "Query : nHydrate.EFCore.DataAccess.IBusinessObjectLINQQuery");

				sb.AppendLine("	{");



				sb.AppendLine("		#region Properties");

				var allTables = table.GetTableHierarchy();



				var columnList = table.GetColumnsFullHierarchy().Where(x => x.Generated).ToList();

				foreach (var c in columnList.OrderBy(x => x.Name))

				{

					var description = c.Description.Trim();

					if (!string.IsNullOrEmpty(description)) description += "\r\n		///";

					description += "(Maps to the '" + table.DatabaseName + "." + c.DatabaseName + "' database field)";



					sb.AppendLine("		/// <summary>");

					sb.AppendLine("		/// " + description);

					sb.AppendLine("		/// </summary>");

					sb.Append("		[Column(");

					sb.Append("Name = \"" + c.DatabaseName + "\", ");

					sb.Append("DbType = \"" + c.DatabaseTypeRaw + "\", ");

					sb.Append("CanBeNull = " + c.AllowNull.ToString().ToLower() + ", ");

					sb.Append("IsPrimaryKey = " + table.PrimaryKeyColumns.Contains(c).ToString().ToLower());

					sb.AppendLine(")]");

					sb.AppendLine("		public virtual " + c.GetCodeType(true) + " " + c.PascalName + " { get; set; }");

				}



				if (table.AllowCreateAudit)

				{

					sb.AppendLine("		/// <summary>");

					sb.AppendLine("		/// The date of creation");

					sb.AppendLine("		/// </summary>");

					sb.AppendLine("		[Column(Name = \"" + _model.Database.CreatedDateColumnName + "\", DbType = \"DateTime\", CanBeNull = true)]");

					sb.AppendLine("		public virtual DateTime? " + _model.Database.CreatedDatePascalName + " { get; set; }");



					sb.AppendLine("		/// <summary>");

					sb.AppendLine("		/// The name of the creating entity");

					sb.AppendLine("		/// </summary>");

					sb.AppendLine("		[Column(Name = \"" + _model.Database.CreatedByColumnName + "\", DbType = \"VarChar(100)\", CanBeNull = true)]");

					sb.AppendLine("		public virtual string " + _model.Database.CreatedByPascalName + " { get; set; }");

				}



				if (table.AllowModifiedAudit)

				{

					sb.AppendLine("		/// <summary>");

					sb.AppendLine("		/// The date of last modification");

					sb.AppendLine("		/// </summary>");

					sb.AppendLine("		[Column(Name = \"" + _model.Database.ModifiedDateColumnName + "\", DbType = \"DateTime\", CanBeNull = true)]");

					sb.AppendLine("		public virtual DateTime? " + _model.Database.ModifiedDatePascalName + " { get; set; }");



					sb.AppendLine("		/// <summary>");

					sb.AppendLine("		/// The name of the last modifing entity");

					sb.AppendLine("		/// </summary>");

					sb.AppendLine("		[Column(Name = \"" + _model.Database.ModifiedByColumnName + "\", DbType = \"VarChar(100)\", CanBeNull = true)]");

					sb.AppendLine("		public virtual string " + _model.Database.ModifiedByPascalName + " { get; set; }");

				}



				if (table.AllowTimestamp)

				{

					sb.AppendLine("		/// <summary>");

					sb.AppendLine("		/// This is an internal field and is not to be used.");

					sb.AppendLine("		/// </summary>");

					sb.AppendLine("		[Column(Name = \"" + _model.Database.TimestampColumnName + "\", DbType = \"Binary\", CanBeNull = false)]");

					sb.AppendLine("		public virtual byte[] " + _model.Database.TimestampPascalName + " { get; set; }");

				}



				//Add child relationships

				foreach (var relation in _model.Database.Relations.FindByParentTable(table, true).Where(x => x.IsGenerated))

				{

					//Relation relation = (Relation)reference.Object;

					var parentTable = (Table)relation.ParentTableRef.Object;

					var childTable = (Table)relation.ChildTableRef.Object;

					//Column pkColumn = (Column)relation.ColumnRelationships[0].ChildColumnRef.Object;



					var thisKey = string.Empty;

					var otherKey = string.Empty;

					foreach (ColumnRelationship columnRelationship in relation.ColumnRelationships)

					{

						thisKey += ((Column)columnRelationship.ParentColumnRef.Object).PascalName + ",";

						otherKey += ((Column)columnRelationship.ChildColumnRef.Object).PascalName + ",";

					}

					if (!string.IsNullOrEmpty(thisKey)) thisKey = thisKey.Substring(0, thisKey.Length - 1);

					if (!string.IsNullOrEmpty(otherKey)) otherKey = otherKey.Substring(0, otherKey.Length - 1);



					if (childTable.Generated && (!allTables.Contains(childTable)))

					{

						sb.AppendLine("		/// <summary>");

						sb.AppendLine("		/// This is a mapping of the relationship with the " + childTable.PascalName + " entity." + (relation.PascalRoleName == "" ? "" : " (Role: '" + relation.RoleName + "')"));

						sb.AppendLine("		/// </summary>");

						sb.AppendLine("		[Association(ThisKey = \"" + thisKey + "\", OtherKey = \"" + otherKey + "\")]");

						if (relation.IsOneToOne)

							sb.AppendLine("		public " + this.GetLocalNamespace() + "." + childTable.PascalName + "Query " + relation.PascalRoleName + childTable.PascalName + " { get; private set; }");

						else

							sb.AppendLine("		public " + this.GetLocalNamespace() + "." + childTable.PascalName + "Query " + relation.PascalRoleName + childTable.PascalName + "List { get; private set; }");

					}



				}



				//Add parent relationships

				foreach (var relation in _model.Database.Relations.FindByChildTable(table, true).Where(x => x.IsGenerated))

				{

					var parentTable = (Table)relation.ParentTableRef.Object;

					var childTable = (Table)relation.ChildTableRef.Object;



					//Do not process self-referencing relationships

					if (parentTable != table)

					{

						var thisKey = string.Empty;

						var otherKey = string.Empty;

						foreach (ColumnRelationship columnRelationship in relation.ColumnRelationships)

						{

							thisKey += ((Column)columnRelationship.ChildColumnRef.Object).PascalName + ",";

							otherKey += ((Column)columnRelationship.ParentColumnRef.Object).PascalName + ",";

						}

						if (!string.IsNullOrEmpty(thisKey)) thisKey = thisKey.Substring(0, thisKey.Length - 1);

						if (!string.IsNullOrEmpty(otherKey)) otherKey = otherKey.Substring(0, otherKey.Length - 1);



						if (parentTable.Generated && (!allTables.Contains(parentTable)))

						{

							sb.AppendLine("		/// <summary>");

							sb.AppendLine("		/// This is a mapping of the relationship with the " + parentTable.PascalName + " entity." + (relation.PascalRoleName == "" ? "" : " (Role: '" + relation.RoleName + "')"));

							sb.AppendLine("		/// </summary>");

							sb.AppendLine("		[Association(ThisKey = \"" + thisKey + "\", OtherKey = \"" + otherKey + "\")]");

							sb.AppendLine("		public " + this.GetLocalNamespace() + "." + parentTable.PascalName + "Query " + relation.PascalRoleName + parentTable.PascalName + " { get; private set; }");

						}



					}

				}



				sb.AppendLine();

				sb.AppendLine("		#endregion");

				sb.AppendLine();

				sb.AppendLine("	}");

				sb.AppendLine();



				sb.AppendLine("	#endregion");

				sb.AppendLine();



			}

			catch (Exception ex)

			{

				throw;

			}

		}



		#endregion



	}

}