private void Add()
{
JediTournamentEntities.Jedi j = new JediTournamentEntities.Jedi();
this.SelectedItem = new JediViewModel(j);
Jedis.Add(j);
}
private void Add()
{
JediTournamentEntities.Jedi j = new JediTournamentEntities.Jedi();
this.SelectedItem = new JediViewModel(j);
Jedis.Add(j);
}
public void AddJediTest()
{
JediTournamentManager jtm = new JediTournamentManager();
Jedi newJedi = new Jedi("Palpatine", true);
jtm.AddJedi(newJedi);
var jedis = jtm.GetJedis();
Assert.IsTrue(jedis.Last().Equals(newJedi));
}
public Match(int id, Jedi vainqueur, Jedi jedi1, Jedi jedi2, EPhaseTournoi phaseTournoi, Stade stade) : base(id)
{
Vainqueur = vainqueur;
Jedi1 = jedi1;
Jedi2 = jedi2;
PhaseTournoi = phaseTournoi;
Stade = stade;
}
public Match(int id,Jedi vainqueur,Jedi jedi1,Jedi jedi2,EPhaseTournoi phaseTournoi,Stade stade):base(id)
{
Vainqueur = vainqueur;
Jedi1 = jedi1;
Jedi2 = jedi2;
PhaseTournoi = phaseTournoi;
Stade = stade;
}
public static Jedi JediContractToJedi(JediContract j)
{
Jedi jedi = new Jedi();
jedi.ID = j.ID;
jedi.Nom = j.Nom;
jedi.IsSith = j.IsSith;
return jedi;
}
public void DeleteJedi(Jedi jedi)
{
using (SqlConnection sqlConnection = new SqlConnection(_connectionString))
{
string query = "DELETE FROM Jedi WHERE Id=@id";
SqlCommand sqlCommand = new SqlCommand(query, sqlConnection);
sqlCommand.Parameters.AddWithValue("@id", jedi.ID);
sqlConnection.Open();
sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
}
}
public void AddJedi(Jedi jedi)
{
using (SqlConnection sqlConnection = new SqlConnection(_connectionString))
{
string query = "INSERT INTO Jedi (Nom, IsSith) VALUES (@nom, @isSith); SELECT SCOPE_IDENTITY()";
SqlCommand sqlCommand = new SqlCommand(query, sqlConnection);
sqlCommand.Parameters.AddWithValue("@nom", jedi.Nom);
sqlCommand.Parameters.AddWithValue("@isSith", jedi.IsSith);
sqlConnection.Open();
jedi.ID= System.Convert.ToInt32(sqlCommand.ExecuteScalar());
sqlConnection.Close();
}
}
public void UpdateJedi(Jedi jedi)
{
using (SqlConnection sqlConnection = new SqlConnection(_connectionString))
{
string query = "UPDATE Jedi SET Nom=@nom, IsSith=@isSith WHERE Id=@id";
SqlCommand sqlCommand = new SqlCommand(query, sqlConnection);
sqlCommand.Parameters.AddWithValue("@nom", jedi.Nom);
sqlCommand.Parameters.AddWithValue("@isSith", jedi.IsSith);
sqlCommand.Parameters.AddWithValue("@id", jedi.ID);
sqlConnection.Open();
sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
}
}
public void UpdateJedi(Jedi jedi)
{
_DataAccess.UpdateJedi(jedi);
}
public void AddJedi(Jedi jedi)
{
_DataAccess.AddJedi(jedi);
}
public void DeleteJedi(Jedi jedi)
{
_DataAccess.DeleteJedi(jedi);
}
public JediViewModel(Jedi jediModel)
{
_jedi = jediModel;
}
public void DelJedi(Jedi jedi)
{
DalManager.Instance.DeleteJedi(jedi);
}
public void AddJedi(Jedi jedi)
{
DalManager.Instance.AddJedi(jedi);
}
public void UpdateJedi(Jedi jedi)
{
DalManager.Instance.UpdateJedi(jedi);
}
