Exemple #1
0
        public virtual IList <TEntity> ExecuteProcedureWithPerameterwithoutPagination <TEntity>(string procedureName, System.Collections.ObjectModel.Collection <DBParameters> parameters, string productUid = null)
        {
            AppConfiguration appSettings = new AppConfiguration(productUid);

            return(DBClient.ExecuteProcedure <TEntity>(procedureName, parameters, appSettings.GetConnectionString));
        }
Exemple #2
0
        /// <summary>
        /// Execute Procedure for custom methods without pagination
        /// </summary>
        /// <param name="procedureName"></param>
        /// <returns>returns data table</returns>
        public virtual DataTable ExecuteProcedurewithoutPaginationDatatable(string procedureName, System.Collections.ObjectModel.Collection <DBParameters> parameter, string productUid = null)
        {
            AppConfiguration appSettings = new AppConfiguration(productUid);

            return(DBClient.ExecuteProcedureDatatable(procedureName, parameter, appSettings.GetConnectionString));
        }
Exemple #3
0
        /// <summary>
        /// Executes the procedurewith out parameter.
        /// </summary>
        /// <param name="procedureName">Name of the procedure.</param>
        /// <param name="executeType">Type of the execute.</param>
        /// <param name="parameters">The parameters.</param>
        /// <param name="dic">The dic.</param>
        /// <returns></returns>
        public virtual object ExecuteProcedurewithOutParameter(string procedureName, ExecuteType executeType, System.Collections.ObjectModel.Collection <DBParameters> parameters, out Dictionary <string, string> dic, string productUid = null)
        {
            AppConfiguration appSettings = new AppConfiguration(productUid);

            return(DBClient.ExecuteProcedurewithOutParameter(procedureName, executeType, parameters, appSettings.GetConnectionString, out dic));
        }
Exemple #4
0
        /// <summary>
        /// Execute Procedure for custom methods without pagination
        /// </summary>
        /// <typeparam name="TEntity">Entity Type which require to be return as list</typeparam>
        /// <param name="procedureName">procedure name</param>
        /// <returns>return procedure output</returns>
        public virtual IList <TEntity> ExecuteProcedurewithoutPagination <TEntity>(string procedureName, string productUid = null)
        {
            AppConfiguration appSettings = new AppConfiguration(productUid);

            return(DBClient.ExecuteProcedure <TEntity>(procedureName, null, appSettings.GetConnectionString));
        }