private static List <T> LoadPivotTypeWithQuery <T>(string query, Func <MySqlDataReader, object[], T> action, params MySqlParameter[] parameters) { List <T> listofT = new List <T>(); using (var sqlConnection = new MySqlConnection(GlobalAppConfig.GetConnectionString())) { sqlConnection.Open(); using (var sqlCommand = sqlConnection.CreateCommand()) { sqlCommand.CommandText = query; foreach (var parameter in parameters) { sqlCommand.Parameters.Add(parameter); } using (var sqlReader = sqlCommand.ExecuteReader()) { while (sqlReader.Read()) { listofT.Add(action.Invoke(sqlReader, new object[] { GlobalAppConfig.GetProfilePictureBaseDirectory() })); } } } } return(listofT); }
private static void LoadConfiguration() { using (var sqlConnection = new MySqlConnection(GlobalAppConfig.GetConnectionString())) { sqlConnection.Open(); using (var sqlCommand = sqlConnection.CreateCommand()) { sqlCommand.CommandText = "SELECT * FROM configuration WHERE id = @id"; sqlCommand.Parameters.Add(new MySqlParameter("@id", MySqlDbType.UInt32) { Value = GlobalAppConfig.GetInt32(AppKey.ConfigurationId) }); using (var sqlReader = sqlCommand.ExecuteReader()) { if (sqlReader.Read()) { ConfigurationPivot.Initialize(sqlReader); } } } } }