public List <MyDoctorDataContract> GetDoctorAroundUserList(string username)
{
echelperDBEntities context = new echelperDBEntities();
context.Refresh(System.Data.Objects.RefreshMode.StoreWins, context.Doctor);
context.Refresh(System.Data.Objects.RefreshMode.StoreWins, context.Patient);
List <MyDoctorDataContract> temp = new List <MyDoctorDataContract>();
List <Doctor> tempuser = context.Doctor.ToList();
List <string> keylist = context.Patient.Select(c => c.LiveID).Distinct().ToList();
echelperDBEntities context_ = new echelperDBEntities();
Patient data = context_.GetObjectByKey(new System.Data.EntityKey("echelperDBEntities.Patient", "LiveID", username)) as Patient;
foreach (Doctor i in tempuser)
{
if (i.Status == 1)
{
bool ismy = false;
if (i.Patient.Contains(data))
{
ismy = true;
}
temp.Add(ConvertMyDoctorToDataContract(i, ismy));
}
}
return(temp);
}
public void EmergencyCall(string username, string doctorid, EmergencyMesg mesg)
{
echelperDBEntities context = new echelperDBEntities();
context.Refresh(System.Data.Objects.RefreshMode.StoreWins, context.Patient);
context.Refresh(System.Data.Objects.RefreshMode.StoreWins, context.Doctor);
Patient patient = context.Patient.First(p => p.LiveID == username);
patient.Latitude = mesg.latitude;
patient.Longitude = mesg.longitude;
context.SaveChanges();
Doctor doctor = context.Doctor.First(p => p.LiveID == doctorid);
string toastMessage = "<?xml version=\"1.0\" encoding=\"utf-8\"?>" +
"<wp:Notification xmlns:wp=\"WPNotification\">" +
"<wp:Toast>" +
"<wp:Text0>1</wp:Text0>" +
"<wp:Text1>" + patient.Name + "</wp:Text1>" +
"<wp:Text2>" + patient.Latitude + "</wp:Text2>" +
"<wp:Text3>" + patient.Longitude + "</wp:Text3>" +
"</wp:Toast>" +
"</wp:Notification>";
byte[] strBytes = new UTF8Encoding().GetBytes(toastMessage);
if (doctor.Channel != null)
{
sendNotificationType(strBytes, doctor.Channel);
}
}
public void EmergencyConfirm1(string username, string patientid)
{
echelperDBEntities context = new echelperDBEntities();
context.Refresh(System.Data.Objects.RefreshMode.StoreWins, context.Doctor);
context.Refresh(System.Data.Objects.RefreshMode.StoreWins, context.Patient);
Doctor doctor = context.Doctor.First(p => p.LiveID == username);
Patient patient = context.Patient.First(p => p.LiveID == patientid);
string toastMessage = null;
toastMessage = "<EmergencyConfirm>" +
"<Type>1</Type>" +
"<doctorName>" + doctor.Name + "</doctorName>" +
"<latitude>" + doctor.Longitude + "</latitude>" +
"<longitude>" + doctor.Latitude + "</longitude>" +
"<reply>false</reply>" +
"</EmergencyConfirm>";
byte[] strBytes = new UTF8Encoding().GetBytes(toastMessage);
if (patient.Channel != null)
{
sendWinNotificationType(strBytes, patient.Channel);
}
}
public void BuildDoctorChannel(string username, NoticeUri uri)
{
echelperDBEntities context = new echelperDBEntities();
context.Refresh(System.Data.Objects.RefreshMode.StoreWins, context.Doctor);
Doctor doctor = context.Doctor.First(p => p.LiveID == username);
doctor.Channel = uri.uri;
context.SaveChanges();
}
public void BuildPatientChannel(string username, NoticeUri uri)
{
echelperDBEntities context = new echelperDBEntities();
context.Refresh(System.Data.Objects.RefreshMode.StoreWins, context.Patient);
Patient patient = context.Patient.First(p => p.LiveID == username);
patient.Channel = uri.uri;
context.SaveChanges();
}
public PatientUserDataContract GetPatientUser(string username)
{
echelperDBEntities context = new echelperDBEntities();
context.Refresh(System.Data.Objects.RefreshMode.StoreWins, context.Patient);
List <string> keylist = context.Patient.Select(c => c.LiveID).Distinct().ToList();
echelperDBEntities context_ = new echelperDBEntities();
Patient data = context_.GetObjectByKey(new System.Data.EntityKey("echelperDBEntities.Patient", "LiveID", username)) as Patient;
return(ConvertPatientUserToDataContract(data));
}
public void IsReadMailp(string username, string mailid)
{
echelperDBEntities context = new echelperDBEntities();
context.Refresh(System.Data.Objects.RefreshMode.StoreWins, context.Doctor);
context.Refresh(System.Data.Objects.RefreshMode.StoreWins, context.Mail);
int id = (int)Convert.ToInt32(mailid);
Mail mail = context.Mail.First(p => p.ID == id);
mail.IsRead = 1;
context.SaveChanges();
}
public void UpdatePatientOffline(string username, OnlineStatusDataContract user)
{
echelperDBEntities context = new echelperDBEntities();
context.Refresh(System.Data.Objects.RefreshMode.StoreWins, context.Patient);
Patient patient = context.Patient.First(p => p.LiveID == username);
patient.Latitude = user.Latitude;
patient.Longitude = user.Longtitude;
patient.Status = 0;
context.SaveChanges();
}
public DoctorUserDataContract GetDoctorUser(string username)
{
echelperDBEntities context = new echelperDBEntities();
context.Refresh(System.Data.Objects.RefreshMode.StoreWins, context.Doctor);
//List<string> keylist = context.Doctor.Select(c => c.LiveID).Distinct().ToList();
// echelperDBEntities context_ = new echelperDBEntities();
// Doctor data = context_.GetObjectByKey(new System.Data.EntityKey("echelperDBEntities.Doctor", "LiveID", username)) as Doctor;
Doctor data = context.Doctor.First(p => p.LiveID == username);
return(ConvertDoctorUserToDataContract(data));
}
public void UpdateDoctorOnline(string username, OnlineStatusDataContract user)
{
echelperDBEntities context = new echelperDBEntities();
context.Refresh(System.Data.Objects.RefreshMode.StoreWins, context.Patient);
context.Refresh(System.Data.Objects.RefreshMode.StoreWins, context.Doctor);
Doctor doctor = context.Doctor.First(p => p.LiveID == username);
doctor.Latitude = user.Latitude;
doctor.Longitude = user.Longtitude;
doctor.Status = 1;
context.SaveChanges();
}
public void addDiagnosis(string username, NewMailDataContract temp)
{
echelperDBEntities context = new echelperDBEntities();
context.Refresh(System.Data.Objects.RefreshMode.StoreWins, context.Mail);
context.Refresh(System.Data.Objects.RefreshMode.StoreWins, context.Patient);
context.Refresh(System.Data.Objects.RefreshMode.StoreWins, context.Doctor);
DateTime time = DateTime.Now;
Mail newMail = new Mail();
newMail.PatientID = temp.PatientId;
newMail.DoctorID = temp.DoctorId;
newMail.Title = temp.Title;
newMail.TextContent = temp.TextContent;
newMail.Time = time;
newMail.ECG = temp.ECG;
newMail.FromOrTo = temp.FromOrTo;
newMail.IsRead = 0;
context.AddToMail(newMail);
context.SaveChanges();
// return ConvertMailToDataContract(newMail);
Patient patient = context.Patient.First(p => p.LiveID == temp.PatientId);
int count = 0;
foreach (Mail i in context.Mail)
{
if (i.PatientID == temp.PatientId && i.FromOrTo == 0 && i.IsRead == 0)
{
count++;
}
}
string toastMessage = null;
toastMessage = "<EmergencyConfirm>" +
"<Type>0</Type>" +
"<doctorName>" + count + "</doctorName>" +
"<latitude>0</latitude>" +
"<longitude>0</longitude>" +
"<reply>0</reply>" +
"</EmergencyConfirm>";
byte[] strBytes = new UTF8Encoding().GetBytes(toastMessage);
if (patient.Channel != null)
{
sendWinNotificationType(strBytes, patient.Channel);
}
}
public void addnewMail(string username, NewMailDataContract temp)
{
echelperDBEntities context = new echelperDBEntities();
context.Refresh(System.Data.Objects.RefreshMode.StoreWins, context.Mail);
context.Refresh(System.Data.Objects.RefreshMode.StoreWins, context.Patient);
DateTime time = DateTime.Now;
Mail newMail = new Mail();
newMail.PatientID = temp.PatientId;
newMail.DoctorID = temp.DoctorId;
newMail.Title = temp.Title;
newMail.TextContent = temp.TextContent;
newMail.Time = time;
newMail.ECG = temp.ECG;
newMail.FromOrTo = temp.FromOrTo;
newMail.IsRead = 0;
context.AddToMail(newMail);
context.SaveChanges();
//Patient patient = context.Patient.First(p => p.LiveID == username);
Doctor doctor = context.Doctor.First(p => p.LiveID == temp.DoctorId);
int count = 0;
foreach (Mail i in context.Mail)
{
if (i.DoctorID == temp.DoctorId && i.FromOrTo == 1 && i.IsRead == 0)
{
count++;
}
}
string toastMessage = "<?xml version=\"1.0\" encoding=\"utf-8\"?>" +
"<wp:Notification xmlns:wp=\"WPNotification\">" +
"<wp:Toast>" +
"<wp:Text0>0</wp:Text0>" +
"<wp:Text1>" + count + "</wp:Text1>" +
"<wp:Text2>0</wp:Text2>" +
"<wp:Text3>0</wp:Text3>" +
"</wp:Toast>" +
"</wp:Notification>";
byte[] strBytes = new UTF8Encoding().GetBytes(toastMessage);
if (doctor.Channel != null)
{
sendNotificationType(strBytes, doctor.Channel);
}
//return ConvertMailToDataContract(newMail);
}
public List <MailDataContract> GetPatientMailList(string username)
{
echelperDBEntities context = new echelperDBEntities();
context.Refresh(System.Data.Objects.RefreshMode.StoreWins, context.Patient);
context.Refresh(System.Data.Objects.RefreshMode.StoreWins, context.Mail);
List <MailDataContract> temp = new List <MailDataContract>();
List <Mail> mails = context.Mail.Where(a => a.PatientID == username).ToList();
foreach (Mail i in mails)
{
temp.Add(ConvertMailToDataContract(i));
}
return(temp);
}
public void AddDoctor(string username, string doctorid)
{
echelperDBEntities context = new echelperDBEntities();
context.Refresh(System.Data.Objects.RefreshMode.StoreWins, context.Doctor);
context.Refresh(System.Data.Objects.RefreshMode.StoreWins, context.Patient);
Patient pa = context.Patient.First(p => p.LiveID == username);
Doctor doc = context.Doctor.First(p => p.LiveID == doctorid);
if (!pa.Doctor.Contains(doc) && !doc.Patient.Contains(pa))
{
pa.Doctor.Add(doc);
doc.Patient.Add(pa);
}
context.SaveChanges();
}
public DoctorUserDataContract UpdateDoctorUser(string username, DoctorUserDataContract user)
{
echelperDBEntities context = new echelperDBEntities();
context.Refresh(System.Data.Objects.RefreshMode.StoreWins, context.Doctor);
Doctor doctor = context.Doctor.First(p => p.LiveID == username);
doctor.Name = user.NickName;
doctor.Description = user.Description;
doctor.Phone = user.phone;
doctor.Email = user.email;
// doctor.
context.SaveChanges();
context.Refresh(System.Data.Objects.RefreshMode.StoreWins, doctor);
return(user);
}
public void UpdatePatientUser(string username, PatientUserDataContract user)
{
echelperDBEntities context = new echelperDBEntities();
context.Refresh(System.Data.Objects.RefreshMode.StoreWins, context.Patient);
Patient patient = context.Patient.First(p => p.LiveID.Equals(user.UserName));
patient.Name = user.NickName;
patient.Gender = user.Gender;
patient.Age = user.Age;
patient.Description = user.Description;
patient.Allergy = user.Allery;
context.SaveChanges();
//return user;
//context.Refresh
}
public string GetPatientTempKey(string username)
{
echelperDBEntities context = new echelperDBEntities();
context.Refresh(System.Data.Objects.RefreshMode.StoreWins, context.Patient);
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(
RoleEnvironment.GetConfigurationSettingValue("StorageAccountConnectionString"));
CloudBlobClient blobClient = storageAccount.CreateCloudBlobClient();
CloudBlobContainer container = blobClient.GetContainerReference(username);
container.CreateIfNotExist();
BlobContainerPermissions permissions = new BlobContainerPermissions();
permissions.PublicAccess = BlobContainerPublicAccessType.Off;
container.SetPermissions(permissions);
string sas = container.GetSharedAccessSignature(new SharedAccessPolicy()
{
SharedAccessExpiryTime = DateTime.UtcNow.AddSeconds(60),
Permissions = SharedAccessPermissions.Read | SharedAccessPermissions.Write
});
return(sas);
}
public List <FileListDataContract> GetPatientFileList(string username)
{
echelperDBEntities context = new echelperDBEntities();
context.Refresh(System.Data.Objects.RefreshMode.StoreWins, context.Patient);
List <FileListDataContract> list = new List <FileListDataContract>();
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(
RoleEnvironment.GetConfigurationSettingValue("StorageAccountConnectionString"));
CloudBlobClient blobClient = storageAccount.CreateCloudBlobClient();
CloudBlobContainer container = blobClient.GetContainerReference(username);
container.CreateIfNotExist();
BlobContainerPermissions permissions = new BlobContainerPermissions();
permissions.PublicAccess = BlobContainerPublicAccessType.Off;
foreach (IListBlobItem i in container.ListBlobs())
{
FileListDataContract m = new FileListDataContract();
m.Filename = i.Uri.ToString();
list.Add(m);
}
return(list);
}
