public void AddInboxMessages(Domain.Socioboard.Domain.InboxMessages _InboxMessages) { //Creates a database connection and opens up a session using (NHibernate.ISession session = SessionFactory.GetNewSession()) { //After Session creation, start and open Transaction. using (NHibernate.ITransaction transaction = session.BeginTransaction()) { //Proceed action to save data. session.Save(_InboxMessages); transaction.Commit(); } //End Using trasaction } //End Using session }
public int UpdateMessageSentiments(Domain.Socioboard.Domain.InboxMessages _InboxMessages) { using (NHibernate.ISession session = SessionFactory.GetNewSession()) { using (NHibernate.ITransaction transaction = session.BeginTransaction()) { int i = session.CreateQuery("Update InboxMessages set Negative =: Negative, Positive =: Positive where MessageId =: MessageId and MessageType=:MessageType") .SetParameter("Negative", _InboxMessages.Negative) .SetParameter("Positive", _InboxMessages.Positive) .SetParameter("MessageId", _InboxMessages.MessageId) .SetParameter("MessageType", _InboxMessages.MessageType) .ExecuteUpdate(); transaction.Commit(); return(i); } } }
public int UpdateTwitterFollowerInfo(Domain.Socioboard.Domain.InboxMessages _InboxMessages) { using (NHibernate.ISession session = SessionFactory.GetNewSession()) { using (NHibernate.ITransaction transaction = session.BeginTransaction()) { int i = session.CreateQuery("Update InboxMessages set FromName =: FromName, Message =: Message, FromImageUrl =: FromImageUrl, FollowerCount =: FollowerCount, FollowingCount =: FollowingCount where FromId =: FromId and MessageType=:MessageType") .SetParameter("FromName", _InboxMessages.FromName) .SetParameter("Message", _InboxMessages.Message) .SetParameter("FromImageUrl", _InboxMessages.FromImageUrl) .SetParameter("MessageType", _InboxMessages.MessageType) .SetParameter("FollowerCount", _InboxMessages.FollowerCount) .SetParameter("FollowingCount", _InboxMessages.FollowingCount) .SetParameter("FromId", _InboxMessages.FromId) .ExecuteUpdate(); transaction.Commit(); return(i); } } }
public Domain.Socioboard.Domain.InboxMessages getInboxMessageByMessageId(Guid UserId, Guid MessageId) { //Creates a database connection and opens up a session using (NHibernate.ISession session = SessionFactory.GetNewSession()) { try { NHibernate.IQuery results = session.CreateQuery("from InboxMessages Where UserId =: UserId and Id =: MessageId") .SetParameter("UserId", UserId) .SetParameter("MessageId", MessageId); Domain.Socioboard.Domain.InboxMessages result = (Domain.Socioboard.Domain.InboxMessages)results.UniqueResult(); return(result); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return(new Domain.Socioboard.Domain.InboxMessages()); } }//End using session }
public string getInboxMessageByMessageId(string UserId, string MessageId) { Domain.Socioboard.Domain.InboxMessages _InboxMessages = objInboxMessagesRepository.getInboxMessageByMessageId(Guid.Parse(UserId), Guid.Parse(MessageId)); return(new JavaScriptSerializer().Serialize(_InboxMessages)); }