protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { //if (LoginHelper.UserRole(Page.User.Identity.Name) == "admin") //{ // GridView1.Columns[0].Visible = true; //} //else //{ // GridView1.Columns[0].Visible = false; //} if (Status == 4) //Ordered by class - need to insert headers to indicate the class name { GridView1.Columns[0].Visible = false; GridView1.Columns[GetColumnIndexByHeaderText(GridView1, "Classe")].Visible = false; if (e.Row.RowType == DataControlRowType.DataRow) { EleveWithContacts current = (EleveWithContacts)e.Row.DataItem; Table tbl = e.Row.Parent as Table; GroupByClass(tbl, current.ClasseActuelle, false); } } }
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { foreach (DictionaryEntry de in e.NewValues) { DateTime currentDate = DateTime.MinValue; if (de.Value != null && DateTime.TryParse(de.Value.ToString(), out currentDate)) { e.NewValues[de.Key] = currentDate.ToString(new CultureInfo("en-US")); } } IDictionary values = GetValues(GridView1.Rows[GridView1.EditIndex]); EleveWithContacts current = (EleveWithContacts)GridView1.Rows[e.RowIndex].DataItem; int inscritcol = GetColumnIndexByHeaderText(GridView1, "Inscrit"); int permissioncol = GetColumnIndexByHeaderText(GridView1, "Problèmes et Permissions"); int rowindex = e.RowIndex; if (GridView1.Columns[1].Visible) { e.NewValues["ActuellementInscrit"] = IsChecked("ActuellementInscrit", rowindex, 1); e.NewValues["PreInscrit"] = IsChecked("PreInscrit", rowindex, 1); } else { e.NewValues["ActuellementInscrit"] = e.OldValues["ActuellementInscrit"]; e.NewValues["PreInscrit"] = e.OldValues["PreInscrit"]; } if (GridView1.Columns[8].Visible) { e.NewValues["PbMedicaux"] = IsChecked("PbMedicaux", rowindex, 8); e.NewValues["PhotosClasse"] = IsChecked("PhotosClasse", rowindex, 8); e.NewValues["PhotosWeb"] = IsChecked("PhotosWeb", rowindex, 8); e.NewValues["Gateaux"] = IsChecked("Gateaux", rowindex, 8); } else { e.NewValues["PbMedicaux"] = e.OldValues["PbMedicaux"]; e.NewValues["PhotosClasse"] = e.OldValues["PhotosClasse"]; e.NewValues["PhotosWeb"] = e.OldValues["PhotosWeb"]; e.NewValues["Gateaux"] = e.OldValues["Gateaux"]; } }
public static List <EleveWithContacts> GetElevesWithContacts(string SortColumns, string Filter) { //MySqlCommand cmd = new MySqlCommand("ShowAllEleves", // new MySqlConnection(GetConnectionString())); //cmd.CommandType = CommandType.StoredProcedure; string verifiedsort = VerifySortColumns(SortColumns); string filter = Filter; string sqlstring = "SELECT *, ct_contacts.nom AS NomContact, ct_contacts.prenom AS PrenomContact, " + "ct_contacts.ActuellementInscrit AS ActuellementInscritContact, classes.Niveau " + "FROM eleves LEFT JOIN ct_contacts ON eleves.contactid = ct_contacts.id LEFT JOIN classes ON eleves.ClasseActuelle = classes.Nom"; if (!String.IsNullOrEmpty(filter)) { sqlstring += " WHERE " + filter; } if (verifiedsort.Trim() == "") { sqlstring += " ORDER BY eleves.Nom"; } else { sqlstring += " ORDER BY " + verifiedsort; } MySqlCommand cmd = new MySqlCommand(sqlstring, new MySqlConnection(GetConnectionString())); cmd.Connection.Open(); MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); List <EleveWithContacts> EleveList = new List <EleveWithContacts>(); while (dr.Read()) { EleveWithContacts contact = new EleveWithContacts(); contact.Eleve_ID = Convert.ToInt32(dr["ID"]); contact.ActuellementInscrit = MakeBool(dr["ActuellementInscrit"].ToString()); contact.ContactID = Convert.ToInt32(dr["ContactID"]); contact.AdresseAutreParent = Convert.ToString(dr["AdresseAutreParent"]); contact.ClasseActuelle = Convert.ToString(dr["ClasseActuelle"]); contact.DateNaissance = String.IsNullOrEmpty(dr["DateNaissance"].ToString()) ? Convert.ToDateTime("01/01/0001") : Convert.ToDateTime(dr["DateNaissance"]); //Convert.ToDateTime(dr["DateNaissance"]); contact.DetailsMedicaux = Convert.ToString(dr["DetailsMedicaux"]); contact.Docteur = Convert.ToString(dr["Docteur"]); contact.EmailAutreParent = Convert.ToString(dr["EmailAutreParent"]); contact.FixeAutreParent = Convert.ToString(dr["FixeAutreParent"]); contact.Gateaux = MakeBool(dr["Gateaux"].ToString()); contact.Nationalite = Convert.ToString(dr["Nationalite"]); contact.Nom = Convert.ToString(dr["Nom"]); contact.NomAutreParent = Convert.ToString(dr["NomAutreParent"]); contact.PbMedicaux = MakeBool(dr["PbMedicaux"].ToString()); contact.PhotosClasse = MakeBool(dr["PhotosClasse"].ToString()); contact.PhotosWeb = MakeBool(dr["PhotosWeb"].ToString()); contact.PortableAutreParent = Convert.ToString(dr["PortableAutreParent"]); contact.PreInscrit = MakeBool(dr["PreInscrit"].ToString()); contact.PremiereRentree = String.IsNullOrEmpty(dr["PremiereRentree"].ToString()) ? Convert.ToDateTime("01/01/0001") : Convert.ToDateTime(dr["PremiereRentree"]); contact.Prenom = Convert.ToString(dr["Prenom"]); contact.PrenomAutreParent = Convert.ToString(dr["PrenomAutreParent"]); contact.RelationAutreParent = Convert.ToString(dr["RelationAutreParent"]); contact.Sexe = Convert.ToString(dr["Sexe"]); // Information from Contacts table contact.ActuellementInscritContact = MakeBool(dr["ActuellementInscritContact"].ToString()); contact.Adresse1 = Convert.ToString(dr["Adresse1"]); contact.Adresse2 = Convert.ToString(dr["Adresse2"]); contact.Adresse3 = Convert.ToString(dr["Adresse3"]); contact.CodePostal = Convert.ToString(dr["Code Postal"]); contact.Comite = MakeBool(dr["Comite"].ToString()); contact.Email = Convert.ToString(dr["Email"]); contact.Fixe = Convert.ToString(dr["Fixe"]); contact.NePasContacter = MakeBool(dr["NePasContacter"].ToString()); contact.NomContact = Convert.ToString(dr["NomContact"]); contact.Notes = Convert.ToString(dr["Notes"]); contact.Portable = Convert.ToString(dr["Portable"]); contact.PrenomContact = Convert.ToString(dr["PrenomContact"]); contact.Ville = Convert.ToString(dr["Ville"]); EleveList.Add(contact); } dr.Close(); return(EleveList); }
public static void UpdateEleveWithContacts(EleveWithContacts contact) { string sqlstring = "UPDATE `eleves` SET `ContactID`=?vContactID, `Nom`=?vNom,`Prenom`=?vPrenom,`DateNaissance`=?vDateNaissance,`Nationalite`=?vNationalite,`PremiereRentree`=?vPremiereRentree,`ClasseActuelle`=?vClasseActuelle,`ActuellementInscrit`=?vActuellementInscrit,`PreInscrit`=?vPreInscrit,`Sexe`=?vSexe, " + "RelationAutreParent=?vRelationAutreParent, NomAutreParent=?vNomAutreParent, PrenomAutreParent=?vPrenomAutreParent, AdresseAutreParent=?vAdresseAutreParent, FixeAutreParent=?vFixeAutreParent, PortableAutreParent=?vPortableAutreParent, EmailAutreParent=?vEmailAutreParent, Docteur=?vDocteur, " + "PhotosClasse=?vPhotosClasse, PhotosWeb=?vPhotosWeb, Gateaux=?vGateaux, PbMedicaux=?vPbMedicaux, DetailsMedicaux=?vDetailsMedicaux WHERE id=?key"; using (MySqlCommand cmd = new MySqlCommand(sqlstring, new MySqlConnection(GetConnectionString()))) { cmd.Parameters.Add(new MySqlParameter("key", contact.Eleve_ID)); cmd.Parameters.Add(new MySqlParameter("vContactID", contact.ContactID)); cmd.Parameters.Add(new MySqlParameter("vNom", contact.Nom)); cmd.Parameters.Add(new MySqlParameter("vPrenom", contact.Prenom)); cmd.Parameters.Add(new MySqlParameter("vDateNaissance", (String.IsNullOrEmpty(contact.DateNaissance.ToString()) ? Convert.ToDateTime("01/01/0001") : contact.DateNaissance))); cmd.Parameters.Add(new MySqlParameter("vNationalite", contact.Nationalite)); cmd.Parameters.Add(new MySqlParameter("vPremiereRentree", contact.PremiereRentree)); //cmd.Parameters.Add(new MySqlParameter("vNiveau", contact.Niveau)); cmd.Parameters.Add(new MySqlParameter("vClasseActuelle", contact.ClasseActuelle)); cmd.Parameters.Add(new MySqlParameter("vActuellementInscrit", Convert.ToInt32(contact.ActuellementInscrit))); cmd.Parameters.Add(new MySqlParameter("vPreInscrit", Convert.ToInt32(contact.PreInscrit))); cmd.Parameters.Add(new MySqlParameter("vSexe", contact.Sexe)); cmd.Parameters.Add(new MySqlParameter("vRelationAutreParent", contact.RelationAutreParent)); cmd.Parameters.Add(new MySqlParameter("vNomAutreParent", contact.NomAutreParent)); cmd.Parameters.Add(new MySqlParameter("vPrenomAutreParent", contact.PrenomAutreParent)); cmd.Parameters.Add(new MySqlParameter("vAdresseAutreParent", contact.AdresseAutreParent)); cmd.Parameters.Add(new MySqlParameter("vFixeAutreParent", contact.FixeAutreParent)); cmd.Parameters.Add(new MySqlParameter("vPortableAutreParent", contact.PortableAutreParent)); cmd.Parameters.Add(new MySqlParameter("vEmailAutreParent", contact.EmailAutreParent)); cmd.Parameters.Add(new MySqlParameter("vDocteur", contact.Docteur)); cmd.Parameters.Add(new MySqlParameter("vPhotosClasse", Convert.ToInt32(contact.PhotosClasse))); cmd.Parameters.Add(new MySqlParameter("vPhotosWeb", Convert.ToInt32(contact.PhotosWeb))); cmd.Parameters.Add(new MySqlParameter("vGateaux", Convert.ToInt32(contact.Gateaux))); cmd.Parameters.Add(new MySqlParameter("vPbMedicaux", Convert.ToInt32(contact.PbMedicaux))); cmd.Parameters.Add(new MySqlParameter("vDetailsMedicaux", contact.DetailsMedicaux)); cmd.Connection.Open(); cmd.ExecuteNonQuery(); } sqlstring = "UPDATE ct_contacts SET `Nom`=?vNom, `Prenom`=?vPrenom, `Adresse1`=?vAdresse1, `Adresse2`=?vAdresse2, `Adresse3`=?vAdresse3, `Ville`=?vVille, `Code Postal`=?vCodePostal, `Fixe`=?vFixe, `Portable`=?vPortable, `Email`=?vEmail, `Notes`=?vNotes, `ActuellementInscrit`=?vActuellementInscrit, `Comite`=?vComite, `NePasContacter`=?vNePasContacter WHERE ID = ?vContactID"; using (MySqlCommand cmd = new MySqlCommand(sqlstring, new MySqlConnection(GetConnectionString()))) { //cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new MySqlParameter("vContactID", contact.ContactID)); cmd.Parameters.Add(new MySqlParameter("vNom", contact.NomContact)); cmd.Parameters.Add(new MySqlParameter("vPrenom", contact.PrenomContact)); cmd.Parameters.Add(new MySqlParameter("vAdresse1", contact.Adresse1)); cmd.Parameters.Add(new MySqlParameter("vAdresse2", contact.Adresse2)); cmd.Parameters.Add(new MySqlParameter("vAdresse3", contact.Adresse3)); cmd.Parameters.Add(new MySqlParameter("vVille", contact.Ville)); cmd.Parameters.Add(new MySqlParameter("vCodePostal", contact.CodePostal)); cmd.Parameters.Add(new MySqlParameter("vFixe", contact.Fixe)); cmd.Parameters.Add(new MySqlParameter("vPortable", contact.Portable)); cmd.Parameters.Add(new MySqlParameter("vEmail", contact.Email)); cmd.Parameters.Add(new MySqlParameter("vNotes", contact.Notes)); cmd.Parameters.Add(new MySqlParameter("vActuellementInscrit", Convert.ToInt32(contact.ActuellementInscritContact))); cmd.Parameters.Add(new MySqlParameter("vComite", Convert.ToInt32(contact.Comite))); cmd.Parameters.Add(new MySqlParameter("vNePasContacter", Convert.ToInt32(contact.NePasContacter))); cmd.Connection.Open(); cmd.ExecuteNonQuery(); } }