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