예제 #1
0
        int IComparer <T> .Compare(T obj1, T obj2)
        {
            tgEntity         obj      = obj1 as tgEntity;
            tgColumnMetadata esColumn = obj.tg.Meta.Columns.FindByPropertyName(sortProperty.Name);

            return(obj1.OnSort(obj2, esColumn, sortProperty.Name));
        }
예제 #2
0
        protected AspNetUserClaimsMetadata()
        {
            m_columns = new tgColumnMetadataCollection();
            tgColumnMetadata c;

            c = new tgColumnMetadata(AspNetUserClaimsMetadata.ColumnNames.Id, 0, typeof(System.Int32), tgSystemType.Int32);
            c.PropertyName     = AspNetUserClaimsMetadata.PropertyNames.Id;
            c.IsInPrimaryKey   = true;
            c.IsAutoIncrement  = true;
            c.NumericPrecision = 10;
            m_columns.Add(c);

            c = new tgColumnMetadata(AspNetUserClaimsMetadata.ColumnNames.UserId, 1, typeof(System.String), tgSystemType.String);
            c.PropertyName       = AspNetUserClaimsMetadata.PropertyNames.UserId;
            c.CharacterMaxLength = 128;
            m_columns.Add(c);

            c = new tgColumnMetadata(AspNetUserClaimsMetadata.ColumnNames.ClaimType, 2, typeof(System.String), tgSystemType.String);
            c.PropertyName       = AspNetUserClaimsMetadata.PropertyNames.ClaimType;
            c.IsNullable         = true;
            c.CharacterMaxLength = 2147483647;
            m_columns.Add(c);

            c = new tgColumnMetadata(AspNetUserClaimsMetadata.ColumnNames.ClaimValue, 3, typeof(System.String), tgSystemType.String);
            c.PropertyName       = AspNetUserClaimsMetadata.PropertyNames.ClaimValue;
            c.IsNullable         = true;
            c.CharacterMaxLength = 2147483647;
            m_columns.Add(c);
        }
예제 #3
0
        protected TVShowsMetadata()
        {
            m_columns = new tgColumnMetadataCollection();
            tgColumnMetadata c;

            c = new tgColumnMetadata(TVShowsMetadata.ColumnNames.Id, 0, typeof(System.Int32), tgSystemType.Int32);
            c.PropertyName   = TVShowsMetadata.PropertyNames.Id;
            c.IsInPrimaryKey = true;
            m_columns.Add(c);

            c = new tgColumnMetadata(TVShowsMetadata.ColumnNames.Title, 1, typeof(System.String), tgSystemType.String);
            c.PropertyName = TVShowsMetadata.PropertyNames.Title;
            m_columns.Add(c);

            c = new tgColumnMetadata(TVShowsMetadata.ColumnNames.MazeId, 2, typeof(System.String), tgSystemType.String);
            c.PropertyName = TVShowsMetadata.PropertyNames.MazeId;
            m_columns.Add(c);

            c = new tgColumnMetadata(TVShowsMetadata.ColumnNames.Synopsis, 3, typeof(System.String), tgSystemType.String);
            c.PropertyName = TVShowsMetadata.PropertyNames.Synopsis;
            c.IsNullable   = true;
            m_columns.Add(c);

            c = new tgColumnMetadata(TVShowsMetadata.ColumnNames.Image, 4, typeof(System.String), tgSystemType.String);
            c.PropertyName = TVShowsMetadata.PropertyNames.Image;
            c.IsNullable   = true;
            m_columns.Add(c);

            c = new tgColumnMetadata(TVShowsMetadata.ColumnNames.NextAirDate, 5, typeof(System.String), tgSystemType.String);
            c.PropertyName = TVShowsMetadata.PropertyNames.NextAirDate;
            c.IsNullable   = true;
            m_columns.Add(c);
        }
예제 #4
0
        static public jsColumn[] PopulateColumns(tgEntity entity)
        {
            List <jsColumn> cols = new List <jsColumn>();

            // we just put some fake data in the footer section for the demo
            decimal footer = 100M;

            List <string> columns = entity.GetCurrentListOfColumns();

            foreach (string column in columns)
            {
                tgColumnMetadata esCol = entity.tg.Meta.Columns.FindByColumnName(column);

                jsColumn c = new jsColumn();

                footer += 2M;

                if (esCol != null)
                {
                    c.isVisible          = true;
                    c.displayName        = esCol.PropertyName;
                    c.dataType           = esCol.Type.ToString();
                    c.columnName         = esCol.Name;
                    c.propertyName       = esCol.PropertyName;
                    c.ordinal            = esCol.Ordinal;
                    c.numericPrecision   = esCol.NumericPrecision;
                    c.numericScale       = esCol.NumericScale;
                    c.characterMaxLength = esCol.CharacterMaxLength;
                    c.defaultValue       = esCol.Default;
                    c.hasDefault         = esCol.HasDefault;
                    c.isInPrimaryKey     = esCol.IsInPrimaryKey;
                    c.isAutoIncrement    = esCol.IsAutoIncrement;
                    c.isNullable         = esCol.IsNullable;
                    c.isConcurrency      = esCol.IsConcurrency || esCol.IsTiraggoConcurrency;
                    c.isSortable         = true;
                    c.footerValue        = "$" + Convert.ToString(footer);
                }
                else
                {
                    object o = entity.GetColumn(column);

                    if (o != DBNull.Value && o != null)
                    {
                        c.dataType = o.GetType().ToString();
                    }

                    c.isVisible    = true;
                    c.displayName  = column;
                    c.columnName   = column;
                    c.propertyName = column;
                    c.isSortable   = false;
                    c.footerValue  = "$" + Convert.ToString(footer);
                }

                cols.Add(c);
            }

            return(cols.ToArray());
        }
        protected AspNetRolesMetadata()
        {
            m_columns = new tgColumnMetadataCollection();
            tgColumnMetadata c;

            c = new tgColumnMetadata(AspNetRolesMetadata.ColumnNames.Id, 0, typeof(System.String), tgSystemType.String);
            c.PropertyName       = AspNetRolesMetadata.PropertyNames.Id;
            c.IsInPrimaryKey     = true;
            c.CharacterMaxLength = 128;
            m_columns.Add(c);

            c = new tgColumnMetadata(AspNetRolesMetadata.ColumnNames.Name, 1, typeof(System.String), tgSystemType.String);
            c.PropertyName       = AspNetRolesMetadata.PropertyNames.Name;
            c.CharacterMaxLength = 256;
            m_columns.Add(c);
        }
