public async Task <IActionResult> PutRapport_Geo(int id, Rapport_Geo rapport_Geo) { if (id != rapport_Geo.Id) { return(BadRequest()); } _context.Entry(rapport_Geo).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!Rapport_GeoExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <ActionResult <Rapport_Geo> > PostRapport_Geo(Rapport_Geo rapport_Geo) { _context.Rapport_Geo.Add(rapport_Geo); await _context.SaveChangesAsync(); return(CreatedAtAction("GetRapport_Geo", new { id = rapport_Geo.Id }, rapport_Geo)); }
public List <Rapport_Geo> Rapport_Geo_Pays(string Pays) { List <Rapport_Geo> rapport_Geos = new List <Rapport_Geo>(); using (SqlConnection connection = new SqlConnection(connectionString)) { string sqlQuery = "Select * from Rapport_Geo where Pays = '" + Pays + "'"; SqlCommand command = new SqlCommand(sqlQuery, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { Rapport_Geo rapport_Geo = new Rapport_Geo(); rapport_Geo.Id = reader.GetInt32(0); rapport_Geo.FestivalId = reader.GetInt32(1); rapport_Geo.FestivalierId = reader.GetInt32(2); rapport_Geo.Pays = reader.GetString(3); rapport_Geo.Departement = reader.GetString(4); rapport_Geo.Region = reader.GetString(5); rapport_Geo.Genre = reader.GetString(6); rapport_Geos.Add(rapport_Geo); } } } return(rapport_Geos); }