public GameSelection(Entrainement en)
{
InitializeComponent();
// chargement de la liste des parties
entr = en;
lstGames.ItemsSource = entr.lstScores.Select(_ => _.dt).Distinct().OrderByDescending(_ => _).ToList();
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
//btnGo.Background = Brushes.Green;
//btnExport.Background = Brushes.Green;
// on charge les fiches existantes si elles existent
Properties.Settings pApp = new Properties.Settings();
entr = new Entrainement();
LoadData();
int joursRet = 0;
if (int.TryParse(pApp.JoursRetention, out joursRet) && joursRet != 0)
{
// on va nettoyer un peu le fichier de fiches de score pour garder de la place
DateTime dtLimite = DateTime.Now.AddDays(-joursRet);
var query = from q in entr.lstScores
where q.jourTravail < dtLimite
select q;
// dans query on a les fiches a supprimer
entr.lstScores.RemoveRange(0, query.Count());
// on sauvegarde tout
SaveData();
}
nbGamesBack = nbHeures = nbJours = 0;
visuSelected = typeVisu.TOUT;
menuTout.IsChecked = true;
LoadDataGrid();
}
public MainWindow()
{
InitializeComponent();
entr = new Entrainement();
index = 0;
CommandPlus.InputGestures.Add(new KeyGesture(Key.Add));
CommandMoins.InputGestures.Add(new KeyGesture(Key.Subtract));
CommandSave.InputGestures.Add(new KeyGesture(Key.S, ModifierKeys.Control));
CommandNew.InputGestures.Add(new KeyGesture(Key.N, ModifierKeys.Control));
CommandBindings.Add(new CommandBinding(CommandPlus, CommandBinding_Executed));
CommandBindings.Add(new CommandBinding(CommandMoins, CommandBinding_Executed_1));
CommandBindings.Add(new CommandBinding(CommandSave, CommandBinding_Executed_Save));
CommandBindings.Add(new CommandBinding(CommandNew, CommandBinding_Executed_New));
Configuration conf = new Configuration();
ficheScore.cmdPseudo.ItemsSource = conf.pseudoListe;
ficheScore.cmdEquipe.ItemsSource = conf.equipeListe;
XmlSerializer xs = new XmlSerializer(typeof(Entrainement));
using (StreamReader rd = new StreamReader("c:\\temp\\scorecards.xml")) {
entr = xs.Deserialize(rd) as Entrainement;
}
entr.lstScores = entr.lstScores.OrderBy(p => p.dt).ThenBy(p => p.rank).ToList();
txtNbFiche.Text = entr.lstScores.Count().ToString();
LoadFiche(index);
nouveau = false;
cmbDate.ItemsSource = entr.lstScores.Select(s => s.dt).Distinct().ToList();
ficheStats.entr = entr;
ficheStats.LoadData();
}
public Entrainement Get(int idAChercher)
{
Entrainement GetEntrainement = new Entrainement();
using (_connection)
{
_connection.Open();
SqlCommand command = new SqlCommand("SELECT * FROM Entrainement where id = @idCherch", _connection);
command.Parameters.AddWithValue("idCherch", idAChercher);
using SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
new Entrainement
{
Id_Entainement = reader["Id_Entainement"] == DBNull.Value ? 0 : (int)reader["Id_Entainement"],
Cheval = reader["Cheval"] == DBNull.Value ? string.Empty : (string)reader["Cheval"],
Plat = reader["Plat"] == DBNull.Value ? string.Empty : (string)reader["Plat"],
Obstacle = reader["Obstacle"] == DBNull.Value ? string.Empty : (string)reader["Obstacle"],
Marcheur = reader["Marcheur"] == DBNull.Value ? string.Empty : (string)reader["Marcheur"],
Pré = reader["Pré"] == DBNull.Value ? string.Empty : (string)reader["Pré"],
Durée = reader["Durée"] == DBNull.Value ? 0 : (int)reader["Durée"],
};
}
return(GetEntrainement);
}
}
public void Create(Entrainement NouvelEntrainement)
{
using (_connection)
{
_connection.Open();
SqlCommand command = new SqlCommand("INSERT INTO Entrainement (Id_Entainement,Cheval,Plat," + //les champs de la table
"Obstacle,Marcheur," +
"Pré,Durée)" +
"VALUES (@id_entrainement, @cheval, @plat," + //les champs a rentrer
"@obstacle, @marcheur, " +
"@pré, @durée)");
command.Parameters.AddWithValue("id_entrainement", NouvelEntrainement.Id_Entainement);
command.Parameters.AddWithValue("cheval", NouvelEntrainement.Cheval);
command.Parameters.AddWithValue("plat", NouvelEntrainement.Plat);
command.Parameters.AddWithValue("obstacle", NouvelEntrainement.Obstacle);
command.Parameters.AddWithValue("marcheur", NouvelEntrainement.Marcheur);
command.Parameters.AddWithValue("pré", NouvelEntrainement.Pré);
command.Parameters.AddWithValue("durée", NouvelEntrainement.Durée);
command.ExecuteNonQuery();
_connection.Close();
}
}
static void Main(string[] args)
{
IMyService Service = new MyService();
Athlete athlete = new Athlete() //ou bien seed
{
Adresse = "California",
CategoryAthlete = CategoryAthlete.Benjamin,
DateNaissance = new DateTime(1992, 01, 01),
NomAthlete = "DeBois",
PrenomAthlete = "Jack",
NumeroLicence = 123
};
Entrainement entrainement = new Entrainement()
{
DateEntrainement = new DateTime(2016, 02, 02),
NombreSeance = 2,
};
Piscine piscine = new Piscine()
{
AdressePiscine = "Paris",
NomPiscine = "Les champions",
NumPiscine = 123
};
Service.AddAthlete(athlete);
Service.AddPiscine(piscine);
Service.AddEntrainement(entrainement, 123);
Service.AddPlan(athlete, new DateTime(2016, 02, 02), 50);
Service.Commit();
Service.Dispose();
}
public ActionResult DeleteConfirmed(int id)
{
Entrainement entrainement = db.Entrainements.Find(id);
db.Entrainements.Remove(entrainement);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private void lbx_Entrainement_SelectedIndexChanged(object sender, EventArgs e)
{
if (lbx_Entrainement.SelectedIndex != -1)
{
SuppPictureBox();
Entrainement lentrainement = (Entrainement)lbx_Entrainement.SelectedItem;
List <Entrainement> lesEntrainements = DAL.Instance.RecupEntrainementDB();
Entrainement entrain = lesEntrainements.Find(c => c.Id == lentrainement.Id);
AfficherTour(entrain);
}
}
/// <summary>
/// charge les fiches sauvegardés
/// </summary>
private void LoadData()
{
Properties.Settings pApp = new Properties.Settings();
if (File.Exists(pApp.FichierSauvegarde))
{
XmlSerializer xload = new XmlSerializer(typeof(Entrainement));
using (StreamReader rd = new StreamReader(pApp.FichierSauvegarde))
{
entr = xload.Deserialize(rd) as Entrainement;
}
}
}
public ActionResult Edit([Bind(Include = "idEntrainement,DateEntrainement,HeureDebut,HeureFin,idEntrainement_1,idEntraineur,idEquipe")] Entrainement entrainement)
{
if (ModelState.IsValid)
{
db.Entry(entrainement).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.idEntrainement_1 = new SelectList(db.TypeEntrainements, "idEntrainement", "Libelle", entrainement.idEntrainement_1);
ViewBag.idEntraineur = new SelectList(db.Entraineurs, "idEntraineur", "Nom", entrainement.idEntraineur);
ViewBag.idEquipe = new SelectList(db.Equipes, "idEquipe", "LibelleEquipe", entrainement.idEquipe);
return(View(entrainement));
}
public int Create(Entrainement entrainement)
{
Command command = new Command("CreateEntrainement", true);
command.AddParameter("Plat", entrainement.Plat);
command.AddParameter("Obstacle", entrainement.Obstacle);
command.AddParameter("Marcheur", entrainement.Marcheur);
command.AddParameter("Duree", entrainement.Marcheur);
command.AddParameter("Pre", entrainement.Pre);
command.AddParameter("Date_Entrainement", entrainement.Date_Entrainement);
return((int)_connection.ExecuteScalar(command));
}
// GET: Entrainements/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Entrainement entrainement = db.Entrainements.Find(id);
if (entrainement == null)
{
return(HttpNotFound());
}
return(View(entrainement));
}
public void AddPlan(Athlete athlete, DateTime date, int distance)
{
Entrainement entrainement = GetEntrainement(date);
if (entrainement != null)
{
PlanEntrainement plan = new PlanEntrainement()
{
NumEntrainement = entrainement.NumEntrainement,
NumLicence = athlete.NumeroLicence,
DistanceAParcourir = distance
};
ut.getRepository <PlanEntrainement>().Add(plan);
}
}
// GET: Entrainements/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Entrainement entrainement = db.Entrainements.Find(id);
if (entrainement == null)
{
return(HttpNotFound());
}
ViewBag.idEntrainement_1 = new SelectList(db.TypeEntrainements, "idEntrainement", "Libelle", entrainement.idEntrainement_1);
ViewBag.idEntraineur = new SelectList(db.Entraineurs, "idEntraineur", "Nom", entrainement.idEntraineur);
ViewBag.idEquipe = new SelectList(db.Equipes, "idEquipe", "LibelleEquipe", entrainement.idEquipe);
return(View(entrainement));
}
static void Main(string[] args)
{
Properties.Settings pApp = new Properties.Settings();
string sauvegarde = pApp.fichierSauvegarde;
List <string> lstFiles = Directory.GetFiles(pApp.repCible).ToList();
Entrainement entr = new Entrainement();
// on charge les fiches existantes si elles existent
if (File.Exists(sauvegarde))
{
XmlSerializer xload = new XmlSerializer(typeof(Entrainement));
using (StreamReader rd = new StreamReader(sauvegarde)) {
entr = xload.Deserialize(rd) as Entrainement;
}
}
//ScoreCard sc = new ScoreCard();
//List<ScoreCard> lstScores = new List<ScoreCard>();
// on boucle sur tous les fichiers du repertoire
foreach (string f in lstFiles)
{
Console.WriteLine("Traitement de " + f);
try {
List <ScoreCard> lst = Tools.readScoreCardFromFile(f, pApp.dateFormat);
foreach (ScoreCard sc in lst)
{
// pas de doublons
if (!entr.lstScores.Contains(sc))
{
entr.lstScores.Add(sc);
}
}
}
catch (Exception ex) {
Console.WriteLine(string.Format("Erreur sur {0} : {1} ", f, ex.Message));
}
}
// on sauvegarde tout
XmlSerializer xs = new XmlSerializer(typeof(Entrainement));
using (StreamWriter wr = new StreamWriter(sauvegarde)) {
xs.Serialize(wr, entr);
}
Console.ReadLine();
}
protected void addEntrainement_Click(object sender, EventArgs e)
{
Entrainement entrainement = new Entrainement();
entrainement.type = typeEntrainement.Text;
entrainement.date = Convert.ToDateTime(dateEntrainement.Text + " " + heureEntrainement.Text);
entities.Entrainement.Add(entrainement);
EntrainementClubTerrain entrainementClubTerrain = new EntrainementClubTerrain();
entrainementClubTerrain.Club = userConnected.Club;
entrainementClubTerrain.Entrainement = entrainement;
entrainementClubTerrain.id_Terrain = Int32.Parse(ListTerrainEntrainement.SelectedValue);
entities.EntrainementClubTerrain.Add(entrainementClubTerrain);
entities.SaveChanges();
}
public int Update(int id, Entrainement entrainement)
{
Command command = new Command("UPDATE Entrainement SET Plat = @Plat," +
"Obstacle = @Obstacle , Marcheur = @Marcheur, " +
"Pre = @Pre , Duree = @Duree, " +
"Date_Entrainement = @Date_Entrainement " +
"where Id_Entrainement = @Id_Entrainement");
command.AddParameter("Plat", entrainement.Plat);
command.AddParameter("Obstacle", entrainement.Obstacle);
command.AddParameter("Marcheur", entrainement.Marcheur);
command.AddParameter("Pre", entrainement.Pre);
command.AddParameter("Duree", entrainement.Duree);
command.AddParameter("Date_Entrainement", entrainement.Date_Entrainement);
return(_connection.ExecuteNonQuery(command));
}
internal void AjouterEntrainementDB(Entrainement lentrainement)
{
cnx.Open();
SqlTransaction sqlT = cnx.BeginTransaction("SampleTransaction");
try
{
SqlCommand cmd = new SqlCommand("dbo.AjouterEntrainement", cnx);
cmd.Transaction = sqlT;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@idEntrainement", SqlDbType.NVarChar).Value = lentrainement.Id.Trim();
cmd.Parameters.Add("@nomEntrainement", SqlDbType.NVarChar).Value = lentrainement.Nom.Trim();
cmd.Parameters.Add("@nbTour", SqlDbType.Int).Value = lentrainement.NbTour;
cmd.ExecuteNonQuery();
foreach (var leTour in lentrainement.lesTours)
{
foreach (var Lexercice in leTour.lesExercices)
{
cmd = new SqlCommand("dbo.AjouterTour", cnx);
cmd.Transaction = sqlT;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@idEntrainement", SqlDbType.NVarChar).Value = lentrainement.Id.Trim();
cmd.Parameters.Add("@idExercice", SqlDbType.NVarChar).Value = Lexercice.Id;
cmd.Parameters.Add("@numeroTour", SqlDbType.NVarChar).Value = leTour.numeroTour;
cmd.Parameters.Add("@nbFoisExercice", SqlDbType.Int).Value = Lexercice.leNbdeFois;
cmd.Parameters.Add("@sequenceExercice", SqlDbType.Int).Value = Lexercice.sequence;
cmd.ExecuteNonQuery();
}
}
sqlT.Commit();
}
catch (Exception ex)
{
sqlT.Rollback();
throw new Exception(ex.Message);
}
finally
{
cnx.Close();
}
}
internal List <Entrainement> RecupEntrainementDB()
{
Entrainement lesEntrainements = new Entrainement();
SqlCommand cmd = new SqlCommand("dbo.RecupEntrainement", cnx);
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = cmd;
// Remplir le DataSet
DsMyBuild DsDataMyBuild = new DsMyBuild();
adapter.Fill(DsDataMyBuild, DsDataMyBuild.TableEntrainement.TableName);
var myData = DsDataMyBuild.Tables["TableEntrainement"].AsEnumerable().Select(dataRow => new Entrainement
{
Id = dataRow.Field <string>("Id").Trim(),
Nom = dataRow.Field <string>("Nom").Trim(),
NbTour = dataRow.Field <int>("NbTour")
});
var list = myData.ToList();
return(list);
}
private void AfficherTour(Entrainement p_entrainement)
{
List <Tour> lesTours = DAL.Instance.RecupExerciceParTour(p_entrainement.Id, p_entrainement.NbTour);
foreach (Tour leTour in lesTours)
{
Label lelabelTour = new Label();
lelabelTour.Text = "Tour : " + leTour.numeroTour.ToString();
lelabelTour.Location = new Point(x, y - 25);
listLabelTour.Add(lelabelTour);
this.Controls.Add(lelabelTour);
foreach (Exercice lExercice in leTour.lesExercices)
{
PictureBox laPicturebox = new PictureBox();
laPicturebox.Width = 133;
laPicturebox.Height = 75;
Label lelabnbTour = new Label();
lelabnbTour.Text = " x " + lExercice.leNbdeFois.ToString();
lelabnbTour.Location = new Point(x + 135, y);
lelabnbTour.Width = 36;
this.Controls.Add(lelabnbTour);
listLabelTour.Add(lelabnbTour);
laPicturebox.Location = new Point(x, y);
Image image = Image.FromFile(lExercice.imagePath.Replace(@"\\", @"\"));
laPicturebox.Image = image;
this.Controls.Add(laPicturebox);
lesPicturesBox.Add(laPicturebox);
y += 82;
}
y = 50;
x += 172;
}
}
public void Update(Entrainement EntrainementAModifier)
{
using (_connection)
{
_connection.Open();
SqlCommand command = new SqlCommand("UPDATE Entrainement SET Cheval = @cheval, Plat = @plat" +
"Obstacle = @obstacle , Marcheur = @obstacle, Pré = @pré , Durée = @durée" +
"Where Id_Entainement = @id_entrainement");
command.Parameters.AddWithValue("id_entrainement", EntrainementAModifier.Id_Entainement);
command.Parameters.AddWithValue("cheval", EntrainementAModifier.Cheval);
command.Parameters.AddWithValue("plat", EntrainementAModifier.Plat);
command.Parameters.AddWithValue("obstacle", EntrainementAModifier.Obstacle);
command.Parameters.AddWithValue("marcheur", EntrainementAModifier.Marcheur);
command.Parameters.AddWithValue("pré", EntrainementAModifier.Pré);
command.Parameters.AddWithValue("durée", EntrainementAModifier.Durée);
command.ExecuteNonQuery();
_connection.Close();
}
}
public int createEntrainement(Entrainement entrainement)
{
return(entrainementrepository.Create(entrainement));
}
public void AddEntrainement(Entrainement entrainement, int IdPiscine)
{
entrainement.NumPiscine = IdPiscine;
ut.getRepository <Entrainement>().Add(entrainement);
}
internal static EntrainementEmployeChevalAPI DALEntrainementEmployeChevalToAPI(this Entrainement entrainement)
{
return(new EntrainementEmployeChevalAPI()
{
Nom_Cheval = entrainementRepository.GetNomChevalParEntrainement(entrainement.Id_Entrainement),
Date_Entrainement = entrainement.Date_Entrainement,
Nom_Employe = entrainementRepository.GetEmployeByEntrainementId(entrainement.Id_Entrainement),
Age = entrainementRepository.GetAgeChevalParEntrainement(entrainement.Id_Entrainement),
Sexe = entrainementRepository.GetSexParEntrainement(entrainement.Id_Entrainement),
Plat = entrainement.Plat,
Obstacle = entrainement.Obstacle,
Marcheur = entrainement.Marcheur,
Pre = entrainement.Pre,
Duree = entrainement.Duree
});
}