예제 #6
0
        protected RecipientsMetadata()
        {
            m_columns = new tgColumnMetadataCollection();
            tgColumnMetadata c;

            c = new tgColumnMetadata(RecipientsMetadata.ColumnNames.Id, 0, typeof(System.Int32), tgSystemType.Int32);
            c.PropertyName   = RecipientsMetadata.PropertyNames.Id;
            c.IsInPrimaryKey = true;
            c.IsNullable     = true;
            m_columns.Add(c);

            c = new tgColumnMetadata(RecipientsMetadata.ColumnNames.EmailAddress, 1, typeof(System.String), tgSystemType.String);
            c.PropertyName       = RecipientsMetadata.PropertyNames.EmailAddress;
            c.IsNullable         = true;
            c.CharacterMaxLength = 255;
            m_columns.Add(c);
        }
        protected AspNetUserLoginsMetadata()
        {
            m_columns = new tgColumnMetadataCollection();
            tgColumnMetadata c;

            c = new tgColumnMetadata(AspNetUserLoginsMetadata.ColumnNames.LoginProvider, 0, typeof(System.String), tgSystemType.String);
            c.PropertyName       = AspNetUserLoginsMetadata.PropertyNames.LoginProvider;
            c.IsInPrimaryKey     = true;
            c.CharacterMaxLength = 128;
            m_columns.Add(c);

            c = new tgColumnMetadata(AspNetUserLoginsMetadata.ColumnNames.ProviderKey, 1, typeof(System.String), tgSystemType.String);
            c.PropertyName       = AspNetUserLoginsMetadata.PropertyNames.ProviderKey;
            c.IsInPrimaryKey     = true;
            c.CharacterMaxLength = 128;
            m_columns.Add(c);

            c = new tgColumnMetadata(AspNetUserLoginsMetadata.ColumnNames.UserId, 2, typeof(System.String), tgSystemType.String);
            c.PropertyName       = AspNetUserLoginsMetadata.PropertyNames.UserId;
            c.IsInPrimaryKey     = true;
            c.CharacterMaxLength = 128;
            m_columns.Add(c);
        }
예제 #8
0
        static public NpgsqlCommand BuildDynamicInsertCommand(tgDataRequest request, tgEntitySavePacket packet)
        {
            string sql          = String.Empty;
            string defaults     = String.Empty;
            string into         = String.Empty;
            string values       = String.Empty;
            string comma        = String.Empty;
            string defaultComma = String.Empty;

            string where = String.Empty;
            string autoInc = String.Empty;

            NpgsqlParameter p = null;

            Dictionary <string, NpgsqlParameter> types = Cache.GetParameters(request);

            NpgsqlCommand cmd = new NpgsqlCommand();

            if (request.CommandTimeout != null)
            {
                cmd.CommandTimeout = request.CommandTimeout.Value;
            }

            tgColumnMetadataCollection cols = request.Columns;

            foreach (tgColumnMetadata col in cols)
            {
                bool isModified = packet.ModifiedColumns == null ? false : packet.ModifiedColumns.Contains(col.Name);

                if (isModified && (!col.IsAutoIncrement && !col.IsConcurrency && !col.IsTiraggoConcurrency))
                {
                    p = cmd.Parameters.Add(CloneParameter(types[col.Name]));

                    object value = packet.CurrentValues[col.Name];
                    p.Value = value != null ? value : DBNull.Value;

                    into   += comma + Delimiters.ColumnOpen + col.Name + Delimiters.ColumnClose;
                    values += comma + p.ParameterName;
                    comma   = ", ";
                }
                else if (col.IsAutoIncrement && request.ProviderMetadata.ContainsKey("AutoKeyText"))
                {
                    string sequence = request.ProviderMetadata["AutoKeyText"].Replace("nextval", "currval");

                    if (sequence != null && sequence.Length > 0)
                    {
                        // Our identity column ...
                        p           = cmd.Parameters.Add(CloneParameter(types[col.Name]));
                        p.Direction = ParameterDirection.Output;

                        autoInc += " SELECT * FROM " + sequence + " as \"" + col.Name + "\"";
                    }

                    p           = CloneParameter(types[col.Name]);
                    p.Direction = ParameterDirection.Output;
                    cmd.Parameters.Add(p);
                }
                else if (col.IsConcurrency)
                {
                    // These columns have defaults and they weren't supplied with values, so let's
                    // return them
                    p           = cmd.Parameters.Add(CloneParameter(types[col.Name]));
                    p.Direction = ParameterDirection.InputOutput;

                    defaults    += defaultComma + Delimiters.ColumnOpen + col.Name + Delimiters.ColumnClose;
                    defaultComma = ", ";

                    if (col.CharacterMaxLength > 0)
                    {
                        p.Size = (int)col.CharacterMaxLength;
                    }
                }
                else if (col.IsTiraggoConcurrency)
                {
                    p           = cmd.Parameters.Add(CloneParameter(types[col.Name]));
                    p.Direction = ParameterDirection.Output;

                    into   += comma + Delimiters.ColumnOpen + col.Name + Delimiters.ColumnClose;
                    values += comma + "1";
                    comma   = ", ";

                    p.Value = 1; // Seems to work, We'll take it ...
                }
                else if (col.IsComputed)
                {
                    // Do nothing but leave this here
                }
                else if (cols.IsSpecialColumn(col))
                {
                    // Do nothing but leave this here
                }
                else if (col.HasDefault)
                {
                    // These columns have defaults and they weren't supplied with values, so let's
                    // return them
                    p           = cmd.Parameters.Add(CloneParameter(types[col.Name]));
                    p.Direction = ParameterDirection.InputOutput;

                    defaults    += defaultComma + Delimiters.ColumnOpen + col.Name + Delimiters.ColumnClose;
                    defaultComma = ",";

                    if (col.CharacterMaxLength > 0)
                    {
                        p.Size = (int)col.CharacterMaxLength;
                    }
                }

                if (col.IsInPrimaryKey)
                {
                    p = types[col.Name];

                    if (where.Length > 0)
                    {
                        where += " AND ";
                    }
                    where += Delimiters.ColumnOpen + col.Name + Delimiters.ColumnClose + " = " + p.ParameterName;

                    if (!cmd.Parameters.Contains(p.ParameterName))
                    {
                        p           = CloneParameter(p);
                        p.Direction = ParameterDirection.Output;
                        cmd.Parameters.Add(p);
                    }
                }
            }

            #region Special Column Logic
            if (cols.DateAdded != null && cols.DateAdded.IsServerSide &&
                cols.FindByColumnName(cols.DateAdded.ColumnName) != null)
            {
                p           = CloneParameter(types[cols.DateAdded.ColumnName]);
                p.Direction = ParameterDirection.Output;
                cmd.Parameters.Add(p);

                into   += comma + Delimiters.ColumnOpen + cols.DateAdded.ColumnName + Delimiters.ColumnClose;
                values += comma + request.ProviderMetadata["DateAdded.ServerSideText"];
                comma   = ", ";

                defaults    += defaultComma + cols.DateAdded.ColumnName;
                defaultComma = ",";
            }

            if (cols.DateModified != null && cols.DateModified.IsServerSide &&
                cols.FindByColumnName(cols.DateModified.ColumnName) != null)
            {
                p           = CloneParameter(types[cols.DateModified.ColumnName]);
                p.Direction = ParameterDirection.Output;
                cmd.Parameters.Add(p);

                into   += comma + Delimiters.ColumnOpen + cols.DateModified.ColumnName + Delimiters.ColumnClose;
                values += comma + request.ProviderMetadata["DateModified.ServerSideText"];
                comma   = ", ";

                defaults    += defaultComma + cols.DateModified.ColumnName;
                defaultComma = ",";
            }

            if (cols.AddedBy != null && cols.AddedBy.IsServerSide &&
                cols.FindByColumnName(cols.AddedBy.ColumnName) != null)
            {
                p           = CloneParameter(types[cols.AddedBy.ColumnName]);
                p.Direction = ParameterDirection.Output;
                cmd.Parameters.Add(p);

                into   += comma + Delimiters.ColumnOpen + cols.AddedBy.ColumnName + Delimiters.ColumnClose;
                values += comma + request.ProviderMetadata["AddedBy.ServerSideText"];
                comma   = ", ";

                defaults    += defaultComma + cols.AddedBy.ColumnName;
                defaultComma = ",";

                tgColumnMetadata col = request.Columns[cols.ModifiedBy.ColumnName];

                if (col.CharacterMaxLength > 0)
                {
                    p.Size = (int)col.CharacterMaxLength;
                }
            }

            if (cols.ModifiedBy != null && cols.ModifiedBy.IsServerSide &&
                cols.FindByColumnName(cols.ModifiedBy.ColumnName) != null)
            {
                p           = CloneParameter(types[cols.ModifiedBy.ColumnName]);
                p.Direction = ParameterDirection.Output;
                cmd.Parameters.Add(p);

                into   += comma + Delimiters.ColumnOpen + cols.ModifiedBy.ColumnName + Delimiters.ColumnClose;
                values += comma + request.ProviderMetadata["ModifiedBy.ServerSideText"];
                comma   = ", ";

                defaults    += defaultComma + cols.ModifiedBy.ColumnName;
                defaultComma = ",";

                tgColumnMetadata col = request.Columns[cols.ModifiedBy.ColumnName];

                if (col.CharacterMaxLength > 0)
                {
                    p.Size = (int)col.CharacterMaxLength;
                }
            }
            #endregion

            string fullName = CreateFullName(request);

            sql += " INSERT INTO " + fullName;

            if (into.Length != 0)
            {
                sql += " (" + into + ") VALUES (" + values + ");";
            }
            else
            {
                sql += " DEFAULT VALUES;";
            }

            sql += autoInc;

            if (defaults.Length > 0)
            {
                sql += " SELECT " + defaults + " FROM " + fullName + " WHERE (" + where + ")";
            }

            cmd.CommandText = sql + String.Empty;
            cmd.CommandType = CommandType.Text;
            return(cmd);
        }
