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