public ClassName ExecuteClassQuery <ClassName>(string storedProcedureName, ObjectFromParameterizedDataRowHandler <ClassName> generateMethod, object[] filterParameters, Dictionary <string, object> parameters)
{
if (parameters == null)
{
parameters = new Dictionary <string, object>();
}
DataTable table = ExecuteDataTable(storedProcedureName, parameters);
DoPostCommandProcessing();
if (table.Rows.Count > 0)
{
return(generateMethod(table.Rows[0], filterParameters));
}
return(default(ClassName));
}
public PagedList <ClassName> ExecutePagedClassListQuery <ClassName>(string storedProcedureName, ObjectFromParameterizedDataRowHandler <ClassName> generateMethod, int?startIndex, int?endIndex, object[] filterParameters, Dictionary <string, object> parameters)
{
if (parameters == null)
{
parameters = new Dictionary <string, object>();
}
SqlParameter virtualCountParameter = new SqlParameter("@VirtualCount", SqlDbType.Int)
{
Direction = ParameterDirection.Output
};
SqlParameter startIndexParameter = new SqlParameter("@StartIndex", startIndex == null ? DBNull.Value : (object)startIndex.Value);
SqlParameter endIndexParameter = new SqlParameter("@EndIndex", endIndex == null ? DBNull.Value : (object)endIndex.Value);
SqlParameterCollection outputParameters;
DataTable table = ExecuteDataTable(storedProcedureName, parameters, new[] { startIndexParameter, endIndexParameter, virtualCountParameter }, out outputParameters);
PagedList <ClassName> result = new PagedList <ClassName> {
VirtualCount = Convert.ToInt32(outputParameters["@VirtualCount"])
};
foreach (DataRow row in table.Rows)
{
result.Add(generateMethod(row, filterParameters));
}
DoPostCommandProcessing();
return(result);
}
public PagedList <ClassName> ExecutePagedClassListQuery <ClassName>(string storedProcedureName, ObjectFromParameterizedDataRowHandler <ClassName> generateMethod, int?startIndex, int?endIndex, object[] filterParameters, params object[] parameters)
{
return(ExecutePagedClassListQuery(storedProcedureName, generateMethod, startIndex, endIndex, filterParameters, GetParametersFromObjectArray(parameters)));
}
public List <ClassName> ExecuteClassListQuery <ClassName>(string storedProcedureName, ObjectFromParameterizedDataRowHandler <ClassName> generateMethod, object[] filterParameters, Dictionary <string, object> parameters)
{
if (parameters == null)
{
parameters = new Dictionary <string, object>();
}
DataTable table = ExecuteDataTable(storedProcedureName, parameters);
List <ClassName> result = new List <ClassName>();
foreach (DataRow row in table.Rows)
{
result.Add(generateMethod(row, filterParameters));
}
DoPostCommandProcessing();
return(result);
}
public List <ClassName> ExecuteClassListQuery <ClassName>(string storedProcedureName, ObjectFromParameterizedDataRowHandler <ClassName> generateMethod, object[] filterParameters, params object[] parameters)
{
return(ExecuteClassListQuery(storedProcedureName, generateMethod, filterParameters, GetParametersFromObjectArray(parameters)));
}
public ClassName ExecuteClassQuery <ClassName>(string storedProcedureName, ObjectFromParameterizedDataRowHandler <ClassName> generateMethod, object[] filterParameters)
{
return(ExecuteClassQuery(storedProcedureName, generateMethod, filterParameters, (object[])null));
}
