/// <Update>
/// Update All Fields of Blog_Comments by Id.
/// </summary>
/// <param name="blog_Comments">The object of the Blog_Comments class(Domain.Blog_Comments)</param>
/// <returns>Integer where 0 is failed and 1 is success </returns>
public int Update(Blog_Comments blog_Comments)
{
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.
//Return int (0 or 1)
session.Update(blog_Comments.Id, blog_Comments);
transaction.Commit();
update = 1;
} //End using Transaction
} //End using session
}
catch (Exception ex)
{
Console.WriteLine("Error : " + ex.StackTrace);
}
return(update);
}
/// <Insert>
/// Add a Blog_Comment in a Database
/// </summary>
/// <param name="blog_Comments">The object of the Blog_Comments class(Domain.Blog_Comments)</param>
/// <returns>Return Integer</returns>
public int Insert(Blog_Comments blog_Comments)
{
int insert = 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 save data
session.Save(blog_Comments);
transaction.Commit();
insert = 1;
} //End Using trasaction
} //End using session
}
catch (Exception ex)
{
Console.WriteLine("Error : " + ex.StackTrace);
}
return(insert);
}
/// <Delete>
/// Delete a Blog_Comments from Database by Id.
/// </summary>
/// <param name="blog_Comments">The object of the Blog_Comments class(Domain.Blog_Comments)</param>
/// <returns>Integer</returns>
public int Delete(Blog_Comments blog_Comments)
{
int delete = 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 Delete
session.Delete(blog_Comments.Id);
transaction.Commit();
delete = 1;
} //End Trsaction
} //End session
}
catch (Exception ex)
{
Console.WriteLine("Error : " + ex.StackTrace);
}
return(delete);
}
public ActionResult MakeComment(FormCollection collection)
{
try
{
int blogId = Convert.ToInt32(collection.Get("blogId"));
string commentText = collection.Get("CommentText");
string userId = collection.Get("userId");
Blog_Comments bComment = new Blog_Comments()
{
BlogId = blogId,
Comment = commentText,
Commenter = userId,
InReplyTo = "No-One",
TimeStamp = DateTime.Now
};
db.Blog_Comments.Add(bComment);
db.SaveChanges();
return(RedirectToAction("Article", "Blogs", new { id = blogId }));
}
catch
{
return(RedirectToAction("Index", "Manage", null));
}
}
/// <GetAllBlog_Comments>
/// Get AllBlog Comment.
/// </summary>
/// <param name="blog_Comments">The object of the Blog_Comments class(Domain.Blog_Comments)</param>
/// <returns>Return Blog Comment from Blog_Comments in the form of ICollection Type.</returns>
public ICollection <Blog_Comments> GetAllBlog_Comments(Blog_Comments blog_Comments)
{
ICollection <Blog_Comments> iCol = null;
try
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//Proceed action, to get data.
iCol = session.CreateCriteria(typeof(Blog_Comments)).List <Blog_Comments>();
}
}
catch (Exception ex)
{
Console.WriteLine("Error : " + ex.StackTrace);
}
return(iCol);
}
/// <summary>
/// Map a Comments database Model object to a View Model object for presentation
/// </summary>
/// <param name="item">database model object</param>
/// <returns>view model presentation object</returns>
public static ViewModel.Blog.Comments ToViewModel(this Blog_Comments item)
{
return(Mapper.Map <ViewModel.Blog.Comments>(item));
}
