public async Task <AllUserSettings> GetAllUserSettings(string userName, string previousUser)
{
AllUserSettings allUserSettings = new AllUserSettings();
SettingsLayer settings = new SettingsLayer();
UserLayer userLayer = new UserLayer();
// var //stopwatch0 = new //stopwatch();
// var //stopwatch = new //stopwatch();
// var //stopwatch1 = new //stopwatch();
// var //stopwatch2 = new //stopwatch();
// //stopwatch0.Start();
using (SqlConnection sqlCon = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["CC_ProdConn"].ConnectionString))
{
sqlCon.Open();
//stopwatch.Start();
allUserSettings.session = await userLayer.GetSessionAsync(userName, previousUser, sqlCon);
//stopwatch.Stop();
//stopwatch1.Start();
allUserSettings.columns = await settings.GetUserCollums(userName, sqlCon);
//stopwatch1.Stop();
//stopwatch2.Start();
allUserSettings.settings = await GetSavedUserSettings(new List <string>(), userName, sqlCon);
//stopwatch2.Stop();
}
//stopwatch0.Stop();
if (previousUser == null || previousUser == "")
{
await Task.Run(() =>
{
try
{
allUserSettings.settings = allUserSettings.settings.FindAll(a => a.name != "allUserSettings");
SavedUserSettings setting = new SavedUserSettings()
{
name = "allUserSettings", value = new JavaScriptSerializer()
{
MaxJsonLength = 16777216
}.Serialize(allUserSettings)
};
SaveUserSettings(setting, userName);
}
catch
{
}
});
}
return(allUserSettings);
}
/// <summary>
/// SaveUserSettings
/// </summary>
/// <param name="setting"></param>
/// <returns></returns>
public string SaveUserSettings(SavedUserSettings setting)
{
using (var sqlCon = new SqlConnection(System.Configuration.ConfigurationManager
.ConnectionStrings["CC_ProdConn"].ConnectionString))
{
var userName = HttpContext.Current.User.Identity.Name;
var sqlComm = new SqlCommand
{
Connection = sqlCon,
CommandText = "[SaveUserSettings]",
CommandType = CommandType.StoredProcedure
};
sqlComm.Parameters.AddWithValue("@username", userName);
sqlComm.Parameters.AddWithValue("@Value", setting.value);
sqlComm.Parameters.AddWithValue("@Name", setting.name);
sqlCon.Open();
try
{
if ((setting.name != string.Empty))
{
sqlComm.ExecuteReader();
}
}
catch (Exception ex)
{
HttpContext.Current.Response.Write(ex.Message);
}
}
return("Success");
}
public void SaveUserData(UserPreferences newUserPreferces)
{
CurrentUserPreferences = newUserPreferces;
SavedUserSettings.AddOrUpdateValue(AppSettingKeys.USER_MAX_TEMP, newUserPreferces.MaxRidingTemp);
SavedUserSettings.AddOrUpdateValue(AppSettingKeys.USER_MIN_TEMP, newUserPreferces.MinRidingTemp);
SavedUserSettings.AddOrUpdateValue(AppSettingKeys.USER_LOCATION, newUserPreferces.LocationZipCode);
SavedUserSettings.AddOrUpdateValue(AppSettingKeys.USER_MAX_PRECIP_PERCENT, newUserPreferces.MaxRainPercentage);
SavedUserSettings.AddOrUpdateValue(AppSettingKeys.USER_MAX_RAIN_ACCUMULATION, newUserPreferces.MaxRainAccumulation);
}
public UserPreferences LoadCurrentUserPreferences()
{
CurrentUserPreferences.MaxRidingTemp = SavedUserSettings.GetValueOrDefault(AppSettingKeys.USER_MAX_TEMP, 90);
CurrentUserPreferences.MinRidingTemp = SavedUserSettings.GetValueOrDefault(AppSettingKeys.USER_MIN_TEMP, 40);
CurrentUserPreferences.LocationZipCode = SavedUserSettings.GetValueOrDefault(AppSettingKeys.USER_LOCATION, string.Empty);
CurrentUserPreferences.MaxRainPercentage = SavedUserSettings.GetValueOrDefault(AppSettingKeys.USER_MAX_PRECIP_PERCENT, 5);
CurrentUserPreferences.MaxRainAccumulation = SavedUserSettings.GetValueOrDefault(AppSettingKeys.USER_MAX_RAIN_ACCUMULATION, 1.0);
return(CurrentUserPreferences);
}
public string SaveUserSettings(SavedUserSettings setting)
{
UserLayer userLayer = new UserLayer();
return(userLayer.SaveUserSettings(setting));
}
