/// <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)); }