public ICollection <FanPageStatus> GetAllFanPageStatus(FanPageStatus acc)
{
ICollection <FanPageStatus> iCol = null;
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
iCol = session.CreateCriteria(typeof(FanPageStatus)).List <FanPageStatus>();
}
}
catch (Exception ex)
{
GlobusLogHelper.log.Error("Error : " + ex.StackTrace);
}
return(iCol);
}
public void Update(FanPageStatus acc)
{
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
//session.Update(acc.Password, acc);
transaction.Commit();
}
}
}
catch (Exception ex)
{
GlobusLogHelper.log.Error("Error : " + ex.StackTrace);
}
}
public void Insert(FanPageStatus acc)
{
try
{
lock (lockerInsert)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
session.Save(acc);
transaction.Commit();
}
}
}
}
catch (Exception ex)
{
GlobusLogHelper.log.Error("Error : " + ex.StackTrace);
}
}
public void DeleteUsingMainPageUrl(FanPageStatus fpStatus)
{
try
{
lock (lockerDeleteUsingMainPageUrl)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
var query = session.CreateQuery("Delete from FanPageStatus where MainPageUrl= :mainPageUrl");
query.SetParameter("mainPageUrl", fpStatus.MainPageUrl);
int res = query.ExecuteUpdate();
transaction.Commit();
}
}
}
}
catch (Exception ex)
{
GlobusLogHelper.log.Error("Error : " + ex.StackTrace);
}
}