public bool SupprimerFigurineStuff(FigurineStuff NouvelleFigurineStuff) { if (!m_BD.EstConnecte) { Initialiser(); } NouvelleFigurineStuff.SupprimerEnCascade(m_BD); return(true); }
public bool ModifierFigurineStuff(FigurineStuff NouvelleFigurineStuff) { if (NouvelleFigurineStuff.Enregistrer(m_BD, NouvelleFigurineStuff, null, false) && (NouvelleFigurineStuff.Figurine.Enregistrer(m_BD, NouvelleFigurineStuff.Figurine, null, false))) { return(true); } else { return(false); } }
/// <summary> /// Met à jour la listview des Equipements et y insére les elements /// </summary> /// <typeparam name="T"></typeparam> /// <param name="Entites"></param> /// <returns></returns> private bool MettreAJourListe <T>(IEnumerable <T> Entites) where T : class, IEntiteMySQL { bool EstEquipement = typeof(T).Equals(typeof(FigurineStuff)); if (!EstEquipement) { return(false); } listViewEquipement.Items.Clear(); if (Entites == null) { return(false); } if (EstEquipement && (listViewEquipement.Columns.Count != 2)) { listViewEquipement.Columns.Clear(); listViewEquipement.Columns.Add(new ColumnHeader() { Name = "Equipements", Text = "Equipements", TextAlign = HorizontalAlignment.Center, }); } foreach (T Entite in Entites) { ListViewItem NouvelElement = new ListViewItem() { Tag = Entite }; NouvelElement.SubItems.Clear(); if (EstEquipement) { FigurineStuff Equipement = Entite as FigurineStuff; NouvelElement.Text = Equipement.Stuff.Name; NouvelElement.SubItems.Add(Equipement.Stuff.Name); } listViewEquipement.Items.Add(NouvelElement); } listViewEquipement.Visible = false; foreach (ColumnHeader Colonne in listViewEquipement.Columns) { Colonne.AutoResize(ColumnHeaderAutoResizeStyle.HeaderSize); } listViewEquipement.Visible = true; listViewEquipement_SelectedIndexChanged(listViewEquipement, EventArgs.Empty); return(true); }
private void Stuff_SurChangementSelection(object sender, EventArgs e) { // J'ai le stuff de la figurine // Je dois faire un figurinestuff? m_FigurineStuff = new FigurineStuff(); m_FigurineStuff = Program.GMBD.EnumererFigurineStuff(null, null, new MyDB.CodeSql("WHERE fs_fk_figurine_id = {0} AND fs_fk_stuff_id", m_Figurine.Id, z_listeDeroulanteStuff.StuffSelectionnee.Id), null).FirstOrDefault(); z_listeDeroulanteRank.Rank = Program.GMBD.EnumererRank(new MyDB.CodeSql("DISTINCT rank.ra_id, rank.ra_name"), new MyDB.CodeSql(@"JOIN char_rank ON char_rank.cr_fk_ra_id = rank.ra_id AND char_rank.cr_fk_ch_id = {0} JOIN stuff_char_rank ON stuff_char_rank.scr_fk_char_rank_id = char_rank.cr_id JOIN figurine ON figurine.fi_fk_character_id = 60 AND figurine.fi_fk_user_id = {1} ", z_listeDeroulanteChar.CharactSelectionnee.Id, Utilisateur.Id), new MyDB.CodeSql("WHERE stuff_char_rank.scr_fk_stuff_id = {0}", z_listeDeroulanteStuff.StuffSelectionnee.Id), null); z_listeDeroulanteRank.SurChangementSelection += Rank_SurChangementSelection; }
/// <summary> /// Permet d'énumrer les figurines_stuff liés à cette figurine /// </summary> /// <returns></returns> public IEnumerable <FigurineStuff> EnumererFigurineStuff() { if (base.Connexion == null) { return(new FigurineStuff[0]); } return(FigurineStuff.Enumerer(Connexion, Connexion.Enumerer( @"SELECT fi_id, fi_name, fs_id, st_id, st_name FROM figurine INNER JOIN figurine_stuff on fi_id = fs_fk_figurine_id INNER JOIN stuff on st_id = fs_fk_stuff_id WHERE fi_id = {0}", Id))); }
private void AjoutEquipementSurFigurine(object sender, EventArgs e) { if ((ficheEquipementSansRecherche1.EquipementSelectionne != null) && (ficheFigurineStuff1.FigurineSelectionne != null)) { FigurineStuff NouvelleFigurineStuff = new FigurineStuff(); // NouvelleFigurine.SurErreur += FigurineEnEdition_SurErreur; // NouvelleFigurine.AvantChangement += FigurineEnEdition_AvantChangement; // NouvelleFigurine.ApresChangement += FigurineEnEdition_ApresChangement; NouvelleFigurineStuff.Figurine = ficheFigurineStuff1.FigurineSelectionne; NouvelleFigurineStuff.Stuff = ficheEquipementSansRecherche1.EquipementSelectionne; if ((NouvelleFigurineStuff.EstValide) && Program.GMBD.AjouterFigurineStuff(NouvelleFigurineStuff)) { ficheEquipementSurFigurine1.Equipement = Program.GMBD.EnumererFigurineStuff(null, new MyDB.CodeSql("JOIN stuff on fs_fk_stuff_id = st_id"), new MyDB.CodeSql("WHERE fs_fk_figurine_id = {0}", ficheFigurineStuff1.FigurineSelectionne.Id), new MyDB.CodeSql("ORDER BY st_name")); } } }
public IEnumerable <FigurineStuff> EnumererFigurineStuff(MyDB.CodeSql ValeurSouhaitee, MyDB.CodeSql ClauseJoin, MyDB.CodeSql ClauseWhere, MyDB.CodeSql ClauseOrderBy) { if (ClauseWhere == null) { ClauseWhere = MyDB.CodeSql.Vide; } if (ClauseOrderBy == null) { ClauseOrderBy = MyDB.CodeSql.Vide; } if (ClauseJoin == null) { ClauseJoin = MyDB.CodeSql.Vide; } if (ValeurSouhaitee == null) { ValeurSouhaitee = new MyDB.CodeSql("*"); } return(FigurineStuff.Enumerer(m_BD, m_BD.Enumerer("SELECT {0} FROM {1} {2} {3} {4}", ValeurSouhaitee, c_NomTable_FigurineStuff, ClauseJoin, ClauseWhere, ClauseOrderBy))); }
//+=========================+ //| Requetes Figurine Stuff | //+=========================+ public bool AjouterFigurineStuff(FigurineStuff NouvelleFigurineStuff) { return(NouvelleFigurineStuff.Enregistrer(m_BD, NouvelleFigurineStuff, null, false)); }