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));
}
/// <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));
}
/// <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));
}
/// <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));
}