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));
}
