public bool InsertCompaign(CmpFanPageLiker acc)
{
bool Flage = false;
try
{
lock (lockerInsert)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
session.Save(acc);
transaction.Commit();
Flage = true;
}
}
}
}
catch (Exception ex)
{
GlobusLogHelper.log.Error("Error : " + ex.StackTrace);
}
return(Flage);
}
public List <CmpFanPageLiker> GetCmpFanPageLikerDataUsingCmpName(CmpFanPageLiker cmpFanPageLiker)
{
List <CmpFanPageLiker> lstCmpFanPageLiker = new List <CmpFanPageLiker>();
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
NHibernate.IQuery nIquery = session.CreateQuery("from CmpFanPageLiker s where s.CampaignName = :CampaignName");
nIquery.SetParameter("CampaignName", cmpFanPageLiker.CampaignName);
foreach (CmpFanPageLiker item in nIquery.Enumerable <CmpFanPageLiker>())
{
try
{
lstCmpFanPageLiker.Add(item);
}
catch (Exception ex)
{
GlobusLogHelper.log.Error("Error : " + ex.StackTrace);
}
}
}
}
catch (Exception ex)
{
GlobusLogHelper.log.Error("Error : " + ex.StackTrace);
}
return(lstCmpFanPageLiker);
}
public int UpdateUsingCmpName(CmpFanPageLiker cmpFanPageLiker)
{
lock (lockerUpdateUsingCmpName)
{
int res = 0;
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
var query = session.CreateQuery("Update CmpFanPageLiker set CampaignProcess = :CampaignProcess, AccountsFile= :AccountsFile, FanPageURLsFile= :FanPageURLsFile, FanPageMessageFile= :FanPageMessageFile, FanPageCommentsFile = :FanPageCommentsFile where CampaignName= :CampaignName");
query.SetParameter("CampaignProcess", cmpFanPageLiker.CampaignProcess);
query.SetParameter("AccountsFile", cmpFanPageLiker.AccountsFile);
query.SetParameter("FanPageURLsFile", cmpFanPageLiker.FanPageURLsFile);
query.SetParameter("FanPageMessageFile", cmpFanPageLiker.FanPageMessageFile);
query.SetParameter("FanPageCommentsFile", cmpFanPageLiker.FanPageCommentFile);
query.SetParameter("CampaignName", cmpFanPageLiker.CampaignName);
res = query.ExecuteUpdate();
transaction.Commit();
}
}
}
catch (Exception ex)
{
GlobusLogHelper.log.Error("Error : " + ex.StackTrace);
}
return(res);
}
}
public void Delete(CmpFanPageLiker acc)
{
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
//session.Delete(acc.UserName);
transaction.Commit();
}
}
}
catch (Exception ex)
{
GlobusLogHelper.log.Error("Error : " + ex.StackTrace);
}
}
public void Insert(CmpFanPageLiker 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);
}
}