예제 #9
0
        static public NpgsqlCommand BuildDynamicUpdateCommand(tgDataRequest request, tgEntitySavePacket packet)
        {
            string where = String.Empty;
            string conncur       = String.Empty;
            string scomma        = String.Empty;
            string defaults      = String.Empty;
            string defaultsComma = String.Empty;
            string and           = String.Empty;

            string sql = "UPDATE " + CreateFullName(request) + " SET ";

            PropertyCollection props = new PropertyCollection();
            NpgsqlParameter    p     = null;

            Dictionary <string, NpgsqlParameter> types = Cache.GetParameters(request);

            NpgsqlCommand cmd = new NpgsqlCommand();

            if (request.CommandTimeout != null)
            {
                cmd.CommandTimeout = request.CommandTimeout.Value;
            }

            tgColumnMetadataCollection cols = request.Columns;

            foreach (tgColumnMetadata col in cols)
            {
                bool isModified = packet.ModifiedColumns == null ? false : packet.ModifiedColumns.Contains(col.Name);

                if (isModified && (!col.IsAutoIncrement && !col.IsConcurrency && !col.IsTiraggoConcurrency))
                {
                    p = cmd.Parameters.Add(CloneParameter(types[col.Name]));

                    object value = packet.CurrentValues[col.Name];
                    p.Value = value != null ? value : DBNull.Value;

                    sql   += scomma + Delimiters.ColumnOpen + col.Name + Delimiters.ColumnClose + " = " + p.ParameterName;
                    scomma = ", ";
                }
                else if (col.IsAutoIncrement)
                {
                    // Nothing to do but leave this here
                }
                else if (col.IsConcurrency)
                {
                    p = CloneParameter(types[col.Name]);
                    p.SourceVersion = DataRowVersion.Original;
                    p.Direction     = ParameterDirection.InputOutput;
                    cmd.Parameters.Add(p);

                    conncur += Delimiters.ColumnOpen + col.Name + Delimiters.ColumnClose + " = " + p.ParameterName;
                }
                else if (col.IsTiraggoConcurrency)
                {
                    p           = CloneParameter(types[col.Name]);
                    p.Value     = packet.OriginalValues[col.Name];
                    p.Direction = ParameterDirection.InputOutput;
                    cmd.Parameters.Add(p);

                    sql += scomma;
                    sql += Delimiters.ColumnOpen + col.Name + Delimiters.ColumnClose + " = " + p.ParameterName + " + 1";

                    conncur += Delimiters.ColumnOpen + col.Name + Delimiters.ColumnClose + " = " + p.ParameterName;

                    defaults     += defaultsComma + Delimiters.ColumnOpen + col.Name + Delimiters.ColumnClose;
                    defaultsComma = ",";
                }
                else if (col.IsComputed)
                {
                    // Do nothing but leave this here
                }
                else if (cols.IsSpecialColumn(col))
                {
                    // Do nothing but leave this here
                }
                else if (col.HasDefault)
                {
                    // defaults += defaultsComma + Delimiters.ColumnOpen + col.Name + Delimiters.ColumnClose;
                    // defaultsComma = ",";
                }

                if (col.IsInPrimaryKey)
                {
                    p       = CloneParameter(types[col.Name]);
                    p.Value = packet.OriginalValues[col.Name];
                    cmd.Parameters.Add(p);

                    where += and + Delimiters.ColumnOpen + col.Name + Delimiters.ColumnClose + " = " + p.ParameterName;
                    and    = " AND ";
                }
            }

            #region Special Column Logic
            if (cols.DateModified != null && cols.DateModified.IsServerSide &&
                cols.FindByColumnName(cols.DateModified.ColumnName) != null)
            {
                p           = CloneParameter(types[cols.DateModified.ColumnName]);
                p.Direction = ParameterDirection.Output;
                cmd.Parameters.Add(p);

                sql   += scomma + Delimiters.ColumnOpen + cols.DateModified.ColumnName + Delimiters.ColumnClose + " = " + request.ProviderMetadata["DateModified.ServerSideText"];
                scomma = ", ";

                defaults     += defaultsComma + cols.DateModified.ColumnName;
                defaultsComma = ",";
            }

            if (cols.ModifiedBy != null && cols.ModifiedBy.IsServerSide &&
                cols.FindByColumnName(cols.ModifiedBy.ColumnName) != null)
            {
                p           = CloneParameter(types[cols.ModifiedBy.ColumnName]);
                p.Direction = ParameterDirection.Output;
                cmd.Parameters.Add(p);

                sql   += scomma + Delimiters.ColumnOpen + cols.ModifiedBy.ColumnName + Delimiters.ColumnClose + " = " + request.ProviderMetadata["ModifiedBy.ServerSideText"];
                scomma = ", ";

                defaults     += defaultsComma + cols.ModifiedBy.ColumnName;
                defaultsComma = ",";

                tgColumnMetadata col = request.Columns[cols.ModifiedBy.ColumnName];

                if (col.CharacterMaxLength > 0)
                {
                    p.Size = (int)col.CharacterMaxLength;
                }
            }
            #endregion

            sql += " WHERE " + where + "";
            if (conncur.Length > 0)
            {
                sql += " AND " + conncur;
            }

            if (defaults.Length > 0)
            {
                sql += "; SELECT " + defaults + " FROM " + CreateFullName(request) + " WHERE (" + where + ")";
            }

            cmd.CommandText = sql;
            cmd.CommandType = CommandType.Text;
            return(cmd);
        }
