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