public ActionResult Index()
{
Medicine_Purchase medicine_Purchase = new Medicine_Purchase();
medicine_Purchase.getAllPatientsName = patientPortal.getAllPatientsName();
medicine_Purchase.getAllMedicinesName = medicinetPortal.getAllMedicinesName();
return(View(medicine_Purchase));
}
public ActionResult AddMedicine(FormCollection collection)
{
Medicine_Purchase medicine_Purchase = new Medicine_Purchase();
medicine_Purchase.patient_id = Convert.ToInt32(collection["patient_id"]);
medicine_Purchase.medicine_id = Convert.ToInt32(collection["medicine_id"]);
medicine_Purchase.quantitly = Convert.ToInt32(collection["quantitly"]);
medicine_Purchase.dateTime = DateTime.Now;
medicine_Purchase.total_bill = medicinePurchasePortal.getMedicinePrice(medicine_Purchase.medicine_id) * medicine_Purchase.quantitly;
medicinePurchasePortal.insert(medicine_Purchase);
medicinePurchasePortal.updateProductQuantity(medicine_Purchase.quantitly);
return(RedirectToAction("Index"));
}
public void insert(Medicine_Purchase medicine_Purchase)
{
using (SqlConnection conn = new SqlConnection(cs))
{
string query = "insert into medicine_purchase values(@p_id,@m_id,@quantity,@total_bill,@date)";
SqlCommand sqlCommand = new SqlCommand(query, conn);
sqlCommand.Parameters.AddWithValue("@p_id", medicine_Purchase.patient_id);
sqlCommand.Parameters.AddWithValue("@m_id", medicine_Purchase.medicine_id);
sqlCommand.Parameters.AddWithValue("@quantity", medicine_Purchase.quantitly);
sqlCommand.Parameters.AddWithValue("@total_bill", medicine_Purchase.total_bill);
sqlCommand.Parameters.AddWithValue("@date", medicine_Purchase.dateTime);
conn.Open();
sqlCommand.ExecuteNonQuery();
}
}
