public void AddInboxMessages(Domain.Myfashion.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 Domain.Myfashion.Domain.InboxMessages getInboxMessageByMessageId(Guid UserId, Guid MessageId) { //Creates a database connection and opens up a session using (NHibernate.ISession session = SessionFactory.GetNewSession()) { //After Session creation, start Transaction. using (NHibernate.ITransaction transaction = session.BeginTransaction()) { try { NHibernate.IQuery results = session.CreateQuery("from InboxMessages Where UserId =: UserId and Id =: MessageId") .SetParameter("UserId", UserId) .SetParameter("MessageId", MessageId); Domain.Myfashion.Domain.InboxMessages result = (Domain.Myfashion.Domain.InboxMessages)results.UniqueResult(); return(result); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return(new Domain.Myfashion.Domain.InboxMessages()); } } //End using transaction } //End using session }
public string getInboxMessageByMessageId(string UserId, string MessageId) { Domain.Myfashion.Domain.InboxMessages _InboxMessages = objInboxMessagesRepository.getInboxMessageByMessageId(Guid.Parse(UserId), Guid.Parse(MessageId)); return(new JavaScriptSerializer().Serialize(_InboxMessages)); }