public ActionResult ViewOrderDetails() { int mid = Convert.ToInt32(Session["MemberId"]); List <DrugOrderModel> lst = new List <DrugOrderModel>(); using (ProjectEntities db = new ProjectEntities()) { var id = db.Patients.FirstOrDefault(a => a.MemberId == mid); int pid = id.PatientId; var getdata = db.PatientOrderDetails.Where(a => a.PatientId == pid); foreach (var item in getdata) { lst.Add(new DrugOrderModel { DrugId = item.DrugId, DrugName = item.Drug.DrugName, OrderNumber = Convert.ToInt32(item.OrderNumber), Quantity = Convert.ToInt32(item.Quantity), OrderDate = Convert.ToDateTime(item.OrderedDate), OrderStatus = item.OrderStatus }); } } DrugOrderModel model = new DrugOrderModel(); model.lstDrugOrder = lst; return(View(model)); }
public ActionResult Add(int id, FormCollection collection) { try { // TODO: Add update logic here int ElementsToDiscount = int.Parse(collection["add"]); if (ElementsToDiscount <= Storage.Instance.drugList.ElementAt(id - 1).Stock) { int updateStock = Storage.Instance.drugList.ElementAt(id - 1).Stock - ElementsToDiscount; Storage.Instance.drugList.ElementAt(id - 1).Stock = updateStock; var drugExpended = new DrugOrderModel { Name = collection["name"], Address = collection["address"], Nit = collection["nit"], Id = Storage.Instance.drugList.ElementAt(id - 1).Id, DrugName = Storage.Instance.drugList.ElementAt(id - 1).DrugName, Description = Storage.Instance.drugList.ElementAt(id - 1).Description, Producer = Storage.Instance.drugList.ElementAt(id - 1).Producer, Price = Storage.Instance.drugList.ElementAt(id - 1).Price, Stock = ElementsToDiscount, Total = Storage.Instance.drugList.ElementAt(id - 1).Price *ElementsToDiscount, }; if (updateStock == 0) { DrugModel.Delete(Storage.Instance.drugList.ElementAt(id - 1).DrugName); } Storage.Instance.drugCartList.Add(drugExpended); return(RedirectToAction("Cart")); } else { return(View("ErrorMessage")); } //CALL HERE FUNCTION TO DELETE FROM TREE IF NO STOCK LEFT. } catch { return(View("ErrorMessage")); } }
public ActionResult PostOrderDetail(DrugOrderModel model) { using (ProjectEntities db = new ProjectEntities()) { if (model.SupplierId != 0) { // insert db.InsertDrugDelivery(model.OrderId, model.SupplierId, null); return(Json("assigned")); } else { return(Json("Choose Supplier")); } } }
public ActionResult PostDrugOrder(DrugOrderModel model) { int mid = Convert.ToInt32(Session["MemberId"]); int year = Convert.ToInt32(DateTime.Now.Year); int month = Convert.ToInt32(DateTime.Now.Month); int minute = Convert.ToInt32(DateTime.Now.Minute); int ordernumber = Convert.ToInt32(string.Format("{0}{1}{2}", year, month, minute)); string orderstatus = "Requested"; using (ProjectEntities db = new ProjectEntities()) { var id = db.Patients.FirstOrDefault(a => a.MemberId == mid); int pid = id.PatientId; if (model.DrugName != "Select") { // insert db.InsertPatientDrugOrder(pid, model.DrugId, ordernumber, model.Quantity, DateTime.Now, orderstatus); ViewBag.Message = "Order Successful"; } else { ViewBag.Message = "Please Select Drug to be Ordered"; } } List <SelectListItem> lst = new List <SelectListItem>(); using (ProjectEntities db = new ProjectEntities()) { var getdata = db.Drugs.ToList(); foreach (var item in getdata) { lst.Add(new SelectListItem { Value = item.DrugId.ToString(), Text = item.DrugName }); } } DrugOrderModel model1 = new DrugOrderModel(); model1.lstDrugName = lst; return(View("RaiseDrugOrder", model1)); }
public ActionResult Index(FormCollection collection) { try { var drugName = collection["search"]; Storage.Instance.drugOrderList.Clear(); int drugPosition = DrugModel.Search(drugName) - 1; DrugOrderModel drugFound = Storage.Instance.drugList.ElementAt(drugPosition); Storage.Instance.drugOrderList.Add(drugFound); return(View(Storage.Instance.drugOrderList)); } catch { return(View("ErrorMessage")); } }
public ActionResult PostOrderDetail(DrugOrderModel model) { using (ProjectEntities db = new ProjectEntities()) { if (model.Decision != null) { if (model.Decision == "Dispatched") { var getdata = db.PatientOrderDetails.SingleOrDefault(a => a.OrderId == model.OrderId); string status = getdata.OrderStatus; if (status != "Dispatched") { db.UpdatePatientOrderDetails(model.OrderId, model.Decision); return(Json("Item Dispatched")); } else { return(Json("Oops! Item has already been Dispatched")); } } else { var getdata = db.PatientOrderDetails.SingleOrDefault(a => a.OrderId == model.OrderId); string status = getdata.OrderStatus; if (status == "Dispatched") { db.UpdatePatientOrderDetails(model.OrderId, model.Decision); db.UpdateDrugDelivery(model.OrderId, DateTime.Now); return(Json("Item Delivered")); } else { return(Json("Ooops ! Item has not been Dispatched yet")); } } } else { return(Json("Please Choose Your Decision")); } } }
public ActionResult ViewOrderDetail() { List <SelectListItem> lstsup = new List <SelectListItem>(); List <DrugOrderModel> lst = new List <DrugOrderModel>(); using (ProjectEntities db = new ProjectEntities()) { var data = db.Suppliers.ToList(); // ddl supplier populated here foreach (var item in data) { lstsup.Add(new SelectListItem { Value = item.SupplierId.ToString(), Text = item.FirstName }); } var getdata = db.PatientOrderDetails.ToList(); // table record updated here foreach (var item in getdata) { lst.Add(new DrugOrderModel { OrderId = item.OrderId, PatientId = item.PatientId, PatientName = item.Patient.FirstName, DrugId = item.DrugId, DrugName = item.Drug.DrugName, OrderNumber = Convert.ToInt32(item.OrderNumber), Quantity = Convert.ToInt32(item.Quantity), OrderDate = Convert.ToDateTime(item.OrderedDate) }); } } DrugOrderModel model = new DrugOrderModel(); // passing all records collected above to model model.lstDrugOrder = lst; model.lstSupplier = lstsup; return(View(model)); }
public ActionResult RaiseDrugOrder() { List <SelectListItem> lst = new List <SelectListItem>(); using (ProjectEntities db = new ProjectEntities()) { var getdata = db.Drugs.ToList(); foreach (var item in getdata) { lst.Add(new SelectListItem { Value = item.DrugId.ToString(), Text = item.DrugName }); } } DrugOrderModel model = new DrugOrderModel(); model.lstDrugName = lst; return(View(model)); }
public ActionResult ViewPatientOrder() { int mid = Convert.ToInt32(Session["MemberId"]); List <DrugOrderModel> lst = new List <DrugOrderModel>(); using (ProjectEntities db = new ProjectEntities()) { var data = db.Suppliers.SingleOrDefault(a => a.MemberId == mid); int sid = data.SupplierId; var getdata = (from dd in db.DrugDeliveries join pod in db.PatientOrderDetails on dd.OrderId equals pod.OrderId join p in db.Patients on pod.PatientId equals p.PatientId join d in db.Drugs on pod.DrugId equals d.DrugId where dd.SupplierId == sid select new { p.FirstName, p.Address, pod.OrderId, pod.OrderNumber, pod.Quantity, d.DrugName, pod.OrderedDate }).ToList(); foreach (var item in getdata) { lst.Add(new DrugOrderModel { OrderId = item.OrderId, OrderNumber = Convert.ToInt32(item.OrderNumber), PatientName = item.FirstName, DrugName = item.DrugName, Address = item.Address, Quantity = Convert.ToInt32(item.Quantity), OrderDate = Convert.ToDateTime(item.OrderedDate) }); } } DrugOrderModel model = new DrugOrderModel(); model.lstDrugOrder = lst; return(View(model)); }
public ActionResult CSV(HttpPostedFileBase postedfile) { string FilePath; if (postedfile != null) { string Path = Server.MapPath("~/Data/"); if (!Directory.Exists(Path)) { Directory.CreateDirectory(Path); } FilePath = Path + System.IO.Path.GetFileName(postedfile.FileName); postedfile.SaveAs(FilePath); string csvData = System.IO.File.ReadAllText(FilePath); csvData.Split(); foreach (string row in csvData.Split('\n')) { if (!string.IsNullOrEmpty(row)) { try { Regex regx = new Regex("," + "(?=(?:[^\"]*\"[^\"]*\")*(?![^\"]*\"))"); string[] line = regx.Split(row); string price = Convert.ToString(regx.Split(row)[4]); price = price.Substring(1, price.Length - 1); var drug = new DrugOrderModel { Id = Convert.ToInt32(regx.Split(row)[0]), DrugName = line[1], Description = line[2], Producer = line[3], Price = Convert.ToDouble(price), Stock = Convert.ToInt32(regx.Split(row)[5]), }; //SAVE MEDICINE ON THE LIST Storage.Instance.drugList.Add(drug); } catch { } } } using (var fileStream = new FileStream(FilePath, FileMode.Open)) { using (var streamReader = new StreamReader(fileStream)) { streamReader.ReadLine(); while (!streamReader.EndOfStream) { var row = streamReader.ReadLine(); Regex regx = new Regex("," + "(?=(?:[^\"]*\"[^\"]*\")*(?![^\"]*\"))"); string[] line = regx.Split(row); var drug = new DrugModel { Id = Convert.ToInt32(line[0]), Name = line[1], }; //SAVE MEDICINE ON THE TREE DrugModel.Add(drug); } } } } return(View()); }
// GET: DrugOrder/Add/5 public ActionResult Add(int id) { DrugOrderModel drugToAdd = Storage.Instance.drugList.ElementAt(id - 1); return(View(drugToAdd)); }