/// <summary>
        /// Deletes all roles from the database which are connected with specific member.
        /// </summary>
        /// <returns>Returns true if it was successfully deleted.</returns>
        public virtual bool Delete()
        {
            this.WasDeleted = false;

            SpRoleAdmin sp = new SpRoleAdmin(String.Format("DELETE FROM {0} WHERE MemberTokenID=@MemberTokenID", Table));

            sp.AddParameter("MemberTokenID", MemberTokenID);

            if (sp.ExecuteNonQuery() == 0)
            {
                this.WasDeleted = true;
            }

            return(this.WasDeleted);
        }
Example #2
0
        /// <summary>
        /// Deletes all roles from the database which are connected with specific member.
        /// </summary>
        /// <returns>Returns true if it was successfully deleted.</returns>
        public virtual bool Delete()
        {
            this.WasDeleted = false;

            SpRoleAdmin sp = new SpRoleAdmin(String.Format(@" 
                DELETE FROM DomainProfileFields WHERE DomainID = @DomainID;
                DELETE FROM MemberDomains WHERE DomainID = @DomainID;
                DELETE FROM {0} WHERE DomainID = @DomainID;", Table));

            sp.AddParameter("DomainID", DomainID);

            if (sp.ExecuteNonQuery() == 0)
            {
                this.WasDeleted = true;
            }

            return(this.WasDeleted);
        }
        /// <summary>
        /// Updates member token string and set modification date.
        /// </summary>
        /// <returns>Returns true if it was successfully deleted.</returns>
        public virtual bool SaveToken()
        {
            bool        result = false;
            SpRoleAdmin sp     = null;

            if (this.MemberID > 0)
            {
                sp = new SpRoleAdmin(String.Format(@"
                        UPDATE {0} SET Token = @Token, Modified = @Modified
                        WHERE MemberID = @MemberID", Table));

                sp.AddParameter("MemberID", MemberID);
                sp.AddParameter("Token", Token);
                sp.AddParameter("Modified", DateTime.Now.ToUniversalTime());

                if (sp.ExecuteNonQuery() == 0)
                {
                    result = true;
                }
            }

            return(result);
        }
Example #4
0
        /// <summary>
        /// Save attempt number for specific type.
        /// </summary>
        /// <returns></returns>
        public virtual bool SaveAttempts()
        {
            bool        result = false;
            SpRoleAdmin sp     = null;

            if (this.MemberID > 0)
            {
                sp = new SpRoleAdmin(@"
                        UPDATE " + ApplicationTables.TableName(this) + @" SET Attempts = @Attempts, Modified = @Modified
                        WHERE MemberID = @MemberID");

                sp.AddParameter("MemberID", MemberID);
                sp.AddParameter("Attempts", Attempts);
                sp.AddParameter("AttemptType", AttemptType);
                sp.AddParameter("Modified", DateTime.Now.ToUniversalTime());

                if (sp.ExecuteNonQuery() == 0)
                {
                    result = true;
                }
            }

            return(result);
        }
        /// <summary>
        /// Inserts an object in database according to class properties.
        /// </summary>
        /// <returns>Returns true if it was successfully saved.</returns>
        public virtual bool Save()
        {
            this.WasSaved = false;
            SpRoleAdmin sp = null;

            if (this.MemberTokenID > 0)
            {
                sp = new SpRoleAdmin(String.Format(@"
                        UPDATE {0} SET 
                               Token        = @Token, 
                               GeneratedBy  = @GeneratedBy,                               
                               Modified     = @Modified
                        WHERE MemberTokenID = @MemberTokenID", Table));

                sp.AddParameter("MemberTokenID", MemberTokenID);
                sp.AddParameter("Modified", DateTime.UtcNow);
            }
            else
            {
                sp = new SpRoleAdmin(String.Format(@"
                        INSERT INTO  {0} ( MemberID, Token,GeneratedBy, Created, Modified) 
                               VALUES( @MemberID, @Token, @GeneratedBy, @Created, @Modified); SELECT @MemberTokenID = @@IDENTITY", Table));

                sp.AddParameter("MemberTokenID", MemberID, System.Data.ParameterDirection.Output);

                if (Modified != DateTime.MinValue)
                {
                    sp.AddParameter("Modified", Created);
                }
                else
                {
                    sp.AddParameter("Modified", DateTime.UtcNow);
                }
            }

            sp.AddParameter("MemberID", MemberID);
            sp.AddParameter("GeneratedBy", GeneratedBy);
            sp.AddParameter("Token", Token);

            if (Created != DateTime.MinValue)
            {
                sp.AddParameter("Created", Created);
            }
            else
            {
                sp.AddParameter("Created", DateTime.UtcNow);
            }

            if (sp.ExecuteNonQuery() == 0)
            {
                this.WasSaved = true;
            }

            if (this.MemberTokenID <= 0)
            {
                switch (DbRoleAdmin.CurrentProvider)
                {
                case DatabaseProvider.MSSQLServer:
                {
                    MemberID = (long)sp.GetParameter("MemberTokenID");
                    break;
                }

                case DatabaseProvider.MySQLServer:
                {
                    break;
                }
                }
            }

            return(this.WasSaved);
        }
        /// <summary>
        /// Deletes all roles from the database which are connected with specific member.
        /// </summary>
        /// <returns>Returns true if it was successfully deleted.</returns>
        public virtual bool Delete()
        {
            this.WasDeleted = false;

            SpRoleAdmin sp = new SpRoleAdmin(String.Format("DELETE FROM {0} WHERE MemberTokenID=@MemberTokenID",Table));
            sp.AddParameter("MemberTokenID", MemberTokenID);

            if (sp.ExecuteNonQuery() == 0)
                this.WasDeleted = true;

            return this.WasDeleted;
        }
        /// <summary>
        /// Updates member token string and set modification date.
        /// </summary>
        /// <returns>Returns true if it was successfully deleted.</returns>
        public virtual bool SaveToken()
        {
            bool result = false;
            SpRoleAdmin sp = null;

            if (this.MemberID > 0)
            {
                sp = new SpRoleAdmin(String.Format(@"
                        UPDATE {0} SET Token = @Token, Modified = @Modified
                        WHERE MemberID = @MemberID",Table));

                sp.AddParameter("MemberID", MemberID);
                sp.AddParameter("Token", Token);
                sp.AddParameter("Modified", DateTime.Now.ToUniversalTime());

                if (sp.ExecuteNonQuery() == 0)
                    result = true;
            }

            return result;
        }
        /// <summary>
        /// Inserts an object in database according to class properties.
        /// </summary>
        /// <returns>Returns true if it was successfully saved.</returns>            
        public virtual bool Save()
        {
            this.WasSaved = false;
            SpRoleAdmin sp = null;

            if (this.MemberTokenID > 0)
            {
                sp = new SpRoleAdmin(String.Format(@"
                        UPDATE {0} SET
                               Token        = @Token,
                               GeneratedBy  = @GeneratedBy,
                               Modified     = @Modified
                        WHERE MemberTokenID = @MemberTokenID",Table));

                sp.AddParameter("MemberTokenID", MemberTokenID);
                sp.AddParameter("Modified", DateTime.UtcNow);
            }
            else
            {
                sp = new SpRoleAdmin(String.Format(@"
                        INSERT INTO  {0} ( MemberID, Token,GeneratedBy, Created, Modified)
                               VALUES( @MemberID, @Token, @GeneratedBy, @Created, @Modified); SELECT @MemberTokenID = @@IDENTITY",Table));

                sp.AddParameter("MemberTokenID", MemberID, System.Data.ParameterDirection.Output);

                if (Modified != DateTime.MinValue)
                    sp.AddParameter("Modified", Created);
                else
                    sp.AddParameter("Modified", DateTime.UtcNow);

            }

            sp.AddParameter("MemberID", MemberID);
            sp.AddParameter("GeneratedBy", GeneratedBy);
            sp.AddParameter("Token", Token);

            if(Created != DateTime.MinValue)
                sp.AddParameter("Created", Created);
            else
                sp.AddParameter("Created", DateTime.UtcNow);

            if (sp.ExecuteNonQuery() == 0)
                this.WasSaved = true;

            if (this.MemberTokenID <= 0)
            {

                switch (DbRoleAdmin.CurrentProvider)
                {
                    case DatabaseProvider.MSSQLServer:
                        {
                            MemberID = (long)sp.GetParameter("MemberTokenID");
                            break;
                        }
                    case DatabaseProvider.MySQLServer:
                        {

                            break;
                        }
                }

            }

            return this.WasSaved;
        }
Example #9
0
        /// <summary>
        /// Inserts an object in database according to class properties.
        /// </summary>
        /// <returns>Returns true if it was successfully saved.</returns>
        public virtual bool Save()
        {
            this.WasSaved = false;
            SpRoleAdmin sp = null;

            if (this.DomainID > 0)
            {
                sp = new SpRoleAdmin(String.Format(@"
                        UPDATE {0} SET 
                             Name           = @Name, 
                             Description    = @Description, 
                             Modified       = @Modified
                        WHERE DomainID = @DomainID
                    ", Table));

                sp.AddParameter("DomainID", DomainID);
                sp.AddParameter("Modified", DateTime.UtcNow);
            }
            else
            {
                sp = new SpRoleAdmin(String.Format(@"
                        INSERT INTO {0} (Name, Description, Created) 
                               VALUES(@Name, @Description, @Created); SELECT @DomainID = @@IDENTITY", Table));

                sp.AddParameter("DomainID", DomainID, System.Data.ParameterDirection.Output);
            }

            sp.AddParameter("Name", Name);

            if (Description == null || Description.Trim().Length == 0)
            {
                sp.AddParameter("Description", DBNull.Value);
            }
            else
            {
                sp.AddParameter("Description", Description);
            }

            if (Created != DateTime.MinValue)
            {
                sp.AddParameter("Created", Created);
            }
            else
            {
                sp.AddParameter("Created", DateTime.UtcNow);
            }

            if (sp.ExecuteNonQuery() == 0)
            {
                this.WasSaved = true;
            }

            if (this.DomainID <= 0)
            {
                switch (DbRoleAdmin.CurrentProvider)
                {
                case DatabaseProvider.MSSQLServer:
                {
                    DomainID = (int)sp.GetParameter("DomainID");
                    break;
                }

                case DatabaseProvider.MySQLServer:
                {
                    MySqlCommand cm = (MySqlCommand)sp.SqlCommand;

                    if (cm.LastInsertedId > 0)
                    {
                        DomainID = Convert.ToInt32(cm.LastInsertedId);
                    }

                    break;
                }
                }
            }

            return(this.WasSaved);
        }
        /// <summary>
        /// Deletes all roles from the database which are connected with specific member.
        /// </summary>
        /// <returns>Returns true if it was successfully deleted.</returns>
        public virtual bool Delete()
        {
            this.WasDeleted = false;

            SpRoleAdmin sp = new SpRoleAdmin(String.Format(@"
                DELETE FROM DomainProfileFields WHERE DomainID = @DomainID;
                DELETE FROM MemberDomains WHERE DomainID = @DomainID;
                DELETE FROM {0} WHERE DomainID = @DomainID;", Table));
            sp.AddParameter("DomainID", DomainID);

            if (sp.ExecuteNonQuery() == 0)
                this.WasDeleted = true;

            return this.WasDeleted;
        }
        /// <summary>
        /// Inserts an object in database according to class properties.
        /// </summary>
        /// <returns>Returns true if it was successfully saved.</returns>
        public virtual bool Save()
        {
            this.WasSaved = false;
            SpRoleAdmin sp = null;

            if (this.DomainID > 0)
            {
                sp = new SpRoleAdmin(String.Format(@"
                        UPDATE {0} SET
                             Name           = @Name,
                             Description    = @Description,
                             Modified       = @Modified
                        WHERE DomainID = @DomainID
                    ", Table));

                sp.AddParameter("DomainID", DomainID);
                sp.AddParameter("Modified", DateTime.UtcNow);
            }
            else
            {
                sp = new SpRoleAdmin(String.Format(@"
                        INSERT INTO {0} (Name, Description, Created)
                               VALUES(@Name, @Description, @Created); SELECT @DomainID = @@IDENTITY", Table));

                sp.AddParameter("DomainID", DomainID, System.Data.ParameterDirection.Output);
            }

            sp.AddParameter("Name", Name);

            if (Description == null || Description.Trim().Length == 0)
                sp.AddParameter("Description", DBNull.Value);
            else
                sp.AddParameter("Description", Description);

            if (Created != DateTime.MinValue)
                sp.AddParameter("Created", Created);
            else
                sp.AddParameter("Created", DateTime.UtcNow);

            if (sp.ExecuteNonQuery() == 0)
                this.WasSaved = true;

            if (this.DomainID <= 0)
            {
                switch (DbRoleAdmin.CurrentProvider)
                {
                    case DatabaseProvider.MSSQLServer:
                        {
                            DomainID = (int)sp.GetParameter("DomainID");
                            break;
                        }
                    case DatabaseProvider.MySQLServer:
                        {
                            MySqlCommand cm = (MySqlCommand)sp.SqlCommand;

                            if (cm.LastInsertedId > 0)
                                DomainID = Convert.ToInt32(cm.LastInsertedId);

                            break;
                        }
                }
            }

            return this.WasSaved;
        }
Example #12
0
        /// <summary>
        /// Inserts an object in database according to class properties.
        /// </summary>
        /// <returns>Returns true if it was successfully saved.</returns>
        public virtual bool Save()
        {
            this.WasSaved = false;
            SpRoleAdmin sp = null;

            if (this.AttemptID > 0)
            {
                sp = new SpRoleAdmin(String.Format(@"
                        UPDATE {0} SET 
                               Attempts     = @Attempts, 
                               AttemptType  = @AttemptType,                               
                               IsAttemptValid  = @IsAttemptValid,
                               Modified     = @Modified
                        WHERE AttemptID = @AttemptID", Table));

                sp.AddParameter("AttemptID", AttemptID);
                sp.AddParameter("Modified", DateTime.UtcNow);
            }
            else
            {
                switch (DbRoleAdmin.CurrentProvider)
                {
                case DatabaseProvider.MSSQLServer:
                {
                    sp = new SpRoleAdmin(String.Format(@"
                               IF NOT EXISTS(SELECT AttemptID FROM {0} WHERE MemberID = @MemberID AND AttemptType = @AttemptType AND Year(Created) = Year(@Created) AND Month(Created) = Month(@Created) AND Day(Created) = Day(@Created) AND IsAttemptValid = 1)
                               BEGIN
                                   INSERT INTO {0} ( MemberID, Attempts,AttemptType, Created,  IsAttemptValid) 
                                          VALUES( @MemberID, @Attempts, @AttemptType, @CreatedNow, @IsAttemptValid); SELECT @AttemptID = @@IDENTITY
                               END
                               ELSE
                               BEGIN
                                   UPDATE {0} SET 
                                          Attempts = @Attempts, 
                                          Modified = @Modified
                                   WHERE AttemptID = @AttemptID AND AttemptType = @AttemptType
                               END
                            ", Table));
                    break;
                }

                case DatabaseProvider.MySQLServer:
                {
                    sp = new SpRoleAdmin(String.Format(@"
                                INSERT INTO {0} (MemberID, Attempts, AttemptType, Created,  IsAttemptValid) 
                                          SELECT @MemberID, @Attempts, @AttemptType, @CreatedNow, @IsAttemptValid FROM DUAL 
                                                WHERE NOT EXISTS(SELECT * FROM {0} WHERE MemberID = @MemberID AND AttemptType = @AttemptType AND Year(Created) = Year(@Created) AND Month(Created) = Month(@Created) AND Day(Created) = Day(@Created) AND IsAttemptValid = 1) LIMIT 1;
                                                            
                                UPDATE {0} SET 
                                       Attempts = @Attempts, 
                                       Modified = @Modified
                                WHERE AttemptID = @AttemptID AND AttemptType = @AttemptType;
                              ", Table));

                    break;
                }
                }

                sp.AddParameter("AttemptID", MemberID, System.Data.ParameterDirection.Output);
                sp.AddParameter("Modified", DateTime.UtcNow);
            }

            sp.AddParameter("MemberID", MemberID);
            sp.AddParameter("AttemptType", AttemptType);
            sp.AddParameter("Attempts", Attempts);
            sp.AddParameter("CreatedNow", DateTime.UtcNow);
            sp.AddParameter("Created", Created != DateTime.MinValue ? Created : DateTime.UtcNow);
            sp.AddParameter("IsAttemptValid", IsAttemptValid);

            if (sp.ExecuteNonQuery() == 0)
            {
                this.WasSaved = true;
            }

            if (this.AttemptID <= 0)
            {
                switch (DbRoleAdmin.CurrentProvider)
                {
                case DatabaseProvider.MSSQLServer:
                {
                    AttemptID = (long)sp.GetParameter("AttemptID");
                    break;
                }

                case DatabaseProvider.MySQLServer:
                {
                    MySqlCommand cm = (MySqlCommand)sp.SqlCommand;

                    if (cm.LastInsertedId > 0)
                    {
                        AttemptID = Convert.ToInt64(cm.LastInsertedId);
                    }

                    break;
                }
                }
            }

            return(this.WasSaved);
        }
        /// <summary>
        /// Save attempt number for specific type.
        /// </summary>
        /// <returns></returns>
        public virtual bool SaveAttempts()
        {
            bool result = false;
            SpRoleAdmin sp = null;

            if (this.MemberID > 0)
            {
                sp = new SpRoleAdmin(@"
                        UPDATE " + ApplicationTables.TableName(this) + @" SET Attempts = @Attempts, Modified = @Modified
                        WHERE MemberID = @MemberID");

                sp.AddParameter("MemberID", MemberID);
                sp.AddParameter("Attempts", Attempts);
                sp.AddParameter("AttemptType", AttemptType);
                sp.AddParameter("Modified",DateTime.Now.ToUniversalTime());

                if (sp.ExecuteNonQuery() == 0)
                    result = true;
            }

            return result;
        }
        /// <summary>
        /// Inserts an object in database according to class properties.
        /// </summary>
        /// <returns>Returns true if it was successfully saved.</returns>
        public virtual bool Save()
        {
            this.WasSaved = false;
            SpRoleAdmin sp = null;

            if (this.AttemptID > 0)
            {
                sp = new SpRoleAdmin(String.Format(@"
                        UPDATE {0} SET
                               Attempts     = @Attempts,
                               AttemptType  = @AttemptType,
                               IsAttemptValid  = @IsAttemptValid,
                               Modified     = @Modified
                        WHERE AttemptID = @AttemptID",Table));

                sp.AddParameter("AttemptID", AttemptID);
                sp.AddParameter("Modified", DateTime.UtcNow);
            }
            else
            {
                switch (DbRoleAdmin.CurrentProvider)
                {
                    case DatabaseProvider.MSSQLServer:
                        {
                            sp = new SpRoleAdmin(String.Format(@"
                               IF NOT EXISTS(SELECT AttemptID FROM {0} WHERE MemberID = @MemberID AND AttemptType = @AttemptType AND Year(Created) = Year(@Created) AND Month(Created) = Month(@Created) AND Day(Created) = Day(@Created) AND IsAttemptValid = 1)
                               BEGIN
                                   INSERT INTO {0} ( MemberID, Attempts,AttemptType, Created,  IsAttemptValid)
                                          VALUES( @MemberID, @Attempts, @AttemptType, @CreatedNow, @IsAttemptValid); SELECT @AttemptID = @@IDENTITY
                               END
                               ELSE
                               BEGIN
                                   UPDATE {0} SET
                                          Attempts = @Attempts,
                                          Modified = @Modified
                                   WHERE AttemptID = @AttemptID AND AttemptType = @AttemptType
                               END
                            ", Table));
                            break;
                        }
                    case DatabaseProvider.MySQLServer:
                        {
                            sp = new SpRoleAdmin(String.Format(@"
                                INSERT INTO {0} (MemberID, Attempts, AttemptType, Created,  IsAttemptValid)
                                          SELECT @MemberID, @Attempts, @AttemptType, @CreatedNow, @IsAttemptValid FROM DUAL
                                                WHERE NOT EXISTS(SELECT * FROM {0} WHERE MemberID = @MemberID AND AttemptType = @AttemptType AND Year(Created) = Year(@Created) AND Month(Created) = Month(@Created) AND Day(Created) = Day(@Created) AND IsAttemptValid = 1) LIMIT 1;

                                UPDATE {0} SET
                                       Attempts = @Attempts,
                                       Modified = @Modified
                                WHERE AttemptID = @AttemptID AND AttemptType = @AttemptType;
                              ", Table));

                            break;
                        }
                }

                sp.AddParameter("AttemptID", MemberID, System.Data.ParameterDirection.Output);
                sp.AddParameter("Modified", DateTime.UtcNow);
            }

            sp.AddParameter("MemberID", MemberID);
            sp.AddParameter("AttemptType", AttemptType);
            sp.AddParameter("Attempts", Attempts);
            sp.AddParameter("CreatedNow", DateTime.UtcNow);
            sp.AddParameter("Created", Created != DateTime.MinValue ? Created : DateTime.UtcNow);
            sp.AddParameter("IsAttemptValid", IsAttemptValid);

            if (sp.ExecuteNonQuery() == 0)
                this.WasSaved = true;

            if (this.AttemptID <= 0)
            {

                switch (DbRoleAdmin.CurrentProvider)
                {
                    case DatabaseProvider.MSSQLServer:
                        {
                            AttemptID = (long)sp.GetParameter("AttemptID");
                            break;
                        }
                    case DatabaseProvider.MySQLServer:
                        {
                            MySqlCommand cm = (MySqlCommand)sp.SqlCommand;

                            if (cm.LastInsertedId > 0)
                                AttemptID = Convert.ToInt64(cm.LastInsertedId);

                            break;
                        }
                }

            }

            return this.WasSaved;
        }