private void button2_Click(object sender, EventArgs e)
{
dataGridView2.Rows.Clear();
List <Objet> result = new List <Objet>();
if (radioSacDynamique.Checked)
{
sac = new SacDynamique(notreListeObjet);
}
if (radioSacGlouton.Checked)
{
sac = new SacRapportValPoid();
}
if (radioSacComplet.Checked)
{
sac = new SacComplet();
}
sac.sac = new List <Objet>();
sac.grosLot(notreListeObjet);
result = sac.sac;
int valeur = 0;
foreach (Objet re in result)
{
string[] row =
{
"" + re.nom, "" + re.poid, "" + re.valeur
};
valeur += re.valeur;
label2.Text = "" + valeur;
dataGridView2.Rows.Add(row);
}
dataGridView1.DataSource = notreListeObjet;
}
public bool UpdateSac(Sac objeto)
{
bool retorno = false;
MySqlConnection conn = new MySqlConnection(connectionString);
StringBuilder sb = new StringBuilder();
sb.Append(" UPDATE `sac`.`sac` ");
sb.Append(" SET ");
sb.AppendFormat(" `id` = {0}, ", objeto.Id);
sb.AppendFormat(" `idUsuario` = {0}, ", objeto.IdUsuario);
sb.AppendFormat(" `titulo` = '{0}', ", objeto.Titulo);
sb.AppendFormat(" `descricao` = '{0}', ", objeto.Descricao);
sb.AppendFormat(" `solucao` = '{0}', ", objeto.Solucao);
sb.AppendFormat(" `status` = '{0}' ", objeto.Status);
sb.AppendFormat(" WHERE `id` = {0}", objeto.Id);
MySqlCommand comando = new MySqlCommand(sb.ToString(), conn);
try
{
conn.Open();
comando.ExecuteNonQuery();
retorno = true;
}
catch (Exception)
{
retorno = false;
}
finally
{
conn.Close();
}
return(retorno);
}
public IActionResult Detail(int id)
{
var aSac = new Sac();
aSac.name = "FirstSac";
return(View(aSac));
}
public void porterEquipement(ObjetEquipable obj, Sac sac)
{
if (obj.getTypeObjet() == EnumTypeObjet.ARME)
{
if (_arme != null)
{
sac.ajouterObjet(_arme);
_arme = obj;
}
else
{
_arme = obj;
}
}
if (obj.getTypeObjet() == EnumTypeObjet.CASQUE)
{
if (_casque != null)
{
sac.ajouterObjet(_casque);
_casque = obj;
}
else
{
_casque = obj;
}
}
if (obj.getTypeObjet() == EnumTypeObjet.TORSE)
{
if (_torse != null)
{
sac.ajouterObjet(_torse);
_torse = obj;
}
else
{
_torse = obj;
}
}
if (obj.getTypeObjet() == EnumTypeObjet.ACCESSOIRE)
{
//retoucher ici
if (_accesoire1 == null)
{
_accesoire1 = obj;
}
else if (_accesoire2 == null)
{
_accesoire2 = obj;
}
else if (_accesoire3 == null)
{
_accesoire3 = obj;
}
else ;
}
}
private void button1_Click(object sender, EventArgs e)
{
sac = new SacRapportValPoid();
notreListeObjet = sac.getObjets();
dataGridView1.DataSource = notreListeObjet;
buttonMeilleurCombinaison.Visible = true;
dataGridView2.Rows.Clear();
}
public string Put(int id, Sac _sac)
{
SacDal _sacDal = new SacDal();
_sac.Id = id;
bool retorno = _sacDal.UpdateSac(_sac);
return(retorno.ToString());
}
public string Post(Sac _sac)
{
SacDal _sacDal = new SacDal();
_sac.Solucao = string.Empty;
_sac.Status = "Em aberto";
bool retorno = _sacDal.InsertSac(_sac);
return(retorno.ToString());
}
public void enleverEquipement(ObjetEquipable obj, Sac sac)
{
//retoucher
sac.ajouterObjet(obj);
if(obj.getTypeObjet() == EnumTypeObjet.ARME)
_arme = null;
if (obj.getTypeObjet() == EnumTypeObjet.CASQUE)
_casque = null;
if (obj.getTypeObjet() == EnumTypeObjet.TORSE)
_torse = null;
if (obj.getTypeObjet() == EnumTypeObjet.ACCESSOIRE)
_accesoire3 = null;
}
//Insert
public bool InsertSac(Sac objeto)
{
bool retorno = false;
MySqlConnection conn = new MySqlConnection(connectionString);
StringBuilder sb = new StringBuilder();
sb.AppendLine(" INSERT INTO `sac`.`sac` ");
sb.AppendLine(" (`id`, ");
sb.AppendLine(" `idUsuario`, ");
sb.AppendLine(" `titulo`, ");
sb.AppendLine(" `descricao`, ");
sb.AppendLine(" `solucao`, ");
sb.AppendLine(" `status`) ");
sb.AppendLine(" VALUES ");
sb.AppendLine(" (null, ");
sb.AppendFormat(" {0}, ", objeto.IdUsuario);
sb.AppendFormat(" '{0}', ", objeto.Titulo);
sb.AppendFormat(" '{0}', ", objeto.Descricao);
sb.AppendFormat(" '{0}', ", objeto.Solucao);
sb.AppendFormat(" '{0}'); ", objeto.Status);
MySqlCommand comando = new MySqlCommand(sb.ToString(), conn);
try
{
conn.Open();
comando.ExecuteNonQuery();
long id = comando.LastInsertedId;
if (id != 0)
{
retorno = true;
}
}
catch (Exception)
{
retorno = false;
}
finally
{
conn.Close();
}
return(retorno);
}
public List <Sac> retornaSac()
{
MySqlConnection conn = new MySqlConnection(connectionString);
MySqlCommand comando = new MySqlCommand("SELECT * FROM `sac`.`sac`", conn);
List <Sac> lista = new List <Sac>();
try
{
conn.Open();
MySqlDataReader dr = comando.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
Sac sac = new Sac();
sac.Id = Convert.ToInt32(dr.GetValue(0));
sac.IdUsuario = Convert.ToInt32(dr.GetValue(1));
sac.Titulo = dr.GetValue(2).ToString();
sac.Descricao = dr.GetValue(3).ToString();
sac.Solucao = dr.GetValue(4).ToString();
sac.Status = dr.GetValue(5).ToString();
lista.Add(sac);
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(lista);
}
public void init()
{
_isInit = true;
_vie = GetComponent<Sante>();
_vie.setPersonnage(this);
_mana = GetComponent<Magie>();
_mana.setPersonnage(this);
_moteur = GetComponent<Moteur>();
_moteur.setPersonnage(this);
_potions = GetComponent<PochettePotion>();
_potions.setPersonnage(this);
_sac = GetComponent<Sac>();
_sac.setPersonnage(this);
// _cam = Camera.current.GetComponent<CameraBehaviour>();
cam.personnage = this;
}
