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