public ActionResult UpdateOrder(int?ID, string str) { CASDatabaseEntities db = new CASDatabaseEntities(); PatientOrderModel dt = new PatientOrderModel(); PatientOrderDetail objOrder = new PatientOrderDetail(); DrugDelivery objDelivery = new DrugDelivery(); var id = Convert.ToInt32(ID); var getData = db.PatientOrderDetails.Where(m => m.PatientOrderID == id).FirstOrDefault(); if (str == "Deliver") { getData.OrderStatus = "Delivered"; objDelivery.PatientOrderID = getData.PatientOrderID; objDelivery.DeliveryDate = DateTime.Today; db.DrugDeliveries.Add(objDelivery); Session["Deliver"] = "Delivered"; } else { getData.OrderStatus = "Rejected"; } dt.OrderStatus = getData.OrderStatus; db.SaveChanges(); return(RedirectToAction("ViewPatientOrders", "Salesperson")); }
public ActionResult ViewOrders() { CASDatabaseEntities db = new CASDatabaseEntities(); List <PatientOrderModel> list = new List <PatientOrderModel>(); PatientOrderModel dt = new PatientOrderModel(); int id = Convert.ToInt32(Session["ID"]); var getDetails = from o in db.PatientOrderDetails join d in db.Drugs on o.DrugID equals d.DrugID where o.PatientID == id select new { d.DrugName, o.OrderNumber, o.OrderDate, o.OrderStatus, o.Quantity }; foreach (var item in getDetails) { list.Add(new PatientOrderModel { DrugName = item.DrugName, OrderNumber = item.OrderNumber, OrderDate = Convert.ToDateTime(item.OrderDate), OrderStatus = item.OrderStatus, Quantity = Convert.ToInt32(item.Quantity) }); } dt.ListOrder = list; return(View(dt)); }
public ActionResult OrderDrugs() { CASDatabaseEntities db = new CASDatabaseEntities(); PatientOrderModel dt = new PatientOrderModel(); List <SelectListItem> list = new List <SelectListItem>(); var getDrugDetails = from d in db.Drugs where d.IsDeleted == false select new { d.DrugID, d.DrugName, }; foreach (var item in getDrugDetails) { list.Add(new SelectListItem { Text = item.DrugName, Value = item.DrugID.ToString() }); } dt.ListDrug = list; return(View(dt)); }
public ActionResult ViewPatientOrders() { CASDatabaseEntities db = new CASDatabaseEntities(); List <PatientOrderModel> list = new List <PatientOrderModel>(); PatientOrderModel dt = new PatientOrderModel(); var getData = from po in db.PatientOrderDetails join d in db.Drugs on po.DrugID equals d.DrugID join p in db.Patients on po.PatientID equals p.PatientID select new { p.FirstName, p.LastName, d.DrugName, po.PatientOrderID, po.OrderNumber, po.OrderDate, po.Quantity, po.OrderStatus }; foreach (var item in getData) { list.Add(new PatientOrderModel { PatientOrderID = item.PatientOrderID, OrderNumber = item.OrderNumber, DrugName = item.DrugName, PatientName = item.FirstName + " " + item.LastName, Quantity = Convert.ToInt32(item.Quantity), OrderStatus = item.OrderStatus, OrderDate = Convert.ToDateTime(item.OrderDate) }); } dt.ListOrder = list; return(View(dt)); }
public ActionResult OrderDrugs(PatientOrderModel dt) { CASDatabaseEntities db = new CASDatabaseEntities(); PatientOrderDetail objOrder = new PatientOrderDetail(); Random random = new Random(); List <SelectListItem> list = new List <SelectListItem>(); var getDrugDetails = from d in db.Drugs where d.IsDeleted == false select new { d.DrugID, d.DrugName, }; foreach (var item in getDrugDetails) { list.Add(new SelectListItem { Text = item.DrugName, Value = item.DrugID.ToString() }); } dt.ListDrug = list; var getQuantity = db.Drugs.Where(m => m.DrugID == dt.DrugID).FirstOrDefault(); dt.QuantityAvailable = getQuantity.QOH; dt.QuantityType = getQuantity.QOHType; dt.DrugID = getQuantity.DrugID; var getSales = db.Salespersons.SingleOrDefault(); dt.SalespersonID = getSales.SalespersonID; if (ModelState.IsValid) { if (dt.Quantity == 0) { ViewBag.text = "Quantity Must Not be Zero."; } else if (dt.Quantity <= dt.QuantityAvailable) { objOrder.DrugID = dt.DrugID; objOrder.Quantity = dt.Quantity; objOrder.OrderNumber = random.Next(); objOrder.OrderDate = DateTime.Today; objOrder.OrderStatus = "Requested"; objOrder.PatientID = Convert.ToInt32(Session["ID"]); objOrder.SalespersonID = dt.SalespersonID; db.PatientOrderDetails.Add(objOrder); getQuantity.QOH -= dt.Quantity; if (getQuantity.QOH == 0) { getQuantity.IsDeleted = true; } db.SaveChanges(); ViewBag.text = "Order Successfully Placed"; } else if (dt.Quantity > dt.QuantityAvailable) { ViewBag.text = "Quantity Exceeded"; } } return(View(dt)); }