public IList GetListByTableName(TableList tableName)
{
Database database = (new DbFactory()).CreateDatabase();
IDataProvider <SimpleTable> resultTableProvider =
new DataProviderWithSynchronouseAccessor <SimpleTable>();
resultTableProvider.StoredProcedureName =
(new Resources().CreateSelectSPList())[tableName].ToString();
IRowMapper <SimpleTable> mapper = MapBuilder <SimpleTable> .MapAllProperties()
.MapByName(x => x.Name)
.Build();
return(resultTableProvider.GetDataFromStoredProcedureAccessor(database, null, mapper).ToList());
}
public IList GetListByTableName(TableList tableName)
{
IList nameList = null;
Database database = (new DbFactory()).CreateDatabase();
IDataProvider <ResultTable> resultTableProvider;
IDataProvider <SimpleTable> simpleTableProvider;
string parameter = "Name";
switch (tableName)
{
case TableList.Title:
{
parameter = "TrackTitle";
} break;
case TableList.FileName:
{
parameter = "FileName";
} break;
}
if ((tableName == TableList.Title) || (tableName == TableList.FileName))
{
resultTableProvider =
new DataProviderWithSynchronouseAccessor <ResultTable>();
resultTableProvider.SqlQueryString = (new Resources().CreateQueryStringList())[tableName].ToString();
nameList = resultTableProvider.GetDataFromSqlQueryStringAccessor(database).ToList();
}
else
{
simpleTableProvider =
new DataProviderWithSynchronouseAccessor <SimpleTable>();
simpleTableProvider.SqlQueryString = (new Resources().CreateQueryStringList())[tableName].ToString();
nameList = simpleTableProvider.GetDataFromSqlQueryStringAccessor(database).ToList();
}
return(nameList);
}
public object GetCustomizedViewByTableName(
int pageSize,
int pageIndex,
string albumFilter,
string artistFilter,
string genreFilter,
string fileNameFilter)
{
Database database = (new DbFactory()).CreateDatabase();
IDataProvider <ResultTable> resultTableProvider =
new DataProviderWithSynchronouseAccessor <ResultTable>();
resultTableProvider.StoredProcedureName =
(new Resources().CreateSelectSPList())[TableList.Track].ToString();
// - stored procedure parameter order is very important thing
object[] myParameterList =
new object[]
{ new ParameterItem()
{
ParameterName = "@Album",
ParameterValue = albumFilter
},
new ParameterItem()
{
ParameterName = "@Artist",
ParameterValue = artistFilter
},
new ParameterItem()
{
ParameterName = "@Genre",
ParameterValue = genreFilter
},
new ParameterItem()
{
ParameterName = "@FileName",
ParameterValue = fileNameFilter
},
new ParameterItem()
{
ParameterName = "@PageSize",
ParameterValue = pageSize
},
new ParameterItem()
{
ParameterName = "@PageIndex",
ParameterValue = pageIndex
} };
resultTableProvider.DbParameterValues = myParameterList;
IRowMapper <ResultTable> mapper = MapBuilder <ResultTable> .MapAllProperties()
.MapByName(x => x.AlbumName)
.MapByName(x => x.ArtistName)
.MapByName(x => x.Bitrate)
.MapByName(x => x.FileName)
.MapByName(x => x.FileSize)
.MapByName(x => x.GenreName)
.MapByName(x => x.NewName)
.MapByName(x => x.FullPath)
.MapByName(x => x.TrackTitle)
.Build();
resultList = resultTableProvider.GetDataFromStoredProcedureAccessor(database, myParameterList, mapper).ToList();
return(resultList);
}
public object GetCustomizedViewByTableName(
int pageSize,
int pageIndex,
string albumFilter,
string artistFilter,
string genreFilter,
string fileNameFilter)
{
Database database = (new DbFactory()).CreateDatabase();
IDataProvider<ResultTable> resultTableProvider =
new DataProviderWithSynchronouseAccessor<ResultTable>();
resultTableProvider.StoredProcedureName =
(new Resources().CreateSelectSPList())[TableList.Track].ToString();
// - stored procedure parameter order is very important thing
object[] myParameterList =
new object[]
{ new ParameterItem()
{
ParameterName = "@Album",
ParameterValue = albumFilter
} ,
new ParameterItem()
{
ParameterName = "@Artist",
ParameterValue = artistFilter
} ,
new ParameterItem()
{
ParameterName = "@Genre",
ParameterValue = genreFilter
} ,
new ParameterItem()
{
ParameterName = "@FileName",
ParameterValue = fileNameFilter
},
new ParameterItem()
{
ParameterName = "@PageSize",
ParameterValue = pageSize
} ,
new ParameterItem()
{
ParameterName = "@PageIndex",
ParameterValue = pageIndex
}
};
resultTableProvider.DbParameterValues = myParameterList;
IRowMapper<ResultTable> mapper = MapBuilder<ResultTable>.MapAllProperties()
.MapByName(x => x.AlbumName)
.MapByName(x => x.ArtistName)
.MapByName(x => x.Bitrate)
.MapByName(x => x.FileName)
.MapByName(x => x.FileSize)
.MapByName(x => x.GenreName)
.MapByName(x => x.NewName)
.MapByName(x => x.FullPath)
.MapByName(x => x.TrackTitle)
.Build();
resultList = resultTableProvider.GetDataFromStoredProcedureAccessor(database, myParameterList, mapper).ToList();
return resultList;
}
public IList GetListByTableName(TableList tableName)
{
Database database = (new DbFactory()).CreateDatabase();
IDataProvider<SimpleTable> resultTableProvider =
new DataProviderWithSynchronouseAccessor<SimpleTable>();
resultTableProvider.StoredProcedureName =
(new Resources().CreateSelectSPList())[tableName].ToString();
IRowMapper<SimpleTable> mapper = MapBuilder<SimpleTable>.MapAllProperties()
.MapByName(x => x.Name)
.Build();
return resultTableProvider.GetDataFromStoredProcedureAccessor(database, null, mapper).ToList();
}
