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