/// <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() })); }