public override Revertable2Collection<BlogArticle> GetBlogArticlesWithReverters(IEnumerable<int> articleIDs)
{
if (ValidateUtil.HasItems(articleIDs) == false)
return null;
Revertable2Collection<BlogArticle> articles = new Revertable2Collection<BlogArticle>();
using (SqlQuery query = new SqlQuery())
{
query.CommandText = @"
SELECT
A.*,
SubjectReverter = ISNULL(R.SubjectReverter, ''),
ContentReverter = ISNULL(R.ContentReverter, '')
FROM
bx_BlogArticles A WITH(NOLOCK)
LEFT JOIN
bx_BlogArticleReverters R WITH(NOLOCK) ON R.ArticleID = A.ArticleID
WHERE
A.ArticleID IN (@ArticleIDs)";
query.CreateInParameter<int>("@ArticleIDs", articleIDs);
using (XSqlDataReader reader = query.ExecuteReader())
{
while (reader.Read())
{
string subjectReverter = reader.Get<string>("SubjectReverter");
string contentReverter = reader.Get<string>("ContentReverter");
BlogArticle article = new BlogArticle(reader);
articles.Add(article, subjectReverter, contentReverter);
}
}
}
return articles;
}
public override Revertable2Collection<Photo> GetPhotosWithReverters(IEnumerable<int> photoIds)
{
if (ValidateUtil.HasItems(photoIds) == false)
return null;
Revertable2Collection<Photo> photos = new Revertable2Collection<Photo>();
using (SqlQuery query = new SqlQuery())
{
query.CommandText = @"SELECT P.*,
NameReverter = ISNULL(R.NameReverter, ''),
DescriptionReverter = ISNULL(R.DescriptionReverter, '')
FROM bx_Photos P WITH(NOLOCK) LEFT JOIN bx_PhotoReverters R WITH(NOLOCK) ON P.PhotoID = R.PhotoID
WHERE P.PhotoID IN (@PhotoIds)";
query.CreateInParameter<int>("@PhotoIds", photoIds);
using (XSqlDataReader reader = query.ExecuteReader())
{
while (reader.Read())
{
string nameReverter = reader.Get<string>("NameReverter");
string descriptionReverter = reader.Get<string>("DescriptionReverter");
Photo photo = new Photo(reader);
photos.Add(photo, nameReverter, descriptionReverter);
}
}
}
return photos;
}
public override Revertable2Collection<PostV5> GetPostsWithReverters(IEnumerable<int> postIDs)
{
if (ValidateUtil.HasItems(postIDs) == false)
return null;
Revertable2Collection<PostV5> posts = new Revertable2Collection<PostV5>();
using (SqlQuery query = new SqlQuery())
{
query.CommandText = @"
SELECT
A.*,
SubjectReverter = ISNULL(R.SubjectReverter, ''),
ContentReverter = ISNULL(R.ContentReverter, '')
FROM
bx_Posts A WITH(NOLOCK)
LEFT JOIN
bx_PostReverters R WITH(NOLOCK) ON R.PostID = A.PostID
WHERE
A.PostID IN (@PostIDs)";
query.CreateInParameter<int>("@PostIDs", postIDs);
using (XSqlDataReader reader = query.ExecuteReader())
{
while (reader.Read())
{
string subjectReverter = reader.Get<string>("SubjectReverter");
string contentReverter = reader.Get<string>("ContentReverter");
PostV5 post = new PostV5(reader);
posts.Add(post, subjectReverter, contentReverter);
}
}
}
return posts;
}
public override Revertable2Collection<Album> GetAlbumsWithReverters(IEnumerable<int> albumIds)
{
if (ValidateUtil.HasItems(albumIds) == false)
return null;
Revertable2Collection<Album> albums = new Revertable2Collection<Album>();
using (SqlQuery query = new SqlQuery())
{
query.CommandText = @"SELECT A.*,
NameReverter = ISNULL(R.NameReverter, ''),
DescriptionReverter = ISNULL(R.DescriptionReverter, '')
FROM bx_Albums A WITH(NOLOCK)
LEFT JOIN bx_AlbumReverters R WITH(NOLOCK) ON R.AlbumID = A.AlbumID
WHERE A.AlbumID IN (@AlbumIds)";
query.CreateInParameter<int>("@AlbumIds", albumIds);
using (XSqlDataReader reader = query.ExecuteReader())
{
while (reader.Read())
{
string nameReverter = reader.Get<string>("NameReverter");
string descriptionReverter = reader.Get<string>("DescriptionReverter");
Album album = new Album(reader);
albums.Add(album, nameReverter, descriptionReverter);
}
}
}
return albums;
}
//public override void TryUpdateKeyword(TextReverterCollection_Temp replaceKeywordContents)
//{
// using (SqlQuery query = new SqlQuery())
// {
// StringBuilder sql = new StringBuilder();
// int i = 0;
// foreach (TextReverter_Temp content in replaceKeywordContents)
// {
// sql.AppendFormat(@"UPDATE [bx_Shares] SET [Description] = @Description_{0}, [DescriptionReverter] = @DescriptionReverter_{0} WHERE [ShareID] = @ShareID_{0};", i);
// query.CreateParameter<string>("@Description_" + i, content.Text1, SqlDbType.NVarChar, 500);
// query.CreateParameter<string>("@DescriptionReverter_" + i, content.TextReverter1, SqlDbType.NVarChar, 500);
// query.CreateParameter<int>("@ShareID_" + i, content.ID, SqlDbType.Int);
// i++;
// }
// query.CommandText = sql.ToString();
// query.ExecuteNonQuery();
// }
//}
public override Revertable2Collection<Share> GetSharesWithReverters(IEnumerable<int> shareIDs)
{
if (ValidateUtil.HasItems(shareIDs) == false)
return null;
Revertable2Collection<Share> shares = new Revertable2Collection<Share>();
using (SqlQuery query = new SqlQuery())
{
query.CommandText = @"
SELECT
A.*,
SubjectReverter = ISNULL(R.SubjectReverter, ''),
DescriptionReverter = ISNULL(R.DescriptionReverter, '')
FROM
[bx_SharesView] A WITH(NOLOCK)
LEFT JOIN
bx_UserShareReverters R WITH(NOLOCK) ON R.UserShareID = A.UserShareID
WHERE
A.ShareID IN (@ShareIDs)";
query.CreateInParameter<int>("@ShareIDs", shareIDs);
using (XSqlDataReader reader = query.ExecuteReader())
{
while (reader.Read())
{
string subjectReverter = reader.Get<string>("SubjectReverter");
string descriptionReverter = reader.Get<string>("DescriptionReverter");
Share share = new Share(reader);
shares.Add(share, subjectReverter, descriptionReverter);
}
}
}
return shares;
}
