Exemple #1
0
        public ActionResult DeleteConfirmed(int id)
        {
            TMedication tMedication = db.TMedications.Find(id);

            db.TMedications.Remove(tMedication);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
Exemple #2
0
 public ActionResult Edit([Bind(Include = "intMedicationID,strMedicationName,strMedicationDesc,dblCost,dblPrice,strNotes,intQuantity,intMethodID")] TMedication tMedication)
 {
     if (ModelState.IsValid)
     {
         db.Entry(tMedication).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(tMedication));
 }
Exemple #3
0
        public ActionResult Create([Bind(Include = "intMedicationID,strMedicationName,strMedicationDesc,dblCost,dblPrice,strNotes,intQuantity,intMethodID")] TMedication tMedication)
        {
            if (ModelState.IsValid)
            {
                db.TMedications.Add(tMedication);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(tMedication));
        }
Exemple #4
0
        // GET: TMedications/Delete/5
        public ActionResult Delete(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            TMedication tMedication = db.TMedications.Find(id);

            if (tMedication == null)
            {
                return(HttpNotFound());
            }
            return(View(tMedication));
        }
Exemple #5
0
        // GET: TMedications/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            TMedication tMedication = db.TMedications.Find(id);

            if (tMedication == null)
            {
                return(HttpNotFound());
            }
            ViewBag.intMethodID = new SelectList(db.TMethods, "intMethodID", "strMethod");
            return(View(tMedication));
        }
Exemple #6
0
        public ActionResult AddOrder(int id)
        {
            TMedication medication = db.TMedications.Where(x => x.intMedicationID == id).FirstOrDefault();

            OrderMedication orderMedication = new OrderMedication()
            {
                dtmDateOfOrder     = DateTime.Now,
                intMedicationId    = medication.intMedicationID,
                strMedicationName  = medication.strMedicationName,
                dblUnitCost        = medication.dblCost,
                intCurrentQuantity = medication.intQuantity,
                intOrderQuantity   = 0,
                dblTotal           = 0,
                strNotes           = ""
            };

            ViewBag.intMedicationId = new SelectList(db.TMedications, "intMedicationID", "strMedicationName");
            return(View(orderMedication));
        }
