Example #1
0
        /// <summary>
        /// Column name of which condition will be specified
        /// </summary>
        /// <param name="column">Name of column</param>
        /// <returns>Clause instance object</returns>
        public IDeleteClause Where(String column)
        {
            where = new DeleteClauseImpl(this);
            where.AddCol(column);

            return(where);
        }
Example #2
0
        /// <summary>
        /// Used to specify HAVING clause to SQL because the WHERE keyword could not be used with aggregate functions
        /// </summary>
        /// <param name="column">Name of column on which condition need to be applied</param>
        /// <returns>Clause instance object</returns>
        public IDeleteClause Having(String column)
        {
            having = new DeleteClauseImpl(this);
            having.AddCol(column);

            return(having);
        }
Example #3
0
        /// <summary>
        /// Used to delete, this method should be called in last to delete tuples from table.
        /// </summary>
        public void Execute()
        {
            String where = "";
            if (this.whereClause != null && this.whereClause.Length > 0)
            {
                where = this.whereClause;
            }
            else
            {
                if (this.where != null)
                {
                    where = this.where.ToString();
                }
            }

            String having = "";

            if (this.havingClause != null && this.havingClause.Length > 0)
            {
                having = this.havingClause;
            }
            else
            {
                if (this.having != null)
                {
                    having = this.having.ToString();
                }
            }

            if (this.columns == null)
            {
                this.columns = new String[] { };
            }

            if (this.orderBy == null)
            {
                this.orderBy = new String[] { };
            }

            if (this.groupBy == null)
            {
                this.groupBy = new String[] { };
            }

            String limit = null;

            if (this.limit != 0)
            {
                limit = this.limit.ToString();
            }


            DatabaseHelper.Delete(referObject, where);
        }
Example #4
0
        /// <summary>
        /// Column name of which condition will be specified
        /// </summary>
        /// <param name="column">Name of column</param>
        /// <returns>Clause instance object</returns>
        public IDeleteClause Where(String column)
        {
            where = new DeleteClauseImpl(this);
            where.AddCol(column);

            return where;
        }
Example #5
0
        /// <summary>
        /// Used to specify HAVING clause to SQL because the WHERE keyword could not be used with aggregate functions
        /// </summary>
        /// <param name="column">Name of column on which condition need to be applied</param>
        /// <returns>Clause instance object</returns>
        public IDeleteClause Having(String column)
        {
            having = new DeleteClauseImpl(this);
            having.AddCol(column);

            return having;
        }
Example #6
0
        public void Execute()
        {
            String where = "";
            if (this.whereClause != null && this.whereClause.Length > 0)
            {
                where = this.whereClause;
            }
            else
            {
                if (this.where != null)
                {
                    where = this.where.ToString();
                }
            }

            String having = "";
            if (this.havingClause != null && this.havingClause.Length > 0)
            {
                having = this.havingClause;
            }
            else
            {
                if (this.having != null)
                {
                    having = this.having.ToString();
                }
            }

            if (this.columns == null)
            {
                this.columns = new String[] { };
            }

            if (this.orderBy == null)
            {
                this.orderBy = new String[] { };
            }

            if (this.groupBy == null)
            {
                this.groupBy = new String[] { };
            }

            String limit = null;
            if (this.limit != 0)
            {
                limit = this.limit.ToString();
            }

            DatabaseHelper.Delete(referObject, where);
        }