public Refill(Prescription prescription)
{
PrescriptionId = prescription.PrescriptionId;
Refilled = false;
RefillIt = false;
var notification = Notification.CreateNotification(prescription.PrescriptionDateFilled.AddDays(prescription.PrescriptionDaysSupply - 2), prescription.PatientId, Notification.NotificationType.Refill);
DatabaseNotificationService.Insert(notification);
}
//Sends test emails with working callbacks to the email specified
public string SendTestEmail()
{
var u = new User();
var p = new Patient();
var n = new Notification();
var pr = new Prescription();
var r = new Refill();
u.Email = "*****@*****.**"; // PUT YOUR EMAIL HERE TO TEST
u.FirstName = "Test";
u.LastName = "User";
u.Phone = "+14055555555";
u.UserId = DatabaseUserService.Insert(u);
p.UserId = u.UserId;
p.PharmacyId = 1;
p.DateOfBirth = DateTime.Now;
p.PreferedContactTime = DateTime.Now;
p.ContactMethod = Patient.PrimaryContactMethod.Email;
p.PersonCode = "0";
p.SendBirthdayMessage = true;
p.SendRefillMessage = true;
p.PatientId = DatabasePatientService.Insert(p);
pr.PatientId = p.PatientId;
pr.PrescriptionDaysSupply = 30;
pr.PrescriptionRefills = 3;
pr.PrescriptionName = "Tylenol";
pr.PrescriptionNumber = 1;
pr.PrescriptionUpc = "ABC123";
pr.PrescriptionDateFilled = DateTime.Now;
pr.PrescriptionId = DatabasePrescriptionService.Insert(pr);
r.RefillIt = false;
r.PrescriptionId = pr.PrescriptionId;
r.Refilled = false;
r.RefillDate = DateTime.Now;
r.RefillId = DatabaseRefillService.Insert(r);
n.PatientId = p.PatientId;
n.Type = Notification.NotificationType.Refill;
n.NotificationMessage = "This is a test email for a refill";
n.ScheduledTime = DateTime.Now;
n.SentTime = null;
n.Sent = false;
n.NotificationId = DatabaseNotificationService.Insert(n);
EmailService.SendNotification(n);
EmailService.SendReset(u);
return("Sent an notification and reset email to test account");
}
public ActionResult UploadRecalls(HttpPostedFileBase upload, string recallMessage)
{
var pharm = DatabasePharmacyService.GetById((long)Session["pharm_id"]);
pharm.GetTemplates();
if (ModelState.IsValid)
{
if (upload != null && upload.ContentLength > 0)
{
if (upload.FileName.EndsWith(".csv"))
{
var stream = upload.InputStream;
var csvTable = new DataTable();
using (var csvReader =
new CsvReader(new StreamReader(stream), true))
{
csvTable.Load(csvReader);
}
foreach (DataRow row in csvTable.Rows)
{
var patient = new Patient {
FirstName = row["PatientFirstName"].ToString(),
LastName = row["PatientLastName"].ToString(),
Phone = row["Phone"].ToString(),
PharmacyId = 1,
DateOfBirth = DateTime.Now,
Email = "*****@*****.**",
ContactMethod = Patient.PrimaryContactMethod.Call,
PreferedContactTime = DateTime.Now,
PersonCode = row["PersonCode"].ToString()
};
var id = DatabaseUserService.Insert(patient);
patient.UserId = id;
patient.PatientId = DatabasePatientService.Insert(patient);
var notification = new Notification(DateTime.Now, patient.PatientId, Notification.NotificationType.Recall, recallMessage);
DatabasePatientService.Disable(patient.PatientId);
DatabaseNotificationService.Insert(notification);
}
}
else
{
ModelState.AddModelError("File", "This file format is not supported");
return(View(pharm));
}
}
else
{
ModelState.AddModelError("File", "Please Upload Your file");
}
}
return(View(pharm));
}
public static bool SendFilledNotification(Refill refill)
{
var n = new Notification(refill, Notification.NotificationType.Ready);
var p = DatabasePrescriptionService.GetById(refill.PrescriptionId);
n.PatientId = p.PatientId;
System.Diagnostics.Debug.WriteLine(n.PatientId);
n.NotificationId = DatabaseNotificationService.Insert(n);
var pat = Patient.PatientDict[n.PatientId];
var twilio = new TwilioApi(pat.getPharmacy());
SendNotification(n, twilio);
return(true);
}