public MainForm()
{
InitializeComponent();
string dbPath = RegistrySettings.GetLatestOpenedDatabase();
currentSortType = RegistrySettings.GetSortType();
UpdateSortTypeButtons();
currentRateType = RegistrySettings.GetGameType();
UpdateRateTypeButtons();
showInactivePlayers = RegistrySettings.GetShowInactivePlayersOption();
UpdateShowInactivePlayersMenuItem();
playersListRight.Dock = DockStyle.Fill;
playersListRight.OnItemDoubleClick += new PlayersList.MouseDoubleClickEvent(this.OnPlayerDoubleClick);
playersListRight.OnItemMouseRightClick += new PlayersList.MouseRightClickEvent(this.OnPlayerMouseRightClick);
playersListRight.OnColumnHeaderClick += new PlayersList.ColumnHeadertClickEvent(this.OnSortTypeChange);
playersListLeft.Dock = DockStyle.Fill;
playersListLeft.OnItemDoubleClick += new PlayersList.MouseDoubleClickEvent(this.OnPlayerDoubleClick);
playersListLeft.OnItemMouseRightClick += new PlayersList.MouseRightClickEvent(this.OnPlayerMouseRightClick);
playersListLeft.OnColumnHeaderClick += new PlayersList.ColumnHeadertClickEvent(this.OnSortTypeChange);
this.splitContainer.Panel1.Controls.Add(playersListLeft);
this.splitContainer.Panel2.Controls.Add(playersListRight);
printPageSettings = RegistrySettings.GetPageSettings();
if(dbPath != null && dbPath.Length != 0)
{
InitListView(dbPath);
}
}
public ActionResult Index(PlayerSortType? sortType, int? page)
{
var urlHelper = new UrlHelper(new RequestContext(HttpContext, RouteData), RouteTable.Routes );
var url = urlHelper.Action("Index", "Players", new RouteValueDictionary {{"sortType", sortType}, {"page", page}},
"http", "wikipediamaze.com");
return new PermanentRedirectResult(url);
}
public IEnumerable<User> GetAllUsers(PlayerSortType playerSortType)
{
using (_repository.OpenSession())
{
switch (playerSortType)
{
case PlayerSortType.Reputation:
return _repository.All<User>().OrderByDescending(x => x.Reputation).ToList();
case PlayerSortType.Newest:
return _repository.All<User>().OrderByDescending(x => x.DateCreated).ToList();
case PlayerSortType.Oldest:
return _repository.All<User>().OrderBy(x => x.DateCreated).ToList();
case PlayerSortType.Name:
return _repository.All<User>().OrderBy(x => x.DisplayName).ToList();
default:
return _repository.All<User>().OrderByDescending(x => x.Reputation).ToList();
}
}
}
public IPagination<User> GetUsers(int page, int pageSize, PlayerSortType playerSortType)
{
IList<User> users;
int totalUsers;
using (_repository.OpenSession())
{
totalUsers = _repository.All<User>().Count();
switch (playerSortType)
{
case PlayerSortType.Reputation:
users = _repository.All<User>().OrderByDescending(x => x.Reputation).Skip((page - 1) * pageSize).Take(pageSize).ToList();
break;
case PlayerSortType.Newest:
users = _repository.All<User>().OrderByDescending(x => x.DateCreated).Skip((page - 1) * pageSize).Take(pageSize).ToList();
break;
case PlayerSortType.Oldest:
users = _repository.All<User>().OrderBy(x => x.DateCreated).Skip((page - 1) * pageSize).Take(pageSize).ToList();
break;
case PlayerSortType.Name:
users = _repository.All<User>().OrderBy(x => x.DisplayName).Skip((page - 1) * pageSize).Take(pageSize).ToList();
break;
default:
users = _repository.All<User>().OrderByDescending(x => x.Reputation).Skip((page - 1) * pageSize).Take(pageSize).ToList();
break;
}
}
return users.AsCustomPagination(page, pageSize, totalUsers);
}
private int GetColumnIndexBySortType(PlayerSortType type)
{
int index = -1;
ColumnHeader ch = null;
switch (type)
{
case PlayerSortType.ByRate:
ch = this.rateColumnHeader;
break;
case PlayerSortType.ByName:
ch = this.lastNameColumnHeader;
break;
}
if (ch != null)
{
index = ch.Index;
}
return index;
}
public void HiglightSortedColumn(PlayerSortType type)
{
int index = GetColumnIndexBySortType(type);
if (index >= 0)
{
foreach (ListViewItem item in listPlayersView.Items)
{
item.SubItems[index].BackColor = System.Drawing.SystemColors.ControlLight;
}
}
}
public static void SetSortType(PlayerSortType type)
{
try
{
if (rkOptions != null)
{
rkOptions.SetValue(sortTypeKeyName, type.ToString());
}
}
catch
{
}
}
private SQLiteCommand GetSelectCmd(PlayerSortType st, GameType gt)
{
switch (st)
{
case PlayerSortType.ByRate:
switch (gt)
{
case GameType.Blitz:
return selectAllCmdSortBlitz;
case GameType.Rapid:
return selectAllCmdSortRapid;
case GameType.Classic:
return selectAllCmdSortClassic;
}
return selectAllCmdSortBlitz;
case PlayerSortType.ByName:
return selectAllCmdSortName;
}
return selectAllCmd;
}
public List<Player> LoadAllPlayers(PlayerSortType st, GameType gt)
{
SQLiteCommand selectCmd = GetSelectCmd(st, gt);
List<Player> players = new List<Player>();
SQLiteDataReader dataReader = selectCmd.ExecuteReader();
while (dataReader.Read())
{
Player p = new Player(dataReader.GetInt64(7))
{
Name = dataReader.GetString(0),
BlitzRate = dataReader.GetInt32(1),
RapidRate = dataReader.GetInt32(2),
ClassicRate = dataReader.GetInt32(3),
BlitzLastUpdate = dataReader.GetDateTime(4),
RapidLastUpdate = dataReader.GetDateTime(5),
ClassicLastUpdate = dataReader.GetDateTime(6),
};
players.Add(p);
}
dataReader.Close();
return players;
}
public UserProfileListViewModel(IPagination<UserInfoViewModel> users, PlayerSortType sortType)
{
Users = users;
SortType = sortType;
}
public ActionResult Index(HeaderInfoController headerInfoController, PlayerSortType? sortType, int? page)
{
sortType = sortType ?? PlayerSortType.Reputation;
page = page ?? 1;
var users = _accountService.GetUsers(page.Value, 28, sortType.Value);
var userVms = users.Select(x => new UserInfoViewModel(x)).AsCustomPagination(users.PageNumber, users.PageSize, users.TotalItems);
return View(new UserProfileListViewModel(userVms, sortType.Value));
}
private void SetCurrentSortType(PlayerSortType type)
{
if(currentSortType == type)
{
return;
}
currentSortType = type;
UpdateSortTypeButtons();
switch (currentSortType)
{
case PlayerSortType.ByRate:
switch (currentRateType)
{
case GameType.Blitz:
allPlayers.Sort(ComparePlayersByBlitzRate);
break;
case GameType.Rapid:
allPlayers.Sort(ComparePlayersByRapidRate);
break;
case GameType.Classic:
allPlayers.Sort(ComparePlayersByClassicRate);
break;
}
break;
case PlayerSortType.ByName:
allPlayers.Sort(ComparePlayersByName);
break;
}
ReloadListView();
}
private void OnSortTypeChange(PlayerSortType st)
{
if(st != PlayerSortType.Undefined)
{
SetCurrentSortType(st);
}
}
