public void VirusOpslaanInDatabase(VirusDto virus)
{
string query = "_VirusOpslaan";
if (this.OpenConnection())
{
try
{
MySqlCommand cmd = new MySqlCommand(query, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@naam", MySqlDbType.String).Value = virus.naam;
cmd.Parameters.Add("@besmettingsgraad", MySqlDbType.Decimal).Value = virus.besmettingsgraad;
cmd.Parameters.Add("@herkenbaarheidsgraad", MySqlDbType.Decimal).Value = virus.herkenbaarheidsgraad;
cmd.Parameters.Add("@sterftegraad", MySqlDbType.Decimal).Value = virus.sterftegraad;
cmd.Parameters.Add("@aantalDagenSindsEersteUitbraak", MySqlDbType.Int32).Value = virus.aantalDagenSindsEersteUitbraak;
cmd.ExecuteNonQuery();
}
catch (Exception exception)
{
throw new Exception(exception.ToString());
}
this.CloseConnection();
}
}
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 VirusDto VraagVirusOpInDatabase(string naam)
{
string query = "_VirusOpvragenNaarNaam";
VirusDto resultaat = null;
if (this.OpenConnection())
{
try
{
MySqlCommand cmd = new MySqlCommand(query, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@naam", MySqlDbType.String).Value = naam;
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
resultaat = new VirusDto(dataReader.GetString(0), dataReader.GetDecimal(1), dataReader.GetDecimal(2), dataReader.GetDecimal(3), dataReader.GetInt32(4));
}
dataReader.Close();
}
catch (Exception exception)
{
resultaat = null;
throw new Exception(exception.ToString());
}
this.CloseConnection();
}
return(resultaat);
}
public void UitbraakAanpassenInDatabase(UitbraakDto uitbraak, VirusDto virus)
{
string query = "";
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("@virus", MySqlDbType.String).Value = virus.naam;
cmd.Parameters.Add("@land", MySqlDbType.String).Value = uitbraak.land;
cmd.Parameters.Add("@aantalBesmettingen", MySqlDbType.Int32).Value = uitbraak.aantalBesmettingen;
cmd.Parameters.Add("@aantalGeregistreerdeBesmettingen", MySqlDbType.Int32).Value = uitbraak.aantalGeregistreerdeBesmettingen;
cmd.Parameters.Add("@aantalSterfgevallen", MySqlDbType.Int32).Value = uitbraak.aantalSterfgevalen;
cmd.ExecuteNonQuery();
}
catch (Exception exception)
{
throw new Exception(exception.ToString());
}
this.CloseConnection();
}
}
public void Edit(VirusDto model)
{
if (model.Key.IsNullOrEmpty())
{
throw new ActionStatusMessageException(ActionStatusMessage.StaticMessage.IdIsNull);
}
var r = context.VirusesDb.FirstOrDefault(i => i.Key == model.Key);
var client = r ?? new Virus()
{
Status = VirusStatus.Unhandle
};
model.ToModel(context.Clients, client);
if (client.IsRemoved && r != null)
{
context.Viruses.Update(r);
r.Remove();
}
if (r == null)
{
RelateVirusTrace(client);
context.Viruses.Add(client);
}
else
{
context.Viruses.Update(client);
}
}
public Virus HaalVirusOpUitDatabaseBijNaam(string naam)
{
VirusDto virus = _virusContext.VraagVirusOpInDatabase(naam);
Virus result = new Virus();
result.InitieerVirus(virus.naam, virus.besmettingsgraad, virus.herkenbaarheidsgraad, virus.sterftegraad, virus.aantalDagenSindsEersteUitbraak);
return(result);
}
// 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 SymptoomAanVirusToevoegenInDatabase(SymptoomDto symptoom, VirusDto virus)
{
string query = "";
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.Parameters.Add("@virus", MySqlDbType.String).Value = virus.naam;
cmd.ExecuteNonQuery();
}
catch (Exception exception)
{
throw new Exception(exception.ToString());
}
this.CloseConnection();
}
}
public IEnumerable <UitbraakDto> VraagAlleUitbrakenOpVanVirusUitDatabase(VirusDto virus)
{
string query = "";
List <UitbraakDto> resultaat = new List <UitbraakDto>();
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())
{
// Uitbraak uitbraak = new Uitbraak();
// Land land = new Land();
// DbLandContext context = new DbLandContext();
// land = context.
// uitbraak.land = land;
// uitbraak.aantalBesmettingen = dataReader.GetInt32(1);
// uitbraak.aantalGeregistreerdeBesmettingen = dataReader.GetInt32(2);
// uitbraak.aantalSterfgevalen = dataReader.GetInt32(3);
// resultaat.Add(uitbraak);
return(null);
}
dataReader.Close();
}
catch (Exception exception)
{
resultaat = null;
throw new Exception(exception.ToString());
}
this.CloseConnection();
}
return(resultaat);
}
