public ActionResult Details(int id = 0, int?p = 1)
{
Jockey jockey = db.Jockeys.Find(id);
if (jockey == null)
{
return(HttpNotFound());
}
if (jockey.TwitterId != null)
{
var auth = TwitterUtilities.GetAuthorizer();
var ctx = new TwitterContext(auth);
var tweets =
from tweet in ctx.Status
where tweet.Type == StatusType.User &&
tweet.ScreenName == jockey.TwitterId
select tweet;
if (tweets != null)
{
try
{
ViewData["Tweets"] = tweets.ToList();
}
catch
{
Console.WriteLine("Tweet problem...");
}
}
}
int page = p ?? 1;
ViewBag.Results = db.Results.Include("Race.Meeting.Course").Include("Horse").Where(r => r.Jockey.Id == jockey.Id).OrderByDescending(r => r.Race.OffTime).ToPagedList(page, 50);
return(View(jockey));
}
public static List <Jockey> GetJockeys()
{
List <Jockey> ListJockey = new List <Jockey>();
ConnexionDb MaConnectionSql = new ConnexionDb();
MaConnectionSql.InitializeConnection();
MaConnectionSql.OpenConnection();
string stringSql2 = "select * from jockey";
MaConnectionSql.Cmd.CommandText = stringSql2;
MaConnectionSql.MonLecteur = MaConnectionSql.Cmd.ExecuteReader();
while (MaConnectionSql.MonLecteur.Read())
{
// recuperation de valeurs
int jockId = (int)MaConnectionSql.MonLecteur["joc_id"];
string jockNom = (string)MaConnectionSql.MonLecteur["joc_nom"];
string jockPrenom = (string)MaConnectionSql.MonLecteur["joc_prenom"];
int jockAge = (int)MaConnectionSql.MonLecteur["joc_age"];
string jockCiv = (string)MaConnectionSql.MonLecteur["joc_civilite"];
Jockey unJockey = new Jockey(jockId, jockNom, jockPrenom, jockAge, jockCiv);
ListJockey.Add(unJockey);
}
MaConnectionSql.MonLecteur.Close();
MaConnectionSql.CloseConnection();
return(ListJockey);
}
public ActionResult DeleteConfirmed(int id)
{
Jockey jockey = db.Jockeys.Find(id);
db.Jockeys.Remove(jockey);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private static Jockey BuildJockeyForDB(string name)
{
if (name == null) name = "NO JOCKEY";
var jockey = new Jockey()
{
JockeyName = name
};
return jockey;
}
//
// GET: /Jockey/Delete/5
public ActionResult Delete(int id = 0)
{
Jockey jockey = db.Jockeys.Find(id);
if (jockey == null)
{
return(HttpNotFound());
}
return(View(jockey));
}
public ActionResult Edit(Jockey jockey)
{
if (ModelState.IsValid)
{
db.Entry(jockey).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(jockey));
}
private static Jockey AddDetails(Jockey jockey)
{
Jockey returnJockey = new Jockey();
JockeyService jockeyService = new JockeyService();
returnJockey = jockey;
returnJockey.RealAge = jockeyService.GetRealAge(returnJockey.DateOfBirth);
returnJockey.DOBString = returnJockey.DateOfBirth.ToString("dd/MM/yyyy");
return(returnJockey);
}
public void TextMyMock ()
{
Jockey jockey = new Jockey ();
IDataService mockData = jockey.Mock<IDataService> ();
Expect.When (mockData)
.CallsMethod ("returnDexter")
.ThatItReturns ("CSI");
Assert.AreEqual ("CSI", mockData.returnDexter ());
}
public ActionResult Create(Jockey jockey)
{
if (ModelState.IsValid)
{
db.Jockeys.Add(jockey);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(jockey));
}
public string GetJockey(int?id)
{
string result = string.Empty;
if (id != null)
{
Jockey jockey = SessionService.DbContainer.Resolve <JockeyDataManager>().GetById(id);
result = jockey == null ? "" : jockey.Fullname;
}
return(result);
}
//Cette méthode modifie un utilisateur passé en paramétre dans la BD
// A VERIFIER ABSOLUMENT (SQL)
public static int UpdateJockey(Jockey unJockey)
{
int nbEnr;
// connexion à la BD
SqlConnection MaConnectionSql = ConnexionDb.GetSqlConnexion();
SqlCommand Cmd = MaConnectionSql.CreateCommand();
Cmd.CommandText = "update jockey set joc_nom = '" + unJockey.Nom + "', joc_prenom = '" + unJockey.Prenom + "', joc_age = " + unJockey.Age + ", joc_civilite = '" + unJockey.Civilite + "' WHERE joc_id = " + unJockey.Id;
nbEnr = Cmd.ExecuteNonQuery();
ConnexionDb.CloseConnexion();
return(nbEnr);
}
public static int AjoutJockey(Jockey unJockey)
{
int nbEnr;
// connexion à la BD
SqlConnection MaConnectionSql = ConnexionDb.GetSqlConnexion();
SqlCommand Cmd = MaConnectionSql.CreateCommand();
Cmd.CommandText = " insert into jockey (joc_nom, joc_prenom, joc_age, joc_civilite) VALUES ('" + unJockey.Nom + "','" + unJockey.Prenom + "'," + unJockey.Age + ",'" + unJockey.Civilite + "')";
nbEnr = Cmd.ExecuteNonQuery();
ConnexionDb.CloseConnexion();
return(nbEnr);
}
public JockeyWindow(Jockey jockeyToChange)
{
if (jockeyToChange == null)
{
throw new ArgumentNullException();
}
InitializeComponent();
AssignComboBoxValues();
oldJockey = jockeyToChange;
ShowOldContestInformation();
}
private void JockeyGrid_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
Jockey jockey = JockeyGrid.SelectedItem as Jockey;
if (jockey == null)
{
return;
}
jockeyWindow = new JockeyWindow(jockey);
jockeyWindow.Title = string.Format("Jockey - Id: {0}, Name: {1}", jockey.Id, jockey.FirstName + " " + jockey.LastName);
jockeyWindow.OnAdd += managementSystem.Library.Jockeys.Add;
jockeyWindow.OnUpdate += managementSystem.Library.Jockeys.Update;
jockeyWindow.Show();
}
private void buttonUpdate_Click(object sender, RoutedEventArgs e)
{
if (oldJockey != null)
{
if (CheckInformationFields())
{
Jockey jockey = GetJockey();
jockey.Id = oldJockey.Id;
OnUpdate?.Invoke(jockey, oldJockey.Id);
MessageBox.Show("Contest was successfully updated in the database.");
this.Close();
}
}
}
public void AddNewJockey(JockeyViewModel model)
{
using (var unit = new UnitOfWork())
{
var jockey = new Jockey
{
Alias = model.Alias,
DateBirth = DateTime.Parse(model.DateBirth),
FirstName = model.FirstName,
LastName = model.LastName,
MiddleName = model.MiddleName
};
unit.Jockey.Save(jockey);
}
}
//Cette méthode modifie un utilisateur passé en paramétre dans la BD
// A VERIFIER ABSOLUMENT (SQL)
public static int UpdateJockey(Jockey unJockey)
{
int nbEnr;
// connexion à la BD
ConnexionDb MaConnectionSql = new ConnexionDb();
MaConnectionSql.InitializeConnection();
MaConnectionSql.OpenConnection();
string stringSql = "update jockey set joc_nom = '" + unJockey.Nom + "', joc_prenom = '" + unJockey.Prenom + "', joc_age = " + unJockey.Age + ", joc_civilite = '" + unJockey.Civilite + "' WHERE joc_id = " + unJockey.Id;
MaConnectionSql.Cmd.CommandText = stringSql;
nbEnr = MaConnectionSql.Cmd.ExecuteNonQuery();
MaConnectionSql.CloseConnection();
return(nbEnr);
}
public List <Jockey> InputJockeyCSV(string fileName)
{
List <Jockey> JockeyData = new List <Jockey>();
TextAsset csvFile = Resources.Load("CSV/" + fileName) as TextAsset;
StringReader reader = new StringReader(csvFile.text);
while (reader.Peek() > -1)
{
string line = reader.ReadLine();
string[] line_arr = line.Split(','); // リストに入れる
Jockey j = new Jockey();
j.Name = line_arr[CSV_CULUMN_NUM_JOCKEY_NAME];
j.Winrate = float.Parse(line_arr[CSV_CULUMN_NUM_JOCKEY_WINRATE]);
JockeyData.Add(j);
}
return(JockeyData);
}
public static int AjoutJockey(Jockey unJockey)
{
int nbEnr;
// connexion à la BD
ConnexionDb MaConnectionSql = new ConnexionDb();
MaConnectionSql.InitializeConnection();
MaConnectionSql.OpenConnection();
// ok, la ligne suivante en sql fait un peu mal à la tête
// merci de bien la vérifié au niveau de cheval.ent.id et cheval.pro.Id
string stringSql = " insert into jockey (joc_nom, joc_prenom, joc_age, joc_civilite) VALUES ('" + unJockey.Nom + "','" + unJockey.Prenom + "'," + unJockey.Age + ",'" + unJockey.Civilite + "')";
MaConnectionSql.Cmd.CommandText = stringSql;
nbEnr = MaConnectionSql.Cmd.ExecuteNonQuery();
MaConnectionSql.CloseConnection();
return(nbEnr);
}
public IHttpActionResult PostJockey([FromBody] List <Jockey> jockeys)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
List <Jockey> returnJockeys = new List <Jockey>();
foreach (var jockey in jockeys)
{
Jockey returnJockey = AddDetails(jockey);
returnJockeys.Add(returnJockey);
}
return(Ok(returnJockeys));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
// methode qui relie les cables de la DAL avec la BLL
// C'est VIIIIIINCE qui m'a donné cette méthode. Va falloir la tester (voir CHEVAL DAO création de l'objet cheval a partir de la BDD)
public static Jockey GetUnJockey(int id)
{
Jockey unJockey = null;
SqlConnection MaConnectionSql = ConnexionDb.GetSqlConnexion();
SqlCommand Cmd = MaConnectionSql.CreateCommand();
Cmd.CommandText = "select * from jockey where joc_id = " + id;
SqlDataReader MonLecteur = Cmd.ExecuteReader();
if (MonLecteur.Read())
{
int jockId = (int)MonLecteur["joc_id"];
string jockNom = (string)MonLecteur["joc_nom"];
string jockPrenom = (string)MonLecteur["joc_prenom"];
int jockAge = (int)MonLecteur["joc_age"];
string jockCiv = (string)MonLecteur["joc_civilite"];
unJockey = new Jockey(jockId, jockNom, jockPrenom, jockAge, jockCiv);
}
MonLecteur.Close();
ConnexionDb.CloseConnexion();
return(unJockey);
}
public static List <Jockey> GetJockeys()
{
List <Jockey> ListJockey = new List <Jockey>();
SqlConnection MaConnectionSql = ConnexionDb.GetSqlConnexion();
SqlCommand Cmd = MaConnectionSql.CreateCommand();
Cmd.CommandText = "select * from jockey";
SqlDataReader MonLecteur = Cmd.ExecuteReader();
while (MonLecteur.Read())
{
// recuperation de valeurs
int jockId = (int)MonLecteur["joc_id"];
string jockNom = (string)MonLecteur["joc_nom"];
string jockPrenom = (string)MonLecteur["joc_prenom"];
int jockAge = (int)MonLecteur["joc_age"];
string jockCiv = (string)MonLecteur["joc_civilite"];
Jockey unJockey = new Jockey(jockId, jockNom, jockPrenom, jockAge, jockCiv);
ListJockey.Add(unJockey);
}
MonLecteur.Close();
ConnexionDb.CloseConnexion();
return(ListJockey);
}
// methode qui relie les cables de la DAL avec la BLL
// C'est VIIIIIINCE qui m'a donné cette méthode. Va falloir la tester (voir CHEVAL DAO création de l'objet cheval a partir de la BDD)
public static Jockey GetUnJockey(int id)
{
Jockey unJockey = null;
ConnexionDb MaConnectionSql = new ConnexionDb();
MaConnectionSql.InitializeConnection();
MaConnectionSql.OpenConnection();
string stringSql = "select * from jockey where joc_id = " + id;
MaConnectionSql.Cmd.CommandText = stringSql;
MaConnectionSql.MonLecteur = MaConnectionSql.Cmd.ExecuteReader();
if (MaConnectionSql.MonLecteur.Read())
{
int jockId = (int)MaConnectionSql.MonLecteur["joc_id"];
string jockNom = (string)MaConnectionSql.MonLecteur["joc_nom"];
string jockPrenom = (string)MaConnectionSql.MonLecteur["joc_prenom"];
int jockAge = (int)MaConnectionSql.MonLecteur["joc_age"];
string jockCiv = (string)MaConnectionSql.MonLecteur["joc_civilite"];
unJockey = new Jockey(jockId, jockNom, jockPrenom, jockAge, jockCiv);
}
MaConnectionSql.CloseConnection();
return(unJockey);
}
public void TextMyMockEvent ()
{
Jockey jockey = new Jockey ();
IEventsTest myMockEvents = jockey.Mock<IEventsTest> ();
myMockEvents.TestEvent += MySubscriber;
Expect.When (myMockEvents)
.CallsMethod ("ExecuteWithSideEffect")
.ThatItRaises ("TestEvent", myMockEvents, new EventArgs ());
myMockEvents.ExecuteWithSideEffect ();
Assert.IsTrue (eventFlag);
Jockey myJockey = new Jockey ();
IDataService myMockService = myJockey.Mock<IDataService> ();
Expect.When (myMockService)
.CallsProperty ("Name")
.ThatItReturns ("My Product Name");
Assert.IsNotNull (myMockService);
Assert.AreEqual ("My Product Name", myMockService.Name);
}
public void DownloadData(string url)
{
string MAIN_URL = url;
HtmlDocument doc;
Task <HtmlDocument> tsk = GetData(MAIN_URL);
doc = tsk.Result;
Link lnk = new Link();
lnk.URL = (MAIN_URL);
HtmlNode node = doc.GetElementbyId("racecard");
string courseandDate = node.ChildNodes[1].InnerText;
DateTime raceDate;
string raceLocation = "";
if (courseandDate.Contains('-'))
{
raceLocation = courseandDate.Split('-').ElementAt(0).Split(',').ElementAt(0);
var dateStr = courseandDate.Split('-').ElementAt(1).Split(',').ElementAt(1);
raceDate = DateTime.Parse(dateStr);
}
else
{
raceLocation = courseandDate.Split(',').ElementAt(0);
int tempLen = courseandDate.Split(',').Count();
raceDate = DateTime.Parse(courseandDate.Split(',').ElementAt(tempLen - 1));
}
var allRace = node.ChildNodes[5].ChildNodes.Where(m => m.OriginalName.Equals("li"));
int totalRaces = allRace.Count();
if (totalRaces > 0)
{
using (var conn = new RaceContext())
{
conn.Links.Add(lnk);
//conn.SaveChanges();
lnk.Races = new List <Race>();
var tempcontentsRaces = node.ChildNodes[7].ChildNodes[3].ChildNodes[1];
var contentsRaces = tempcontentsRaces.ChildNodes.Where(m => m.Name == "div");
List <Race> races = new List <Race>();
foreach (var item in contentsRaces)
{
Race race = new Race();
race.Date = raceDate;
race.Location = raceLocation;
var itemcontentsRace = item.ChildNodes.Where(m => m.Attributes.Contains("class") && m.Attributes["class"].Value.Contains("raceDetails")).SingleOrDefault();
var itemcontentsRaceRunners = item.ChildNodes.Where(m => m.Attributes.Contains("class") && m.Attributes["class"].Value.Contains("cardFields")).SingleOrDefault();
var detailsInfo = itemcontentsRace.ChildNodes.Where(m => m.Attributes.Contains("class") && m.Attributes["class"].Value.Contains("detailInfo")).SingleOrDefault();
race.Title = detailsInfo.ChildNodes[1].InnerText;
var tempTime = detailsInfo.ChildNodes[3].ChildNodes[1].InnerText;
race.Time = race.Date;
if (!tempTime.Equals(" : : : "))
{
race.Time = race.Time.AddHours(double.Parse(tempTime.Split(':')[0]));
race.Time = race.Time.AddMinutes(double.Parse(tempTime.Split(':')[1]));
}
var typeandclass = detailsInfo.ChildNodes[3].ChildNodes[3].InnerText;
race.Class = typeandclass.Split('-')[1];
race.Type = typeandclass.Split('-')[0];
race.TrackLength = detailsInfo.ChildNodes[3].ChildNodes[5].InnerText.Split('M')[0] + "M";
race.TrackType = detailsInfo.ChildNodes[3].ChildNodes[5].InnerText.Split('M')[1];
var winningPriceCurrency = detailsInfo.ChildNodes[3].ChildNodes[7].InnerText.Split(' ');
race.WinningCurrency = winningPriceCurrency.ElementAt(1);
string temprice = winningPriceCurrency.ElementAt(19).ToString().Replace(",", "");
race.WinningPrice = long.Parse(temprice);
var railSafety = detailsInfo.ChildNodes.Where(m => m.Attributes.Contains("class") && m.Attributes["class"].Value.Contains("railSafety")).SingleOrDefault();
race.Weather = railSafety.ChildNodes[1].ChildNodes[2].ChildNodes[0].InnerText;
race.TrackCondition = railSafety.ChildNodes[3].ChildNodes[2].ChildNodes.Count > 0 ? railSafety.ChildNodes[3].ChildNodes[2].ChildNodes[0].InnerText : "";
race.RailPosition = railSafety.ChildNodes[7].ChildNodes[2].ChildNodes.Count > 0 ? railSafety.ChildNodes[7].ChildNodes[2].ChildNodes[0].InnerText : "";
race.SafetyLimit = railSafety.ChildNodes[9].ChildNodes[2].ChildNodes.Count > 0 ? railSafety.ChildNodes[9].ChildNodes[2].ChildNodes[0].InnerText : "";
var finishTime = detailsInfo.ChildNodes.Where(m => m.Attributes.Contains("class") && m.Attributes["class"].Value.Contains("finishTime")).SingleOrDefault();
//finishTime.InnerText.Substring(finishTime.InnerText.IndexOf(@" " "))
Regex reg = new Regex("[0-9]{2}:[0-9]{2}:[0-9]{2}");
Match mch = reg.Match(finishTime.InnerText);
race.RunningTime = mch.Value;
//getting null string <span>(Hand Timed)</span> = <span></span>
reg = new Regex("[(].*[)]");
mch = reg.Match(finishTime.InnerHtml);
race.RunningTimeType = mch.Value;
//race.RunningTimeType = "Test";
var fullConditions = itemcontentsRace.ChildNodes.Where(m => m.Attributes.Contains("class") && m.Attributes["class"].Value.Contains("fullConditions")).SingleOrDefault();
var prizeBreak = fullConditions.ChildNodes.Where(m => m.Attributes.Contains("class") && m.Attributes["class"].Value.Contains("prizeBreak")).SingleOrDefault();
var prizeTable = prizeBreak.ChildNodes.Where(m => m.Name == "table").SingleOrDefault();
var prizeTableTr = prizeTable.ChildNodes.Where(m => m.Name == "tr");
List <WinningPrice> allPrizes = new List <WinningPrice>();
List <Runner> allRunners = new List <Runner>();
int[] pricePosition = { 1, 4, 2, 5, 3, 7 };
int tmp = 0;
foreach (var bodyRow in prizeTableTr)
{
WinningPrice prize = new WinningPrice();
WinningPrice prize2 = new WinningPrice();
var tablePrizestd = bodyRow.ChildNodes.Where(m => m.Name == "td");
prize.Position = pricePosition[tmp];
prize.Price = long.Parse(tablePrizestd.ElementAt(1).InnerHtml.Replace(",", ""));
prize.Race = race;
conn.WinningPrizes.Add(prize);
tmp = tmp + 1;
prize2.Position = pricePosition[tmp];
prize2.Price = long.Parse(tablePrizestd.ElementAt(4).InnerHtml.Replace(",", ""));
prize2.Race = race;
allPrizes.Add(prize);
allPrizes.Add(prize2);
tmp = tmp + 1;
conn.WinningPrizes.Add(prize2);
}
var detailedConditions = fullConditions.ChildNodes.Where(m => m.Attributes.Contains("class") && m.Attributes["class"].Value.Contains("detailedConditions")).SingleOrDefault();
race.Notes = detailedConditions.InnerText;
race.WinningPrices = allPrizes;
conn.Races.Add(race);
lnk.Races.Add(race);
//conn.SaveChanges();
var resultsTable = itemcontentsRaceRunners.ChildNodes.Where(m => m.Attributes.Contains("class") && m.Attributes["class"].Value.Contains("entriesTable resultsTable")).SingleOrDefault();
var resultsTableRows = resultsTable.ChildNodes.Where(m => m.Name == "tbody").SingleOrDefault().ChildNodes.Where(m => m.Name == "tr");
race.Runners = new List <Runner>();
foreach (var runnerRow in resultsTableRows)
{
Runner tempRunner = new Runner();
tempRunner.Name = runnerRow.Attributes["owner"].Value;
var tempRunnerCols = runnerRow.ChildNodes.Where(m => m.Name == "td");
var tempPositionValidate = tempRunnerCols.ElementAt(0).InnerText;
var tmpPosition = (tempPositionValidate.Contains("nd") ? tempPositionValidate.Replace("nd", "") : tempPositionValidate.Contains("st") ? tempPositionValidate.Replace("st", "") : tempPositionValidate.Contains("th") ? tempPositionValidate.Replace("th", "") : tempPositionValidate.Contains("rd") ? tempPositionValidate.Replace("rd", "") : tempPositionValidate);
tempRunner.Position = tmpPosition;
tempRunner.Margin = tempRunnerCols.ElementAt(1).InnerText.ToString();
tempRunner.Drawn = !string.IsNullOrEmpty(tempRunnerCols.ElementAt(2).InnerText) ? int.Parse(tempRunnerCols.ElementAt(2).InnerText) : 0;
tempRunner.OR = tempRunnerCols.ElementAt(3).InnerText;
//tempRunner. Horse
string horseUrl = "http:/" + tempRunnerCols.ElementAt(4).ChildNodes.Where(m => m.Name == "a").SingleOrDefault().Attributes["href"].Value;
Horse tempHorse = new Horse()
{
URL = horseUrl,
Name = tempRunnerCols.ElementAt(4).ChildNodes.Where(m => m.Name == "a").SingleOrDefault().InnerText,
};
conn.Horses.Add(tempHorse);
tempHorse.Runners = new List <Runner>();
tempHorse.Runners.Add(tempRunner);
tempRunner.Equipment = tempRunnerCols.ElementAt(6).InnerText;
string trainerURl = "http:/" + tempRunnerCols.ElementAt(7).ChildNodes.Where(m => m.Name == "a").SingleOrDefault().Attributes["href"].Value;
Trainer tempTrainer = new Trainer()
{
Name = tempRunnerCols.ElementAt(7).ChildNodes.Where(m => m.Name == "a").SingleOrDefault().InnerText,
URL = trainerURl
};
tempTrainer.Runners = new List <Runner>();
tempTrainer.Runners.Add(tempRunner);
conn.Trainers.Add(tempTrainer);
string jockeyUrl = "http:/" + tempRunnerCols.ElementAt(8).ChildNodes.Where(m => m.Name == "a").SingleOrDefault().Attributes["href"].Value;
Jockey tempJockey = new Jockey()
{
URL = jockeyUrl,
Name = tempRunnerCols.ElementAt(8).ChildNodes.Where(m => m.Name == "a").SingleOrDefault().InnerText,
Weight = decimal.Parse(tempRunnerCols.ElementAt(5).InnerText)
};
tempJockey.Runners = new List <Runner>();
tempJockey.Runners.Add(tempRunner);
conn.Jockeys.Add(tempJockey);
tempRunner.Race = race;
race.Runners.Add(tempRunner);
conn.Runners.Add(tempRunner);
}
conn.SaveChanges();
}
}
}
}
public void Save(Jockey jockey)
{
jockey.IsActive = true;
save(jockey);
}
public void Delete(Jockey jockey)
{
jockey.IsActive = false;
save(jockey);
}
public static int ModifierJockey(string nom, string prenom, int age, string civilite)
{
Jockey jo = new Jockey(nom, prenom, age, civilite);
return(JockeyDAO.UpdateJockey(jo));
}
public static int CreerJockey(string nom, string prenom, int age, string civilite)
{
Jockey jo = new Jockey(nom, prenom, age, civilite);
return(JockeyDAO.AjoutJockey(jo));
}