예제 #10
0
        protected EmployeesMetadata()
        {
            m_columns = new tgColumnMetadataCollection();
            tgColumnMetadata c;

            c = new tgColumnMetadata(EmployeesMetadata.ColumnNames.EmployeeID, 0, typeof(System.Int32), tgSystemType.Int32);
            c.PropertyName    = EmployeesMetadata.PropertyNames.EmployeeID;
            c.IsInPrimaryKey  = true;
            c.IsAutoIncrement = true;
            m_columns.Add(c);

            c = new tgColumnMetadata(EmployeesMetadata.ColumnNames.LastName, 1, typeof(System.String), tgSystemType.String);
            c.PropertyName       = EmployeesMetadata.PropertyNames.LastName;
            c.CharacterMaxLength = 20;
            m_columns.Add(c);

            c = new tgColumnMetadata(EmployeesMetadata.ColumnNames.FirstName, 2, typeof(System.String), tgSystemType.String);
            c.PropertyName       = EmployeesMetadata.PropertyNames.FirstName;
            c.CharacterMaxLength = 10;
            m_columns.Add(c);

            c = new tgColumnMetadata(EmployeesMetadata.ColumnNames.Title, 3, typeof(System.String), tgSystemType.String);
            c.PropertyName       = EmployeesMetadata.PropertyNames.Title;
            c.IsNullable         = true;
            c.CharacterMaxLength = 30;
            m_columns.Add(c);

            c = new tgColumnMetadata(EmployeesMetadata.ColumnNames.TitleOfCourtesy, 4, typeof(System.String), tgSystemType.String);
            c.PropertyName       = EmployeesMetadata.PropertyNames.TitleOfCourtesy;
            c.IsNullable         = true;
            c.CharacterMaxLength = 25;
            m_columns.Add(c);

            c = new tgColumnMetadata(EmployeesMetadata.ColumnNames.BirthDate, 5, typeof(System.DateTime), tgSystemType.DateTime);
            c.PropertyName = EmployeesMetadata.PropertyNames.BirthDate;
            c.IsNullable   = true;
            m_columns.Add(c);

            c = new tgColumnMetadata(EmployeesMetadata.ColumnNames.HireDate, 6, typeof(System.DateTime), tgSystemType.DateTime);
            c.PropertyName = EmployeesMetadata.PropertyNames.HireDate;
            c.IsNullable   = true;
            m_columns.Add(c);

            c = new tgColumnMetadata(EmployeesMetadata.ColumnNames.Address, 7, typeof(System.String), tgSystemType.String);
            c.PropertyName       = EmployeesMetadata.PropertyNames.Address;
            c.IsNullable         = true;
            c.CharacterMaxLength = 60;
            m_columns.Add(c);

            c = new tgColumnMetadata(EmployeesMetadata.ColumnNames.City, 8, typeof(System.String), tgSystemType.String);
            c.PropertyName       = EmployeesMetadata.PropertyNames.City;
            c.IsNullable         = true;
            c.CharacterMaxLength = 15;
            m_columns.Add(c);

            c = new tgColumnMetadata(EmployeesMetadata.ColumnNames.Region, 9, typeof(System.String), tgSystemType.String);
            c.PropertyName       = EmployeesMetadata.PropertyNames.Region;
            c.IsNullable         = true;
            c.CharacterMaxLength = 15;
            m_columns.Add(c);

            c = new tgColumnMetadata(EmployeesMetadata.ColumnNames.PostalCode, 10, typeof(System.String), tgSystemType.String);
            c.PropertyName       = EmployeesMetadata.PropertyNames.PostalCode;
            c.IsNullable         = true;
            c.CharacterMaxLength = 10;
            m_columns.Add(c);

            c = new tgColumnMetadata(EmployeesMetadata.ColumnNames.Country, 11, typeof(System.String), tgSystemType.String);
            c.PropertyName       = EmployeesMetadata.PropertyNames.Country;
            c.IsNullable         = true;
            c.CharacterMaxLength = 15;
            m_columns.Add(c);

            c = new tgColumnMetadata(EmployeesMetadata.ColumnNames.HomePhone, 12, typeof(System.String), tgSystemType.String);
            c.PropertyName       = EmployeesMetadata.PropertyNames.HomePhone;
            c.IsNullable         = true;
            c.CharacterMaxLength = 24;
            m_columns.Add(c);

            c = new tgColumnMetadata(EmployeesMetadata.ColumnNames.Extension, 13, typeof(System.String), tgSystemType.String);
            c.PropertyName       = EmployeesMetadata.PropertyNames.Extension;
            c.IsNullable         = true;
            c.CharacterMaxLength = 4;
            m_columns.Add(c);

            c = new tgColumnMetadata(EmployeesMetadata.ColumnNames.Photo, 14, typeof(System.Byte[]), tgSystemType.Byte);
            c.PropertyName       = EmployeesMetadata.PropertyNames.Photo;
            c.IsNullable         = true;
            c.CharacterMaxLength = 2147483647;
            m_columns.Add(c);

            c = new tgColumnMetadata(EmployeesMetadata.ColumnNames.Notes, 15, typeof(System.String), tgSystemType.String);
            c.PropertyName       = EmployeesMetadata.PropertyNames.Notes;
            c.IsNullable         = true;
            c.CharacterMaxLength = 1073741823;
            m_columns.Add(c);

            c = new tgColumnMetadata(EmployeesMetadata.ColumnNames.ReportsTo, 16, typeof(System.Int32), tgSystemType.Int32);
            c.PropertyName = EmployeesMetadata.PropertyNames.ReportsTo;
            c.IsNullable   = true;
            m_columns.Add(c);

            c = new tgColumnMetadata(EmployeesMetadata.ColumnNames.PhotoPath, 17, typeof(System.String), tgSystemType.String);
            c.PropertyName       = EmployeesMetadata.PropertyNames.PhotoPath;
            c.IsNullable         = true;
            c.CharacterMaxLength = 255;
            m_columns.Add(c);
        }
