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