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)));
}
