public async Task <IActionResult> PutRapport_Activite(int id, Rapport_Activite rapport_Activite)
{
if (id != rapport_Activite.Id)
{
return(BadRequest());
}
_context.Entry(rapport_Activite).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!Rapport_ActiviteExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ActionResult <Rapport_Activite> > PostRapport_Activite(Rapport_Activite rapport_Activite)
{
_context.Rapport_Activite.Add(rapport_Activite);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetRapport_Activite", new { id = rapport_Activite.Id }, rapport_Activite));
}
public List <Rapport_Activite> Rapport_Activite_Festival(int FestivalId)
{
List <Rapport_Activite> rapport_Activites = new List <Rapport_Activite>();
using (SqlConnection connection = new SqlConnection(connectionString))
{
string sqlQuery = "Select * from Rapport_Activite where FestivalId = " + FestivalId;
SqlCommand command = new SqlCommand(sqlQuery, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
Rapport_Activite rapport_Activite = new Rapport_Activite();
rapport_Activite.Id = reader.GetInt32(0);
rapport_Activite.Annee = reader.GetInt32(1);
rapport_Activite.FestivalId = reader.GetInt32(2);
rapport_Activite.Departement = reader.GetString(3);
rapport_Activite.Region = reader.GetString(4);
rapport_Activite.Somme_Vente = reader.GetDouble(5);
rapport_Activites.Add(rapport_Activite);
}
}
}
return(rapport_Activites);
}
