public PersonalizationData GetUserSettings(PersonalizationSearchCriteria searchCriteria)
{
var userSettingsToReturn = new PersonalizationData();
SqlConnection cn;
SPSecurity.RunWithElevatedPrivileges(delegate
{
using (cn = new SqlConnection(EPMLiveCore.CoreFunctions.getConnectionString(_web.Site.WebApplication.Id)))
{
cn.Open();
var cmd = new SqlCommand("SELECT * FROM PERSONALIZATIONS WHERE FK=@FK and UserId=@userid and [Key]=@key and SiteId=@siteid and WebId=@webid", cn);
cmd.Parameters.AddWithValue("@FK", searchCriteria.WebPartId.ToString());
cmd.Parameters.AddWithValue("@siteid", searchCriteria.SiteId.ToString());
cmd.Parameters.AddWithValue("@webid", searchCriteria.WebId.ToString());
cmd.Parameters.AddWithValue("@userid", searchCriteria.UserId);
cmd.Parameters.AddWithValue("@key", _personalizationKey);
var reader = cmd.ExecuteReader();
userSettingsToReturn.Hydrate(reader);
cn.Close();
}
});
return(userSettingsToReturn);
}
public EpmChartUserSettings GetChartSettings(PersonalizationSearchCriteria searchCriteria)
{
var personalizationsRepo = new PersonalizationDataRepository(_web, EpmChartUserSettings.Key);
var personalizationsData = personalizationsRepo.GetUserSettings(searchCriteria);
var chartSettingsToReturn = new EpmChartUserSettings();
chartSettingsToReturn.Hydrate(personalizationsData);
return(chartSettingsToReturn);
}
private EpmChartUserSettings GetPersistedBubbleChartPersonalizations()
{
var web = SPContext.Current.Web;
var searchCriteria = new PersonalizationSearchCriteria
{
SiteId = web.Site.ID,
WebId = web.ID,
WebPartId = WebPartHelper.ConvertWebPartIdToGuid(ID),
UserId = web.CurrentUser.ID.ToString(),
Key = EpmChartUserSettings.Key
};
var repo = new EpmChartUserSettingsRepository(web);
return(repo.GetChartSettings(searchCriteria));
}
public void PersistUserSettings(PersonalizationData userSettings)
{
var searchCriteria = new PersonalizationSearchCriteria
{
WebPartId = userSettings.ForeignKey,
SiteId = userSettings.SiteId,
WebId = userSettings.WebId,
UserId = userSettings.UserId,
Key = _personalizationKey
};
if (UserHasPersistedSettings(searchCriteria))
{
UpdateUserSettings(userSettings);
}
else
{
InsertUserSettings(userSettings);
}
}
private void LoadChartUserSettings()
{
if (string.IsNullOrEmpty(PropChartWebPartId))
{
return;
}
var web = SPContext.Current.Web;
var repo = new EpmChartUserSettingsRepository(web);
var searchCriteria = new PersonalizationSearchCriteria
{
WebPartId = WebPartHelper.ConvertWebPartIdToGuid(PropChartWebPartId),
WebId = web.ID,
SiteId = web.Site.ID,
UserId = web.CurrentUser.ID.ToString(),
Key = EpmChartUserSettings.Key
};
_chartUserSettings = repo.GetChartSettings(searchCriteria);
}
private bool UserHasPersistedSettings(PersonalizationSearchCriteria personalizationSearchCriteria)
{
var searchResults = GetUserSettings(personalizationSearchCriteria);
return(!string.IsNullOrEmpty(searchResults.Key));
}
