public void SendChatMessage(string sender, string email, string message, string clientName)
{
foreach (var connectionId in _connections.GetConnections(email))
{
Clients.Client(connectionId).addChatMessage(sender, email, message, clientName);
}
ClientService CS = new ClientService();
client cls = CS.Get(x => x.email.Equals(sender));
client clr = CS.Get(x => x.email.Equals(email));
ConversationUsersService CUS = new ConversationUsersService();
IEnumerable <conversation_user> conversationsuserslist = CUS.GetMany();
ConversationService COS = new ConversationService();
IEnumerable <conversation> conversationslist = COS.GetMany();
conversation c0 = null;
int s = 0;
foreach (conversation c in conversationslist)
{
s = 0;
foreach (conversation_user cu in conversationsuserslist)
{
if (cu.Conversation_idConversation == c.idConversation && (cu.participants_idUser == cls.idUser || cu.participants_idUser == clr.idUser))
{
s++;
}
}
if (s > 1)
{
c0 = c;
break;
}
}
if (c0 == null)
{
c0 = new conversation
{
startDate = DateTime.Now
};
conversation_user cu1 = new conversation_user
{
conversation = c0,
Conversation_idConversation = c0.idConversation,
participants_idUser = cls.idUser
};
conversation_user cu2 = new conversation_user
{
conversation = c0,
Conversation_idConversation = c0.idConversation,
participants_idUser = clr.idUser
};
c0.conversation_user.Add(cu1);
c0.conversation_user.Add(cu2);
COS.Add(c0);
COS.Commit();
}
MessageService MS = new MessageService();
message m = new message
{
content = message,
conversation_idConversation = c0.idConversation,
sendingDate = DateTime.Now,
sender_idUser = cls.idUser
};
message_user mu = new message_user
{
Message_idMessage = m.idMessage,
receivers_idUser = clr.idUser
};
m.message_user.Add(mu);
MS.Add(m);
MS.Commit();
}