/// <summary>
/// Loads the shared personalization record for the given path.
/// </summary>
/// <param name="path">The path to the file to load data for</param>
/// <param name="create">If true, the personalization record is created if
/// it does not exist.</param>
/// <returns>Thje shared personalization record for the given path</returns>
public static SharedPersonalization LoadForPath(string path, bool create)
{
SharedPersonalization sharedPersonalization = null;
//CREATE THE DYNAMIC SQL TO LOAD OBJECT
StringBuilder selectQuery = new StringBuilder();
selectQuery.Append("SELECT " + SharedPersonalization.GetColumnNames("acSP"));
selectQuery.Append(" FROM ac_SharedPersonalization acSP, ac_PersonalizationPaths acP");
selectQuery.Append(" WHERE acSP.PersonalizationPathId = acP.PersonalizationPathId AND acP.Path = @path AND acP.StoreId = @storeId");
Database database = Token.Instance.Database;
DbCommand selectCommand = database.GetSqlStringCommand(selectQuery.ToString());
database.AddInParameter(selectCommand, "@path", System.Data.DbType.String, path);
database.AddInParameter(selectCommand, "@storeId", System.Data.DbType.Int32, Token.Instance.StoreId);
//EXECUTE THE COMMAND
using (IDataReader dr = database.ExecuteReader(selectCommand))
{
if (dr.Read())
{
sharedPersonalization = new SharedPersonalization();
SharedPersonalization.LoadDataReader(sharedPersonalization, dr);
}
dr.Close();
}
if ((sharedPersonalization == null) && create)
{
sharedPersonalization = new SharedPersonalization(PersonalizationPathDataSource.LoadForPath(path, true));
}
return(sharedPersonalization);
}
public static PersonalizationPath Load(Int32 personalizationPathId)
{
return(PersonalizationPathDataSource.Load(personalizationPathId, true));
}
public static PersonalizationPathCollection LoadForUser(Int32 userId, int maximumRows, int startRowIndex)
{
return(PersonalizationPathDataSource.LoadForUser(userId, maximumRows, startRowIndex, string.Empty));
}
public static PersonalizationPathCollection LoadForUser(Int32 userId, string sortExpression)
{
return(PersonalizationPathDataSource.LoadForUser(userId, 0, 0, sortExpression));
}
public static PersonalizationPathCollection LoadForUser(Int32 userId)
{
return(PersonalizationPathDataSource.LoadForUser(userId, 0, 0, string.Empty));
}
){kind=link}