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); }