public void insert(avis unavis) { string AvisInsert; AvisInsert = ("avis (idAvis, idClient, idSalle, avis) values (" + unavis.IdAvis + "," + unavis.LeClient + "," + unavis.IdSalle + ",'" + unavis.Avis.Replace("'", "''") + "')"); _dbal.Insert(AvisInsert); }
public void insert(theme untheme) { string ThemeInsert; ThemeInsert = ("themes (id, theme) values (" + untheme.IdTheme + ",'" + untheme.Theme.Replace("'", "''") + "')"); _dbal.Insert(ThemeInsert); }
public void insert(salles unesalle, theme untheme) { string SalleInsert; SalleInsert = ("salle (idSalle, ville, idTheme) values (" + unesalle.IdSalle + ",'" + unesalle.Ville.Replace("'", "''") + "'," + untheme.IdTheme + ")"); _dbal.Insert(SalleInsert); }
public void insert(avis unavis, Clients unClient, salles uneSalle) { string AvisInsert; AvisInsert = ("avis (idAvis, idClient, idSalle, avis) values (" + unavis.IdAvis + "," + unClient.getIdClient() + "," + uneSalle.IdSalle + ",'" + unavis.Avis.Replace("'", "''") + "')"); _dbal.Insert(AvisInsert); }
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 Add(Joueur joueur, DateTime date, string comm) { Dictionary <string, dynamic> dic = new Dictionary <string, dynamic>(); dic.Add("commentaire", comm); dic.Add("joueur", joueur.Id); dic.Add("date", date); _dbal.Insert("avis", dic); }
public void NouvellePartie(Partie partie) { _dbal.Insert("partie", partie.ToArray()); Partie p = new Partie(_dbal.SelectOrderBy("partie", "id", "DESC", "1").Rows[0]); foreach (Joueur joueur in partie.LstJoueur) { Dictionary <string, dynamic> dic = new Dictionary <string, dynamic>(); dic.Add("joueur", joueur.Id); dic.Add("partie", p.Id); _dbal.Insert("joueur_partie", dic); } for (var i = 0; i < partie.LstObstacle.Count; i++) { Dictionary <string, dynamic> dic = new Dictionary <string, dynamic>(); dic.Add("obstacle", partie.LstObstacle[i].Id); dic.Add("partie", p.Id); dic.Add("position", i + 1); _dbal.Insert("obstacle_partie", dic); } }
public void Insert(Obstacle unObstacle) //insérer une ligne { _DBAL.Insert(" Obstacle values (" + unObstacle.NomObstacle + ", '" + unObstacle.Definition + "','" + unObstacle.Photo + "','" + unObstacle.TypeObstacle + "');"); }
public void Insert(Reservation uneReservation) { _DBAL.Insert(" Reservation VALUES (" + uneReservation.IdReservation + "," + uneReservation.LeClient + "," + uneReservation.LaSalle + "," + uneReservation.LaTransaction + ",'" + uneReservation.DateReservation + "'," + uneReservation.NbJoueurs + "," + uneReservation.NbObstacles + ");"); }
public void Insert(PositionObstacle unePositionObstacle) { _DBAL.Insert(" PositionObstacle values ('" + unePositionObstacle.IdPositionObstacle + "','" + unePositionObstacle.NomObstacle + "', " + unePositionObstacle.IdReservation + "," + unePositionObstacle.Position + ");"); }
public void AddJoueur(ref Joueur joueur) { _dbal.Insert("joueur", joueur.ToArray()); joueur.Id = (int)_dbal.SelectLast("joueur")["id"]; }
public void NouveauClient(Client c) { _dbal.Insert("client", c.ToArray()); }
public void Insert(Reservations uneReservation) { _DBAL.Insert(" Reservation VALUES (" + uneReservation.IdReservation + "," + uneReservation.LeClient.getIdClient() + "," + uneReservation.LaSalle.IdSalle + "," + uneReservation.LaTransaction.getIdTransactions() + ",'" + uneReservation.DateReservation.ToString("yyyy-MM-dd") + "'," + uneReservation.NbJoueurs + "," + uneReservation.NbObstacles + ");"); }
public void New(ref Horaire horaire) { _dbal.Insert("horaire", horaire.ToArray()); horaire.Id = (int)_dbal.Select("horaire", "heure = '" + horaire.Heure + "'").Rows[0]["id"]; }
public void NouvelleFacture(Facture f) { _dbal.Insert("facture", f.ToArray()); }