/// <summary> /// methode pou ajouter etudiant nan class /// </summary> void ajouteretudiant() { exceptionclick(); // Save info in ClassSession table string sSql = ""; Response.Write(string.Empty); if (SessionRemplie()) { lblMessage.Text = "Classe Remplie, Plus de places !!!"; } //ScriptManager.RegisterStartupScript(this, this.GetType(), "Messagebox", "alert(' Classe Remplie, Plus de places !!! ');", true); else { try { SqlParameter paramSessionID = new SqlParameter("@SessionID", SqlDbType.Int); paramSessionID.Value = int.Parse(DropDownListOptionhoraire1.SelectedValue); SqlParameter paramStudentID = new SqlParameter("@PersonneID", SqlDbType.Int); paramStudentID.Value = int.Parse(lstEtudiant.SelectedValue); SqlParameter paramUserId = new SqlParameter("@CreeParUsername", SqlDbType.VarChar); paramUserId.Value = BaseDeDonnees.GetWindowsUser(); sSql = "INSERT INTO EtudiantsCourants (SessionID, PersonneID, CreeParUsername) VALUES (@SessionID, @PersonneID, @CreeParUsername)"; if (donnees.IssueCommandWithParams(sSql, paramSessionID, paramStudentID, paramUserId)) { lblMessage.Text = "Succès: Etudiant Inscrit!"; // ScriptManager.RegisterStartupScript(this, this.GetType(), "Messagebox", "alert(' Succès: Etudiant Inscrit! ');", true); choisirSujet(); DropDownListNiveau.Items.Clear(); DropDownListOptionhoraire1.Items.Clear(); btneffacer(); lstEtudiant.Items.Clear(); btnsauvegarder.Enabled = true; } else { lblMessage.Text = "ERREUR: Etudiant n'est pas inscrit!"; // ScriptManager.RegisterStartupScript(this, this.GetType(), "Messagebox", "alert(' ERREUR: Etudiant n'est pas inscrit! ');", true); } //Redirect to another page } catch (Exception ex) { Response.Write("ERROR: " + ex.Message); } } }
protected void btnTerminer_Click(object sender, EventArgs e) { // Save info in ClassSession table string sSql = ""; if (SessionRemplie()) { lblMessage.Text = (""); } else { try { SqlParameter paramSessionID = new SqlParameter("@SessionID", SqlDbType.Int); paramSessionID.Value = int.Parse(ListeHoraire.SelectedValue); SqlParameter paramStudentID = new SqlParameter("@PersonneID", SqlDbType.Int); paramStudentID.Value = int.Parse(lstClasse.SelectedValue); SqlParameter paramUserId = new SqlParameter("@CreeParUsername", SqlDbType.VarChar); paramUserId.Value = BaseDeDonnees.GetWindowsUser(); sSql = "INSERT INTO EtudiantsCourants (SessionID, PersonneID, CreeParUsername) VALUES (@SessionID, @PersonneID, @CreeParUsername)"; if (donnees.IssueCommandWithParams(sSql, paramSessionID, paramStudentID, paramUserId)) { lblMessage.Text = ("Succès: étudiant inscrit avec succès!!!"); } else { lblMessage.Text = ("Les Conditions sont-elles réunies?\n 1- Vérifier si l'étudiant n'est pas déjà inscrit dans la classe. \n 2-Avez-vous choisi les options à gauche de ta fenêtre? 3- Vérifier si l'étudiant est élligible pour la classe\n 4- Ou voir un technicien. "); } //Redirect to another page } catch (Exception ex) { //this.Page.ClientScript.RegisterStartupScript(this.GetType(), "ex", "alert('" + ex.Message + "');", true); lblMessage.Text = ("Les Conditions sont-elles réunies?\n 1- Vérifier si vous avez choisi l'option, " + "l'horaire et la classe vous voulez inscrire l'étudiant.\n 2- Vérifier si l'étudiant est élligible pour la classe " + ex.Message); } } }
public void Dernier_Etudiant_Inscrit() { //String remplirdropop = "Select SessionID, JourRencontre + ': ' + Heures As SessionName From Sessions Where Actif = 1"; //string sSql = "SELECT PersonneID, Nom + ', ' + Prenom as NomComplet FROM Personnes WHERE Etudiant = 1 ORDER BY Nom, Prenom"; BaseDeDonnees donnees = new BaseDeDonnees(); String user = BaseDeDonnees.GetWindowsUser(); // String Administrator = System.Security.Principal.WindowsIdentity.GetCurrent().Name; //String sSql = "SELECT PersonneID, Nom + ', ' + Prenom as NomComplet From Personnes WHERE Etudiant = 1 AND CreeParUsername = '******' AND PersonneID = (Select MAX(Personnes.PersonneID) From Personnes)"; String sSql = ("SELECT PersonneID,Nom + ' ' + Prenom + '---' + replace(convert(nvarchar,Isnull(DDN,'')), '1900-01-01', 'N/A') as NomComplet From Personnes, DatesSessionCourante D WHERE Etudiant = 1 AND D.actif = 1 AND CreeParUsername = '******' order by Personnes.PersonneID DESC"); //'" + user.Trim(); //String sSql = String.Format("SELECT P.PersonneID, P.Nom + ', ' + P.Prenom + '--' + replace(convert(nvarchar,Isnull(P.DDN,'')), '1900-01-01', 'N/A') as NomComplet " + // "FROM Personnes P,EtudiantsCourants E,DatesSessionCourante D, Sessions S WHERE E.PersonneID = P.PersonneID AND E.SessionID = S.SessionID AND Etudiant = 1 AND D.actif = 1 ORDER BY NomComplet"); DataSet dc = new DataSet(); dc = donnees.GetDataSet(sSql); this.lstEtudiant.DataSource = dc; lstEtudiant.DataValueField = "PersonneID"; lstEtudiant.DataTextField = "NomComplet"; lstEtudiant.DataBind(); this.lstEtudiant.SelectedIndex = 0; }
void selectcount() { String user = BaseDeDonnees.GetWindowsUser().ToString().Trim(); String sTemp = ""; string sql = "SELECT count(CreeParUsername) as countuser FROM Personnes where DateCreee= CONVERT(date, getdate()) and CreeParUsername ='******'"; try { SqlDataAdapter da = new SqlDataAdapter(sql, ChaineDeConnexion); DataTable dt = new DataTable(); da.Fill(dt); DataTableReader dr = dt.CreateDataReader(); if (dr != null) { dr.Read(); sTemp = dr["countuser"].ToString().Trim(); LblCount.ForeColor = System.Drawing.Color.Green; LblCount.Text = " Vous avez inscrit " + sTemp + " Etudiant(s) Pour Aujourd' ! "; } }catch (Exception e) { lblSucces.Text = ("Error: No database connection"); } }
protected void Edit() { int etu = 1; int prof = 0; int addstaf = 0; string mydate; string sSql = ""; string sStudentID = ""; lblMessage.Text = string.Empty; sPersonneID = txtPersonneID.Text; try { // ToutbagayOk(); SqlParameter paramPersonneID = new SqlParameter("@PersonneID", SqlDbType.Int); if (Request["pid"] != null) // Existing student { sStudentID = Request["pid"].ToString(); paramPersonneID.Value = int.Parse(sStudentID); } else if (sPersonneID != String.Empty) { sStudentID = sPersonneID; // Was selected in list box of existing students/personnes paramPersonneID.Value = int.Parse(sStudentID); } mydate = DateTime.Now.ToString("MM.dd.yyyy"); SqlParameter nomparam = new SqlParameter("@Nom", DbType.String.ToString()); nomparam.Value = txtNom.Text; SqlParameter prenomparam = new SqlParameter("@Prenom", DbType.String.ToString()); prenomparam.Value = txtPrenom.Text; SqlParameter ddnparam = new SqlParameter("@DDN", DbType.String.ToString()); ddnparam.Value = txtdate.Text; SqlParameter niveauetudeparam = new SqlParameter("@NiveauEtude", DbType.String.ToString()); niveauetudeparam.Value = txtetude.Text; SqlParameter telephoneparam = new SqlParameter("@Telephone1", DbType.String.ToString()); telephoneparam.Value = txttelephone.Text; SqlParameter emailparam = new SqlParameter("@Email", DbType.String.ToString()); emailparam.Value = txtemail.Text; SqlParameter numeromaisonparam = new SqlParameter("@AdresseExtra", DbType.String.ToString()); numeromaisonparam.Value = txtnumeromaison.Text; SqlParameter Adresserueparam = new SqlParameter("@AdresseRue", DbType.String.ToString()); Adresserueparam.Value = txtrue.Text; SqlParameter Villeparam = new SqlParameter("@Ville", DbType.String.ToString()); Villeparam.Value = txtville.Text; SqlParameter Remarqueparam = new SqlParameter("@Remarque", DbType.String.ToString()); Remarqueparam.Value = txtRemarque.InnerText; SqlParameter UserIdparam = new SqlParameter("@CreeParUsername", DbType.String.ToString()); UserIdparam.Value = BaseDeDonnees.GetWindowsUser(); SqlParameter datecreparam = new SqlParameter("@DateCreee", DbType.Date); datecreparam.Value = mydate; SqlParameter profparam = new SqlParameter("@Professeur", DbType.Int32.ToString()); profparam.Value = prof; SqlParameter etudiantparam = new SqlParameter("@Etudiant", DbType.Int32.ToString()); etudiantparam.Value = etu; SqlParameter AdminStafparam = new SqlParameter("@AdminStaff", DbType.Int32.ToString()); AdminStafparam.Value = addstaf; // Current User SqlParameter paramCreeParUsername = new SqlParameter("@CreeParUsername", SqlDbType.VarChar); paramCreeParUsername.Value = BaseDeDonnees.GetWindowsUser(); SqlParameter Sexeparam = new SqlParameter("@Sexe", DbType.String.ToString()); Sexeparam.Value = DrpSexe.SelectedItem.Text; SqlParameter departementparam = new SqlParameter("@GroupeSanguin", DbType.String.ToString()); departementparam.Value = DropDownDepartement.SelectedItem.Text; SqlParameter telephone2param = new SqlParameter("@Telephone2", DbType.String.ToString()); telephone2param.Value = Txturgence.Text; sSql = "UPDATE Personnes SET Prenom = @Prenom, Nom = @Nom, Telephone1 = @Telephone1, DDN = @DDN, AdresseRue = @AdresseRue, AdresseExtra = @AdresseExtra, Ville = @Ville, NiveauEtude = @NiveauEtude, Remarque = @Remarque, Etudiant = @Etudiant, Professeur = @Professeur,AdminStaff = @AdminStaff, CreeParUsername = @CreeParUsername, Email = @Email WHERE PersonneID = @PersonneID"; if (donnees.IssueCommandWithParams(sSql, nomparam, prenomparam, ddnparam, niveauetudeparam, telephoneparam, emailparam, numeromaisonparam, Villeparam, datecreparam, Adresserueparam, UserIdparam, etudiantparam, profparam, AdminStafparam, Remarqueparam, paramPersonneID)) { lblSucces.Text = string.Format("'{0} {1}' est mis à jour !", txtPrenom.Text, txtNom.Text); Nettoyer(); } else { lblMessage.Text = "ERREUR: Dossier n'est pas mis à jour !"; } } catch (Exception ex) { lblMessage.Text = "ERROR: " + ex.Message + string.Format("--Specific Error: ('{0} {1}') Dossier Non Modifié!", txtPrenom.Text, txtNom.Text);; } }
/// <summary> /// Methode sauvegarder /// </summary> void methodesauvegarder() { string sSql = ""; string sStudentID = ""; lblMessage.Text = string.Empty; sPersonneID = txtPersonneID.Text; try { ToutbagayOk(); SqlParameter paramPersonneID = new SqlParameter("@PersonneID", SqlDbType.Int); if (Request["pid"] != null) // Existing student { sStudentID = Request["pid"].ToString(); paramPersonneID.Value = int.Parse(sStudentID); } else if (sPersonneID != String.Empty) { sStudentID = sPersonneID; // Was selected in list box of existing students/personnes paramPersonneID.Value = int.Parse(sStudentID); } int etu = 1; int prof = 0; int addstaf = 0; string mydate; mydate = DateTime.Now.ToString("MM.dd.yyyy"); SqlParameter nomparam = new SqlParameter("@Nom", DbType.String.ToString()); nomparam.Value = txtNom.Text; SqlParameter prenomparam = new SqlParameter("@Prenom", DbType.String.ToString()); prenomparam.Value = txtPrenom.Text; SqlParameter ddnparam = new SqlParameter("@DDN", DbType.String.ToString()); ddnparam.Value = txtdate.Text; SqlParameter niveauetudeparam = new SqlParameter("@NiveauEtude", DbType.String.ToString()); niveauetudeparam.Value = txtetude.Text; SqlParameter telephoneparam = new SqlParameter("@Telephone1", DbType.String.ToString()); telephoneparam.Value = txttelephone.Text; SqlParameter emailparam = new SqlParameter("@Email", DbType.String.ToString()); emailparam.Value = txtemail.Text; SqlParameter numeromaisonparam = new SqlParameter("@AdresseExtra", DbType.String.ToString()); numeromaisonparam.Value = txtnumeromaison.Text; SqlParameter Adresserueparam = new SqlParameter("@AdresseRue", DbType.String.ToString()); Adresserueparam.Value = txtrue.Text; SqlParameter Villeparam = new SqlParameter("@Ville", DbType.String.ToString()); Villeparam.Value = txtville.Text; SqlParameter Remarqueparam = new SqlParameter("@Remarque", DbType.String.ToString()); Remarqueparam.Value = txtRemarque.InnerText; SqlParameter UserIdparam = new SqlParameter("@CreeParUsername", DbType.String.ToString()); UserIdparam.Value = BaseDeDonnees.GetWindowsUser(); SqlParameter datecreparam = new SqlParameter("@DateCreee", DbType.Date); datecreparam.Value = mydate; SqlParameter profparam = new SqlParameter("@Professeur", DbType.Int32.ToString()); profparam.Value = prof; SqlParameter etudiantparam = new SqlParameter("@Etudiant", DbType.Int32.ToString()); etudiantparam.Value = etu; SqlParameter AdminStafparam = new SqlParameter("@AdminStaff", DbType.Int32.ToString()); AdminStafparam.Value = addstaf; // Current User SqlParameter paramCreeParUsername = new SqlParameter("@CreeParUsername", SqlDbType.VarChar); paramCreeParUsername.Value = BaseDeDonnees.GetWindowsUser(); SqlParameter Sexeparam = new SqlParameter("@Sexe", DbType.String.ToString()); Sexeparam.Value = DrpSexe.SelectedItem.Text; SqlParameter departementparam = new SqlParameter("@GroupeSanguin", DbType.String.ToString()); departementparam.Value = DropDownDepartement.SelectedItem.Text; SqlParameter telephone2param = new SqlParameter("@Telephone2", DbType.String.ToString()); telephone2param.Value = Txturgence.Text; if (sStudentID == String.Empty) { // methodesauvegarder(); sSql = "INSERT INTO Personnes (Prenom, Nom, Telephone1,Telephone2, DDN, AdresseRue, AdresseExtra, Ville, NiveauEtude, Remarque, Etudiant, Professeur, AdminStaff, CreeParUsername,Email,Sexe,GroupeSanguin) VALUES (" + "@Prenom, @Nom, @Telephone1, @Telephone2,@DDN, @AdresseRue, @AdresseExtra, @Ville, @NiveauEtude, @Remarque, @Etudiant, @Professeur, @AdminStaff, @CreeParUsername,@Email,@Sexe,@GroupeSanguin)"; bool bResult = donnees.IssueCommandWithParams(sSql, nomparam, prenomparam, ddnparam, niveauetudeparam, telephoneparam, telephone2param, emailparam, numeromaisonparam, Villeparam, datecreparam, Adresserueparam, UserIdparam, etudiantparam, profparam, AdminStafparam, departementparam , Remarqueparam, Sexeparam); //int iIdentity = DB_Access.GetScalarWithParams(sSql, nomparam, prenomparam, ddnparam, //niveauetudeparam, telephoneparam, emailparam, numeromaisonparam, Villeparam, datecreparam, Adresserueparam, UserIdparam, etudiantparam, profparam, AdminStafparam, Remarqueparam); if (bResult == true) { sPersonneID = bResult.ToString(); lblSucces.Text = string.Format("'{0} {1}' est ajouté dans le système !", txtPrenom.Text, txtNom.Text); // ClearForm(); Nettoyer(); btnsauvegarder.Enabled = false; } else { lblMessage.Text = string.Format("ERROR Adding User '{0} {1}'!", txtPrenom.Text, txtNom.Text); } } } catch (Exception ex) { lblMessage.Text = "ERROR: " + ex.Message + string.Format("--Specific Error: ('{0} {1}') Dossier Non Modifié!", txtPrenom.Text, txtNom.Text);; } }
protected void BtnAddClasse_Click(object sender, EventArgs e) { donnees = new BaseDeDonnees(); string[] sTemp = new string[2]; // Split date Debut and Date fin String ChaineDeConnexion = ConfigurationManager.ConnectionStrings["connection"].ToString(); string sSql = "SELECT SessionDateID, Convert(varchar, SessionDateDebut) + ' - ' + Convert(varchar,SessionDateFin) AS SessionDate from DatesSessionCourante WHERE Actif = 1 ORDER BY SessionDateDebut DESC"; donnees.GetDataReader(sSql); SqlDataAdapter da = new SqlDataAdapter(sSql, ChaineDeConnexion); DataTable dTable = new DataTable(); da.Fill(dTable); //DataTableReader dt = donnees; DataTableReader dr = dTable.CreateDataReader(); if (dr != null) { dr.Read(); sTemp = dr["SessionDate"].ToString().Split('-'); lblDateDebut.InnerText = sTemp[0].Trim(); lblDateFin.InnerText = sTemp[1].Trim(); } // Fin try { if (!ToutBagayPaAnfom()) { lblError.InnerText = ("Toutes les Informations sont obligatoires Pour Continuer !!!"); } else { lblError.InnerText = string.Empty; string sSql1 = string.Format("INSERT INTO Sessions(ClasseID, ProfesseurID, MaxEtudiants, JourRencontre, Heures, " + "MontantParticipation, DateCommence, DateFin, byUsername) VALUES ({0},{1},{2},'{3}','{4}',{5},'{6}','{7}','{8}')", NomClasse.SelectedItem.Value, DrpProfesseurName.SelectedItem.Value, txtMaxEtudiant.Text, dJourDeClasse.SelectedItem.Text, DropHeureDeClasse.SelectedItem.Text, txtMontant.Text, lblDateDebut.InnerText, lblDateFin.InnerText, BaseDeDonnees.GetWindowsUser()); //donnees.GetWindowsUser() if (donnees.IssueCommand(sSql1)) { lblSucces.Text = "Données sauvegardees avec succes !!"; ResetToutBagay(); // Pou ka rantre lòt donnees } else { lblError.InnerText = "ERROR: Données PAS Sauvegardées -- Voir Un Technicien!!!"; } } } catch (Exception ex) { lblError.InnerText = ("ERROR: Données PAS Sauvegardées " + ex); } }
void methodesauvegarder() { if (txtNom.Text == "" || txtdate.Text == "" || txtetude.Text == "" || txtPrenom.Text == "" || txtrue.Text == "" || txtville.Text == "") { lblerror.Text = "Remplissez tout les champs Svp !!!"; // ScriptManager.RegisterStartupScript(this, this.GetType(), "Messagebox", "alert('Remplissez tout les champs Svp !!! ');", true); } else { lblerror.Text = ""; int prof = 1; int etu = 0; int addstaf = 0; nettoyertextbox(); //lowertoupper(); try { // String insereEtudiant = "INSERT INTO Personnes (Prenom,Nom,Telephone1,DDN,AdresseRue,AdresseExtra,Ville,NiveauEtude,DateCreee,Remarque,Etudiant,Professeur,AdminStaff,CreeParUsername,Email" + // "values(@Prenom,@Nom,@Telephone1,@DDN,@AdresseRue,@AdresseExtra,@Ville,@NiveauEtude,@DateCreee,@Remarque,@Etudiant,@Professeur,@AdminStaff,@CreeParUsername,@Email)"; String insereEtudiant = "INSERT INTO Personnes (Prenom, Nom, Telephone1, DDN, AdresseRue, AdresseExtra, Ville, NiveauEtude, Remarque, Etudiant, Professeur, AdminStaff, CreeParUsername,Email) VALUES (" + "@Prenom, @Nom, @Telephone1,@DDN, @AdresseRue, @AdresseExtra, @Ville, @NiveauEtude, @Remarque, @Etudiant, @Professeur, @AdminStaff, @CreeParUsername,@Email)"; string mydate; mydate = DateTime.Now.ToString("MM.dd.yyyy"); string nom = formaterNom(txtNom.Text); string prenom = formaterNom(txtPrenom.Text); SqlParameter nomparam = new SqlParameter("@Nom", DbType.String.ToString()); nomparam.Value = nom; SqlParameter prenomparam = new SqlParameter("@Prenom", DbType.String.ToString()); prenomparam.Value = prenom; SqlParameter ddnparam = new SqlParameter("@DDN", DbType.String.ToString()); ddnparam.Value = txtdate.Text; SqlParameter niveauetudeparam = new SqlParameter("@NiveauEtude", DbType.String.ToString()); niveauetudeparam.Value = txtetude.Text; SqlParameter telephoneparam = new SqlParameter("@Telephone1", DbType.String.ToString()); telephoneparam.Value = txtTelephone.Text; SqlParameter emailparam = new SqlParameter("@Email", DbType.String.ToString()); emailparam.Value = txtemail.Text; SqlParameter numeromaisonparam = new SqlParameter("@AdresseExtra", DbType.String.ToString()); numeromaisonparam.Value = txtnumeromaison.Text; SqlParameter Adresserueparam = new SqlParameter("@AdresseRue", DbType.String.ToString()); Adresserueparam.Value = txtrue.Text; SqlParameter Villeparam = new SqlParameter("@Ville", DbType.String.ToString()); Villeparam.Value = txtville.Text; SqlParameter Remarqueparam = new SqlParameter("@Remarque", DbType.String.ToString()); Remarqueparam.Value = txtRemarque.InnerText; SqlParameter UserIdparam = new SqlParameter("@CreeParUsername", DbType.String.ToString()); UserIdparam.Value = BaseDeDonnees.GetWindowsUser(); SqlParameter datecreparam = new SqlParameter("@DateCreee", DbType.Date); datecreparam.Value = mydate; SqlParameter profparam = new SqlParameter("@Professeur", DbType.Int32.ToString()); profparam.Value = prof; SqlParameter etudiantparam = new SqlParameter("@Etudiant", DbType.Int32.ToString()); etudiantparam.Value = etu; SqlParameter AdminStafparam = new SqlParameter("@AdminStaff", DbType.Int32.ToString()); AdminStafparam.Value = addstaf; // SqlParameter Nifparam = new SqlParameter("@Etudiant", DbType.Int32.ToString()); // Nifparam.Value = TextnifOuCin.Text; ; bool bResult = donnees.IssueCommandWithParams(insereEtudiant, nomparam, prenomparam, ddnparam, niveauetudeparam, telephoneparam, emailparam, numeromaisonparam, Villeparam, datecreparam, Adresserueparam, UserIdparam, etudiantparam, profparam, AdminStafparam, Remarqueparam); } catch (Exception e) { Response.Write("Ërror..." + e); } lblerror.Text = "Professeur Enregistrer avec Succes !!! "; // ScriptManager.RegisterStartupScript(this, this.GetType(), "Messagebox", "alert(' Professeur Enregistrer avec Succes !!! ');", true); Nettoyer(); } }