//Method to Delete a Drug from the database
public bool DeleteDrug(Drug drug)
{
//Connect to database using the connection string from App.config
//Using a 'using' block to terminate the connection after we're finished with it
using (var connection =
new MySqlConnection(ConfigurationManager.ConnectionStrings["premierCare"].ConnectionString)) {
//SQL code to delete the drug from the database
const string sql = "DELETE FROM Drug WHERE drug_id = @drug_id";
//Adding parameters to the code to prevent against SQL injection
//Executing the SQL code with added parameters. Returns number of Rows affected
var rowsAffected = connection.Execute(sql, new { drug_id = drug.drug_id });
//A successful delete will affect at least 1 Row and will return true
//An unsuccessful delete will return 0 and therefore return false
return(rowsAffected > 0);
}
}
//Method to Insert a Drug into the database
public bool CreateDrug(Drug drug)
{
//Connect to database using the connection string from App.config
//Using a 'using' block to terminate the connection after we're finished with it
using (var connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["premierCare"].ConnectionString)) {
//SQL code to insert the drug into the database
const string sql = "INSERT INTO Drug(drug_name, cost) VALUES(@drug_name, @cost)";
//Adding parameters to the code to prevent against SQL injection
//Executing the SQL code with added parameters. Returns number of Rows affected
var rowsAffected = connection.Execute(sql, new {
drug_name = drug.drug_name,
cost = drug.cost
});
//A successful insert will affect at least 1 Row and will return true
//An unsuccessful insert will return 0 and therefore return false
return(rowsAffected > 0);
}
}
public bool UpdateDrug(Drug drug)
{
return(drugDAO.UpdateDrug(drug));
}
public bool DeleteDrug(Drug drug)
{
return(drugDAO.DeleteDrug(drug));
}
public bool CreateDrug(Drug drug)
{
return(drugDAO.CreateDrug(drug));
}