public void update(avis unavis)
{
string AvisUpdate;
AvisUpdate = ("avis set idAvis ='" + unavis.IdAvis + "', idClient = '" + unavis.LeClient + "', idSalle ='" + unavis.IdSalle + "', avis = '" + unavis.Avis.Replace("'", "''") + "'");
_dbal.Update(AvisUpdate);
}
public void update(theme untheme)
{
string ThemeUpdate;
ThemeUpdate = ("pays set id ='" + untheme.IdTheme + "' , nom = '" + untheme.Theme.Replace("'", "''") + "'");
_dbal.Update(ThemeUpdate);
}
public void update(salles unesalle, theme untheme)
{
string SalleUpdate;
SalleUpdate = ("salles set id ='" + unesalle.IdSalle + "' , nom = '" + unesalle.Ville.Replace("'", "''") + untheme.IdTheme + "'");
_dbal.Update(SalleUpdate);
}
public void AssgneToSalle(Theme theme, ref Salle salle)
{
Theme themeActu = GetThemeActuel(salle);
Dictionary <string, dynamic> dicA = new Dictionary <string, dynamic>();
dicA.Add("dateFin", DateTime.Now);
_dbal.Update("theme_salle", dicA, "salle = " + salle.Id + " AND theme = " + themeActu.Id);
Dictionary <string, dynamic> dic = new Dictionary <string, dynamic>();
dic.Add("salle", salle.Id);
dic.Add("theme", theme.Id);
dic.Add("dateDebut", DateTime.Now);
_dbal.Insert("theme_salle", dic);
salle.Theme = GetThemeActuel(salle);
}
public void Update(Obstacle unObstacle)// mettre à jour une ligne
{
_DBAL.Update(" Obstacle SET nom = '" + unObstacle.NomObstacle + "', UneDefinition = '" + unObstacle.Definition + "', Photo = '" + unObstacle.Photo + "', typeObstacle = '" + unObstacle.TypeObstacle + "' WHERE nom = '" + unObstacle.NomObstacle + "';");
}
public void Update(Reservation uneReservation)
{
_DBAL.Update(" Reservation SET idReservation = " + uneReservation.IdReservation + ",idClient = " + uneReservation.LeClient + ",idSalle = " + uneReservation.LaSalle + ",idTransaction = " + uneReservation.LaTransaction + ",dateReservation = " + uneReservation.DateReservation + ", nbJoueurs = " + uneReservation.NbJoueurs + ", nbObstacles = " + uneReservation.NbObstacles + "WHERE idReservation = " + uneReservation.IdReservation + ";");
}
public void Update(PositionObstacle unePositionObstacle)
{
_DBAL.Update(" PositionObstacle SET idPositionObstacle = " + unePositionObstacle.IdPositionObstacle + ",nomObstacle = '" + unePositionObstacle.NomObstacle + "', idReservation = " + unePositionObstacle.IdReservation + " , positionObstacle = " + unePositionObstacle.Position + " WHERE nomObstacle = '" + unePositionObstacle.NomObstacle + "';");
}
public void EditClient(Client c)
{
_dbal.Update("client", c.ToArray(), "id = " + c.Id);
}
public void Update(Reservations uneReservation)
{
_DBAL.Update(" Reservation SET idReservation = " + uneReservation.IdReservation + ",idClient = " + uneReservation.LeClient.getIdClient() + ",idSalle = " + uneReservation.LaSalle.IdSalle + ",idTransaction = " + uneReservation.LaTransaction.getIdTransactions() + ",dateReservation = " + uneReservation.DateReservation.ToString("yyyy-MM-dd") + ", nbJoueurs = " + uneReservation.NbJoueurs + ", nbObstacles = " + uneReservation.NbObstacles + "WHERE idReservation = " + uneReservation.IdReservation + ";");
}
