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