public ChatHub()
{
_db = new OMCSDBContext();
business = new ConversationBusiness(_db);
helper = new ChatHubHelper(_db);
Doctors = helper.GetListDoctors();
}
public ConversationController()
{
business = new ConversationBusiness(_db);
}
public void ConnectDoctor(string username)
{
business = new ConversationBusiness(_db);
var id = Context.ConnectionId;
var doctor = _db.Doctors.Where(x=>x.Username.Equals(username)).FirstOrDefault();
var doctorDetail = Doctors.Where(x => x.Username.Equals(username)).FirstOrDefault();
//Update Doctor list status
if (doctorDetail == null)
{
doctorDetail = new DoctorDetail
{
ConnectionId = id,
CountMessageUnRead = business.CountMessageUnRead(doctor),
ProfilePicture = doctor.ProfilePicture,
IsOnline = doctor.IsOnline,
FullName = doctor.FullName,
Username = doctor.Username,
SpeciatyField = doctor.SpecialtyField.Name
};
Doctors.Add(doctorDetail);
}
else
{
doctorDetail.CountMessageUnRead = business.CountMessageUnRead(doctor);
doctorDetail.IsOnline = doctor.IsOnline;
}
//Add User
UserDetail userDetail = new UserDetail
{
ConnectionId = id,
CountMessageUnRead = business.CountMessageUnRead(doctor),
ProfilePicture = doctor.ProfilePicture,
FullName = doctor.FullName,
Username = doctor.Username,
};
//Show List of Lastest contact
var userDetailList = new List<UserDetail>();
var conversations = _db.Conversations.Where(
x => x.DoctorId == doctor.UserId).
OrderByDescending(x=>x.LatestTimeFromPatient
).ToList();
foreach (var conversation in conversations)
{
var existUser = userDetailList.Where
(x => x.Username == conversation.Patient.Username).FirstOrDefault();
if (existUser == null)
{
//Check user online or not
var connectedUser = ConnectedUsers.Where
(x => x.Username == conversation.Patient.Username).FirstOrDefault();
var IsOnline = (connectedUser != null && connectedUser.IsOnline) ? true: false;
UserDetail userDetailCon = new UserDetail
{
FullName = conversation.Patient.FullName,
LastestContent = conversation.LatestContentFromPatient,
LastestTime = conversation.LatestTimeFromPatient,
ProfilePicture = conversation.Patient.ProfilePicture,
Username = conversation.Patient.Username,
IsRead = conversation.IsRead,
IsOnline = IsOnline
};
userDetailList.Add(userDetailCon);
}
}
ConnectedUsers.Add(userDetail);
Debug.WriteLine("Size of userDetailList: " + userDetailList.Count);
// send to all except caller client
Clients.Caller.onGetConversationList(userDetailList);
Clients.AllExcept(id).onGetDoctorList(Doctors);
}
public void SendMessageTo(string toUsername, string message)
{
business = new ConversationBusiness(_db);
Debug.WriteLine(toUsername + " " + message);
var id = Context.ConnectionId;
var fromUserDetail = ConnectedUsers.Where(x => x.ConnectionId == id).FirstOrDefault();
var fromUser = _db.Users.Where(x => x.Username.Equals(fromUserDetail.Username)).FirstOrDefault();
var toUser = _db.Users.Where(x => x.Username.Equals(toUsername)).FirstOrDefault();
var toUserDetail = ConnectedUsers.Where(x => x.Username.Equals(toUsername)).FirstOrDefault();
var doctor = _db.Doctors.Where(u => u.Username.Equals(fromUser.Username)).FirstOrDefault();
var patient = new Patient();
if (doctor == null)
{
doctor = _db.Doctors.Where(u => u.Username.Equals(toUser.Username)).FirstOrDefault();
patient = _db.Patients.Where(u => u.Username.Equals(fromUser.Username)).FirstOrDefault();
}
else
{
patient = _db.Patients.Where(u => u.Username.Equals(toUser.Username)).FirstOrDefault();
}
if (doctor != null && patient != null)
{
//Store in database
Conversation conversation = _db.Conversations.Where(
x => (x.PatientId == patient.UserId && x.DoctorId == doctor.UserId))
.OrderByDescending(x => x.DateConsulted).FirstOrDefault();
Debug.WriteLine("DoctorId = " + toUser.UserId, " PatientId = " + fromUser.UserId);
if (conversation == null)
{
conversation = new Conversation
{
DoctorId = toUser.UserId,
PatientId = fromUser.UserId,
DateConsulted = DateTime.Now,
LatestTimeFromDoctor = DateTime.Now,
LatestTimeFromPatient = DateTime.Now
};
_db.Conversations.Add(conversation);
}
conversation.LatestTimeFromPatient = DateTime.Now;
conversation.LatestContentFromPatient = message;
conversation.IsRead = false;
ConversationDetail conversationDetail = new ConversationDetail
{
UserId = fromUser.UserId,
Content = message,
Conversation = conversation,
CreatedDate = DateTime.Now,
IsRead = false
};
MessageDetail messageDetail = new MessageDetail
{
Content = message,
Username = fromUser.Username,
CreatedDate = String.Format("{0:H:mm:ss}", DateTime.Now),
IsRead = false
};
_db.ConversationDetails.Add(conversationDetail);
_db.SaveChanges();
//Notify Receiver
var receivers = ConnectedUsers.Where(x => x.Username == toUsername).ToList();
if (receivers != null)
{
foreach (var receiver in receivers)
{
receiver.CountMessageUnRead = business.CountMessageUnRead(toUser);
if (receiver != null && receiver.ConnectionId != null)
Clients.Client(receiver.ConnectionId).messageReceived(fromUserDetail, toUserDetail, messageDetail);
}
}
//Notify Caller
Clients.Caller.messageReceived(fromUserDetail, toUserDetail, messageDetail);
}
}
public void GetMessageList(string username)
{
business = new ConversationBusiness(_db);
var id = Context.ConnectionId;
var fromUserDetail = ConnectedUsers.Where(x => x.ConnectionId == id).FirstOrDefault();
var fromUser = _db.Users.Where(x => x.Username.Equals(fromUserDetail.Username)).FirstOrDefault();
var toUser = _db.Users.Where(x => x.Username.Equals(username)).FirstOrDefault();
var toUserDetail = ConnectedUsers.Where(x => x.Username.Equals(username)).FirstOrDefault();
//Check if toUserDetail is not online yet
if (toUserDetail == null)
{
toUserDetail = new UserDetail
{
FullName = toUser.FullName,
Username = toUser.Username,
IsOnline = false,
ProfilePicture = toUser.ProfilePicture
};
}
var doctor = _db.Doctors.Where(u => u.Username.Equals(fromUser.Username)).FirstOrDefault();
var patient = new Patient();
if (doctor == null)
{
doctor = _db.Doctors.Where(u => u.Username.Equals(toUser.Username)).FirstOrDefault();
patient = _db.Patients.Where(u => u.Username.Equals(fromUser.Username)).FirstOrDefault();
}
else
{
patient = _db.Patients.Where(u => u.Username.Equals(toUser.Username)).FirstOrDefault();
}
if (doctor != null && patient != null)
{
Debug.WriteLine("Patient: " + patient.Username + " " + "Doctor: " + doctor.Username);
DoctorDetail doctorDetail = Doctors.Where(u => u.Username.Equals(doctor.Username)).FirstOrDefault();
var newestConversation = _db.Conversations.Where(
con => (con.PatientId == patient.UserId) && (con.DoctorId == doctor.UserId))
.OrderByDescending(con => con.DateConsulted).FirstOrDefault();
if (newestConversation != null)
{
var conversationDetails = _db.ConversationDetails.Where(cd => cd.Conversation.ConversationId == newestConversation.ConversationId).
OrderBy(cd => cd.CreatedDate).ToList();
//Convert conversationDetails to MessageDetails
var messageDetails = new List<MessageDetail>();
foreach (var conversationDetail in conversationDetails)
{
String date = (DateTime.Now.Subtract(conversationDetail.CreatedDate).Days) > 1 ?
String.Format("{0:HH:mm:ss}", conversationDetail.CreatedDate) :
String.Format("{0:dd/mm/yyyy HH:mm:ss}", conversationDetail.CreatedDate);
MessageDetail messageDetail = new MessageDetail
{
Content = conversationDetail.Content,
CreatedDate = date,
Username = conversationDetail.User.Username,
IsRead = conversationDetail.IsRead
};
messageDetails.Add(messageDetail);
}
Debug.WriteLine(messageDetails.Count);
if (fromUserDetail.Username.Equals(doctor.Username))
{
business.MarkConversationAsRead(newestConversation);
this.ConnectDoctor(doctor.Username);
}
Clients.Caller.onGetMessageList(fromUserDetail, toUserDetail, messageDetails);
}
else
{
Clients.Caller.onGetMessageList(fromUserDetail, toUserDetail, "");
}
}
}
public void ConnectPatient(string username)
{
business = new ConversationBusiness(_db);
var id = Context.ConnectionId;
var userDetail = ConnectedUsers.Where(x => x.Username.Equals(username)).FirstOrDefault();
if (userDetail == null)
{
var user = _db.Users.Where(x => x.Username.Equals(username)).FirstOrDefault();
ConnectedUsers.Add(new UserDetail { ConnectionId = id,
Username = username, CountMessageUnRead = 0,
FullName = user.FullName, ProfilePicture = user.ProfilePicture,
IsOnline = true
});
var DoctorListDB = _db.Doctors.ToList();
foreach (var doctor in DoctorListDB)
{
if (Doctors.Where(d => d.Username.Equals(doctor.Username)).FirstOrDefault() == null)
{
DoctorDetail doctorDetail = new DoctorDetail
{
FullName = doctor.FullName,
IsOnline = false,
SpeciatyField = doctor.SpecialtyField.Name,
Username = doctor.Username,
ProfilePicture = doctor.ProfilePicture
};
Doctors.Add(doctorDetail);
}
}
// send to caller
Clients.Caller.onGetDoctorList(Doctors);
}
}
public void SendMessageTo(string toEmail, string message)
{
business = new ConversationBusiness(_db);
var id = Context.ConnectionId;
var fromUserDetail = ConnectedUsers.Where(x => x.ConnectionId == id).FirstOrDefault();
var fromUser = _db.Users.Where(x => x.Email.Equals(fromUserDetail.Email)).FirstOrDefault();
var toUser = _db.Users.Where(x => x.Email.Equals(toEmail)).FirstOrDefault();
var toUserDetail = ConnectedUsers.Where(x => x.Email.Equals(toEmail)).FirstOrDefault();
var doctor = _db.Doctors.Where(u => u.Email.Equals(fromUser.Email)).FirstOrDefault();
var patient = new Patient();
if (doctor == null)
{
doctor = _db.Doctors.Where(u => u.Email.Equals(toUser.Email)).FirstOrDefault();
patient = _db.Patients.Where(u => u.Email.Equals(fromUser.Email)).FirstOrDefault();
}
else
{
patient = _db.Patients.Where(u => u.Email.Equals(toUser.Email)).FirstOrDefault();
}
if (doctor != null && patient != null)
{
//Check if toUserDetail is not online yet
if (toUserDetail == null)
{
toUserDetail = helper.ConvertUserToUserDetail(toUser);
}
helper.SyncUserDetailWhenSendMessage(fromUserDetail, toEmail, message, ConnectedUsers);
MessageDetail messageDetail = helper.SaveMessageToDatabase(fromUser, patient, doctor, message);
//Notify Receiver
var receivers = ConnectedUsers.Where(x => x.Email == toEmail).ToList();
foreach (var receiver in receivers)
{
if (receiver != null && receiver.ConnectionId != null)
{
receiver.CountMessageUnRead = business.CountMessageUnRead(toUser);
Clients.Client(receiver.ConnectionId).messageReceived(fromUserDetail, toUserDetail, messageDetail);
//If receiver is docter
if (toEmail.Equals(doctor.Email)) {
var userDetailList = helper.GetLastestConversationList(receiver.Email, ConnectedUsers);
receiver.ConversationList = userDetailList;
Clients.Client(receiver.ConnectionId).onGetConversationList(receiver.ConversationList);
}
}
}
//Notify Caller
Clients.Caller.messageReceived(fromUserDetail, toUserDetail, messageDetail);
}
}