public Youbike(ILogger <Youbike> logger, IConfiguration configuration, IHttpClientHelpers httpClientHelpers, IDBHelpers dBHelpers) { this._dBHelpers = dBHelpers; this._httpClientHelpers = httpClientHelpers; _logger = logger; _configuration = configuration; YoubikeRequestUrl = _configuration.GetValue <string>("RequestAPIUrl:YoubikeAPI"); }
private static void CreateTables(IDBHelpers dbHelpers) { CheckAndCreateTable(dbHelpers, "RecentBattles", DatabaseScripts.CreateRecentBattlesTable); CheckAndCreateTable(dbHelpers, "RecentBattles_Session", DatabaseScripts.CreateRecentBattlesSessionTable); CheckAndCreateTable(dbHelpers, "Files", DatabaseScripts.CreateFilesTable); CheckAndCreateTable(dbHelpers, "File_TankDetails", DatabaseScripts.CreateFile_TankDetailsTable); CheckAndCreateTable(dbHelpers, "File_Total", DatabaseScripts.CreateFile_TotalTable); CheckAndCreateTable(dbHelpers, "File_FragList", DatabaseScripts.CreateFile_FragListTable); CheckAndCreateTable(dbHelpers, "File_Company", DatabaseScripts.CreateFile_CompanyTable); CheckAndCreateTable(dbHelpers, "File_Clan", DatabaseScripts.CreateFile_ClanTable); CheckAndCreateTable(dbHelpers, "File_Historical", DatabaseScripts.CreateFile_HistoricalTable); CheckAndCreateTable(dbHelpers, "File_Battles", DatabaseScripts.CreateFile_BattlesTable); CheckAndCreateTable(dbHelpers, "File_Achievements", DatabaseScripts.CreateFile_AchievementsTable); CheckAndCreateTable(dbHelpers, "Overall", DatabaseScripts.CreateFile_OverallTable); CheckAndCreateTable(dbHelpers, "Cache_LastGame", DatabaseScripts.CreateCache_LastGame); }
private static void CheckAndCreateTable(IDBHelpers dbHelpers, string tableName, string tableScript) { try { string sql = String.Format(@"SELECT name FROM sqlite_master WHERE type='table' AND name='{0}';", tableName); using (DataTable tableCheck = dbHelpers.GetDataTable(sql)) { if (tableCheck.Rows.Count <= 0) { dbHelpers.ExecuteNonQuery(tableScript); } } } catch (Exception) { throw; } }
public YoubikeController(ILogger <YoubikeController> logger, IYoubike youbike, IDBHelpers dBHelpers) { this._dBHelpers = dBHelpers; _logger = logger; _youbike = youbike; }
public static void CheckAndCreateColumn(string sTable, string sColumn, string sColumnDef, IDBHelpers dbHelpers, DataTable dt) { var columnCheck = (from x in dt.AsEnumerable() where x.Field <string>("name") == sColumn select x).DefaultIfEmpty(null).FirstOrDefault(); if (columnCheck == null) { string SQL = "Alter table " + sTable + " Add " + sColumn + " " + sColumnDef; Console.WriteLine(SQL); dbHelpers.ExecuteNonQuery(SQL); } }
public static void CheckAndCreateColumn(string sTable, string sColumn, string sColumnDef, IDBHelpers dbHelpers, DataTable dt) { var columnCheck = (from x in dt.AsEnumerable() where x.Field<string>("name") == sColumn select x).DefaultIfEmpty(null).FirstOrDefault(); if (columnCheck == null) { string SQL = "Alter table " + sTable + " Add " + sColumn + " " + sColumnDef; Console.WriteLine(SQL); dbHelpers.ExecuteNonQuery(SQL); } }