private void AppendRegionGetFriendlyName() { sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// Gets the friendly name (if one is defined) of the field."); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public static string GetFriendlyName(FieldNameConstants field)"); sb.AppendLine(" {"); sb.AppendLine(" switch (field)"); sb.AppendLine(" {"); foreach (Reference reference in _currentView.Columns) { CustomViewColumn column = (CustomViewColumn)reference.Object; if (column.Generated) { sb.AppendLine(" case FieldNameConstants."+ column.PascalName + ":"); sb.AppendLine(" return \""+ column.FriendlyName + "\";"); } } sb.AppendLine(" }"); sb.AppendLine(" return \"\";"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" string IBusinessObject.GetFriendlyName(Enum field)"); sb.AppendLine(" {"); sb.AppendLine(" return GetFriendlyName((FieldNameConstants)field);"); sb.AppendLine(" }"); sb.AppendLine(); }
private void AppendRegionGetMaxLength() { sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// Gets the maximum size of the field value."); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public static int GetMaxLength(FieldNameConstants field)"); sb.AppendLine(" {"); sb.AppendLine(" switch (field)"); sb.AppendLine(" {"); foreach (Reference reference in _currentView.Columns) { CustomViewColumn column = (CustomViewColumn)reference.Object; if (column.Generated) { sb.AppendLine(" case FieldNameConstants."+ column.PascalName + ":"); if (ModelHelper.IsTextType(column.DataType)) { sb.AppendLine(" return "+ column.Length + ";"); } else { sb.AppendLine(" return 0;"); } } } sb.AppendLine(" }"); sb.AppendLine(" return 0;"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" int IBusinessObject.GetMaxLength(Enum field)"); sb.AppendLine(" {"); sb.AppendLine(" return GetMaxLength((FieldNameConstants)field);"); sb.AppendLine(" }"); sb.AppendLine(); }
public ArrayList GetValidSearchColumns() { try { ArrayList validColumns = new ArrayList(); foreach (Reference reference in _currentView.GeneratedColumns) { CustomViewColumn dc = (CustomViewColumn)reference.Object; if (!(dc.DataType == System.Data.SqlDbType.Binary || dc.DataType == System.Data.SqlDbType.Image || dc.DataType == System.Data.SqlDbType.NText || dc.DataType == System.Data.SqlDbType.Text || dc.DataType == System.Data.SqlDbType.Timestamp || dc.DataType == System.Data.SqlDbType.Udt || dc.DataType == System.Data.SqlDbType.VarBinary || dc.DataType == System.Data.SqlDbType.Variant || dc.DataType == System.Data.SqlDbType.Money)) { validColumns.Add(dc); } } return(validColumns); } catch (Exception ex) { throw new Exception(_currentView.PascalName + ": Failed on generation of select or template", ex); } }
private void AppendRegionConstructors() { sb.AppendLine(" #region Contructors /Initialization"); sb.AppendLine(); sb.AppendLine(" internal Domain"+ _currentView.PascalName + "Collection():base(\"" + _currentView.PascalName + "\")"); sb.AppendLine(" {"); sb.AppendLine(" try"); sb.AppendLine(" {"); sb.AppendLine(" base.TableName = \""+ _currentView.PascalName + "Collection\";"); sb.AppendLine(" this.InitClass();"); sb.AppendLine(" }"); Globals.AppendBusinessEntryCatch(sb); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" private void InitClass() "); sb.AppendLine(" {"); sb.AppendLine(" BeginInit();"); //Create columns foreach (Reference reference in _currentView.GeneratedColumns) { CustomViewColumn column = (CustomViewColumn)reference.Object; sb.AppendLine(" this.column"+ column.PascalName + " = new DataColumn(\"" + column.DatabaseName + "\", typeof(" + column.GetCodeType() + "), null, System.Data.MappingType.Element);"); sb.AppendLine(" base.Columns.Add(this.column"+ column.PascalName + ");"); sb.AppendLine(" this.column"+ column.PascalName + ".AllowDBNull = true;"); sb.AppendLine(" this.column"+ column.PascalName + ".Caption = \"" + column.PascalName + "\";"); sb.AppendLine(" this.column"+ column.PascalName + ".ReadOnly = true;"); } sb.AppendLine(" EndInit();"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" #endregion"); sb.AppendLine(); }
private string GetPropertyNode(CustomViewColumn column) { var propertyString = new StringBuilder(); //Attributes Name and Type propertyString.AppendFormat(" <Property Name=\"{0}\" Type=\"{1}\" ", column.PascalName, column.EFSqlCodeType()); //Attribute Nullable propertyString.Append("Nullable=\"" + (column.AllowNull ? "true" : "false") + "\" "); //Attribute MaxLength if (!string.IsNullOrEmpty(column.EFGetCodeMaxLengthString())) { propertyString.AppendFormat("MaxLength=\"{0}\" ", column.EFGetCodeMaxLengthString()); } //Attribute Precision Scale if (column.EFSupportsPrecision()) { propertyString.AppendFormat("Precision=\"{0}\" Scale=\"{1}\" ", column.Length.ToString(), column.Scale); } //Attribute Unicode if (column.EFUnicode().HasValue) { var unicodeString = column.EFUnicode().Value ? "true" : "false"; propertyString.AppendFormat("Unicode=\"{0}\" ", unicodeString); } //Attribute FixedLength if (column.EFIsFixedLength().HasValue) { var isFixedLengthString = column.EFIsFixedLength().Value ? "true" : "false"; propertyString.AppendFormat("FixedLength=\"{0}\" ", isFixedLengthString); } //Primary Key /* * if (column.PrimaryKey) * { * //propertyString.Append("xmlns:a=\"http://schemas.microsoft.com/ado/2006/04/codegeneration\" "); * if (column.IsIntegerType && column.Identity == IdentityTypeConstants.Database) * { * //propertyString.Append("a:SetterAccess=\"Private\" DefaultValue=\"-1\" annotation:StoreGeneratedPattern=\"Identity\" "); * propertyString.Append("DefaultValue=\"-1\" annotation:StoreGeneratedPattern=\"Identity\" "); * } * else * { * //propertyString.Append("a:SetterAccess=\"Public\" "); * } * } */ propertyString.Append("/>").AppendLine(); return(propertyString.ToString()); }
private void AppendRegionDataColumnsSetup() { sb.AppendLine(" #region Data Columns Setup"); foreach (Reference reference in _currentView.GeneratedColumns) { CustomViewColumn column = (CustomViewColumn)reference.Object; sb.AppendLine(" private DataColumn column"+ column.PascalName + ";"); sb.AppendLine(); sb.AppendLine(" [Widgetsphere.Core.Attributes.DataSetting(\"\", false, 0)]"); sb.AppendLine(" public DataColumn "+ column.PascalName + "Column"); sb.AppendLine(" {"); sb.AppendLine(" get { return this.column"+ column.PascalName + "; }"); sb.AppendLine(" }"); sb.AppendLine(); } sb.AppendLine(" #endregion"); sb.AppendLine(); }
public static string BuildSelectList(CustomView view, ModelRoot model) { int index = 0; StringBuilder output = new StringBuilder(); foreach (Reference columnRef in view.GeneratedColumns) { CustomViewColumn dc = (CustomViewColumn)columnRef.Object; output.Append("CONVERT(" + dc.DatabaseType + ", [view_" + view.DatabaseName + "].[" + dc.DatabaseName + "]) AS [" + dc.DatabaseName + "]"); if (index < view.GeneratedColumns.Count - 1) { output.Append(","); } output.AppendLine(); index++; } return(output.ToString()); }
private ArrayList GetValidSearchColumns() { ArrayList validColumns = new ArrayList(); foreach (Reference reference in _currentView.GeneratedColumns) { CustomViewColumn dc = (CustomViewColumn)reference.Object; if (!(dc.DataType == System.Data.SqlDbType.Binary || dc.DataType == System.Data.SqlDbType.Image || dc.DataType == System.Data.SqlDbType.NText || dc.DataType == System.Data.SqlDbType.Text || dc.DataType == System.Data.SqlDbType.Timestamp || dc.DataType == System.Data.SqlDbType.Udt || dc.DataType == System.Data.SqlDbType.VarBinary || dc.DataType == System.Data.SqlDbType.Variant || dc.DataType == System.Data.SqlDbType.Money)) { validColumns.Add(dc); } } return(validColumns); }
private void AppendRegionGetFieldLength() { sb.AppendLine(" #region GetFieldLength"); sb.AppendLine(); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// Determines the length of the specified field if it can be set."); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public int GetFieldLength("+ _currentView.PascalName + ".FieldNameConstants field)"); sb.AppendLine(" {"); foreach (Reference colRef in _currentView.Columns) { CustomViewColumn column = (CustomViewColumn)colRef.Object; if (ModelHelper.IsTextType(column.DataType)) { sb.AppendLine(" if(field == FieldNameConstants."+ column.PascalName + ")"); sb.AppendLine(" return "+ column.Length + ";"); } } sb.AppendLine(" //Catch all for all other data types"); sb.AppendLine(" return -1;"); sb.AppendLine(" }"); sb.AppendLine(" #endregion"); sb.AppendLine(); }
private void AppendRegionGetDefault() { sb.AppendLine(" #region GetDefault"); sb.AppendLine(); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// Gets the default value of one of this object's properties."); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public object GetDefault(FieldNameConstants field)"); sb.AppendLine(" {"); foreach (Reference reference in _currentView.GeneratedColumns) { CustomViewColumn dbColumn = (CustomViewColumn)reference.Object; sb.AppendLine(" if(field == FieldNameConstants."+ dbColumn.PascalName + ")"); switch (dbColumn.DataType) { case System.Data.SqlDbType.Char: case System.Data.SqlDbType.NChar: case System.Data.SqlDbType.NText: case System.Data.SqlDbType.NVarChar: case System.Data.SqlDbType.Text: case System.Data.SqlDbType.VarChar: case System.Data.SqlDbType.UniqueIdentifier: sb.AppendLine(" return \""+ dbColumn.Default + "\";"); break; case System.Data.SqlDbType.BigInt: case System.Data.SqlDbType.Int: case System.Data.SqlDbType.SmallInt: case System.Data.SqlDbType.TinyInt: if (dbColumn.AllowNull) { sb.AppendLine(" return null;"); } else { long lvalue; if (long.TryParse("0" + dbColumn.Default, out lvalue)) { sb.AppendLine(" return 0"+ dbColumn.Default + ";"); } else //THIS IS AN ERROR CONDITION { sb.AppendLine(" return 0;"); } } break; case System.Data.SqlDbType.DateTime: case System.Data.SqlDbType.SmallDateTime: if (dbColumn.AllowNull) { sb.AppendLine(" return null;"); } else { DateTime dtvalue; if (dbColumn.Default == "") { sb.AppendLine(" return DateTime.Now;"); } else if (DateTime.TryParse(dbColumn.Default, out dtvalue)) { sb.AppendLine(" return DateTime.Parse(\""+ dbColumn.Default + "\");"); } else //THIS IS AN ERROR CONDITION { sb.AppendLine(" return DateTime.Now;"); } } break; case System.Data.SqlDbType.Bit: bool bvalue; if (bool.TryParse(dbColumn.Default, out bvalue)) { sb.AppendLine(" return "+ (bvalue ? "true" : "false") + ";"); } else //THIS IS AN ERROR CONDITION { sb.AppendLine(" return false;"); } break; case System.Data.SqlDbType.Decimal: case System.Data.SqlDbType.Float: case System.Data.SqlDbType.Money: case System.Data.SqlDbType.Real: case System.Data.SqlDbType.SmallMoney: if (dbColumn.AllowNull) { sb.AppendLine(" return null;"); } else { decimal dvalue; if (decimal.TryParse("0" + dbColumn.Default, out dvalue)) { sb.AppendLine(" return 0"+ dbColumn.Default + ";"); } else //THIS IS AN ERROR CONDITION { sb.AppendLine(" return 0;"); } } break; } } sb.AppendLine(); sb.AppendLine(" return null;"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" object IBusinessObject.GetDefault(Enum field)"); sb.AppendLine(" {"); sb.AppendLine(" return this.GetDefault((FieldNameConstants)field);"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" #endregion"); sb.AppendLine(); }
private void AppendFullTemplate(StringBuilder sb) { int index = 0; try { sb.AppendLine("if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[" + this.StoredProcedureName + "]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)"); sb.AppendLine(" drop procedure [dbo].[" + this.StoredProcedureName + "]"); sb.AppendLine("GO"); sb.AppendLine(); sb.AppendLine("SET QUOTED_IDENTIFIER ON "); sb.AppendLine("GO"); sb.AppendLine("SET ANSI_NULLS ON "); sb.AppendLine("GO"); sb.AppendLine(); sb.AppendLine("CREATE PROCEDURE [dbo].[" + this.StoredProcedureName + "]"); sb.AppendLine("("); sb.AppendLine(" @page int, -- page number selected by the user"); sb.AppendLine(" @pageSize int, -- number of items on the page"); sb.AppendLine(" @orderByColumn varchar(100), -- name of column to order things by"); sb.AppendLine(" @ascending bit, -- order column ascending or descending"); sb.AppendLine(" @filter varchar(100) = null, -- filter statement passed in to determine like criteria on order by column"); sb.AppendLine(" @count int out -- number of items in the collection"); sb.AppendLine(")"); sb.AppendLine("AS"); sb.AppendLine(); sb.AppendLine("SET NOCOUNT ON;"); sb.AppendLine(); sb.AppendLine(); sb.AppendLine("CREATE TABLE #tmpTable "); sb.AppendLine("("); index = 0; foreach (Reference reference in _currentView.Columns) { CustomViewColumn column = (CustomViewColumn)reference.Object; sb.Append("[" + column.DatabaseName + "]" + " " + column.DataType); if (StringHelper.Match(column.DataType.ToString(), "binary", true) || StringHelper.Match(column.DataType.ToString(), "char", true) || StringHelper.Match(column.DataType.ToString(), "decimal", true) || StringHelper.Match(column.DataType.ToString(), "nchar", true) || StringHelper.Match(column.DataType.ToString(), "numeric", true) || StringHelper.Match(column.DataType.ToString(), "nvarchar", true) || StringHelper.Match(column.DataType.ToString(), "varbinary", true) || StringHelper.Match(column.DataType.ToString(), "varchar", true)) { sb.Append("(" + column.Length + ")"); } if (index < _currentView.Columns.Count - 1) { sb.Append(","); } sb.Append(Environment.NewLine + "\t"); index++; } sb.AppendLine(")"); sb.AppendLine(); sb.AppendLine("DECLARE @total__ivqatedr int"); sb.AppendLine("DECLARE @orderByColumnIndex int"); sb.AppendLine("INSERT INTO #tmpTable"); sb.AppendLine("("); index = 0; foreach (Reference reference in _currentView.Columns) { CustomViewColumn column = (CustomViewColumn)reference.Object; sb.Append("[" + column.DatabaseName + "]"); if (index < _currentView.Columns.Count - 1) { sb.Append(","); } sb.Append(Environment.NewLine + "\t"); index++; } sb.AppendLine(")"); sb.AppendLine("SELECT"); index = 0; foreach (Reference reference in _currentView.Columns) { CustomViewColumn column = (CustomViewColumn)reference.Object; sb.Append("CONVERT(" + column.DatabaseType + ", [view_" + _currentView.DatabaseName + "].[" + column.DatabaseName + "]) AS [" + column.DatabaseName + "]"); if (index < _currentView.Columns.Count - 1) { sb.Append(","); } sb.Append(Environment.NewLine + "\t"); index++; } sb.AppendLine("FROM"); sb.AppendLine(" [view_" + _currentView.DatabaseName + "]"); sb.AppendLine("WHERE"); index = 0; foreach (Reference reference in _currentView.Columns) { CustomViewColumn column = (CustomViewColumn)reference.Object; sb.Append(" (@orderByColumn = '" + column.DatabaseName + "' and (((@filter is null) and ([view_" + _currentView.DatabaseName + "].[" + column.DatabaseName + "] is null)) or (@filter is not null and [view_" + _currentView.DatabaseName + "].[" + column.DatabaseName + "] LIKE @filter)))"); if (index < _currentView.Columns.Count - 1) { sb.Append(" OR "); } sb.Append(Environment.NewLine + "\t"); index++; } sb.AppendLine("ORDER BY"); index = 0; foreach (Reference reference in _currentView.Columns) { CustomViewColumn column = (CustomViewColumn)reference.Object; sb.AppendLine(" CASE @ascending WHEN 0 THEN CASE @orderByColumn WHEN '" + column.DatabaseName + "' THEN [view_" + _currentView.DatabaseName + "].[" + column.DatabaseName + "] END END DESC, "); sb.Append(" CASE @ascending WHEN 1 THEN CASE @orderByColumn WHEN '" + column.DatabaseName + "' THEN [view_" + _currentView.DatabaseName + "].[" + column.DatabaseName + "] END END"); if (index < _currentView.Columns.Count - 1) { sb.Append(","); } sb.Append(Environment.NewLine + "\t"); index++; } sb.AppendLine(); sb.AppendLine("-- set @count based on the rows moved in the previous statement"); sb.AppendLine("SET @count = ( SELECT count(*) FROM [#tmpTable] )"); sb.AppendLine(); sb.AppendLine("-- remove top x values from the temp table based upon the specific page requested"); sb.AppendLine("SET @total__ivqatedr = (@pageSize * @page) - @pageSize"); sb.AppendLine("IF (@total__ivqatedr <> 0)"); sb.AppendLine("BEGIN"); sb.AppendLine(" SET ROWCOUNT @total__ivqatedr"); sb.AppendLine(" DELETE FROM #tmpTable"); sb.AppendLine("END"); sb.AppendLine(); sb.AppendLine("-- return the number of rows requested as the page size"); sb.AppendLine("SET ROWCOUNT @pageSize"); sb.AppendLine("SELECT"); index = 0; foreach (Reference reference in _currentView.Columns) { CustomViewColumn column = (CustomViewColumn)reference.Object; sb.Append("[" + column.DatabaseName + "]"); if (index < _currentView.Columns.Count - 1) { sb.Append(","); } sb.Append(Environment.NewLine + "\t"); index++; } sb.AppendLine("FROM"); sb.AppendLine("#tmpTable"); sb.AppendLine("ORDER BY"); index = 0; foreach (Reference reference in _currentView.Columns) { CustomViewColumn column = (CustomViewColumn)reference.Object; sb.AppendLine(" CASE @ascending WHEN 0 THEN CASE @orderByColumn WHEN '" + column.DatabaseName + "' THEN [" + column.DatabaseName + "] END END DESC, "); sb.Append(" CASE @ascending WHEN 1 THEN CASE @orderByColumn WHEN '" + column.DatabaseName + "' THEN [" + column.DatabaseName + "] END END"); if (index < _currentView.Columns.Count - 1) { sb.Append(","); } sb.Append(Environment.NewLine + "\t"); index++; } sb.AppendLine(); sb.AppendLine("DROP TABLE #tmpTable"); sb.AppendLine(); sb.AppendLine(); sb.AppendLine("GO"); } catch (Exception ex) { throw; } }
private void AppendSearchClass() { ArrayList validColumns = new ArrayList(); foreach (Reference reference in _currentView.GeneratedColumns) { CustomViewColumn dc = (CustomViewColumn)reference.Object; if (!(dc.DataType == System.Data.SqlDbType.Binary || dc.DataType == System.Data.SqlDbType.Image || dc.DataType == System.Data.SqlDbType.NText || dc.DataType == System.Data.SqlDbType.Text || dc.DataType == System.Data.SqlDbType.Timestamp || dc.DataType == System.Data.SqlDbType.Udt || dc.DataType == System.Data.SqlDbType.VarBinary || dc.DataType == System.Data.SqlDbType.Variant || dc.DataType == System.Data.SqlDbType.Money)) { validColumns.Add(dc); } } if (validColumns.Count != 0) { sb.AppendLine(" #region " + _currentView.PascalName + "SelectBySearch"); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// The select command used to select all rows from the '"+ _currentView.PascalName + "' table"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" [Serializable]"); sb.AppendLine(" public partial class " + _currentView.PascalName + "SelectBySearch : SelectCommand, ISerializable"); sb.AppendLine(" {"); sb.AppendLine(" private "+ _currentView.PascalName + "Search " + _currentView.PascalName + ";"); sb.AppendLine(); sb.AppendLine(" #region Serialization"); sb.AppendLine(); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// Serialization constructor"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" protected "+ _currentView.PascalName + "SelectBySearch(SerializationInfo info, StreamingContext context)"); sb.AppendLine(" : base(info, context)"); sb.AppendLine(" {"); sb.AppendLine(" "+ _currentView.PascalName + " = (" + _currentView.PascalName + "Search)info.GetValue(\"" + _currentView.PascalName + "\", typeof(" + _currentView.PascalName + "Search));"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// Method used internally for serialization"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public override void GetObjectData(SerializationInfo info, StreamingContext context)"); sb.AppendLine(" {"); sb.AppendLine(" base.GetObjectData(info, context);"); sb.AppendLine(" info.AddValue(\""+ _currentView.PascalName + "\", " + _currentView.PascalName + ");"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" #endregion "); sb.AppendLine(); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// Select objects by "+ _currentView.PascalName + " search object"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public "+ _currentView.PascalName + "SelectBySearch(" + _currentView.PascalName + "Search searchObject)"); sb.AppendLine(" {"); sb.AppendLine(" "+ _currentView.PascalName + " = searchObject;"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(); sb.AppendLine(" "); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// Creates a persistable domainCollection"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public override IDomainCollection CreateDomainCollection()"); sb.AppendLine(" {"); sb.AppendLine(" Domain"+ _currentView.PascalName + "Collection colDomain = new Domain" + _currentView.PascalName + "Collection();"); sb.AppendLine(" return colDomain;"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// The stored procedure name to select values by primary key to populate a '"+ _currentView.PascalName + "' collection"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public override string StoredProcedureName"); sb.AppendLine(" {"); sb.AppendLine(" get"); sb.AppendLine(" {"); sb.AppendLine(" if ("+ _currentView.PascalName + ".SearchType == SearchType.OR)"); sb.AppendLine(" return \"gen_"+ Globals.GetPascalName(_model, _currentView) + "SelectBySearchOr\";"); sb.AppendLine(" else"); sb.AppendLine(" return \"gen_"+ Globals.GetPascalName(_model, _currentView) + "SelectBySearchAnd\";"); sb.AppendLine(" }"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// Initializes the parameters for this select command"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" protected override void SetupParameterValues(SubDomainBase subDomain)"); sb.AppendLine(" {"); sb.AppendLine(" if ("+ _currentView.PascalName + " != null)"); sb.AppendLine(" {"); foreach (CustomViewColumn dc in validColumns) { sb.AppendLine(" if ("+ _currentView.PascalName + "." + dc.PascalName + " != null)"); sb.AppendLine(" {"); sb.AppendLine(" ParameterValues.Add(\"@"+ dc.DatabaseName + "\", " + _currentView.PascalName + "." + dc.PascalName + ");"); sb.AppendLine(" }"); } sb.AppendLine(" ParameterValues.Add(\"@max_row_count\", "+ _currentView.PascalName + ".MaxRowCount);"); sb.AppendLine(); sb.AppendLine(" }"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" #region SelectCommand Abstact Override"); sb.AppendLine(); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// The connection string used to connect to the database"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public override string ConnectionString"); sb.AppendLine(" {"); sb.AppendLine(" get { return ConfigurationValues.GetInstance().ConnectionString; }"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// Determines the default time out"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public override int DefaultTimeOut"); sb.AppendLine(" {"); sb.AppendLine(" get { return ConfigurationValues.GetInstance().DefaultTimeOut; }"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" #endregion"); sb.AppendLine(); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" #endregion"); sb.AppendLine(); } }
private void AppendRegionGetValue() { sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// Gets the value of one of this object's properties."); sb.AppendLine(" /// </summary>"); sb.AppendLine(" #region GetValue"); sb.AppendLine(); sb.AppendLine(" public object GetValue(FieldNameConstants field)"); sb.AppendLine(" {"); sb.AppendLine(" return GetValue(field, null);"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// Gets the value of one of this object's properties."); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public object GetValue(FieldNameConstants field, object defaultValue)"); sb.AppendLine(" {"); foreach (Reference reference in _currentView.GeneratedColumns) { CustomViewColumn dbColumn = (CustomViewColumn)reference.Object; sb.AppendLine(" if(field == FieldNameConstants."+ dbColumn.PascalName + ")"); sb.AppendLine(" {"); if (dbColumn.AllowNull) { sb.AppendLine(" return (this.Is"+ dbColumn.PascalName + "Null() ? defaultValue : this." + EnsureValidPropertyName(dbColumn.PascalName) + ");"); } else { sb.AppendLine(" return this."+ EnsureValidPropertyName(dbColumn.PascalName) + ";"); } sb.AppendLine(" }"); } sb.AppendLine(" throw new Exception(\"Field '\" + field.ToString() + \"' not found!\");"); sb.AppendLine(" }"); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// Gets the value of one of this object's properties."); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public int GetInteger(FieldNameConstants field)"); sb.AppendLine(" {"); sb.AppendLine(" return this.GetInteger(field, int.MinValue);"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// Gets the value of one of this object's properties."); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public int GetInteger(FieldNameConstants field, int defaultValue)"); sb.AppendLine(" {"); sb.AppendLine(" object o = this.GetValue(field, defaultValue);"); sb.AppendLine(" if (o is string)"); sb.AppendLine(" {"); sb.AppendLine(" int a;"); sb.AppendLine(" if (int.TryParse((string)o, out a))"); sb.AppendLine(" return a;"); sb.AppendLine(" else"); sb.AppendLine(" throw new InvalidCastException();"); sb.AppendLine(" }"); sb.AppendLine(" else"); sb.AppendLine(" {"); sb.AppendLine(" return (int)o;"); sb.AppendLine(" }"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// Gets the value of one of this object's properties."); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public double GetDouble(FieldNameConstants field)"); sb.AppendLine(" {"); sb.AppendLine(" return this.GetDouble(field, double.MinValue);"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// Gets the value of one of this object's properties."); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public double GetDouble(FieldNameConstants field, double defaultValue)"); sb.AppendLine(" {"); sb.AppendLine(" object o = this.GetValue(field, defaultValue);"); sb.AppendLine(" if (o is string)"); sb.AppendLine(" {"); sb.AppendLine(" double a;"); sb.AppendLine(" if (double.TryParse((string)o, out a))"); sb.AppendLine(" return a;"); sb.AppendLine(" else"); sb.AppendLine(" throw new InvalidCastException();"); sb.AppendLine(" }"); sb.AppendLine(" else"); sb.AppendLine(" {"); sb.AppendLine(" return (double)o;"); sb.AppendLine(" }"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// Gets the value of one of this object's properties."); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public DateTime GetDateTime(FieldNameConstants field)"); sb.AppendLine(" {"); sb.AppendLine(" return this.GetDateTime(field, DateTime.MinValue);"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// Gets the value of one of this object's properties."); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public DateTime GetDateTime(FieldNameConstants field, DateTime defaultValue)"); sb.AppendLine(" {"); sb.AppendLine(" object o = this.GetValue(field, defaultValue);"); sb.AppendLine(" if (o is string)"); sb.AppendLine(" {"); sb.AppendLine(" DateTime a;"); sb.AppendLine(" if (DateTime.TryParse((string)o, out a))"); sb.AppendLine(" return a;"); sb.AppendLine(" else"); sb.AppendLine(" throw new InvalidCastException();"); sb.AppendLine(" }"); sb.AppendLine(" else"); sb.AppendLine(" {"); sb.AppendLine(" return (DateTime)o;"); sb.AppendLine(" }"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// Gets the value of one of this object's properties."); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public string GetString(FieldNameConstants field)"); sb.AppendLine(" {"); sb.AppendLine(" return this.GetString(field, \"\");"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// Gets the value of one of this object's properties."); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public string GetString(FieldNameConstants field, string defaultValue)"); sb.AppendLine(" {"); sb.AppendLine(" object o = this.GetValue(field, defaultValue);"); sb.AppendLine(" if (o is string)"); sb.AppendLine(" {"); sb.AppendLine(" return (string)o;"); sb.AppendLine(" }"); sb.AppendLine(" else"); sb.AppendLine(" {"); sb.AppendLine(" return o.ToString();"); sb.AppendLine(" }"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" #endregion"); sb.AppendLine(); }
public void AppendFullTemplate() { try { sb.AppendLine(" #region Class Members"); sb.AppendLine(); sb.AppendLine(" #region FieldNameConstants Enumeration"); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// Enumeration to define each property that maps to a database field for the '"+ _currentView.PascalName + "' view."); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public enum FieldNameConstants"); sb.AppendLine(" {"); foreach (Reference reference in _currentView.GeneratedColumns) { CustomViewColumn column = (CustomViewColumn)reference.Object; sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// Field mapping for the '"+ column.PascalName + "' property"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" [System.ComponentModel.Description(\"Field mapping for the '"+ column.PascalName + "' property\")]"); sb.AppendLine(" "+ column.PascalName + ","); } sb.AppendLine(" }"); sb.AppendLine(" #endregion"); sb.AppendLine(); sb.AppendLine(" internal Domain"+ _currentView.PascalName + " wrappedClass;"); sb.AppendLine(); sb.AppendLine(" #endregion"); sb.AppendLine(); //Constructors sb.AppendLine(" #region Constructors"); sb.AppendLine(); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// Creates a '"+ _currentView.PascalName + "' object from a domain object"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" internal "+ _currentView.PascalName + "(Domain" + _currentView.PascalName + " classToWrap)"); sb.AppendLine(" {"); sb.AppendLine(" wrappedClass = classToWrap;"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// Creates a '"+ _currentView.PascalName + "' object from a DataRowView"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public "+ _currentView.PascalName + "(DataRowView drvToWrap)"); sb.AppendLine(" {"); sb.AppendLine(" wrappedClass = (Domain"+ _currentView.PascalName + ")drvToWrap.Row;"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" #endregion"); sb.AppendLine(); //Events sb.AppendLine(" #region Events"); sb.AppendLine(); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// This event is raised when any field is changed."); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public event PropertyChangedEventHandler PropertyChanged;"); foreach (Reference reference in _currentView.GeneratedColumns) { CustomViewColumn dbColumn = (CustomViewColumn)reference.Object; sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// This event is raised when the '"+ dbColumn.PascalName + "' field is changed."); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public event EventHandler "+ dbColumn.PascalName + "Changed;"); } sb.AppendLine(); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// This event is raised when any field is changed."); sb.AppendLine(" /// </summary>"); sb.AppendLine(" protected virtual void OnPropertyChanged(PropertyChangedEventArgs e)"); sb.AppendLine(" {"); sb.AppendLine(" if (this.PropertyChanged != null)"); sb.AppendLine(" this.PropertyChanged(this, e);"); sb.AppendLine(" }"); sb.AppendLine(); foreach (Reference reference in _currentView.GeneratedColumns) { CustomViewColumn dbColumn = (CustomViewColumn)reference.Object; sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// Raises the "+ dbColumn.PascalName + "Changed event."); sb.AppendLine(" /// </summary>"); sb.AppendLine(" protected virtual void On"+ dbColumn.PascalName + "Changed(System.EventArgs e)"); sb.AppendLine(" {"); sb.AppendLine(" if (this."+ dbColumn.PascalName + "Changed != null)"); sb.AppendLine(" this."+ dbColumn.PascalName + "Changed(this, e);"); sb.AppendLine(" }"); sb.AppendLine(); } sb.AppendLine(); sb.AppendLine(" #endregion"); sb.AppendLine(); //Properties sb.AppendLine(" #region Properties"); sb.AppendLine(); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// Determines if this object is part of a collection or is detached"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" [System.ComponentModel.Browsable(false)]"); sb.AppendLine(" public bool IsParented"); sb.AppendLine(" {"); sb.AppendLine(" get { return (((DataRow)this.WrappedClass).RowState != DataRowState.Detached); }"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// Returns the internal object that this object wraps"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" [System.ComponentModel.Browsable(false)]"); sb.AppendLine(" public object WrappedClass"); sb.AppendLine(" {"); sb.AppendLine(" get{return wrappedClass;}"); sb.AppendLine(" set{wrappedClass = (Domain"+ _currentView.PascalName + ")value;}"); sb.AppendLine(" }"); sb.AppendLine(); foreach (Reference reference in _currentView.GeneratedColumns) { CustomViewColumn dbColumn = (CustomViewColumn)reference.Object; sb.AppendLine(" "); sb.AppendLine(); sb.AppendLine(); sb.AppendLine(); sb.AppendLine(" /// <summary>"); if (dbColumn.Description != "") { sb.AppendLine(" /// "+ dbColumn.Description); } else { sb.AppendLine(" /// Property for View field: "+ dbColumn.PascalName); } sb.AppendLine(" /// </summary>"); sb.AppendLine(" [Widgetsphere.Core.Attributes.DataSetting(\""+ dbColumn.FriendlyName + "\", " + dbColumn.GridVisible.ToString().ToLower() + ", " + dbColumn.SortOrder.ToString() + ")]"); sb.AppendLine(" public "+ dbColumn.GetCodeType() + " " + EnsureValidPropertyName(dbColumn.PascalName) + ""); sb.AppendLine(" {"); sb.AppendLine(" get"); sb.AppendLine(" {"); sb.AppendLine(" try"); sb.AppendLine(" {"); sb.AppendLine(" return wrappedClass."+ dbColumn.PascalName + ";"); sb.AppendLine(" }"); Globals.AppendBusinessEntryCatch(sb); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" }"); } sb.AppendLine(); sb.AppendLine(" #endregion"); sb.AppendLine(); sb.AppendLine(" #region Null Methods"); foreach (Reference reference in _currentView.GeneratedColumns) { CustomViewColumn dbColumn = (CustomViewColumn)reference.Object; if (dbColumn.AllowNull) { sb.AppendLine(); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// Determines if the field '"+ dbColumn.PascalName + "' is null"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" /// <returns>Boolean value indicating if the specified value is null</returns>"); sb.AppendLine(" public bool Is"+ dbColumn.PascalName + "Null() "); sb.AppendLine(" {"); sb.AppendLine(" try"); sb.AppendLine(" {"); sb.AppendLine(" return wrappedClass.Is"+ dbColumn.PascalName + "Null();"); sb.AppendLine(" }"); Globals.AppendBusinessEntryCatch(sb); sb.AppendLine(" }"); sb.AppendLine(); } } sb.AppendLine(); sb.AppendLine(" #endregion"); sb.AppendLine(); sb.AppendLine(" #region Collection Operation Methods"); sb.AppendLine(); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// Removes this object from its parent collection. It will not be deleted from the database."); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public void Remove()"); sb.AppendLine(" {"); sb.AppendLine(" try"); sb.AppendLine(" {"); sb.AppendLine(" wrappedClass.Remove();"); sb.AppendLine(" }"); Globals.AppendBusinessEntryCatch(sb); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" #endregion"); sb.AppendLine(); sb.AppendLine(" #region Overrides"); sb.AppendLine(); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// Serves as a hash function for this particular type."); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public override int GetHashCode()"); sb.AppendLine(" {"); sb.AppendLine(" return base.GetHashCode();"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// Returns a value indicating whether the current object is equal to a specified object."); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public override bool Equals(object obj)"); sb.AppendLine(" {"); sb.AppendLine(" if (obj == null)"); sb.AppendLine(" {"); sb.AppendLine(" return false;"); sb.AppendLine(" }"); sb.AppendLine(" else if (obj.GetType() == this.GetType())"); sb.AppendLine(" {"); sb.AppendLine(" if (this.wrappedClass == (("+ _currentView.PascalName + ")obj).wrappedClass)"); sb.AppendLine(" return true;"); sb.AppendLine(" }"); sb.AppendLine(" return false;"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" #endregion"); sb.AppendLine(); //IBusinessObject.ParentCollection sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// This is a reference back to the generic collection that holds this object."); sb.AppendLine(" /// </summary>"); sb.AppendLine(" #region IBusinessObject ParentCollection"); sb.AppendLine(); sb.AppendLine(" [System.ComponentModel.Browsable(false)]"); sb.AppendLine(" IBusinessCollection IBusinessObject.ParentCollection"); sb.AppendLine(" {"); sb.AppendLine(" get"); sb.AppendLine(" {"); sb.AppendLine(" return ParentCollection;"); sb.AppendLine(" }"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" #endregion"); sb.AppendLine(); //ParentCollection sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// This is a reference back to the collection that holds this object."); sb.AppendLine(" /// </summary>"); sb.AppendLine(" #region ParentCollection"); sb.AppendLine(); sb.AppendLine(" [System.ComponentModel.Browsable(false)]"); sb.AppendLine(" public "+ _currentView.PascalName + "Collection ParentCollection"); sb.AppendLine(" {"); sb.AppendLine(" get"); sb.AppendLine(" {"); sb.AppendLine(" return new "+ _currentView.PascalName + "Collection(wrappedClass.ParentCol);"); sb.AppendLine(" }"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" #endregion"); sb.AppendLine(); this.AppendRegionGetFriendlyName(); this.AppendRegionGetMaxLength(); this.AppendRegionGetMask(); this.AppendRegionGetDefault(); this.AppendRegionGetValue(); this.AppendRegionGetFieldLength(); } catch (Exception ex) { throw; } }
private void AppendFullTemplate(StringBuilder sb) { try { sb.AppendLine("if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[" + this.StoredProcedureName + "]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)"); sb.AppendLine(" drop procedure [dbo].[" + this.StoredProcedureName + "]"); sb.AppendLine("GO"); sb.AppendLine(); sb.AppendLine("SET QUOTED_IDENTIFIER ON "); sb.AppendLine("GO"); sb.AppendLine("SET ANSI_NULLS ON "); sb.AppendLine("GO"); sb.AppendLine(); sb.AppendLine("CREATE PROCEDURE [dbo].[" + this.StoredProcedureName + "]"); if (_currentView.Parameters.Count > 0) { sb.AppendLine("("); sb.Append(this.BuildParameterList()); sb.AppendLine(")"); } sb.AppendLine("AS"); sb.AppendLine("SET NOCOUNT ON;"); sb.AppendLine(); sb.AppendLine("SELECT "); int index = 0; foreach (Reference reference in _currentView.Columns) { CustomViewColumn column = (CustomViewColumn)reference.Object; sb.Append("CONVERT(" + column.DatabaseType + ", [view_" + _currentView.DatabaseName + "].[" + column.DatabaseName + "]) AS [" + column.DatabaseName + "]"); if (index < _currentView.Columns.Count - 1) { sb.Append(","); } sb.AppendLine(); index++; } sb.AppendLine("FROM"); sb.AppendLine("[view_" + _currentView.DatabaseName + "]"); sb.AppendLine(); sb.AppendLine(); sb.AppendLine("GO"); sb.AppendLine(); sb.AppendLine("SET QUOTED_IDENTIFIER OFF "); sb.AppendLine("GO"); sb.AppendLine("SET ANSI_NULLS ON "); sb.AppendLine("GO"); sb.AppendLine(); if (_model.Database.GrantExecUser != string.Empty) { sb.AppendFormat("GRANT EXECUTE ON [dbo].[{0}] TO [{1}]", this.StoredProcedureName, _model.Database.GrantExecUser).AppendLine(); sb.AppendLine("GO"); sb.AppendLine(); } } catch (Exception ex) { throw; } }
private void AppendTemplate() { sb.AppendLine(" #region Member Variables"); sb.AppendLine(); sb.AppendLine(" internal Domain"+ _currentView.PascalName + "Collection ParentCol;"); sb.AppendLine(); sb.AppendLine(" #endregion"); sb.AppendLine(); sb.AppendLine(" #region Constructor"); sb.AppendLine(); sb.AppendLine(" internal Domain"+ _currentView.PascalName + "(DataRowBuilder rb) : base(rb) "); sb.AppendLine(" {"); sb.AppendLine(" this.ParentCol = ((Domain"+ _currentView.PascalName + "Collection)(base.Table));"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" #endregion"); sb.AppendLine(); sb.AppendLine(" #region Properties"); sb.AppendLine(); foreach (Reference reference in _currentView.GeneratedColumns) { CustomViewColumn dbColumn = (CustomViewColumn)reference.Object; sb.AppendLine(); sb.AppendLine(" internal "+ dbColumn.GetCodeType() + " " + dbColumn.PascalName); sb.AppendLine(" {"); sb.AppendLine(" get "); sb.AppendLine(" {"); sb.AppendLine(" try "); sb.AppendLine(" {"); sb.AppendLine(" return (("+ dbColumn.GetCodeType() + ")(base[this.ParentCol." + dbColumn.PascalName + "Column]));"); sb.AppendLine(" }"); sb.Append(" catch "); if (StringHelper.Match(dbColumn.GetCodeType(), "string", true)) { sb.AppendLine(" (InvalidCastException) "); sb.AppendLine(" {"); sb.AppendLine(" return string.Empty;"); } else { sb.AppendLine(" (InvalidCastException e) "); sb.AppendLine(" {"); sb.AppendLine(" throw new StrongTypingException(\"Cannot get value because it is DBNull.\", e);"); } sb.AppendLine(" }"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" }"); } sb.AppendLine(); sb.AppendLine(" #endregion"); sb.AppendLine(); sb.AppendLine(" #region Null Methods"); sb.AppendLine(); foreach (Reference reference in _currentView.GeneratedColumns) { CustomViewColumn dbColumn = (CustomViewColumn)reference.Object; if (dbColumn.AllowNull) { sb.AppendLine(); sb.AppendLine(" internal bool Is"+ dbColumn.PascalName + "Null() "); sb.AppendLine(" {"); sb.AppendLine(" return base.IsNull(this.ParentCol."+ dbColumn.PascalName + "Column);"); sb.AppendLine(" }"); sb.AppendLine(" "); } } sb.AppendLine(); sb.AppendLine(" #endregion"); sb.AppendLine(); AppendRegionRelationshipMethods(); sb.Append(" internal void Remove()").AppendLine(); sb.Append(" {").AppendLine(); sb.Append(" this.ParentCol.Remove"+ _currentView.PascalName + "(this);").AppendLine(); sb.Append(" }").AppendLine(); }
private void AppendRegionIBusinessObject() { sb.AppendLine(" #region IBusinessObject Members"); sb.AppendLine(); sb.AppendLine(" IPrimaryKey IBusinessObject.PrimaryKey"); sb.AppendLine(" {"); sb.AppendLine(" get { return null; }"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" object IBusinessObject.GetValue(Enum field)"); sb.AppendLine(" {"); sb.AppendLine(" return this.GetValue((FieldNameConstants)field);"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" object IBusinessObject.GetValue(Enum field, object defaultValue)"); sb.AppendLine(" {"); sb.AppendLine(" return this.GetValue((FieldNameConstants)field, defaultValue);"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" double IBusinessObject.GetDouble(Enum field)"); sb.AppendLine(" {"); sb.AppendLine(" return this.GetDouble((FieldNameConstants)field);"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" double IBusinessObject.GetDouble(Enum field, double defaultValue)"); sb.AppendLine(" {"); sb.AppendLine(" return this.GetDouble((FieldNameConstants)field, defaultValue);"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" DateTime IBusinessObject.GetDateTime(Enum field)"); sb.AppendLine(" {"); sb.AppendLine(" return this.GetDateTime((FieldNameConstants)field);"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" DateTime IBusinessObject.GetDateTime(Enum field, DateTime defaultValue)"); sb.AppendLine(" {"); sb.AppendLine(" return this.GetDateTime((FieldNameConstants)field, defaultValue);"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" int IBusinessObject.GetInteger(Enum field)"); sb.AppendLine(" {"); sb.AppendLine(" return this.GetInteger((FieldNameConstants)field);"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" int IBusinessObject.GetInteger(Enum field, int defaultValue)"); sb.AppendLine(" {"); sb.AppendLine(" return this.GetInteger((FieldNameConstants)field, defaultValue);"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" string IBusinessObject.GetString(Enum field)"); sb.AppendLine(" {"); sb.AppendLine(" return this.GetString((FieldNameConstants)field);"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" string IBusinessObject.GetString(Enum field, string defaultValue)"); sb.AppendLine(" {"); sb.AppendLine(" return this.GetString((FieldNameConstants)field, defaultValue);"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" Enum IBusinessObject.Container"); sb.AppendLine(" {"); sb.AppendLine(" get { return this.Container; }"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// Determines if all of the fields for the specified object exactly matches the current object."); sb.AppendLine(" /// </summary>"); sb.AppendLine(" /// <param name=\"item\">The object to compare</param>"); sb.AppendLine(" /// <returns></returns>"); sb.AppendLine(" public override bool IsEquivalent(IBusinessObject item)"); sb.AppendLine(" {"); sb.AppendLine(" if (item == null) return false;"); sb.AppendLine(" if (!(item is "+ _currentView.PascalName + ")) return false;"); sb.AppendLine(" "+ _currentView.PascalName + " o = item as " + _currentView.PascalName + ";"); sb.AppendLine(" return ("); int index = 0; foreach (Reference reference in _currentView.GeneratedColumns) { CustomViewColumn column = (CustomViewColumn)reference.Object; sb.Append(" o."+ column.PascalName + " == this." + column.PascalName); if (index < _currentView.GeneratedColumns.Count - 1) { sb.Append(" &&"); } sb.AppendLine(); index++; } sb.AppendLine(" );"); sb.AppendLine(" }"); sb.AppendLine(); sb.AppendLine(" #endregion"); sb.AppendLine(); }