예제 #11
0
        protected AspNetUsersMetadata()
        {
            m_columns = new tgColumnMetadataCollection();
            tgColumnMetadata c;

            c = new tgColumnMetadata(AspNetUsersMetadata.ColumnNames.Id, 0, typeof(System.String), tgSystemType.String);
            c.PropertyName       = AspNetUsersMetadata.PropertyNames.Id;
            c.IsInPrimaryKey     = true;
            c.CharacterMaxLength = 128;
            m_columns.Add(c);

            c = new tgColumnMetadata(AspNetUsersMetadata.ColumnNames.Email, 1, typeof(System.String), tgSystemType.String);
            c.PropertyName       = AspNetUsersMetadata.PropertyNames.Email;
            c.IsNullable         = true;
            c.CharacterMaxLength = 256;
            m_columns.Add(c);

            c = new tgColumnMetadata(AspNetUsersMetadata.ColumnNames.EmailConfirmed, 2, typeof(System.Boolean), tgSystemType.Boolean);
            c.PropertyName = AspNetUsersMetadata.PropertyNames.EmailConfirmed;
            m_columns.Add(c);

            c = new tgColumnMetadata(AspNetUsersMetadata.ColumnNames.PasswordHash, 3, typeof(System.String), tgSystemType.String);
            c.PropertyName       = AspNetUsersMetadata.PropertyNames.PasswordHash;
            c.IsNullable         = true;
            c.CharacterMaxLength = 2147483647;
            m_columns.Add(c);

            c = new tgColumnMetadata(AspNetUsersMetadata.ColumnNames.SecurityStamp, 4, typeof(System.String), tgSystemType.String);
            c.PropertyName       = AspNetUsersMetadata.PropertyNames.SecurityStamp;
            c.IsNullable         = true;
            c.CharacterMaxLength = 2147483647;
            m_columns.Add(c);

            c = new tgColumnMetadata(AspNetUsersMetadata.ColumnNames.PhoneNumber, 5, typeof(System.String), tgSystemType.String);
            c.PropertyName       = AspNetUsersMetadata.PropertyNames.PhoneNumber;
            c.IsNullable         = true;
            c.CharacterMaxLength = 2147483647;
            m_columns.Add(c);

            c = new tgColumnMetadata(AspNetUsersMetadata.ColumnNames.PhoneNumberConfirmed, 6, typeof(System.Boolean), tgSystemType.Boolean);
            c.PropertyName = AspNetUsersMetadata.PropertyNames.PhoneNumberConfirmed;
            m_columns.Add(c);

            c = new tgColumnMetadata(AspNetUsersMetadata.ColumnNames.TwoFactorEnabled, 7, typeof(System.Boolean), tgSystemType.Boolean);
            c.PropertyName = AspNetUsersMetadata.PropertyNames.TwoFactorEnabled;
            m_columns.Add(c);

            c = new tgColumnMetadata(AspNetUsersMetadata.ColumnNames.LockoutEndDateUtc, 8, typeof(System.DateTime), tgSystemType.DateTime);
            c.PropertyName = AspNetUsersMetadata.PropertyNames.LockoutEndDateUtc;
            c.IsNullable   = true;
            m_columns.Add(c);

            c = new tgColumnMetadata(AspNetUsersMetadata.ColumnNames.LockoutEnabled, 9, typeof(System.Boolean), tgSystemType.Boolean);
            c.PropertyName = AspNetUsersMetadata.PropertyNames.LockoutEnabled;
            m_columns.Add(c);

            c = new tgColumnMetadata(AspNetUsersMetadata.ColumnNames.AccessFailedCount, 10, typeof(System.Int32), tgSystemType.Int32);
            c.PropertyName     = AspNetUsersMetadata.PropertyNames.AccessFailedCount;
            c.NumericPrecision = 10;
            m_columns.Add(c);

            c = new tgColumnMetadata(AspNetUsersMetadata.ColumnNames.UserName, 11, typeof(System.String), tgSystemType.String);
            c.PropertyName       = AspNetUsersMetadata.PropertyNames.UserName;
            c.CharacterMaxLength = 256;
            m_columns.Add(c);
        }
        internal override PropertyDescriptorCollection GetProperties(tgEntity entity, tgEntityCollectionBase baseCollection)
        {
            bool weHaveData  = false;
            int  lastOrdinal = 0;

            tgColumnMetadataCollection esMetaCols = entity.tg.Meta.Columns;

            tgEntityCollectionBase theBaseCollection = baseCollection != null ? baseCollection : entity.Collection;

            bool enableHierarchcialBinding = theBaseCollection != null ? theBaseCollection.EnableHierarchicalBinding : true;

            if (theBaseCollection != null)
            {
                if (theBaseCollection.GetList() != null)
                {
                    // Do we have any entities?
                    weHaveData = theBaseCollection.GetList().Count > 0;

                    if (weHaveData == false)
                    {
                        // If selectedColumns has data then they attempted a load and we know the columns based on thier select statement
                        weHaveData = theBaseCollection.selectedColumns != null && theBaseCollection.selectedColumns.Keys.Count > 0;
                    }
                }
            }

            //------------------------------------------------------------
            // First we deal with Properties from the DataTable.Columns
            // or from the tgColumnMetadataCollection.
            //------------------------------------------------------------
            ArrayList collNested = new ArrayList();
            SortedList <int, PropertyDescriptor> coll = new SortedList <int, PropertyDescriptor>();

            PropertyDescriptorCollection props = TypeDescriptor.GetProperties(entity, true);

            // Note, we check for selectedColumns because we might be a deserialized collection in which
            // case there will not be any selectedColumns
            if (weHaveData && theBaseCollection.selectedColumns != null)
            {
                SortedList list = GetSortedListOfProperties(entity, baseCollection);

                for (int i = 0; i < list.Count; i++)
                {
                    string column = (string)list.GetByIndex(i);

                    if (column == "ESRN")
                    {
                        continue;
                    }

                    tgColumnMetadata esCol = entity.tg.Meta.Columns.FindByColumnName(column);

                    if (esCol != null)
                    {
                        PropertyDescriptor prop = props[esCol.PropertyName];

                        if (prop != null)
                        {
                            coll.Add(lastOrdinal++, prop);
                        }
                    }
                    else
                    {
                        esCol = theBaseCollection.extraColumnMetadata[column];

                        if (esCol != null)
                        {
                            // Extra or Extended Properties
                            tgPropertyDescriptor dpd = new tgPropertyDescriptor
                                                       (
                                typeof(T),
                                column,
                                esCol != null ? esCol.Type : typeof(string),
                                delegate(object p)
                            {
                                return(((tgEntity)p).currentValues[column]);
                            },
                                delegate(object p, object data)
                            {
                                ((tgEntity)p).currentValues[column] = data;
                                ((tgEntity)p).OnPropertyChanged(column);
                            }
                                                       );

                            coll.Add(lastOrdinal++, dpd);
                        }
                    }
                }
            }
            else
            {
                foreach (tgColumnMetadata esCol in esMetaCols)
                {
                    coll.Add(lastOrdinal++, props[esCol.PropertyName]);
                }
            }

            //------------------------------------------------------------
            // Now we deal with extended properties that are using the
            // esExtendedPropertyAttribute technique
            //------------------------------------------------------------
            foreach (PropertyDescriptor prop in props)
            {
                if (prop.Attributes.Contains(tgEntityCollection <T> .extendedPropertyAttribute))
                {
                    coll.Add(lastOrdinal++, prop);
                }
            }

            //------------------------------------------------------------
            // Now we deal with any local properties. Local properties are
            // properties that users may want to bind with that are
            // NOT backed by data in the DataTable
            //------------------------------------------------------------
            List <tgPropertyDescriptor> localProps = entity.GetLocalBindingProperties();

            if (localProps != null)
            {
                foreach (tgPropertyDescriptor esProp in localProps)
                {
                    // We check this incase they add a local based property for a DataColumn
                    // based property, they would do this so it appears in design time, and
                    // we don't want to add a duplicate
                    bool exists = coll.ContainsValue(props[esProp.Name]);

                    if (!exists)
                    {
                        if (props[esProp.Name] != null)
                        {
                            coll.Add(lastOrdinal++, props[esProp.Name]);
                        }
                        else
                        {
                            coll.Add(lastOrdinal++, esProp);
                        }
                    }
                }
            }

            ArrayList tempColl = new ArrayList();

            if (enableHierarchcialBinding)
            {
                List <tgPropertyDescriptor> hierProps = entity.GetHierarchicalProperties();
                if (hierProps != null)
                {
                    foreach (tgPropertyDescriptor esProp in hierProps)
                    {
                        esProp.TrueDescriptor = props[esProp.Name];
                        //  coll.Add(lastOrdinal++, esProp);

                        tempColl.Add(esProp);
                    }
                }
            }

            // Create the collection
            foreach (PropertyDescriptor p in coll.Values)
            {
                tempColl.Add(p);
            }
            tempColl.AddRange(collNested);

            PropertyDescriptorCollection theProps =
                new PropertyDescriptorCollection((PropertyDescriptor[])tempColl.ToArray(typeof(PropertyDescriptor)));

            return(theProps);
        }
