// Token: 0x06000772 RID: 1906 RVA: 0x00033044 File Offset: 0x00031244 protected override SqlCommand ComposeSelectCollectionCommand(NotificationItemFilter filter) { SqlCommand sqlCommand = new SqlCommand("SELECT{0} * FROM NotificationBlogs LEFT JOIN NotificationItems ON \r\n NotificationBlogs.BlogID = NotificationItems.NotificationID"); SqlCommand result; try { StringBuilder stringBuilder = new StringBuilder(); if (!filter.IncludeAcknowledged) { SqlHelper.AddCondition(stringBuilder, "AcknowledgedAt IS NULL", "AND"); } if (!filter.IncludeIgnored) { SqlHelper.AddCondition(stringBuilder, "Ignored=0", "AND"); } BlogFilter blogFilter = filter as BlogFilter; if (blogFilter != null && blogFilter.MaxResults > 0) { sqlCommand.CommandText = string.Format(sqlCommand.CommandText, " TOP " + blogFilter.MaxResults); } else { sqlCommand.CommandText = string.Format(sqlCommand.CommandText, string.Empty); } SqlCommand sqlCommand2 = sqlCommand; sqlCommand2.CommandText += stringBuilder.ToString(); SqlCommand sqlCommand3 = sqlCommand; sqlCommand3.CommandText += " ORDER BY PublicationDate DESC"; result = sqlCommand; } catch (Exception ex) { sqlCommand.Dispose(); BlogItemDAL.log.Error(string.Format("Error while composing SELECT SQL command for {0} collection: ", base.GetType().Name) + ex.ToString()); throw; } return(result); }
// Token: 0x06000778 RID: 1912 RVA: 0x00033362 File Offset: 0x00031562 public static ICollection <BlogItemDAL> GetItems(BlogFilter filter) { return(NotificationItemDAL.GetItems <BlogItemDAL>(filter)); }