public DTOTheme SelectByIdTheme(int id)
{
string retour = " * from theme where id = " + id + ";";
DataTable table = _dbal.Select(retour);
DTOTheme theme = new DTOTheme(Convert.ToInt32(table.Rows[0]["id"]), Convert.ToString(table.Rows[0]["nom"]));
return(theme);
}
public DTOVille SelectByIdVille(int id)
{
string retour = " * from ville where id = " + id + ";";
DataTable table = _dbal.Select(retour);
DTOVille ville = new DTOVille(Convert.ToInt32(table.Rows[0]["id"]), Convert.ToString(table.Rows[0]["nom"]), Convert.ToString(table.Rows[0]["codepostal"]));
return(ville);
}
public DTOParties SelectByIdPartie(int id)
{
string retour = " * from parties where id = " + id + ";";
DataTable table = _dbal.Select(retour);
DTOParties partie = new DTOParties(Convert.ToInt32(table.Rows[0]["id"]), Convert.ToDateTime(table.Rows[0]["date"]), Convert.ToString(table.Rows[0]["heure"]), Convert.ToInt32(table.Rows[0]["nbjoueur"]));
for (int i = 0; i < table.Rows.Count; i++)
{
DAOxClients dAOxClients = new DAOxClients(_dbal);
DTOClients clients = dAOxClients.SelectByIdClients(Convert.ToString(table.Rows[i]["pseudo_client"]));
DAOxSalle dAOxSalle = new DAOxSalle(_dbal);
DTOSalle salle = dAOxSalle.SelectByIdSalle(Convert.ToInt32(table.Rows[i]["idSalle"]));
partie.SetClient(clients);
partie.SetSalle(salle);
}
return(partie);
}
public DTOClients SelectByIdClients(string pseudo)
{
string retour = " * from clients where pseudo = \"" + pseudo + "\";";
DataTable table = _dbal.Select(retour);
DTOClients client = new DTOClients(Convert.ToString(table.Rows[0]["pseudo"]), Convert.ToString(table.Rows[0]["nom"]), Convert.ToString(table.Rows[0]["prenom"]), Convert.ToDateTime(table.Rows[0]["datenaissance"]), Convert.ToString(table.Rows[0]["adresse"]), Convert.ToString(table.Rows[0]["mail"]), Convert.ToString(table.Rows[0]["telephone"]), Convert.ToInt32(table.Rows[0]["credit"]), Convert.ToBoolean(table.Rows[0]["archiver"]));
for (int i = 0; i < table.Rows.Count; i++)
{
DAOxVille dAOxVille = new DAOxVille(_dbal);
DTOVille ville = dAOxVille.SelectByIdVille(Convert.ToInt32(table.Rows[i]["idVille"]));
client.SetVille(ville);
}
return(client);
}
public DTOSalle SelectByIdSalle(int id)
{
string retour = " * from salle where id = " + id + ";";
DataTable table = _dbal.Select(retour);
DTOSalle salle = new DTOSalle(Convert.ToInt32(table.Rows[0]["id"]), Convert.ToString(table.Rows[0]["nom"]), Convert.ToString(table.Rows[0]["heure_ouverture"]), Convert.ToString(table.Rows[0]["heure_fermeture"]));
for (int i = 0; i < table.Rows.Count; i++)
{
DAOxTheme dAOxTheme = new DAOxTheme(_dbal);
DTOTheme theme = dAOxTheme.SelectByIdTheme(Convert.ToInt32(table.Rows[i][3]));
DAOxVille dAOxVille = new DAOxVille(_dbal);
DTOVille ville = dAOxVille.SelectByIdVille(Convert.ToInt32(table.Rows[i][4]));
salle.SetTheme(theme);
salle.SetVille(ville);
}
return(salle);
}
