public void Update(SystemConfiguration item) { var parameters = new DynamicParameters(item); using (var conn = db.GetOpenConnection()) { string sql = @"UPDATE [dbo].[Configuration] SET [SystemName] = @SystemName ,[SystemDescription] = @SystemDescription ,[Timezone] = @TimeZone ,[SystemDomain] = @SystemDomain ,[SystemEmail] = @SystemEmail ,[GoogleOAuthClientID] = @GoogleOAuthClientID ,[GoogleOAuthClientSecret] = @GoogleOAuthClientSecret ,[ReCaptchaSiteKey] = @ReCaptchaSiteKey ,[ReCaptchaSecretKey] = @ReCaptchaSecretKey ,[GAServiceAccount] = @GAServiceAccount ,[GAApplicationName] = @GAApplicationName ,[GAProfileID] = @GAProfileID ,[GATrackingCode] = @GATrackingCode ,[FacebookAppID] = @FacebookAppID ,[FacebookAppSecret] = @FacebookAppSecret ,[AzureADInstance] = @AzureADInstance ,[AzureADClientID] = @AzureADClientID ,[AzureADClientSecret] = @AzureADClientSecret ,[SendgridUserName] = @SendgridUserName ,[SendgridPassword] = @SendgridPassword"; conn.Execute(sql, parameters); } }
public static void LoadConfiguration(SystemConfiguration configurations) { var type = configurations.GetType(); var properties = type.GetProperties(); foreach(PropertyInfo property in type.GetProperties()) { string name = property.Name; object value = property.GetValue(configurations, null); if (value == null) value = string.Empty; CacheProvider.StoreForever(name, value); } }
public void UpdateSystemConfiguration(SystemConfiguration configuration) { configurationRepository.Update(configuration); }