public ActionResult IndexE() { MedicineDB dbhandle = new MedicineDB(); ModelState.Clear(); return(View(dbhandle.GetLogins())); }
public int[] GetQuantityAvailable() { MedicineDB db = new MedicineDB(); IEnumerable <Medication> meds = GetMedications(); int[] qtys = new int[1000]; foreach (Medication md in meds) { IEnumerable <int> qty = from tr in db.UserTransactions where tr.Med.ID == md.ID select tr.Quantity; if (qty.Count() == 0) { qtys[md.ID] = 0; } else { qtys[md.ID] = qty.Sum(); } } return(qtys); }
public void LoadRows() { using (MedicineDB db = new MedicineDB()) { UserTransaction trans1 = new UserTransaction { Quantity = 10, CreatedByDate = new DateTime(2018, 04, 20), // CreatedByUser = new AppUser { Name = "Person1" }, // ModifiedByUser = new AppUser { Name = "Person2" }, Med = new Medication { Description = "Description One", AlertThreshold = 5 } }; UserTransaction trans2 = new UserTransaction { Quantity = 10, CreatedByDate = new DateTime(2018, 06, 10), // CreatedByUser = new AppUser { Name = "Person3" }, // ModifiedByUser = new AppUser { Name = "Person4" }, Med = new Medication { Description = "Description Two", AlertThreshold = 6 } }; db.UserTransactions.Add(trans1); db.UserTransactions.Add(trans2); db.SaveChanges(); } }
public IEnumerable <Medication> GetMedications() { MedicineDB db = new MedicineDB(); IEnumerable <Medication> meds = from m in db.Medications select m; return(meds); }
public IEnumerable <UserTransaction> GetTransactions() { MedicineDB db = new MedicineDB(); IEnumerable <UserTransaction> Trans = from tr in db.UserTransactions select tr; return(Trans); }
public ActionResult Edit(int id, Medicine login) { try { MedicineDB db = new MedicineDB(); db.UpdateDetails(login); return(RedirectToAction("Index")); } catch (Exception e) { return(View()); } }
public ActionResult Delete(int id) { try { MedicineDB db = new MedicineDB(); if (db.DeleteUser(id)) { ViewBag.AlertMsg = "Medicine Deleted Successfully"; } return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Create(Medicine login) { try { if (ModelState.IsValid) { MedicineDB db = new MedicineDB(); if (db.AddMedicine(login)) { ViewBag.Message = "Medicine Added Successfully"; ModelState.Clear(); } } return(View()); } catch { return(View()); } }
public void AddTrans(Params prms) { MedicineDB db = new MedicineDB(); UserTransaction UserTrans = new UserTransaction(); IEnumerable <Medication> md = from m in db.Medications where m.ID == prms.ID select m; Medication med = md.ElementAt(0); UserTrans.Quantity = prms.Quantity; UserTrans.CreatedByDate = DateTime.Now; UserTrans.CreatedById = db.Users.Find(User.Identity.GetUserId()); UserTrans.Med = med; db.UserTransactions.Add(UserTrans); db.SaveChanges(); }
public ActionResult Edit(int id) { MedicineDB db = new MedicineDB(); return(View(db.GetLogins().Find(smodel => smodel.DrugID == id))); }