public void SymptoomAanpassenInDatabase(SymptoomDto symptoom)
{
string query = "_SymptoomAanpassen";
if (this.OpenConnection())
{
try
{
MySqlCommand cmd = new MySqlCommand(query, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@naam", MySqlDbType.String).Value = symptoom.naam;
cmd.Parameters.Add("@besmettingsgraadFactor", MySqlDbType.Decimal).Value = symptoom.besmettingsgraadFactor;
cmd.Parameters.Add("@herkenbaarheidsgraadFactor", MySqlDbType.Decimal).Value = symptoom.herkenbaarheidsgraadFactor;
cmd.Parameters.Add("@sterftegraadFactor", MySqlDbType.Decimal).Value = symptoom.sterftegraadFactor;
cmd.Parameters.Add("@ernst", MySqlDbType.Int32).Value = symptoom.ernst;
cmd.Parameters.Add("@prijs", MySqlDbType.Int32).Value = symptoom.prijs;
cmd.Parameters.Add("@niveau", MySqlDbType.String).Value = symptoom.niveau;
cmd.Parameters.Add("@categorie", MySqlDbType.String).Value = symptoom.categorie;
cmd.ExecuteNonQuery();
}
catch (Exception exception)
{
throw new Exception(exception.ToString());
}
this.CloseConnection();
}
}
public IEnumerable <SymptoomDto> VraagAlleSymptomenOp()
{
string query = "_AlleSymptomenOpvragen";
List <SymptoomDto> resultaat = new List <SymptoomDto>();
if (this.OpenConnection())
{
try
{
MySqlCommand cmd = new MySqlCommand(query, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
SymptoomDto symptoom = new SymptoomDto(dataReader.GetString(0), dataReader.GetDecimal(1), dataReader.GetDecimal(2), dataReader.GetDecimal(3), dataReader.GetInt32(4), dataReader.GetInt32(5), dataReader.GetString(6), dataReader.GetString(7));
resultaat.Add(symptoom);
}
dataReader.Close();
}
catch
{
resultaat = null;
}
this.CloseConnection();
}
return(resultaat);
}
public IEnumerable <SymptoomDto> VraagAlleSymptomenOpVanVirus(VirusDto virus)
{
string query = "_AlleSymptomenOpvragenVanVirus";
List <SymptoomDto> resultaat = new List <SymptoomDto>();
if (this.OpenConnection())
{
try
{
MySqlCommand cmd = new MySqlCommand(query, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@virus", MySqlDbType.String).Value = virus.naam;
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
SymptoomDto symptoom = new SymptoomDto(dataReader.GetString(0), dataReader.GetDecimal(1), dataReader.GetDecimal(2), dataReader.GetDecimal(3), dataReader.GetInt32(4), dataReader.GetInt32(5), dataReader.GetString(6), dataReader.GetString(7));
resultaat.Add(symptoom);
}
dataReader.Close();
}
catch (Exception exception)
{
throw new Exception(exception.ToString());
}
this.CloseConnection();
}
return(resultaat);
}
public Symptoom OpvragenNaarNaam(string naam, string niveau)
{
SymptoomDto sd = _context.SymptoomSelecteren(naam, niveau);
Symptoom symptoom = new Symptoom(sd.naam, sd.besmettingsgraadFactor, sd.herkenbaarheidsgraadFactor, sd.sterftegraadFactor, sd.ernst, sd.prijs, sd.niveau, sd.categorie);
return(symptoom);
}
// TODO
public void SlaVirusOpInDatabase(Virus virus)
{
VirusDto virusdto = new VirusDto(virus.naam, virus.besmettingsgraad, virus.herkenbaarheidsgraad, virus.sterftegraad, virus.aantalDagenSindsEersteUitbraak);
_virusContext.VirusOpslaanInDatabase(virusdto);
foreach (Symptoom symptoom in virus.beschikbareSymptomen)
{
SymptoomDto symptoomdto = new SymptoomDto(symptoom.naam, symptoom.besmettingsgraadFactor, symptoom.herkenbaarheidsgraadFactor, symptoom.sterftegraadFactor, symptoom.ernst, symptoom.prijs, symptoom.niveau, symptoom.categorie);
_symptoomContext.SymptoomAanVirusToevoegenInDatabase(symptoomdto, virusdto);
}
foreach (Uitbraak uitbraak in virus.uitbraken)
{
}
}
public void SymptoomVerwijderenUitDatabase(SymptoomDto symptoom)
{
string query = "_SymptoomVerwijderen";
if (this.OpenConnection())
{
try
{
MySqlCommand cmd = new MySqlCommand(query, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@naam", MySqlDbType.String).Value = symptoom.naam;
cmd.Parameters.Add("@niveau", MySqlDbType.String).Value = symptoom.niveau;
cmd.ExecuteNonQuery();
}
catch (Exception exception)
{
throw new Exception(exception.ToString());
}
this.CloseConnection();
}
}
public SymptoomDto SymptoomSelecteren(string naam, string niveau)
{
string query = "_SymptoomSelecteren";
SymptoomDto resultaat = new SymptoomDto();
if (this.OpenConnection())
{
try
{
MySqlCommand cmd = new MySqlCommand(query, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@naam", MySqlDbType.String).Value = naam;
cmd.Parameters.Add("@niveau", MySqlDbType.String).Value = niveau;
using (MySqlDataReader dataReader = cmd.ExecuteReader())
{
while (dataReader.Read())
{
resultaat.naam = dataReader.GetString(0);
resultaat.besmettingsgraadFactor = (decimal)dataReader.GetValue(1);
resultaat.herkenbaarheidsgraadFactor = (decimal)dataReader.GetValue(2);
resultaat.sterftegraadFactor = (decimal)dataReader.GetValue(3);
resultaat.ernst = dataReader.GetInt32(4);
resultaat.prijs = dataReader.GetInt32(5);
resultaat.niveau = dataReader.GetString(6);
resultaat.categorie = dataReader.GetString(7);
break;
}
dataReader.Close();
}
}
catch
{
}
this.CloseConnection();
}
return(resultaat);
}
public void SymptoomVerwijderen(Symptoom symptoom)
{
SymptoomDto symptoomDto = new SymptoomDto(symptoom.naam, symptoom.besmettingsgraadFactor, symptoom.herkenbaarheidsgraadFactor, symptoom.sterftegraadFactor, symptoom.ernst, symptoom.prijs, symptoom.niveau, symptoom.categorie);
_context.SymptoomVerwijderenUitDatabase(symptoomDto);
}