public void UpdateStatusUsingFriendId(FanPagePost objFPPost) { try { lock (lockerUpdateStatusUsingFriendId) { using (NHibernate.ISession session = SessionFactory.GetNewSession()) { using (NHibernate.ITransaction transaction = session.BeginTransaction()) { var query = session.CreateQuery("Update FanPagePost set Status = :status where FriendId= :FriendId"); query.SetParameter("status", objFPPost.Status); query.SetParameter("FriendId", objFPPost.FriendId); int res = query.ExecuteUpdate(); transaction.Commit(); } } } } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } }
public ICollection <FanPagePost> GetAllFanPagePost(FanPagePost objFPPost) { ICollection <FanPagePost> iCol = null; try { using (NHibernate.ISession session = SessionFactory.GetNewSession()) { iCol = session.CreateCriteria(typeof(FanPagePost)).List <FanPagePost>(); } } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } return(iCol); }
public void Delete(FanPagePost objFPPost) { 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 InsertChasngeLevel(FanPagePost objFPPost) { try { lock (lockerInsertChasngeLevel) { using (NHibernate.ISession session = SessionFactory.GetNewSession()) { using (NHibernate.ITransaction transaction = session.BeginTransaction()) { session.Save(objFPPost); transaction.Commit(); } } } } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } }
public List <FanPagePost> GetFanPagePostUsingLevelStatusMainPageUrl(FanPagePost objFPPost) { List <FanPagePost> lstFanPagePost = new List <FanPagePost>(); try { using (NHibernate.ISession session = SessionFactory.GetNewSession()) { // NHibernate.ISQLQuery nHquery = session.CreateSQLQuery("Select FilePath from setting where Module ='" + setting.Module + "'");// and FileType='" + setting.FileType + "' NHibernate.IQuery nIquery = session.CreateQuery("from FanPagePost fpPost where fpPost.Level = :level and fpPost.Status = :status and fpPost.MainPageUrl = :mainPageUrl") .SetParameter("level", objFPPost.Level) .SetParameter("status", objFPPost.Status) .SetParameter("mainPageUrl", objFPPost.MainPageUrl); foreach (FanPagePost item in nIquery.Enumerable <FanPagePost>()) { try { lstFanPagePost.Add(item); } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } } } } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } return(lstFanPagePost); }