/// <Update>
/// Update/Change value of blog post
/// </summary>
/// <param name="blog_Posts">Set Values in a blog posts Class Property and Pass the same Object of blog posts Class in paremeter.(Domain.Blog_Posts)</param>
/// <returns></returns>
public int Update(Blog_Posts blog_Posts)
{
int update = 0;
try
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
//Proceed action, to update Data
session.Update(blog_Posts.Id, blog_Posts);
transaction.Commit();
update = 1;
} //End Trsaction
} //End session
}
catch (Exception ex)
{
Console.WriteLine("Error : " + ex.StackTrace);
}
return(update);
}
/// <GetAllBlogPosts>
/// Get all BlogPosts
/// </summary>
/// <param name="blog_Posts"></param>
/// <returns>Icollection of Blog post data objects </returns>
public ICollection <Domain.Socioboard.Domain.Blog_Posts> GetAllBlogPosts(Blog_Posts blog_Posts)
{
ICollection <Blog_Posts> iCol = null;
try
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//Proceed action, to to get all blog posts
iCol = session.CreateCriteria(typeof(Blog_Posts)).List <Blog_Posts>();
}//End session
}
catch (Exception ex)
{
Console.WriteLine("Error : " + ex.StackTrace);
}
return(iCol);
} // End Method
public async Task <List <Blog_Posts> > GetBlogsSummary()
{
List <Blog_Posts> blog_postList = new List <Blog_Posts>();
var datalist = await(from b in _context.Blogs
join p in _context.Posts on b.BlogId equals p.BlogId
select new { b.BlogId, p.PostUrl, b.Subject, p.Title, p.Content }
).ToListAsync();
datalist.ForEach(bp =>
{
var newblogpost = new Blog_Posts();
newblogpost.BlogId = bp.BlogId;
newblogpost.PostUrl = bp.PostUrl;
newblogpost.BlogName = bp.Subject;
newblogpost.postName = bp.Title;
newblogpost.postContent = bp.Content;
blog_postList.Add(newblogpost);
}
);
return(blog_postList);
}
///NOT USED NOW.
/// <summary>
/// Get all Blog_Comments from Database by Id.
/// </summary>
/// <param name="objBlog_Posts">The object of the Blog_Comments class(Domain.Blog_Comments)</param>
/// <returns>Return all Comment By BlogId in the form of List type.</returns>
public ICollection <Blog_Comments> GetAllCommentByBlogIda(Blog_Posts objBlog_Posts)
{
ICollection <Blog_Comments> iCol = null;
// ICollection<Blog_Comments> iColById = null;
try
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//Proceed action, to get all data
iCol = session.CreateCriteria(typeof(Blog_Comments)).List <Blog_Comments>()
.Where <Blog_Comments> (x => x.CommentPostId == objBlog_Posts.Id).ToList <Blog_Comments>();
// iColById = iCol.Where<Blog_Comments>(x => x.CommentPostId == objBlog_Posts.Id).ToList<Blog_Comments>();
}//End session
}
catch (Exception ex)
{
Console.WriteLine("Error : " + ex.StackTrace);
}
return(iCol);
}//End Method
