public List <MedicamenteModel> GetMedicamente()
{
SqlConnection connection = new SqlConnection();
connection.ConnectionString = ConnectionString;
SqlCommand command = new SqlCommand(GetAllMedicamentQuery, connection);
//command.Parameters.AddWithValue("@pricePoint", paramValue);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
List <MedicamenteModel> medicamenteList = new List <MedicamenteModel>();
while (reader.Read())
{
MedicamenteModel Medicament = new MedicamenteModel();
Medicament.Id = reader.GetInt32(0);
Medicament.Name = reader.GetString(1);
medicamenteList.Add(Medicament);
}
reader.Close();
connection.Close();
return(medicamenteList);
}
public ActionResult Add(MedicamenteModel medicament)
{
MedicamenteRepository r = new MedicamenteRepository();
r.Add(medicament);
return(View("SuccesfulAdd"));
}
public void Add(MedicamenteModel medicament)
{
using (var db = new LiteDatabase(@"c:\temp\MedicamenteDB.db"))
{
// Get customer collection
var Medicamente = db.GetCollection <MedicamenteModel>("medicamente");
Medicamente.Insert(medicament);
}
}
public void AddBook(MedicamenteModel medicament)
{
SqlConnection connection = new SqlConnection();
connection.ConnectionString = ConnectionString;
SqlCommand command = new SqlCommand(InsertMedicamentQuery, connection);
command.Parameters.Add("@name", SqlDbType.VarChar).Value = medicament.Name;
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