예제 #13
0
        static public SqlCommand BuildDynamicUpdateCommand(tgDataRequest request, tgEntitySavePacket packet)
        {
            Dictionary <string, SqlParameter> types = Cache.GetParameters(request);

            SqlCommand cmd = new SqlCommand();

            if (request.CommandTimeout != null)
            {
                cmd.CommandTimeout = request.CommandTimeout.Value;
            }

            string set = string.Empty;
            string sql = "SET NOCOUNT OFF ";

            sql += "UPDATE " + CreateFullName(request) + " SET ";

            string where = String.Empty;
            string conncur  = String.Empty;
            string computed = String.Empty;
            string comma    = String.Empty;
            string and      = String.Empty;
            string prolog   = String.Empty;

            SqlParameter p = null;

            List <string> modifiedColumns = packet.ModifiedColumns;

            foreach (string colName in modifiedColumns)
            {
                tgColumnMetadata col = request.Columns[colName];

                if (col == null)
                {
                    continue;
                }

                if (!col.IsInPrimaryKey && !col.IsComputed)
                {
                    p = CloneParameter(types[colName]);
                    p = cmd.Parameters.Add(p);

                    object value = packet.CurrentValues[colName];
                    p.Value = value != null ? value : DBNull.Value;

                    sql  += comma;
                    sql  += Delimiters.ColumnOpen + colName + Delimiters.ColumnClose + " = " + p.ParameterName;
                    comma = ", ";
                }
            }

            foreach (tgColumnMetadata col in request.Columns)
            {
                if (col.IsInPrimaryKey)
                {
                    p       = CloneParameter(types[col.Name]);
                    p.Value = packet.OriginalValues[col.Name];
                    cmd.Parameters.Add(p);

                    where += and;
                    where += Delimiters.ColumnOpen + col.Name + Delimiters.ColumnClose + " = " + p.ParameterName;
                    and    = " AND ";
                }
                else if (col.IsConcurrency)
                {
                    p           = CloneParameter(types[col.Name]);
                    p.Value     = packet.OriginalValues[col.Name];
                    p.Direction = ParameterDirection.InputOutput;
                    cmd.Parameters.Add(p);

                    if (request.DatabaseVersion == "2005" || request.DatabaseVersion == "2008")
                    {
                        conncur += Delimiters.ColumnOpen + col.Name + Delimiters.ColumnClose + " = " + p.ParameterName;
                    }
                    else
                    {
                        conncur += "TSEQUAL(" + Delimiters.ColumnOpen + col.Name + Delimiters.ColumnClose + "," + p.ParameterName + ")";
                    }

                    if (computed.Length > 0)
                    {
                        computed += ", ";
                    }
                    computed += " " + p.ParameterName + " = " + Delimiters.ColumnOpen + col.Name + Delimiters.ColumnClose;
                }
                else if (col.IsComputed && !col.IsAutoIncrement)
                {
                    if (request.SelectedColumns != null && request.SelectedColumns.ContainsKey(col.Name))
                    {
                        p           = CloneParameter(types[col.Name]);
                        p.Direction = ParameterDirection.Output;
                        if (col.CharacterMaxLength > 0)
                        {
                            p.Size = (int)col.CharacterMaxLength;
                        }
                        cmd.Parameters.Add(p);

                        if (computed.Length > 0)
                        {
                            computed += ", ";
                        }
                        computed += " " + p.ParameterName + " = " + Delimiters.ColumnOpen + col.Name + Delimiters.ColumnClose;
                    }
                }
                else if (col.IsTiraggoConcurrency)
                {
                    if (packet.OriginalValues != null && packet.OriginalValues.ContainsKey(col.Name))
                    {
                        p           = CloneParameter(types[col.Name]);
                        p.Direction = ParameterDirection.InputOutput;
                        p.Value     = packet.OriginalValues[col.Name];
                        cmd.Parameters.Add(p);

                        sql += comma.Length > 0 ? ", " : string.Empty;
                        sql += Delimiters.ColumnOpen + col.Name + Delimiters.ColumnClose + " = " +
                               Delimiters.ColumnOpen + col.Name + Delimiters.ColumnClose + " + 1";

                        conncur += Delimiters.ColumnOpen + col.Name + Delimiters.ColumnClose + " = " + p.ParameterName;

                        prolog += " SET " + p.ParameterName + " = " + p.ParameterName + " + 1";
                    }
                }
            }

            tgColumnMetadataCollection cols = request.Columns;

            if (cols.DateModified != null && cols.DateModified.IsServerSide &&
                cols.FindByColumnName(cols.DateModified.ColumnName) != null)
            {
                p           = CloneParameter(types[cols.DateModified.ColumnName]);
                p.Direction = ParameterDirection.Output;
                cmd.Parameters.Add(p);

                sql  += comma;
                sql  += Delimiters.ColumnOpen + cols.DateModified.ColumnName + Delimiters.ColumnClose + " = " + p.ParameterName;
                comma = ", ";

                set += " SET " + p.ParameterName + " = " + request.ProviderMetadata["DateModified.ServerSideText"] + ";";
            }

            if (cols.ModifiedBy != null && cols.ModifiedBy.IsServerSide &&
                cols.FindByColumnName(cols.ModifiedBy.ColumnName) != null)
            {
                p           = CloneParameter(types[cols.ModifiedBy.ColumnName]);
                p.Size      = (int)cols.FindByColumnName(cols.ModifiedBy.ColumnName).CharacterMaxLength;
                p.Direction = ParameterDirection.Output;
                cmd.Parameters.Add(p);

                sql  += comma;
                sql  += Delimiters.ColumnOpen + cols.ModifiedBy.ColumnName + Delimiters.ColumnClose + " = " + p.ParameterName;
                comma = ", ";

                set += " SET " + p.ParameterName + " = " + request.ProviderMetadata["ModifiedBy.ServerSideText"] + ";";
            }


            sql = set + sql + " WHERE (" + where + ")";
            if (conncur.Length > 0)
            {
                sql += " AND " + conncur;
            }

            if (computed.Length > 0)
            {
                sql += " SELECT " + computed + " FROM " + CreateFullName(request) + " WHERE (" + where + ")";
            }

            if (prolog.Length > 0)
            {
                sql += prolog;
            }

            cmd.CommandText = sql;
            cmd.CommandType = CommandType.Text;
            return(cmd);
        }
