public List <Medicine> SelectAllMedicines()
{
//Declare variables
List <Medicine> medicines = new List <Medicine>();
var conn = DBConnection.GetConnection();
var cmd = new SqlCommand("sp_select_all_medicine");
//Setup cmd object
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
//Try to execute the query
try
{
conn.Open();
var reader = cmd.ExecuteReader();
while (reader.Read())
{
Medicine med = new Medicine();
med.MedicineID = reader.GetInt32(0);
med.MedicineName = reader.GetString(1);
med.MedicineDosage = reader.GetString(1);
med.MedicineDescription = reader.GetString(2);
medicines.Add(med);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(medicines);
}
public void addMedicine(Medicine med)
{
db.Medicines.Add(med);
db.SaveChanges();
}
public void updateMedicine(Medicine med)
{
hmsda.updateMedicine(med);
}
public void remove(Medicine med)
{
hmsda.remove(med);
}
public void addMedicine(Medicine med)
{
hmsda.addMedicine(med);
}
