BusinessComponentLINQGeneratedTemplate.cs

/branches/v41/Source/Widgetsphere.Generator.DAL/ProjectItemGenerators/BusinessComponentLINQ/BusinessComponentLINQGeneratedTemplate.cs

#
C# | 267 lines | 192 code | 33 blank | 42 comment | 16 complexity | c0eb3772942c35b0ddfae4d786ee783c MD5 | raw file
Possible License(s): JSON, CC-BY-SA-3.0

#region Copyright (c) 2006-2011 Widgetsphere LLC, All Rights Reserved

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

//                          Widgetsphere  LLC                           *

//             Copyright (c) 2006-2011 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 WIDGETSPHERE LLC   *

//                                                                      *

//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 ANY WIDGETSPHERE PRODUCT.    *

//                                                                      *

//THE REGISTERED DEVELOPER ACKNOWLEDGES THAT THIS SOURCE CODE           *

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

//INC.  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 Widgetsphere.Generator.Models;



namespace Widgetsphere.Generator.DAL.ProjectItemGenerators.BusinessComponentLINQ

{

	class BusinessComponentLINQGeneratedTemplate : DomainProjectTemplate

	{

		private readonly StringBuilder sb = new StringBuilder();

		private readonly TableComponent _currentComponent;



		public BusinessComponentLINQGeneratedTemplate(ModelRoot model, TableComponent currentComponent)

		{

			_model = model;

			_currentComponent = currentComponent;

		}



		#region BaseClassTemplate overrides

		public override string FileName

		{

			get { return string.Format("{0}.Generated.cs", _currentComponent.PascalName); }

		}



		public string ParentItemName

		{

			get

			{

				return string.Format("{0}.cs", _currentComponent.PascalName);

			}

		}



		public override string FileContent

		{

			get

			{

				GenerateContent();

				return sb.ToString();

			}

		}

		#endregion



		#region GenerateContent



		private void GenerateContent()

		{

			try

			{

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

				this.AppendUsingStatements();

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

				sb.AppendLine("{");

				this.AppendClass();

				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 Widgetsphere.Core.DataAccess;");

			sb.AppendLine();

		}



		private void AppendClass()

		{

			try

			{

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

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

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

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

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

				sb.AppendLine("	public partial class " + _currentComponent.PascalName + "Query");

				sb.AppendLine("	{");



				sb.AppendLine("		#region Properties");



				foreach (var column in _currentComponent.GetColumns())

				{

					var description = column.Description.Trim();

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

					description += "(Maps to the '" + _currentComponent.DatabaseName + "." + column.DatabaseName + "' database field)";



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

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

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

					sb.Append("		[Column(");

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

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

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

					sb.Append("IsPrimaryKey = " + _currentComponent.Parent.PrimaryKeyColumns.Contains(column).ToString().ToLower());

					sb.AppendLine(")]");

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

				}



				if (_currentComponent.Parent.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 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 string " + _model.Database.CreatedByPascalName + " { get; set; }");

				}



				if (_currentComponent.Parent.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 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 string " + _model.Database.ModifiedByPascalName + " { get; set; }");

				}



				if (_currentComponent.Parent.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 byte[] " + _model.Database.TimestampPascalName + " { get; set; }");

				}

				sb.AppendLine();



				//Add child relationships

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

				{

					//Relation relation = (Relation)reference.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 generated and not an ancestor of the parent table

					if (childTable.Generated && !_currentComponent.Parent.IsInheritedFrom(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 + "\")]");

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

					}



				}



				//Add parent relationships

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

				{

					var parentTable = relation.ParentTableRef.Object as Table;



					//Do not process self-referencing relationships

					if (parentTable != _currentComponent.Parent)

					{

						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 generated and not an ancestor of the parent table

						if (parentTable.Generated && !_currentComponent.Parent.IsInheritedFrom(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 " + parentTable.PascalName + "Query " + relation.PascalRoleName + parentTable.PascalName + " { get; private set; }");

						}



					}

				}



				sb.AppendLine();

				sb.AppendLine("		#endregion");

				sb.AppendLine();

				sb.AppendLine("	}");

				sb.AppendLine();

			}

			catch (Exception ex)

			{

				throw;

			}

		}



		#endregion



	}

}