public ActionResult List(int?page)
{
ResultListViewModel model = new ResultListViewModel();
model.Filter.CurrentPage = page ?? 1;
using (var module = new ResultModule())
{
model.Result = module.DoGetList(model.Filter);
model.Result.Data = model.Result.Data.Where(o => o.DISABLE == false).ToList();
}
return(View(model));
}
public ActionResult ResultList(int?page, string qry, string sort, string disHome, string disable, string pDate)
{
ResultListViewModel model = new ResultListViewModel();
model.Filter.CurrentPage = page ?? 1;
model.Filter.QueryString = qry ?? string.Empty;
model.Filter.SortColumn = sort ?? string.Empty;
model.Filter.Disable = disable ?? string.Empty;
model.Filter.DisplayForHomePage = disHome ?? string.Empty;
model.Filter.PublishDate = pDate ?? string.Empty;
using (var module = new ResultModule())
{
model.Result = module.DoGetList(model.Filter);
}
return(View(model));
}
private List <ResultListViewModel> GetResultsFromCmd(OleDbCommand cmd)
{
List <ResultListViewModel> results = new List <ResultListViewModel>();
using (OleDbDataReader dbReader = cmd.ExecuteReader())
{
int _playerName = dbReader.GetOrdinal("list_name");
int _playerNumber = dbReader.GetOrdinal("player_nr");
int _setsPlayed = dbReader.GetOrdinal("sets_played");
int _setsWon = dbReader.GetOrdinal("sets_won");
int _percentage = dbReader.GetOrdinal("percentage");
int _rating = dbReader.GetOrdinal("rating");
int _baseRating = dbReader.GetOrdinal("base_rating");
int _teamId = dbReader.GetOrdinal("team_id");
int _clubId = dbReader.GetOrdinal("club_id");
int _clubName = dbReader.GetOrdinal("club_name");
int _teamNumber = dbReader.GetOrdinal("team_number");
int _seasonId = dbReader.GetOrdinal("season_id");
int _seasonYear = dbReader.GetOrdinal("season_year");
int _seasonPeriod = dbReader.GetOrdinal("season_period");
int _pouleId = dbReader.GetOrdinal("poule_id");
int _className = dbReader.GetOrdinal("class_name");
int _classLevel = dbReader.GetOrdinal("class_level");
int _pouleName = dbReader.GetOrdinal("poule_name");
int _pouleCategory = dbReader.GetOrdinal("poule_category");
int _regionName = dbReader.GetOrdinal("region_name");
int _regionId = dbReader.GetOrdinal("region_id");
while (dbReader.Read())
{
var result = new ResultListViewModel();
result.playerName = dbReader.GetString(_playerName);
result.playerNr = dbReader.GetString(_playerNumber);
result.setsPlayed = dbReader.GetInt32(_setsPlayed);
result.setsWon = dbReader.GetInt32(_setsWon);
result.percentage = dbReader.GetInt32(_percentage);
result.sortPercentage = 0;
if (_setsPlayed > 0)
{
result.sortPercentage = (double)result.setsWon / (double)result.setsPlayed;
}
result.rating = dbReader.GetInt32(_rating);
result.baseRating = dbReader.GetInt32(_baseRating);
result.clubId = dbReader.GetInt32(_clubId);
result.clubName = dbReader.GetString(_clubName);
result.teamId = dbReader.GetInt32(_teamId);
result.teamNumber = dbReader.GetInt32(_teamNumber);
result.seasonId = dbReader.GetInt32(_seasonId);
result.seasonYear = dbReader.GetInt32(_seasonYear);
result.seasonPeriod = dbReader.GetInt32(_seasonPeriod);
result.pouleId = dbReader.GetInt32(_pouleId);
result.pouleName = dbReader.GetString(_pouleName);
result.pouleCategory = dbReader.GetInt32(_pouleCategory);
result.className = dbReader.GetString(_className);
result.classLevel = dbReader.GetInt32(_classLevel);
result.regionId = dbReader.GetInt32(_regionId);
result.regionName = dbReader.GetString(_regionName);
result.license = LicenseService.GetLicense(result.rating, result.regionName, result.pouleCategory);
results.Add(result);
}
}
return(results);
}