예제 #14
0
파일: Shared.cs 프로젝트: fushenwen/Tiraggo
        static public OracleCommand BuildDynamicInsertCommand(tgDataRequest request, tgEntitySavePacket packet)
        {
            Dictionary <string, OracleParameter> types = Cache.GetParameters(request);

            OracleCommand cmd = new OracleCommand();

            if (request.CommandTimeout != null)
            {
                cmd.CommandTimeout = request.CommandTimeout.Value;
            }

            string comma              = String.Empty;
            string into               = String.Empty;
            string values             = String.Empty;
            string computedColumns    = String.Empty;
            string computedParameters = String.Empty;
            string computedComma      = String.Empty;

            List <string> modifiedColumns = packet.ModifiedColumns;

            string sql = "BEGIN ";

            OracleParameter p = null;

            foreach (tgColumnMetadata col in request.Columns)
            {
                if (col.IsAutoIncrement)
                {
                    p           = CloneParameter(types[col.Name]);
                    p.Direction = ParameterDirection.Output;
                    cmd.Parameters.Add(p);

                    string AutoKeyText = request.ProviderMetadata["AutoKeyText"];

                    // SELECT EMPLOYEE_ID.NextVal INTO p_EMPLOYEE_ID FROM DUAL;
                    sql += "SELECT \"" + AutoKeyText + "\".NextVal INTO " + p.ParameterName + " FROM DUAL; ";

                    into   += comma;
                    into   += Delimiters.ColumnOpen + col.Name + Delimiters.ColumnClose;
                    values += comma;
                    values += p.ParameterName;
                    comma   = ", ";
                }
                else if (col.IsTiraggoConcurrency)
                {
                    p           = CloneParameter(types[col.Name]);
                    p.Direction = ParameterDirection.Output;
                    cmd.Parameters.Add(p);

                    sql += p.ParameterName + " := 1; ";

                    into   += comma;
                    into   += Delimiters.ColumnOpen + col.Name + Delimiters.ColumnClose;
                    values += comma;
                    values += p.ParameterName;
                    comma   = ", ";
                }
                else if (col.HasDefault && (modifiedColumns != null && !modifiedColumns.Contains(col.Name)))
                {
                    p           = CloneParameter(types[col.Name]);
                    p.Direction = ParameterDirection.Output;
                    cmd.Parameters.Add(p);

                    computedColumns    += computedComma + Delimiters.ColumnOpen + col.Name + Delimiters.ColumnClose;
                    computedParameters += computedComma + p.ParameterName;
                    computedComma       = ", ";

                    if (col.CharacterMaxLength > 0)
                    {
                        p.Size = (int)col.CharacterMaxLength;
                    }
                }
            }

            tgColumnMetadataCollection cols = request.Columns;

            #region Special Column Logic
            if (cols.DateAdded != null && cols.DateAdded.IsServerSide)
            {
                p    = CloneParameter(types[cols.DateAdded.ColumnName]);
                sql += p.ParameterName + " := " + request.ProviderMetadata["DateAdded.ServerSideText"] + ";";

                CreateInsertSQLSnippet(cols.DateAdded.ColumnName, p, ref into, ref values, ref comma);

                p.Direction = ParameterDirection.Output;
                cmd.Parameters.Add(p);
            }

            if (cols.DateModified != null && cols.DateModified.IsServerSide)
            {
                p    = CloneParameter(types[cols.DateModified.ColumnName]);
                sql += p.ParameterName + " := " + request.ProviderMetadata["DateModified.ServerSideText"] + ";";

                CreateInsertSQLSnippet(cols.DateModified.ColumnName, p, ref into, ref values, ref comma);

                p.Direction = ParameterDirection.Output;
                cmd.Parameters.Add(p);
            }

            if (cols.AddedBy != null && cols.AddedBy.IsServerSide)
            {
                p      = CloneParameter(types[cols.AddedBy.ColumnName]);
                p.Size = (int)cols.FindByColumnName(cols.AddedBy.ColumnName).CharacterMaxLength;
                sql   += p.ParameterName + " := " + request.ProviderMetadata["AddedBy.ServerSideText"] + ";";

                CreateInsertSQLSnippet(cols.AddedBy.ColumnName, p, ref into, ref values, ref comma);

                p.Direction = ParameterDirection.Output;
                cmd.Parameters.Add(p);
            }

            if (cols.ModifiedBy != null && cols.ModifiedBy.IsServerSide)
            {
                p      = CloneParameter(types[cols.ModifiedBy.ColumnName]);
                p.Size = (int)cols.FindByColumnName(cols.ModifiedBy.ColumnName).CharacterMaxLength;
                sql   += p.ParameterName + " := " + request.ProviderMetadata["ModifiedBy.ServerSideText"] + ";";

                CreateInsertSQLSnippet(cols.ModifiedBy.ColumnName, p, ref into, ref values, ref comma);

                p.Direction = ParameterDirection.Output;
                cmd.Parameters.Add(p);
            }
            #endregion

            sql += "INSERT INTO " + CreateFullName(request) + " ";

            if (modifiedColumns != null)
            {
                foreach (string colName in modifiedColumns)
                {
                    tgColumnMetadata col = request.Columns[colName];
                    if (col != null && !col.IsAutoIncrement)
                    {
                        p = types[colName];
                        p = cmd.Parameters.Add(CloneParameter(p));

                        object value = packet.CurrentValues[colName];
                        p.Value = value != null ? value : DBNull.Value;

                        into   += comma;
                        into   += Delimiters.ColumnOpen + colName + Delimiters.ColumnClose;
                        values += comma;
                        values += p.ParameterName;
                        comma   = ", ";
                    }
                }
            }

            if (into.Length != 0)
            {
                sql += "(" + into + ") VALUES (" + values + ");";
            }

            if (computedColumns.Length > 0)
            {
                string where = String.Empty;

                foreach (tgColumnMetadata col in request.Columns)
                {
                    if (col.IsInPrimaryKey)
                    {
                        // We need the were clause if there are defaults to bring back
                        p = types[col.Name];

                        if (where.Length > 0)
                        {
                            where += " AND ";
                        }
                        where += Delimiters.ColumnOpen + col.Name + Delimiters.ColumnClose + " = " + p.ParameterName;

                        if (!cmd.Parameters.Contains(p.ParameterName))
                        {
                            p           = CloneParameter(p);
                            p.Direction = ParameterDirection.Output;
                            cmd.Parameters.Add(p);
                        }
                    }
                }

                sql += " SELECT " + computedColumns + " INTO " + computedParameters + " FROM " + CreateFullName(request) + " WHERE (" + where + ");";
            }

            sql += " END;";

            cmd.CommandText = sql;
            cmd.CommandType = CommandType.Text;
            return(cmd);
        }