Exemple #7
0
        public ActionResult AddOrder(OrderMedication order)
        {
            TMedication medication = db.TMedications.Where(x => x.intMedicationID == order.intMedicationId).FirstOrDefault();

            SqlParameter[] param = new SqlParameter[]
            {
                new SqlParameter("@intMedicationID", medication.intMedicationID),
                new SqlParameter("@strMedicationName", medication.strMedicationName),
                new SqlParameter("@strMedicationDesc", medication.strMedicationDesc),
                new SqlParameter("@dblCost", medication.dblCost),
                new SqlParameter("@dblPrice", medication.dblPrice),
                new SqlParameter("@strNotes", medication.strNotes),
                new SqlParameter("@intQuantity", medication.intQuantity + order.intOrderQuantity),
                new SqlParameter("@intMethodID", medication.intMethodID),
            };

            db.uspAddMedicationOrder(order.dtmDateOfOrder, medication.intMedicationID, medication.strMedicationName, medication.dblCost, order.intOrderQuantity, medication.dblCost * order.intOrderQuantity, order.strNotes);
            db.Database.ExecuteSqlCommand("uspUpdateMedication @intMedicationID, @strMedicationName, @strMedicationDesc,@dblCost, @dblPrice,@strNotes,@intQuantity, @intMethodID ", param);
            return(RedirectToAction("Index"));
        }
        public ActionResult DeletePetMedication(int medicationId)
        {
            TVisitMedication visitMedication = db.TVisitMedications.Where(x => x.intVisitMedicationID == medicationId).FirstOrDefault();
            TMedication      medicationInfo  = db.TMedications.Where(x => x.intMedicationID == medicationId).FirstOrDefault();

            SqlParameter[] param = new SqlParameter[]
            {
                new SqlParameter("@intMedicationID", medicationInfo.intMedicationID),
                new SqlParameter("@strMedicationName", medicationInfo.strMedicationName),
                new SqlParameter("@strMedicationDesc", medicationInfo.strMedicationDesc),
                new SqlParameter("@dblCost", medicationInfo.dblCost),
                new SqlParameter("@dblPrice", medicationInfo.dblPrice),
                new SqlParameter("@strNotes", medicationInfo.strNotes),
                new SqlParameter("@intQuantity", medicationInfo.intQuantity + visitMedication.intQuantity),
                new SqlParameter("@intMethodID", medicationInfo.intMethodID)
            };

            db.Database.ExecuteSqlCommand("uspUpdateMedication @intMedicationID, @strMedicationName, @strMedicationDesc,@dblCost, @dblPrice,@strNotes,@intQuantity, @intMethodID ", param);
            db.TVisitMedications.Remove(visitMedication);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
        public ActionResult AddPetMedication([Bind(Include = "intVisitMedicationID, intVisitID, intMedicationID, dtmDatePrescribed, intQuantity, strMedicationNotes")] TVisitMedication visitMedication)
        {
            int intMedicationId = (int)Session["intMedicationID"];
            int intPetId        = (int)Session["intPetID"];
            int intVisitId      = (int)Session["intVisitId"];
            int updatedQuantity = 0;

            if (ModelState.IsValid)
            {
                TMedication medication      = db.TMedications.Where(x => x.intMedicationID == intMedicationId).FirstOrDefault();
                int         currentQuantity = db.TMedications.Where(x => x.intMedicationID == intMedicationId).Select(z => z.intQuantity).FirstOrDefault();

                //Precursory check for medications
                if (currentQuantity >= visitMedication.intQuantity)
                {
                    updatedQuantity = currentQuantity - visitMedication.intQuantity;
                }
                else
                {
                    visitMedication.intQuantity = 0;
                    updatedQuantity             = currentQuantity;
                    ViewBag.Name            = db.TPets.Where(x => x.intPetID == intPetId).Select(z => z.strPetName).FirstOrDefault();
                    ViewBag.intMedicationID = new SelectList(db.TMedications, "intMedicationID", "strMedicationName", visitMedication.intMedicationID);
                    return(View(visitMedication));
                }

                // Insert Visit Medication
                var id = db.TVisitMedications.Where(x => x.intVisitID == intVisitId && x.intMedicationID == intMedicationId).Select(z => z.intVisitMedicationID).FirstOrDefault();
                if (id == 0)
                {
                    TVisitMedication newVisitMedication = new TVisitMedication()
                    {
                        intVisitID         = visitMedication.intVisitID,
                        intMedicationID    = intMedicationId,
                        dtmDatePrescribed  = visitMedication.dtmDatePrescribed,
                        intQuantity        = visitMedication.intQuantity,
                        strMedicationNotes = visitMedication.strMedicationNotes
                    };

                    db.TVisitMedications.Add(newVisitMedication);
                    db.SaveChanges();
                }
                else
                {
                    int currentVisitMedicationQuantity      = db.TVisitMedications.Where(x => x.intVisitMedicationID == id).Select(z => z.intQuantity).FirstOrDefault();
                    TVisitMedication updatedVisitMedication = new TVisitMedication()
                    {
                        intVisitMedicationID = id,
                        intVisitID           = visitMedication.intVisitID,
                        intMedicationID      = intMedicationId,
                        dtmDatePrescribed    = visitMedication.dtmDatePrescribed,
                        intQuantity          = currentVisitMedicationQuantity + visitMedication.intQuantity,
                        strMedicationNotes   = visitMedication.strMedicationNotes
                    };

                    db.Entry(updatedVisitMedication).State = EntityState.Modified;
                    db.SaveChanges();
                };

                SqlParameter[] param = new SqlParameter[]
                {
                    new SqlParameter("@intMedicationID", intMedicationId),
                    new SqlParameter("@strMedicationName", medication.strMedicationName),
                    new SqlParameter("@strMedicationDesc", medication.strMedicationDesc),
                    new SqlParameter("@dblCost", medication.dblCost),
                    new SqlParameter("@dblPrice", medication.dblPrice),
                    new SqlParameter("@strNotes", medication.strNotes),
                    new SqlParameter("@intQuantity", updatedQuantity),
                    new SqlParameter("@intMethodID", medication.intMethodID),
                };

                db.Database.ExecuteSqlCommand("uspUpdateMedication @intMedicationID, @strMedicationName, @strMedicationDesc,@dblCost, @dblPrice,@strNotes,@intQuantity, @intMethodID ", param);

                // Redirect to the visit medications page
                return(RedirectToAction("Index"));
            }

            ViewBag.Name            = db.TPets.Where(x => x.intPetID == intPetId).Select(z => z.strPetName).FirstOrDefault();
            ViewBag.intMedicationID = new SelectList(db.TMedications, "intMedicationID", "strMedicationName", visitMedication.intMedicationID);
            return(View(visitMedication));
        }
        public ActionResult EditMedication(TVisitMedication visitMedication)
        {
            int intPetId   = (int)Session["intPetID"];
            int intVisitId = (int)Session["intVisitId"];

            if (ModelState.IsValid)
            {
                int         oldQuantity    = db.TVisitMedications.Where(x => x.intVisitMedicationID == visitMedication.intVisitMedicationID).Select(z => z.intQuantity).FirstOrDefault();
                int         medicationId   = db.TVisitMedications.Where(x => x.intVisitMedicationID == visitMedication.intVisitMedicationID).Select(z => z.intMedicationID).FirstOrDefault();
                TMedication medicationInfo = db.TMedications.Where(x => x.intMedicationID == medicationId).FirstOrDefault();

                if (oldQuantity > visitMedication.intQuantity)
                {
                    int            medQuantity = oldQuantity - visitMedication.intQuantity;
                    SqlParameter[] param       = new SqlParameter[]
                    {
                        new SqlParameter("@intMedicationID", medicationInfo.intMedicationID),
                        new SqlParameter("@strMedicationName", medicationInfo.strMedicationName),
                        new SqlParameter("@strMedicationDesc", medicationInfo.strMedicationDesc),
                        new SqlParameter("@dblCost", medicationInfo.dblCost),
                        new SqlParameter("@dblPrice", medicationInfo.dblPrice),
                        new SqlParameter("@strNotes", medicationInfo.strNotes),
                        new SqlParameter("@intQuantity", medicationInfo.intQuantity + medQuantity),
                        new SqlParameter("@intMethodID", medicationInfo.intMethodID),
                    };

                    db.Database.ExecuteSqlCommand("uspUpdateMedication @intMedicationID, @strMedicationName, @strMedicationDesc,@dblCost, @dblPrice,@strNotes,@intQuantity, @intMethodID ", param);
                    db.uspUpdateVisitMedication(visitMedication.intVisitMedicationID, visitMedication.intQuantity, visitMedication.strMedicationNotes);
                    //db.Database.ExecuteSqlCommand("uspUpdateVisitMedication @intVisitMedicationID, @intQuantity", visitMedication.intVisitMedicationID, visitMedication.intQuantity);
                }
                else if (medicationInfo.intQuantity >= (visitMedication.intQuantity - oldQuantity) && visitMedication.intQuantity > oldQuantity)
                {
                    int subQuantity = visitMedication.intQuantity - oldQuantity;

                    SqlParameter[] param = new SqlParameter[]
                    {
                        new SqlParameter("@intMedicationID", medicationInfo.intMedicationID),
                        new SqlParameter("@strMedicationName", medicationInfo.strMedicationName),
                        new SqlParameter("@strMedicationDesc", medicationInfo.strMedicationDesc),
                        new SqlParameter("@dblCost", medicationInfo.dblCost),
                        new SqlParameter("@dblPrice", medicationInfo.dblPrice),
                        new SqlParameter("@strNotes", medicationInfo.strNotes),
                        new SqlParameter("@intQuantity", medicationInfo.intQuantity - subQuantity),
                        new SqlParameter("@intMethodID", medicationInfo.intMethodID)
                    };

                    db.Database.ExecuteSqlCommand("uspUpdateMedication @intMedicationID, @strMedicationName, @strMedicationDesc,@dblCost, @dblPrice,@strNotes,@intQuantity, @intMethodID ", param);
                    db.uspUpdateVisitMedication(visitMedication.intVisitMedicationID, visitMedication.intQuantity, visitMedication.strMedicationNotes);
                    //db.Database.ExecuteSqlCommand("uspUpdateVisitMedication @intVisitMedicationID, @intQuantity", visitMedication.intVisitMedicationID, visitMedication.intQuantity);
                }
                else
                {
                    //TO DO: Need some error handling
                    db.uspUpdateVisitMedication(visitMedication.intVisitMedicationID, oldQuantity, visitMedication.strMedicationNotes);
                    //db.Database.ExecuteSqlCommand("uspUpdateVisitMedication @intVisitMedicationID, @intQuantity", visitMedication.intVisitMedicationID, oldQuantity);
                }
                return(RedirectToAction("Index"));
            }

            ViewBag.Name            = db.TPets.Where(x => x.intPetID == intPetId).Select(z => z.strPetName).FirstOrDefault();
            ViewBag.intMedicationID = new SelectList(db.TMedications, "intMedicationID", "strMedicationName", visitMedication.intMedicationID);
            return(View(visitMedication));
        }