private void Rank_SurChangementSelection(object sencder, EventArgs e)
{
StuffCharactRank SCR = new StuffCharactRank();
SCR = Program.GMBD.EnumererStuffCharactRank(new MyDB.CodeSql("DISTINCT stuff_char_rank.scr_id, stuff_char_rank.scr_fk_stuff_id, stuff_char_rank.scr_fk_char_rank_id, stuff_char_rank.scr_cost, stuff_char_rank.scr_min, stuff_char_rank.scr_max"),
new MyDB.CodeSql(@"JOIN char_rank ON char_rank.cr_id = stuff_char_rank.scr_fk_char_rank_id
JOIN rank ON char_rank.cr_fk_ra_id = rank.ra_id And rank.ra_id = {0}
JOIN figurine ON figurine.fi_fk_character_id = {1} AND figurine.fi_fk_user_id = {2}",
z_listeDeroulanteRank.RankSelectionnee.Id, z_listeDeroulanteChar.CharactSelectionnee.Id, Utilisateur.Id),
new MyDB.CodeSql("WHERE stuff_char_rank.scr_fk_stuff_id = {0} AND char_rank.cr_fk_ch_id = {1}",
z_listeDeroulanteStuff.StuffSelectionnee.Id, z_listeDeroulanteChar.CharactSelectionnee.Id), null).FirstOrDefault();
z_textBox.Text = SCR.Cout.ToString();
}
private void buttonAjouterEquipable_Click(object sender, EventArgs e)
{
if ((m_Stuff != null) && (z_listeDeroulanteCharRank.CharactSelectionnee != null))
{
StuffCharactRank StChRa = new StuffCharactRank();
StChRa.CharactRank = z_listeDeroulanteCharRank.CharactSelectionnee;
StChRa.Stuff = m_Stuff;
StChRa.Cout = Convert.ToInt32(z_numericUpDownCout.Value);
StChRa.Min = Convert.ToInt32(z_numericUpDownMinimum.Value);
StChRa.Max = Convert.ToInt32(z_numericUpDownMaximum.Value);
StChRa.Enregistrer(Program.GMBD.BD, StChRa);
m_StuffCharactRankEquipables.Add(StChRa);
z_fichePersonnageEquipement1.Caractere = m_StuffCharactRankEquipables;
}
}
public IEnumerable <StuffCharactRank> EnumererStuffCharactRank(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(StuffCharactRank.Enumerer(m_BD, m_BD.Enumerer("SELECT {0} FROM {1} {2} {3} {4}", ValeurSouhaitee, c_NomTable_StuffCharactRank, ClauseJoin, ClauseWhere, ClauseOrderBy)));
}
/// <summary>
/// Met à jour la listview des sous factions 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 EstCaractere = typeof(T).Equals(typeof(StuffCharactRank));
if (!EstCaractere)
{
return(false);
}
listViewCaractere.Items.Clear();
if (Entites == null)
{
return(false);
}
if (EstCaractere && (listViewCaractere.Columns.Count != 2))
{
listViewCaractere.Columns.Clear();
listViewCaractere.Columns.Add(new ColumnHeader()
{
Name = "Caracteres",
Text = "Caractères",
TextAlign = HorizontalAlignment.Center,
});
listViewCaractere.Columns.Add(new ColumnHeader()
{
Name = "Rank",
Text = "Rank",
TextAlign = HorizontalAlignment.Center,
});
listViewCaractere.Columns.Add(new ColumnHeader()
{
Name = "Cout",
Text = "Coût",
TextAlign = HorizontalAlignment.Center,
});
}
foreach (T Entite in Entites)
{
StuffCharactRank Caractere = Entite as StuffCharactRank;
if (EstCaractere)
{
ListViewItem NouvelElement = new ListViewItem()
{
Tag = Entite,
Text = Caractere.CharactRank.Caractere.Name,
};
NouvelElement.SubItems.Add(Caractere.CharactRank.Rank.Name);
NouvelElement.SubItems.Add(Caractere.Cout.ToString());
listViewCaractere.Items.Add(NouvelElement);
}
}
listViewCaractere.Visible = false;
foreach (ColumnHeader Colonne in listViewCaractere.Columns)
{
Colonne.AutoResize(ColumnHeaderAutoResizeStyle.HeaderSize);
}
listViewCaractere.Visible = true;
listViewCaractere_SelectedIndexChanged(listViewCaractere, EventArgs.Empty);
return(true);
}
