public ActionResult Edit(int id = 0)
{
var result = new MgtRace().GetRace(id).ToModel(true);
List <CategoryModel> categories = new MgtRace().getAllCategory().ToModels();
List <SelectListItem> cats = new List <SelectListItem>();
foreach (CategoryModel cat in categories)
{
SelectListItem slc = new SelectListItem();
slc.Text = cat.Title;
slc.Value = cat.Id.ToString();
cats.Add(slc);
}
ViewBag.Categories = cats;
if (result == null)
{
return(HttpNotFound());
}
return(View(result));
}
public ActionResult AddPoint(RaceModel race)
{
try
{
RaceModel newRace = MgtRace.GetInstance().GetRace(race.Id).ToModel();
newRace.Points = new List <PointModel>();
newRace.Distance = race.Distance;
var check = Request.Form["checkbox"];
if (check == null)
{
race.point.isPoi = false;
race.point.Category = null;
}
else
{
race.point.isPoi = true;
}
newRace.Points.Add(race.point);
var result = MgtRace.GetInstance().UpdateRace(newRace.ToBo());
RaceModel reloadRace = MgtRace.GetInstance().GetRace(race.Id).ToModel();
if (result)
{
return(Json(reloadRace));
}
else
{
return(RedirectToAction("Index"));
}
}
catch (Exception e)
{
return(View());
}
}
public ActionResult Index()
{
List <RaceModel> result = MgtRace.GetInstance().GetAllItemsWithParticipants().ToModels(true);
result = result.Where(x => x.DateEnd >= DateTime.Today).ToList();
int idUser = 0;
if (WebSecurity.IsAuthenticated)
{
if (!WebSecurity.Initialized)
{
WebSecurity.InitializeDatabaseConnection("SqlAdoCs", "UserTable", "Id", "Name", autoCreateTables: true);
}
idUser = WebSecurity.CurrentUserId;
}
if (idUser > 0)
{
Personne user = MgtPersonne.GetInstance().GetPersonneByIdUserTable(idUser);
for (int i = 0; i < result.Count; i++)
{
bool inscrit = MgtParticipant.GetInstance().isIncrit(result.ElementAt(i).Id, user.Id);
result.ElementAt(i).Inscrit = inscrit;
}
}
return(View(result.OrderByDescending(x => x.DateStart).ToList()));
}
public void UpdateDistance(int distance, int idRace)
{
Race newRace = MgtRace.GetInstance().GetRace(idRace);
newRace.Distance = distance;
MgtRace.GetInstance().UpdateDistance(newRace);
}
public ActionResult CreatePDF(int id)
{
RaceModel result = MgtRace.GetInstance().GetRaceWithPoints(id).ToModel(false, true);
Document doc = new Document(PageSize.LETTER, 50, 50, 50, 50);
string html = RenderRazorViewToString("~/Views/Race/CreatePDF.cshtml", result);
TextReader reader = new StringReader(html);
using (MemoryStream output = new MemoryStream())
{
PdfWriter wri = PdfWriter.GetInstance(doc, output);
// step 3: we create a worker parse the document
HTMLWorker worker = new HTMLWorker(doc);
doc.Open();
worker.StartDocument();
// step 5: parse the html into the document
worker.Parse(reader);
// step 6: close the document and the worker
worker.EndDocument();
worker.Close();
doc.Close();
return(File(output.ToArray(), "application/pdf", result.Title + ".pdf"));
}
}
public ActionResult Index()
{
if (!WebSecurity.Initialized)
{
WebSecurity.InitializeDatabaseConnection("SqlAdoCs", "UserTable", "Id", "Name", autoCreateTables: true);
}
//Récupération de la personne par son id UserTable
int idUser = WebSecurity.CurrentUserId;
var personne = MgtPersonne.GetInstance().GetPersonneByIdUserTable(idUser).ToModel();
int idPersonne = personne.Id;
//Récupération de la liste des inscriptions de la personne par son id
var inscriptions = MgtParticipant.GetInstance().GetAllById(idPersonne).ToModels();
//Réupérations des informations de chaque course auquel la personne est inscrite
//On génère une liste des courses auxquelles la personne est inscrite, avec tous les détails les concernant
List <RaceModel> coursesInscrit = new List <RaceModel>();
foreach (var ins in inscriptions)
{
var course = MgtRace.GetInstance().GetRace(ins.CourseId).ToModel();
coursesInscrit.Add(course);
}
//On retourne la vue corespondante avec la liste des inscriptions en paramètre
return(View(coursesInscrit));
}
private void FormAnimaux_Load(object sender, EventArgs e)
{
if (frmClients != null)
{
ClientCourant = frmClients.ClientCourant;
}
else if (frmRDV != null)
{
ClientCourant = frmRDV.ClientCourant;
}
TBox_Code.Enabled = false;
TBox_Client.Enabled = false;
CBox_Espèce.DataSource = MgtRace.GetEspeces();
CBox_Race.DataSource = MgtRace.GetRaces(CBox_Espèce.Items[0].ToString());
TBox_Client.Text = ClientCourant.nomPrenom;
// Affichage en fonction du mode
if (frmClients.ModeAnimal == "Ajout")
{
CBox_Genre.SelectedIndex = 0;
CBox_Espèce.SelectedIndex = 0;
CBox_Race.SelectedItem = 0;
BTN_Dossier.Enabled = false;
}
else if (frmClients.ModeAnimal == "Modification")
{
CBox_Espèce.SelectedIndex = CBox_Espèce.FindStringExact(frmClients.AnimalCourant.espece);
CBox_Race.SelectedIndex = CBox_Race.FindStringExact(frmClients.AnimalCourant.race);
TBox_Tatouage.Enabled = false;
AfficherAnimalCourant();
}
}
public ActionResult Unsubscribe(int idrace)
{
PersonneModel user = (PersonneModel)Session.Contents["User"];
List <Race> races = MgtRace.GetInstance().Unsubscribe(user.Id, idrace);
return(View("MyRaces", races.ToModels()));
}
/// <summary>
/// Ouvre le formulaire d'ajout d'une race poru une espèce
/// </summary>
private void PBox_AddRace_Click(object sender, EventArgs e)
{
FormAjout_EspècesRaces frmAjout = new FormAjout_EspècesRaces(CBox_Espèce.SelectedValue.ToString());
frmAjout.ShowDialog();
CBox_Espèce.DataSource = MgtRace.GetEspeces();
CBox_Race.DataSource = MgtRace.GetRaces(CBox_Espèce.Items[0].ToString());
}
public ActionResult Update(int idPoint = 0)
{
PointModel point = MgtPoint.GetInstance().GetPointById(idPoint).ToModel();
point.ListTypePointOptions = MgtTypePoint.GetInstance().GetAllItems();
point.ListCourseOptions = MgtRace.GetInstance().GetAllItems();
return(View(point));
}
public ActionResult ListRace()
{
PersonneModel user = (PersonneModel)Session.Contents["user"];
//List<Race> races = MgtRace.GetInstance().GetAllItems();
List <Race> racesDispo = MgtRace.GetInstance().getRacebyUser(user.Id);
return(View(racesDispo.ToModels()));
}
public ActionResult Create(RaceModel race)
{
try
{
JavaScriptSerializer js = new JavaScriptSerializer();
LatLng[] listePoints = js.Deserialize <LatLng[]>(race.AjaxPoints);
bool valid = true;
if (ModelState.IsValid)
{
//Ajout de la course
race = MgtRace.GetInstance().AddRace(race.ToBo()).ToModel();
//Ajout des points
for (int i = 0; i < listePoints.Length; i++)
{
Point point = new Point();
point.Titre = "Titre " + i;
point.Latitude = listePoints[i].lat;
point.Longitude = listePoints[i].lng;
point.Ordre = i;
// VALEUR HARCODE => //TODO: modify
if (i == 0)
{
point.TypePointId = 1;
}
else if (i == listePoints.Length - 1)
{
point.TypePointId = 2;
}
else
{
point.TypePointId = 4; //Correspond au KM
}
point.CourseId = race.Id;
valid = valid && MgtPoint.GetInstance().AddPoint(point);
}
if (valid)
{
return(RedirectToAction("Index"));
}
else
{
return(View());
}
}
else
{
return(View());
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
return(View());
}
}
public ActionResult MyRaces()
{
PersonneModel user = (PersonneModel)Session.Contents["User"];
List <Race> races = MgtRace.GetInstance().MyRaces(user.Id);
if (races == null)
{
return(View());
}
return(View(races.ToModels()));
}
public ActionResult InscriptionJour(int id = 0)
{
InscritsView view = new InscritsView();
List <Participant> partipants = MgtParticipant.GetInstance().GetAllByIdCourse(id);
view.Course = MgtRace.GetInstance().GetRace(id).ToModel();
view.inscriptions = initInscriptions(partipants);
return(View(view));
}
public ActionResult Delete(int id)
{
var result = MgtRace.GetInstance().GetRace(id).ToModel();
if (result == null)
{
return(HttpNotFound());
}
return(View(result));
}
public JsonResult Points(int id)
{
RaceModel result = MgtRace.GetInstance().GetRaceWithPoints(id).ToModel(false, true);
result.Points = result.Points.OrderBy(x => x.Ordre).ToList();
if (result == null)
{
return(Json(""));
}
return(Json(result.Points, JsonRequestBehavior.AllowGet));
}
public ActionResult Index(int id = 0)
{
PointView view = new PointView();
List <PointModel> points = MgtPoint.GetInstance().GetAllWithCourseAndTypePointByCourse(id).ToModels();
RaceModel race = MgtRace.GetInstance().GetRace(id).ToModel();
view.points = points.OrderBy(x => x.Ordre).ToList();
view.idCourse = id;
view.libelleCourse = race.Title;
return(View(view));
}
public ActionResult Index()
{
var races = MgtRace.GetInstance().GetAllItems().ToModels();
ArrayList villes = new ArrayList();
foreach (var race in races)
{
villes.Add(race.Town);
}
ViewBag.villes = villes;
return(View());
}
public ActionResult Suscribe(int idRace)
{
PersonneModel user = (PersonneModel)Session.Contents["User"];
if (user == null)
{
return(RedirectToAction("Index", "Register", new { idRace = idRace }));
}
List <Race> races = MgtRace.GetInstance().SuscribeRace(user.ToBo(), idRace);
return(View("MyRaces", races.ToModels()));
}
public ActionResult Old(int page = 1)
{
OldRaceView view = new OldRaceView();
List <RaceModel> result = MgtRace.GetInstance().GetAllItemsWithParticipants().ToModels(true);
result = result.Where(x => x.DateEnd < DateTime.Today).ToList();
Pager pager = new Pager(result.Count(), page);
view.races = result.OrderByDescending(x => x.DateStart).Skip((pager.CurrentPage - 1) * pager.PageSize).Take(pager.PageSize).ToList();
view.Pager = pager;
return(View(view));
}
public ActionResult AfficheResult(int idRace, int?page = 1)
{
List <Resultat> results = MgtResultat.GetInstance().GetResultatsByIdRace(idRace);
Race race = MgtRace.GetInstance().GetRace(idRace);
int pageSize = 50;
int pageNumber = (page ?? 1);
var resultPage = results.Select(x => x.ToModel()).ToPagedList(pageNumber, pageSize);
ViewBag.race = race.Id;
ViewBag.ville = race.Title + " - " + race.Town;
return(View("Import", resultPage));
}
public ActionResult Import(int?page = 1)
{
PersonneModel personne = (PersonneModel)Session.Contents["user"];
List <ResultatModel> modelsResult = new List <ResultatModel>();
HttpPostedFileBase fichier = Request.Files["FileResult"];
if (fichier != null)
{
StreamReader stream = new StreamReader(fichier.InputStream);
string chaine = stream.ReadToEnd();
String[] lignes = chaine.Split('\r', '\n');
foreach (var ligne in lignes)
{
if (String.IsNullOrEmpty(ligne))
{
continue;
}
ResultatModel model = new ResultatModel();
string[] champs = ligne.Split(';');
model.Race = MgtRace.GetInstance().GetRace(int.Parse(champs[1])).ToModel();
model.Personne = MgtPersonne.GetInstance().GetPersonneByID(int.Parse(champs[0])).ToModel();
model.Classement = int.Parse(champs[2]);
model.TempsDeCourse = TimeSpan.Parse(champs[3]);
model.HeureDebut = TimeSpan.Parse(champs[4]);
model.HeureArrivee = TimeSpan.Parse(champs[5]);
modelsResult.Add(model);
}
}
bool res = MgtResultat.GetInstance().Save(modelsResult.Select(x => x.ToBo()).ToList());
if (res)
{
return(RedirectToAction("Index", "Admin"));
//return View(valRet);
}
else
{
return(View("Importresult"));
}
}
public ActionResult Affichage()
{
List <int> results = MgtResultat.GetInstance().GetResultats();
List <RaceModel> races = new List <RaceModel>();
foreach (int result in results)
{
RaceModel race = MgtRace.GetInstance().GetRace(result).ToModel();
races.Add(race);
}
return(View(races));
}
public ActionResult Delete(int idPoint)
{
var result = MgtPoint.GetInstance().GetPointById(idPoint).ToModel();
RaceModel race = MgtRace.GetInstance().GetRace(result.IdCourse).ToModel();
TypePointModel typePoint = MgtTypePoint.GetInstance().GetTypePoint(result.IdTypePoint).ToModel();
result.LibelleCourse = race.Title;
result.LibelleTypePoint = typePoint.Libelle;
if (result == null)
{
return(HttpNotFound());
}
return(View(result));
}
public ActionResult InscritsToPDF(int id)
{
InscritsView view = new InscritsView();
List <Participant> partipants = MgtParticipant.GetInstance().GetAllByIdCourse(id);
List <PersonneModel> personnes = new List <PersonneModel>();
foreach (Participant part in partipants)
{
PersonneModel model = MgtPersonne.GetInstance().GetPersonneById(part.IdPersonne).ToModel();
model.participant = part.ToModel();
personnes.Add(model);
}
view.Course = MgtRace.GetInstance().GetRace(id).ToModel();
view.personnes = personnes;
view.nbInscrits = personnes.Count;
view.inscriptions = initInscriptions(partipants);
Document doc = new Document(PageSize.LETTER, 50, 50, 50, 50);
string html = RenderRazorViewToString("~/Views/Race/InscritsToPDF.cshtml", view);
TextReader reader = new StringReader(html);
using (MemoryStream output = new MemoryStream())
{
PdfWriter wri = PdfWriter.GetInstance(doc, output);
// step 3: we create a worker parse the document
HTMLWorker worker = new HTMLWorker(doc);
doc.Open();
worker.StartDocument();
// step 5: parse the html into the document
worker.Parse(reader);
// step 6: close the document and the worker
worker.EndDocument();
worker.Close();
doc.Close();
return(File(output.ToArray(), "application/pdf", "Inscriptions" + view.Course.Title + ".pdf"));
}
}
public ActionResult DeleteRace(int idRace)
{
try
{
if (MgtRace.GetInstance().RemoveRace(idRace))
{
return(RedirectToAction("Index"));
}
else
{
return(View());
}
}
catch (Exception e)
{
return(View());
}
}
public ActionResult Delete(int id, FormCollection collection)
{
try
{
var result = MgtRace.GetInstance().RemoveRace(id);
if (result)
{
return(RedirectToAction("Index"));
}
else
{
return(View());
}
}
catch
{
return(View());
}
}
public ActionResult Edit(RaceModel race)
{
try
{
var result = MgtRace.GetInstance().UpdateRace(race.ToBo());
if (result)
{
return(RedirectToAction("Index"));
}
else
{
return(View());
}
}
catch
{
return(View());
}
}
public ActionResult Details(int id)
{
RaceModel result = MgtRace.GetInstance().GetRace(id).ToModel();
int idUser = 0;
//On récupère l'ID de l'utilisateur courant
if (WebSecurity.IsAuthenticated)
{
if (!WebSecurity.Initialized)
{
WebSecurity.InitializeDatabaseConnection("SqlAdoCs", "UserTable", "Id", "Name", autoCreateTables: true);
}
idUser = WebSecurity.CurrentUserId;
}
//On récupère l'utisateur
//On personnalise la vue en f(x) du paramètrage du compte
if (idUser > 0)
{
Personne user = MgtPersonne.GetInstance().GetPersonneByIdUserTable(idUser);
if (user.kms)
{
result.KmOrMiles = "Km";
}
else if (user.miles)
{
result.KmOrMiles = "Miles";
}
else
{
result.KmOrMiles = "Km";
}
}
if (result == null)
{
return(HttpNotFound());
}
return(View(result));
}
public ActionResult ExportResults(int idRace)
{
List <Resultat> results = MgtResultat.GetInstance().GetResultatsByIdRace(idRace);
Race course = MgtRace.GetInstance().GetRace(idRace);
string lines = "Id Particpant;IdCourse;Classement;.Temps de course";
// Write the string to a file.
System.IO.StreamWriter file = new System.IO.StreamWriter("D:\\Result" + course.Title + "_" + course.Town + ".csv");
file.WriteLine(lines);
foreach (Resultat resultat in results)
{
string ligne = resultat.Personne.Nom + ";" + resultat.Race.Town + ";" + resultat.Classement + ";" + resultat.TempsDeCourse;
file.WriteLine(ligne);
}
file.Close();
return(RedirectToAction("Index", "Admin"));
}
