public int UpdateQuery(GroupCampaign groupCamp)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (ITransaction transaction = session.BeginTransaction())
{
var query = session.CreateQuery("Update GroupCampaign set Account=:Account,PicFilePath=:PicFilePath,VideoFilePath=:VideoFilePath,MessageFilepath=:MessageFilepath,ScheduleTime=:ScheduleTime,CmpStartTime=:CmpStartTime,Accomplish=:Accomplish,NoOfMessage=:NoOfMessage,MessageMode=:MessageMode,MessageType=:MessageType,TextMessage=:TextMessage where GroupCampaignName=:GroupCampaignName and Module =:module");
//session.SaveOrUpdate(groupCamp);
query.SetParameter("GroupCampaignName", groupCamp.GroupCampaignName);
query.SetParameter("Account", groupCamp.Account);
query.SetParameter("PicFilePath", groupCamp.PicFilePath);
query.SetParameter("VideoFilePath", groupCamp.VideoFilePath);
query.SetParameter("MessageFilepath", groupCamp.MessageFilePath);
query.SetParameter("ScheduleTime", groupCamp.ScheduleTime);
query.SetParameter("CmpStartTime", groupCamp.CmpStartTime);
query.SetParameter("Accomplish", groupCamp.Accomplish);
query.SetParameter("NoOfMessage", groupCamp.NoOfMessage);
query.SetParameter("MessageMode", groupCamp.MessageMode);
query.SetParameter("MessageType", groupCamp.MessageType);
query.SetParameter("TextMessage", groupCamp.TextMessage);
query.SetParameter("module", groupCamp.Module);
int res = query.ExecuteUpdate();
transaction.Commit();
return(res);
}
}
}
public void Delete(GroupCampaign acc)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
//session.Delete(acc.UserName);
transaction.Commit();
}
}
}
public void Update(GroupCampaign acc)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
//session.Update(acc.Password, acc);
transaction.Commit();
}
}
}
public void Insert(GroupCampaign acc)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
session.Save(acc);
transaction.Commit();
}
}
}
public ICollection <GroupCampaign> GetAllAccount(GroupCampaign groupCamp)
{
ICollection <GroupCampaign> iCol = null;
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
iCol = session.CreateCriteria(typeof(GroupCampaign)).List <GroupCampaign>();
}
}
catch (Exception ex)
{
GlobusLogHelper.log.Error("Error : " + ex.StackTrace);
}
return(iCol);
}
public void Update(GroupCampaign groupCamp)
{
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
session.Update(groupCamp.GroupCampaignName, groupCamp);
transaction.Commit();
}
}
}
catch (Exception ex)
{
GlobusLogHelper.log.Error("Error : " + ex.StackTrace);
}
}
public void DeleteSelectRows(GroupCampaign ObjGrpCamp)
{
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
var query = session.CreateSQLQuery("delete from GroupCampaign WHERE GroupCampaignName = :CampaignName and Module =:module").SetParameter("CampaignName", ObjGrpCamp.GroupCampaignName).SetParameter("module", ObjGrpCamp.Module);
int res = query.ExecuteUpdate();
transaction.Commit();
}
}
}
catch (Exception ex)
{
GlobusLogHelper.log.Error("Error : " + ex.StackTrace);
}
}
public ICollection <GroupCampaign> SelectCampaigns(GroupCampaign groupCamp)
{
List <GroupCampaign> lstGroupCampaign = null;
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (ITransaction transaction = session.BeginTransaction())
{
lstGroupCampaign = session.CreateQuery("FROM GroupCampaign gc where gc.Module =:module")
.SetParameter("module", groupCamp.Module)
.List <GroupCampaign>()
.ToList <GroupCampaign>();
return(lstGroupCampaign);
}
}
}
catch (Exception ex)
{
GlobusLogHelper.log.Error(ex.StackTrace);
}
return(lstGroupCampaign);
}