예제 #15
0
파일: Shared.cs 프로젝트: fushenwen/Tiraggo
        //CREATE PROCEDURE "MYGENERATION"."proc_SeqTestUpdate" (
        //    pID IN "SeqTest"."ID"%type,
        //    pTimeStamp IN OUT "SeqTest"."TimeStamp"%type,
        //    pData IN "SeqTest"."Data"%type
        //)
        //IS
        //    pConncurrency "SeqTest"."TimeStamp"%type := pTimeStamp;

        //BEGIN
        //    UPDATE "SeqTest"
        //    SET
        //        "TimeStamp" = "TimeStamp" + 1,
        //        "Data"  = pData
        //    WHERE
        //        "ID" = pID
        //    AND "TimeStamp" = pConncurrency
        //;

        //    IF SQL%ROWCOUNT = 1 THEN
        //     pTimeStamp := (pConncurrency + 1);
        //    ELSE
        //     Raise_application_error(01403, 'NO RECORDS WERE UPDATED');
        //    END IF;

        //END ;

        static public OracleCommand BuildDynamicUpdateCommand(tgDataRequest request, tgEntitySavePacket packet)
        {
            Dictionary <string, OracleParameter> types = Cache.GetParameters(request);

            OracleCommand cmd = new OracleCommand();

            if (request.CommandTimeout != null)
            {
                cmd.CommandTimeout = request.CommandTimeout.Value;
            }

            string sql = string.Empty;

            bool   hasConcurrency    = false;
            string concurrencyColumn = String.Empty;

            List <string> modifiedColumns = packet.ModifiedColumns;

            foreach (tgColumnMetadata col in request.Columns)
            {
                if (col.IsTiraggoConcurrency)
                {
                    hasConcurrency    = true;
                    concurrencyColumn = col.Name;

                    sql += "DECLARE pConncurrency " + request.ProviderMetadata.GetTypeMap(col.PropertyName).NativeType + "; ";
                    break;
                }
            }

            OracleParameter p = null;

            sql += " BEGIN ";

            tgColumnMetadataCollection cols = request.Columns;

            if (cols.DateModified != null && cols.DateModified.IsServerSide)
            {
                p           = CloneParameter(types[cols.DateModified.ColumnName]);
                p.Direction = ParameterDirection.Output;
                cmd.Parameters.Add(p);

                sql += p.ParameterName + " := " + request.ProviderMetadata["DateModified.ServerSideText"] + "; ";
            }

            if (cols.ModifiedBy != null && cols.ModifiedBy.IsServerSide)
            {
                p           = CloneParameter(types[cols.ModifiedBy.ColumnName]);
                p.Size      = (int)cols.FindByColumnName(cols.ModifiedBy.ColumnName).CharacterMaxLength;
                p.Direction = ParameterDirection.Output;
                cmd.Parameters.Add(p);

                sql += p.ParameterName + " := " + request.ProviderMetadata["ModifiedBy.ServerSideText"] + "; ";
            }


            if (hasConcurrency)
            {
                sql += "pConncurrency := " + Delimiters.Param + concurrencyColumn + "; ";
            }

            sql += "UPDATE " + CreateFullName(request) + " SET ";

            string computed = String.Empty;
            string comma    = String.Empty;
            string and      = String.Empty;

            string where = string.Empty;

            foreach (string colName in modifiedColumns)
            {
                tgColumnMetadata col = request.Columns[colName];

                if (col != null && !col.IsInPrimaryKey && !col.IsTiraggoConcurrency)
                {
                    p = cmd.Parameters.Add(CloneParameter(types[colName]));

                    object value = packet.CurrentValues[colName];
                    p.Value = value != null ? value : DBNull.Value;

                    sql  += comma;
                    sql  += Delimiters.ColumnOpen + colName + Delimiters.ColumnClose + " = " + p.ParameterName;
                    comma = ", ";
                }
            }

            foreach (tgColumnMetadata col in request.Columns)
            {
                if (col.IsInPrimaryKey)
                {
                    p       = CloneParameter(types[col.Name]);
                    p.Value = packet.OriginalValues[col.Name];
                    cmd.Parameters.Add(p);

                    where += and;
                    where += Delimiters.ColumnOpen + col.Name + Delimiters.ColumnClose + " = " + p.ParameterName;
                    and    = " AND ";
                }
                else if (col.IsComputed && !col.IsAutoIncrement)
                {
                    if (request.SelectedColumns != null && request.SelectedColumns.ContainsKey(col.Name))
                    {
                        p           = CloneParameter(types[col.Name]);
                        p.Direction = ParameterDirection.Output;
                        if (col.CharacterMaxLength > 0)
                        {
                            p.Size = (int)col.CharacterMaxLength;
                        }
                        cmd.Parameters.Add(p);

                        if (computed.Length > 0)
                        {
                            computed += ", ";
                        }
                        computed += " " + p.ParameterName + " = " + Delimiters.ColumnOpen + col.Name + Delimiters.ColumnClose;
                    }
                }
                if (col.IsTiraggoConcurrency)
                {
                    sql += ", ";
                    sql += Delimiters.ColumnOpen + col.Name + Delimiters.ColumnClose + " = " +
                           Delimiters.ColumnOpen + col.Name + Delimiters.ColumnClose + " + 1";

                    p           = CloneParameter(types[col.Name]);
                    p.Direction = ParameterDirection.InputOutput;
                    p.Value     = packet.OriginalValues[col.Name];
                    cmd.Parameters.Add(p);
                    break;
                }
            }

            sql += " WHERE (" + where + ") ";
            if (hasConcurrency)
            {
                sql += " AND \"" + concurrencyColumn + "\" = pConncurrency; ";

                sql += "IF SQL%ROWCOUNT = 1 THEN ";
                sql += Delimiters.Param + concurrencyColumn + " := pConncurrency + 1; ELSE ";
                sql += "Raise_application_error(-20101, 'NO RECORDS WERE UPDATED'); END IF;";
            }
            else
            {
                sql += ";";
            }

            if (computed.Length > 0)
            {
                sql += " SELECT " + computed + " FROM " + CreateFullName(request) + " WHERE (" + where + ")";
            }

            sql += " END;";

            cmd.CommandText = sql;
            cmd.CommandType = CommandType.Text;
            return(cmd);
        }