// GET: POrderFills/PharmacyCreate
public ActionResult PharmacyCreate(int?id)
{
var manager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(new ApplicationDbContext()));
var currentUser = manager.FindById(User.Identity.GetUserId());
var pOrders = db.POrders.Include(p => p.Pharmacy).Include(p => p.Prescript).Where(p => p.PharmacyId == currentUser.Pharmacist.PharmacyId).Where(p => p.Accept == true);
POrder porder = db.POrders.Find(id);
POrderFill model = new POrderFill();
ViewData["porder"] = porder;
var inventories = db.Inventories.Where(i => i.PharmacyId == currentUser.Pharmacist.PharmacyId).Where(i => i.ItemId == porder.Prescript.ItemId).Where(i => i.Amount >= porder.Prescript.Disp).ToList();
IEnumerable <SelectListItem> selectList = from i in inventories
select new SelectListItem
{
Value = i.InventoryId.ToString(),
Text = string.Format("{0} {1} {2}", i.Brand, i.item.Name, i.DispType)
};
ViewBag.InventoryId = new SelectList(selectList, "Value", "Text");
model.POrderId = porder.POrderId;
return(View(model));
}
public ActionResult PorderCreateRefill([Bind(Include = "POrderId,PrescriptId,PharmacyId,DateOrdered,Note,Fill,Deny,Accept")] POrder pOrder)
{
pOrder.DateOrdered = System.DateTime.Now;
pOrder.Deny = false;
pOrder.Fill = false;
pOrder.Accept = false;
POrderFill pOrderFillCheck = new POrderFill();
pOrderFillCheck = db.POrderFills.Where(p => p.POrder.PrescriptId == pOrder.PrescriptId).First();
pOrder.Refill = true;
int pharmacy = pOrderFillCheck.POrder.PharmacyId;
if (ModelState.IsValid)
{
var prectiptToUpdate = db.Prescripts.Find(pOrder.PrescriptId);
prectiptToUpdate.Sent = true;
db.Entry(prectiptToUpdate).State = EntityState.Modified;
db.POrders.Add(pOrder);
pOrder.Prescript.Ordered = false;
pOrder.PharmacyId = pharmacy;
db.SaveChanges();
return(RedirectToAction("PatientsIndex"));
}
ViewBag.PharmacyId = new SelectList(db.Pharmacies, "PharmacyId", "Name", pOrder.PharmacyId);
ViewBag.PrescriptId = new SelectList(db.Prescripts, "PrescriptId", "DispType", pOrder.PrescriptId);
return(View(pOrder));
}
public ActionResult DeleteConfirmed(int id)
{
POrderFill pOrderFill = db.POrderFills.Find(id);
db.POrderFills.Remove(pOrderFill);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "POrderFillId,POrderId,InventoryId,DateFilled,DatePicked,Note,PhamacistId,Ready")] POrderFill pOrderFill)
{
if (ModelState.IsValid)
{
db.POrderFills.Add(pOrderFill);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.InventoryId = new SelectList(db.Inventories, "InventoryId", "DispType", pOrderFill.InventoryId);
ViewBag.POrderId = new SelectList(db.POrders, "POrderId", "Note", pOrderFill.POrderId);
return(View(pOrderFill));
}
// GET: POrderFills/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
POrderFill pOrderFill = db.POrderFills.Find(id);
if (pOrderFill == null)
{
return(HttpNotFound());
}
return(View(pOrderFill));
}
// GET: POrderFills/PharmacyPickup/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
POrderFill pOrderFill = db.POrderFills.Find(id);
if (pOrderFill == null)
{
return(HttpNotFound());
}
ViewBag.InventoryId = new SelectList(db.Inventories, "InventoryId", "DispType", pOrderFill.InventoryId);
ViewBag.POrderId = new SelectList(db.POrders, "POrderId", "Note", pOrderFill.POrderId);
return(View(pOrderFill));
}
public ActionResult Edit([Bind(Include = "POrderFillId,POrderId,InventoryId,DateFilled,DatePicked,Note,PhamacistId,Ready")] POrderFill pOrderFill)
{
pOrderFill.DatePicked = System.DateTime.Now;
pOrderFill.Ready = false;
POrder pOrder = db.POrders.Find(pOrderFill.POrderId);
pOrder.Deny = true;
pOrder.Prescript.Ordered = true;
if (ModelState.IsValid)
{
db.Entry(pOrder).State = EntityState.Modified;
db.Entry(pOrderFill).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("PharmacyIndex", "Patients"));
}
ViewBag.InventoryId = new SelectList(db.Inventories, "InventoryId", "DispType", pOrderFill.InventoryId);
ViewBag.POrderId = new SelectList(db.POrders, "POrderId", "Note", pOrderFill.POrderId);
return(View(pOrderFill));
}
public ActionResult PharmacyCreate([Bind(Include = "POrderFillId,POrderId,InventoryId,DateFilled,DatePicked,Note,PhamacistId,Ready")] POrderFill pOrderFill)
{
var manager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(new ApplicationDbContext()));
var currentUser = manager.FindById(User.Identity.GetUserId());
int?value = currentUser.PharmacistId;
pOrderFill.PhamacistId = value;
pOrderFill.DateFilled = System.DateTime.Now;
POrder pOrder = db.POrders.Find(pOrderFill.POrderId);
pOrder.Fill = true;
pOrder.Prescript.RefillsUsed += 1;
Inventory inventory = db.Inventories.Find(pOrderFill.InventoryId);
inventory.Amount = inventory.Amount - pOrder.Prescript.Disp;
pOrderFill.Ready = true;
string orderNum = pOrderFill.POrderFillId.ToString();
string patientEmail = pOrder.Prescript.Patient.Email.ToString();
if (ModelState.IsValid)
{
//Email Notification
string senderEmail = System.Configuration.ConfigurationManager.AppSettings["SenderEmail"].ToString();
string senderPassword = System.Configuration.ConfigurationManager.AppSettings["SenderPassword"].ToString();
SmtpClient client = new SmtpClient("smtp-mail.outlook.com", 587);
client.EnableSsl = true;
client.Timeout = 100000;
client.DeliveryMethod = SmtpDeliveryMethod.Network;
client.UseDefaultCredentials = false;
NetworkCredential loginInfo = new NetworkCredential(senderEmail, senderPassword);
client.Credentials = loginInfo;
string toEmail = patientEmail;
string subject = "Your order is ready - #" + orderNum;
string body = "<p> Hello " + pOrder.Prescript.Patient.FirstName + ",<br/> Your prescription order is ready for pickup <br />Order #" + orderNum + "<br /> <a href='http://pharm4metest.azurewebsites.net/'>Pharm4me</a><br /><br /> " + pOrder.Pharmacy.Name + "</p>";
MailMessage mailMessage = new MailMessage(senderEmail, toEmail, subject, body);
mailMessage.IsBodyHtml = true;
mailMessage.BodyEncoding = UTF8Encoding.UTF8;
client.Send(mailMessage);
db.Entry(inventory).State = EntityState.Modified;
db.Entry(pOrder).State = EntityState.Modified;
db.POrderFills.Add(pOrderFill);
db.SaveChanges();
return(RedirectToAction("PharmacyIndex"));
}
ViewBag.InventoryId = new SelectList(db.Inventories, "InventoryId", "DispType", pOrderFill.InventoryId);
ViewBag.POrderId = new SelectList(db.POrders, "POrderId", "Note", pOrderFill.POrderId);
return(View(pOrderFill));
}