public void LoadTables()
{
try
{
using (var sql = new NFLIntDevEntities())
{
var pRanking = sql.PlayerRankings.Single(s => s.SID == ID);
int type = (int)pRanking.Type;
if (type == 0)
{
CurrentSession.ListData = JsonConvert.DeserializeObject <List <NomineePods> >(pRanking.Data).Where(n => !String.IsNullOrEmpty(n.Tricode)).ToList();
CurrentSession.OverallData = null;
}
else
{
CurrentSession.OverallData = JsonConvert.DeserializeObject <List <MockDraft> >(pRanking.Data)
.Where(n => n.ListData != null)
.ToList();
CurrentSession.ListData = null;
}
var playerWindow = new PlayerEditWindow();
playerWindow.Show();
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
public List <Segments> LoadSegments()
{
var segments = new List <Segments>();
try
{
using (var sql = new NFLIntDevEntities())
{
var segs = sql.Segments.Where(i => i.UID == CurrentSession.User.ID && i.Type == (decimal)SegmentType.PlayerRanking);
segments.AddRange(segs.Select(segment => new Segments
{
ID = segment.ID,
Name = segment.Name,
Title = segment.Title
}));
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
return(segments);
}
public List <string> LoadUsers()
{
var users = new List <string>();
try
{
using (var sql = new NFLIntDevEntities())
{
var tempUsers = sql.UserProfiles;
users.AddRange(tempUsers.Select(user => user.UserName));
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
return(users);
}
// TODO: Add methods that will be called by the view
public void SelectUser()
{
if (String.IsNullOrEmpty(SelectedUser))
{
IsActive = false;
return;
}
IsActive = true;
try
{
using (var sql = new NFLIntDevEntities())
{
CurrentSession.User.ID = sql.UserProfiles.Single(u => u.UserName.Equals(SelectedUser)).UserId;
CurrentSession.User.Name = SelectedUser;
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
