public static void Save(string firstName, string lastName, int tourId)
{
//TODO: need to handle spelling updates by passing in ID #
using (var db = new FantasyGolfContext())
{
var query = from x in db.Golfer
where x.FirstName == firstName && x.LastName == lastName && x.TourId == tourId
select x;
var golfer = query.FirstOrDefault();
if (golfer == null)
{
golfer = new Golfer();
db.Golfer.Add(golfer);
}
else
{
db.Entry(golfer).State = System.Data.Entity.EntityState.Modified;
}
golfer.FirstName = firstName;
golfer.LastName = lastName;
golfer.TourId = tourId;
golfer.CreatedOn = DateTime.Now;
golfer.LastSyncedOn = null;
golfer.IsActive = true;
db.SaveChanges();
var cache = new CacheService();
cache.Remove("fg.golfers");
}
}
public static void SaveResult(int tournamentId, int golferId, int place, decimal winnings, bool isCut, bool isTied, bool isWithdrawn, bool isDisqualified, bool isPlayoff)
{
using (var db = new FantasyGolfContext())
{
var query = from x in db.TournamentResult
where x.TournamentId == tournamentId && x.GolferId == golferId
select x;
var result = query.FirstOrDefault();
if (result == null)
{
result = new TournamentResult();
db.TournamentResult.Add(result);
}
else
{
db.Entry(result).State = System.Data.Entity.EntityState.Modified;
}
result.TournamentId = tournamentId;
result.GolferId = golferId;
result.Place = place;
result.Winnings = winnings;
result.IsCut = isCut;
result.IsTied = isTied;
result.IsWithdrawn = isWithdrawn;
result.IsDisqualified = isDisqualified;
result.IsPlayoff = isPlayoff;
db.SaveChanges();
}
}
public static User GetByAspNetUserId(string aspNetUserId)
{
using (var db = new FantasyGolfContext())
{
var result = from x in db.User
where x.AspNetUserId == aspNetUserId && x.IsActive == true
select x;
return(result.Count <User>() == 0 ? null : result.First());
}
}
public static User Get(string email)
{
//var cache = new CacheService();
//return cache.Get("fg.user-" + email, 60, () =>
//{
using (var db = new FantasyGolfContext())
{
var result = from x in db.User
where x.Email == email && x.IsActive == true
select x;
return(result.FirstOrDefault());
}
//});
}
public static League Get(int id)
{
var cache = new CacheService();
return(cache.Get("fg.league-" + id.ToString(), 60, () =>
{
using (var db = new FantasyGolfContext())
{
var result = from x in db.League
where x.Id == id
select x;
return result.FirstOrDefault();
}
}));
}
public static Tournament Get(int id)
{
var cache = new CacheService();
return(cache.Get("fg.tournament-" + id.ToString(), 60, () =>
{
using (var db = new FantasyGolfContext())
{
var result = from x in db.Tournament
where x.Id == id && x.IsActive == true
select x;
return result.FirstOrDefault();
}
}));
}
public static UserPick Get(int userId, int tournamentId)
{
var cache = new CacheService();
return(cache.Get("fg.userpick-" + userId.ToString() + "-" + tournamentId.ToString(), 60, () =>
{
using (var db = new FantasyGolfContext())
{
var result = from x in db.UserPick
where x.UserId == userId && x.TournamentId == tournamentId
select x;
return result.FirstOrDefault();
}
}));
}
public static IList <Golfer> ListActive()
{
var cache = new CacheService();
return(cache.Get("fg.golfers", 60, () =>
{
using (var db = new FantasyGolfContext())
{
var result = from x in db.Golfer
where x.IsActive == true
orderby x.LastName, x.FirstName
select x;
return result.ToList();
}
}));
}
public static IList <Tournament> List(int leagueId)
{
var cache = new CacheService();
return(cache.Get("fg.tournaments-" + leagueId.ToString(), 60, () =>
{
using (var db = new FantasyGolfContext())
{
var result = from lt in db.LeagueTournament
where lt.LeagueId == leagueId && lt.IsActive == true
orderby lt.Tournament.BeginsOn
select lt.Tournament;
return result.ToList();
}
}));
}
public static IList <UserPick> List(int userId)
{
var cache = new CacheService();
return(cache.Get("fg.userpicks-" + userId.ToString(), 60, () =>
{
using (var db = new FantasyGolfContext())
{
var result = from x in db.UserPick
where x.UserId == userId
orderby x.Tournament.BeginsOn
select x;
return result.ToList();
}
}));
}
public static IList <User> List(int leagueId)
{
var cache = new CacheService();
return(cache.Get("fg.users-" + leagueId.ToString(), 60, () =>
{
using (var db = new FantasyGolfContext())
{
var result = from lu in db.LeagueUser
where lu.LeagueId == leagueId && lu.IsActive == true
orderby lu.User.LastName, lu.User.FirstName
select lu.User;
return result.ToList();
}
}));
}
public static League SaveResult(int id, string name, int tourId, int season)
{
League result = null;
using (var db = new FantasyGolfContext())
{
if (id > 0)
{
var query = from x in db.League
where x.Id == id
select x;
var temp = query.FirstOrDefault();
if (temp == null)
{
result = new League();
db.League.Add(result);
}
else
{
result = temp;
db.Entry(result).State = System.Data.Entity.EntityState.Modified;
}
}
else
{
result = new League();
db.League.Add(result);
}
result.Name = name;
result.TourId = tourId;
result.Season = season;
result.ManagerId = 1;
result.PlayoffFormatId = 1;
result.RegularSeasonFormatId = 1;
result.BeginsOn = null;
result.EndsOn = null;
result.IsActive = true;
result.CreatedOn = DateTime.Now;
db.SaveChanges();
}
return(result);
}
public static IList <League> GetActiveLeagues()
{
var cache = new CacheService();
return(cache.Get("fg.leagues", 60, () =>
{
using (var db = new FantasyGolfContext())
{
var result = from x in db.League
where x.IsActive == true
orderby x.Season descending
select x;
return result.ToList();
}
}));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (base.IsLeagueSelected)
{
using (var db = new FantasyGolfContext())
{
var tournaments = TournamentService.List(this.CurrentLeagueId);
tournament_list.DataSource = tournaments;
tournament_list.DataBind();
tournament_list.Items.Insert(0, "");
tournament_list.SelectedIndex = 0;
}
}
message_label_panel.Visible = false;
}
}
public static IList <TournamentGrouping> ListTournamentGroupings(int leagueId)
{
var cache = new CacheService();
return(cache.Get("fg.league-tournament-groupings-" + leagueId.ToString(), 60, () =>
{
using (var db = new FantasyGolfContext())
{
var result = from ltg in db.LeagueTournamentGrouping
join tg in db.TournamentGrouping on ltg.TournamentGroupingId equals tg.Id
where ltg.IsActive == true && tg.IsActive == true && tg.LeagueId == leagueId
orderby ltg.TournamentGrouping.Name
select ltg.TournamentGrouping;
return result.ToList();
}
}));
}
public static IList <Golfer> ListActive(int tournamentId)
{
var cache = new CacheService();
return(cache.Get("fg.golfers-" + tournamentId.ToString(), 60, () =>
{
using (var db = new FantasyGolfContext())
{
var result = from x in db.Golfer
join up in db.UserPick on x.Id equals up.GolferId
where x.IsActive == true && up.TournamentId == tournamentId
orderby x.LastName, x.FirstName
select x;
return result.ToList();
}
}));
}
protected void BindData()
{
var golfers = GolferService.ListActive();
golfer_grid.DataSource = golfers;
golfer_grid.DataBind();
using (var db = new FantasyGolfContext())
{
var tours = from x in db.Tour
where x.IsActive == true
orderby x.Name
select x;
tour_list.DataSource = tours.ToList();
tour_list.DataBind();
tour_list.Items.Insert(0, "");
tour_list.SelectedIndex = 0;
}
}
public static User Create(string email, string firstName, string lastName, string aspNetUserId)
{
User user = new User
{
FirstName = firstName,
LastName = lastName,
Email = email,
AspNetUserId = aspNetUserId,
IsActive = true,
CreatedOn = DateTime.Now
};
using (var db = new FantasyGolfContext())
{
db.User.Add(user);
db.SaveChanges();
}
return(user);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["id"] != null)
{
_id = Convert.ToInt32(Request.QueryString["id"]);
}
if (!Page.IsPostBack)
{
league_user_panel.Visible = (_id > 0);
league_tournament_panel.Visible = (_id > 0);
if (_id > 0)
{
League league = LeagueService.Get(_id);
name_textbox.Text = league.Name;
tour_list.SelectedValue = league.TourId.ToString();
season_textbox.Text = league.Season.ToString();
}
else
{
season_textbox.Text = DateTime.Now.Year.ToString();
}
using (var db = new FantasyGolfContext())
{
var tours = from x in db.Tour
where x.IsActive == true
orderby x.Name
select x;
tour_list.DataSource = tours.ToList();
tour_list.DataBind();
tour_list.Items.Insert(0, "");
tour_list.SelectedIndex = 0;
}
}
}
public static void Save(int userId, int tournamentId, int golferId)
{
using (var db = new FantasyGolfContext())
{
var query = from up in db.UserPick
where up.UserId == userId && up.TournamentId == tournamentId
select up;
var pick = query.FirstOrDefault();
if (pick == null)
{
pick = new UserPick();
db.UserPick.Add(pick);
}
else
{
db.Entry(pick).State = System.Data.Entity.EntityState.Modified;
}
pick.UserId = userId;
pick.TournamentId = tournamentId;
pick.GolferId = golferId;
pick.CreatedOn = DateTime.Now;
var pickChange = new UserPickChangeLog
{
UserId = userId,
TournamentId = tournamentId,
GolferId = golferId,
CreatedOn = DateTime.Now
};
db.UserPickChangeLog.Add(pickChange);
db.SaveChanges();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (base.IsLeagueSelected)
{
//load up values
//SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["default"].ConnectionString);
//connection.Open();
//var tournaments = connection.Query<Tournament>("Tournament_List", new { LeagueId = base.CurrentLeague }, commandType: CommandType.StoredProcedure);
using (var db = new FantasyGolfContext())
{
var tournaments = TournamentService.List(this.CurrentLeagueId);
tournament_list.DataSource = tournaments;
tournament_list.DataBind();
tournament_list.Items.Insert(0, "");
tournament_list.SelectedIndex = 0;
//var users = connection.Query<RonsHouse.FantasyGolf.Model.User>("LeagueUser_List", new { LeagueId = base.CurrentLeague }, commandType: CommandType.StoredProcedure);
var users = UserService.List(this.CurrentLeagueId);
user_list.DataSource = users;
user_list.DataBind();
user_list.Items.Insert(0, "");
user_list.SelectedIndex = 0;
//var golfers = connection.Query<Golfer>("select *, LastName + ', ' + FirstName as Name from Golfer order by LastName");
var golfers = GolferService.ListActive();
golfer_list.DataSource = golfers;
golfer_list.DataBind();
golfer_list.Items.Insert(0, "");
golfer_list.SelectedIndex = 0;
}
}
message_label_panel.Visible = false;
}
}
