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