static public TSQLProcedure Rq_DeletePlayer(int id)
{
ProcedureParameter[] parameters = new ProcedureParameter[1];
parameters[0] = new ProcedureParameter("@id", System.Data.OleDb.OleDbType.Integer, id);
TSQLProcedure proc = new TSQLProcedure("SuppJoueur", parameters);
return proc;
}
static public TSQLProcedure Rq_DeleteQuestion(int id)
{
ProcedureParameter[] parameters = new ProcedureParameter[1];
parameters[0] = new ProcedureParameter("@id_question_jeu", System.Data.OleDb.OleDbType.Integer, id);
TSQLProcedure proc = new TSQLProcedure("SupprQuestionJeu", parameters);
return proc;
}
static public TSQLProcedure Rq_CreatePlayer(string pseudo, int score)
{
ProcedureParameter[] parameters = new ProcedureParameter[2];
parameters[0] = new ProcedureParameter("@pseudo", System.Data.OleDb.OleDbType.VarChar, pseudo);
parameters[1] = new ProcedureParameter("@score", System.Data.OleDb.OleDbType.Integer, score);
TSQLProcedure proc = new TSQLProcedure("AddJoueur", parameters);
return proc;
}
static public TSQLProcedure Rq_UpdatePlayerScore(int id, int score)
{
ProcedureParameter[] parameters = new ProcedureParameter[2];
parameters[0] = new ProcedureParameter("@id_joueur", System.Data.OleDb.OleDbType.Integer, id);
parameters[1] = new ProcedureParameter("@score", System.Data.OleDb.OleDbType.Integer, score);
TSQLProcedure proc = new TSQLProcedure("ModifierJoueur", parameters);
return proc;
}
/* Méthode de création de la procédure de récupération de création d'un admin */
static public TSQLProcedure Rq_CreateAdmin(string login, string hashedPassword)
{
ProcedureParameter[] parameters = new ProcedureParameter[2];
parameters[0] = new ProcedureParameter("@login", System.Data.OleDb.OleDbType.VarChar, login);
parameters[1] = new ProcedureParameter("@score", System.Data.OleDb.OleDbType.VarChar, hashedPassword);
TSQLProcedure proc = new TSQLProcedure("AddAdmin", parameters);
return proc;
}
static public TSQLProcedure Rq_CreateQuestion(string intitule_question_orient, int ordre_orient)
{
ProcedureParameter [] parameters = new ProcedureParameter[2];
parameters[0] = new ProcedureParameter("@intitule_question_orient", System.Data.OleDb.OleDbType.VarChar, intitule_question_orient);
parameters[1] = new ProcedureParameter("@ordre", System.Data.OleDb.OleDbType.Integer, ordre_orient);
TSQLProcedure proc = new TSQLProcedure("AddQuestionOrient", parameters);
return proc;
}
static public TSQLProcedure Rq_CreateMetier(string intitule, string description)
{
ProcedureParameter[] parameters = new ProcedureParameter[2];
parameters[0] = new ProcedureParameter("@intitule_metier", System.Data.OleDb.OleDbType.VarChar, intitule);
parameters[1] = new ProcedureParameter("@description_metier", System.Data.OleDb.OleDbType.VarChar, description);
TSQLProcedure proc = new TSQLProcedure("AddMetier", parameters);
return proc;
}
static public TSQLProcedure Rq_UpdatePlayer(int id, string pseudo, int score)
{
ProcedureParameter[] parameters = new ProcedureParameter[3];
parameters[0] = new ProcedureParameter("@id_joueur", System.Data.OleDb.OleDbType.Integer, id);
parameters[1] = new ProcedureParameter("@pseudo", System.Data.OleDb.OleDbType.VarChar, pseudo);
parameters[2] = new ProcedureParameter("@score", System.Data.OleDb.OleDbType.Integer, score);
TSQLProcedure proc = new TSQLProcedure("ModifJoueur", parameters);
return proc;
}
static public TSQLProcedure Rq_CreateReponse(int id_question_orient, string intitule_reponse_orient, int id_metier)
{
ProcedureParameter[] parameters = new ProcedureParameter[3];
parameters[0] = new ProcedureParameter("@id_question_orient", System.Data.OleDb.OleDbType.VarChar, id_question_orient);
parameters[1] = new ProcedureParameter("@intitule_reponse_orient", System.Data.OleDb.OleDbType.VarChar, intitule_reponse_orient);
parameters[2] = new ProcedureParameter("@id_metier", System.Data.OleDb.OleDbType.Integer, id_metier);
TSQLProcedure proc = new TSQLProcedure("AddReponseOrient", parameters);
return proc;
}
/* Méthode de création de la procédure de modification d'un admin via son ID */
static public TSQLProcedure Rq_UpdateAdmin(int id, string login, string hashedPassword)
{
ProcedureParameter[] parameters = new ProcedureParameter[3];
parameters[0] = new ProcedureParameter("@id", System.Data.OleDb.OleDbType.Integer, id);
parameters[1] = new ProcedureParameter("@login", System.Data.OleDb.OleDbType.VarChar, login);
parameters[2] = new ProcedureParameter("@password", System.Data.OleDb.OleDbType.VarChar, hashedPassword);
TSQLProcedure proc = new TSQLProcedure("ModifierAdmin", parameters);
return proc;
}
static public TSQLProcedure Rq_UpdateMetier(int id, string intitule, string description)
{
ProcedureParameter[] parameters = new ProcedureParameter[3];
parameters[0] = new ProcedureParameter("@id_metier", System.Data.OleDb.OleDbType.Integer, id);
parameters[1] = new ProcedureParameter("@intitule_metier", System.Data.OleDb.OleDbType.VarChar, intitule);
parameters[2] = new ProcedureParameter("@description_metier", System.Data.OleDb.OleDbType.VarChar, description);
TSQLProcedure proc = new TSQLProcedure("ModifMetier", parameters);
return proc;
}
static public TSQLProcedure Rq_UpdateQuestion(int id, string intitule, int point)
{
ProcedureParameter[] parameters = new ProcedureParameter[3];
parameters[0] = new ProcedureParameter("@id_question_jeu", System.Data.OleDb.OleDbType.Integer, id);
parameters[1] = new ProcedureParameter("@intitule_question", System.Data.OleDb.OleDbType.VarChar, intitule);
parameters[2] = new ProcedureParameter("@point", System.Data.OleDb.OleDbType.Integer, point);
TSQLProcedure proc = new TSQLProcedure("ModifQuestionJeu", parameters);
return proc;
}
static public TSQLProcedure Rq_CreateReponse(int id, string intitule, int point, bool iscorrect)
{
ProcedureParameter[] parameters = new ProcedureParameter[4];
parameters[0] = new ProcedureParameter("@id_question_jeu", System.Data.OleDb.OleDbType.Integer, id);
parameters[1] = new ProcedureParameter("@intitule_reponse", System.Data.OleDb.OleDbType.VarChar, intitule);
parameters[2] = new ProcedureParameter("@point", System.Data.OleDb.OleDbType.Integer, point);
parameters[3] = new ProcedureParameter("@etat", System.Data.OleDb.OleDbType.Boolean, iscorrect);
TSQLProcedure proc = new TSQLProcedure("AddReponseJeu", parameters);
return proc;
}
static public TSQLProcedure Rq_CreateStat(int age, bool sexe, string cp, string diplome, string type_diplome, string connaissance)
{
ProcedureParameter[] parameters = new ProcedureParameter[6];
parameters[0] = new ProcedureParameter("@age", System.Data.OleDb.OleDbType.Integer, age);
parameters[1] = new ProcedureParameter("@sexe", System.Data.OleDb.OleDbType.Boolean, sexe);
parameters[2] = new ProcedureParameter("@code_postal", System.Data.OleDb.OleDbType.VarChar, cp);
parameters[3] = new ProcedureParameter("@diplome", System.Data.OleDb.OleDbType.VarChar, diplome);
parameters[4] = new ProcedureParameter("@type_diplome", System.Data.OleDb.OleDbType.VarChar, type_diplome);
parameters[5] = new ProcedureParameter("@connaissance", System.Data.OleDb.OleDbType.VarChar, connaissance);
TSQLProcedure proc = new TSQLProcedure("ModifStatistique", parameters);
return proc;
}
/* Méthode de création de la procédure de récupération d'un admin via son ID */
static public TSQLProcedure Rq_GetAdmin(int id)
{
// On créé un tableau qui va contenir les paramètres de la procédure, la taille du tableau, c'est le nombre de paramètre, ici 1
ProcedureParameter[] parameters = new ProcedureParameter[1];
// Un paramètre --> Un nom (ex: @id ou encore @login), un type (OleDBtype --> type que la BDD comprend),
// une valeur (ex: 1 pour un ID, William pour un admin, ect).
// On ajoute don ces paramètres dans le tableau
parameters[0] = new ProcedureParameter("@id", System.Data.OleDb.OleDbType.Integer, id);
// On créé donc la procédure, en spécifiant le nom et ses paramètres
TSQLProcedure proc = new TSQLProcedure("GetAdmin", parameters);
// On renvoie la procédure
return proc;
}
public TSQLProcedure(string name, ProcedureParameter[] parameters)
{
this.name = name;
this.parameters = parameters;
}