public void LoadDeDupConfigsByType(LoadConfigType type = LoadConfigType.ALL) { try { using (ConnectionFactory connectionFactory = new ConnectionFactory(connectionString)) { switch (type) { case LoadConfigType.PLAN: addonPlans = connectionFactory.DbConnection.Query <PlanInfos>("SELECT * FROM \"dedup-settings\".\"planinfos\";").ToList(); break; case LoadConfigType.CONFIGVARS: var configvars = connectionFactory.DbConnection.Query <dynamic>("SELECT * FROM \"dedup-settings\".\"configvars\";").FirstOrDefault(); SetConfigvars(configvars); break; default: var queryResult = connectionFactory.DbConnection.QueryMultiple("SELECT * FROM \"dedup-settings\".\"configvars\";SELECT * FROM \"dedup-settings\".\"planinfos\";"); if (queryResult != null) { SetConfigvars(queryResult.Read <dynamic>().FirstOrDefault()); addonPlans = queryResult.Read <PlanInfos>().ToList(); } break; } } } catch (Exception ex) { Console.WriteLine("Error: {0}", ex.Message); throw; } }
public async Task <JsonResult> RefreshConfigsByType(LoadConfigType type = LoadConfigType.ALL) { try { Console.WriteLine("RefreshConfigsByType starts"); await ConfigVars.Instance.LoadDeDupConfigsByTypeAsync(type); Console.WriteLine("RefreshConfigsByType ended"); return(Json(new { message = $"{type.ToString()} has been refreshed" })); } catch (Exception ex) { Console.WriteLine("ERROR: {0}", ex.Message); } return(Json(new { message = $"{type.ToString()} has not refreshed" })); }