/// <summary>
/// inserts a game and returns it's id
/// </summary>
public static int AddGame(string gameName, string host, int activity)
{
return(DalHelper.Insert(DalHelper.SimpleInsertQuery(Constants.GAMESTBL, new string[] { GAMENAMEFLD, HOSTFLD, ACTIVITYFLD }, new string[] { $"'{gameName}'", $"'{host}'", activity.ToString() })));
}
/// <summary>
/// inserts a new season and returns it's ID
/// </summary>
public static int CreateNewSeason(DateTime startDate, DateTime endDate)
{
return(DalHelper.Insert(DalHelper.SimpleInsertQuery(Constants.SEASONSTBL, new string[] { STARTDATE, ENDDATE }, new string[] { startDate.ToOADate().ToString(), endDate.ToOADate().ToString() })));
}
/// <summary>
/// inserts a record of user start elo in seasons to rankingHistory table
/// </summary>
public static void InsertRankHistory(string username, int season, int elo)
{
DalHelper.Insert(DalHelper.SimpleInsertQuery(Constants.RANKINGHISTORYTBL, new string[] { USERFLD, SEASONFLD, ELOFLD }, new string[] { $"'{username}'", season.ToString(), elo.ToString() }));
}
