public ActionResult Gestion(int? _idcheval) { ViewBag.Update = "non"; PoneySeller.Models.Users desUsagers = new PoneySeller.Models.Users(Session["MyPonies"]); string commande = "select id from chevaux where id = " + _idcheval + "and idproprio = (select id from usagers where email = '" + Session["Username"].ToString() + "')"; if (Session["Username"].ToString() == "" && !(bool)Session["UserValid"] && !desUsagers.ExecuteCommandBoolReturn(commande)) { return RedirectToAction("Index", "Home"); } ViewBag.IdDuCheval = 1; if (_idcheval != null) { ViewBag.Update = "oui"; int ID = _idcheval.GetValueOrDefault(); ViewBag.IdDuCheval = ID; String[] InfoCheval = desUsagers.GetInfoChevaux(ID); ModelState.SetModelValue("TB_Nom", new ValueProviderResult(InfoCheval[0], string.Empty, new CultureInfo("en-US"))); ModelState.SetModelValue("TB_Age", new ValueProviderResult(InfoCheval[1], string.Empty, new CultureInfo("en-US"))); ModelState.SetModelValue("RB_Sexe", new ValueProviderResult(InfoCheval[2], string.Empty, new CultureInfo("en-US"))); ModelState.SetModelValue("TB_Prix", new ValueProviderResult(InfoCheval[3], string.Empty, new CultureInfo("en-US"))); ModelState.SetModelValue("TB_Race", new ValueProviderResult(InfoCheval[4], string.Empty, new CultureInfo("en-US"))); ViewBag.Image1 = InfoCheval[5]; } else { ViewBag.Image1 = "BasePicture.png"; } return View(new PoneySeller.Models.Jumbotron()); }
public ActionResult Gestion(String TB_Nom, String TB_Age, String RB_Sexe, String TB_Prix, HttpPostedFileBase FileUpload1, String TB_Update, String TB_IDCheval, String CB_Discipline, String TB_Race, String btn) { if (btn == "Enregistrer") { if (TB_Nom != "" && TB_Age != "" && RB_Sexe != "" && TB_Prix != "" && CB_Discipline != "" && TB_Race != "") { string commandesql = ""; if (TB_Update == "non") { PoneySeller.Models.Users desUsagers = new PoneySeller.Models.Users(Session["MyPonies"]); int IDProprio = desUsagers.GetID(Session["Username"].ToString()); commandesql = "insert into chevaux (nom, age, race, prix, sexe, idproprio, photoguid) values ( '" + TB_Nom + "'," + TB_Age + ",'" + TB_Race + "', " + TB_Prix + ", '" + RB_Sexe + "', " + IDProprio + ", '" + FileUpload1.FileName.ToString() + "')"; if (ExecuteCommande(commandesql) > 0) { ViewBag.Reussi = "Cheval ajouté !"; } else { ViewBag.NonReussi = "Erreur dans l'enregistrement du cheval !"; } } else if (TB_Update == "oui") { commandesql = "update chevaux set nom = '" + TB_Nom.ToString() + "', " + "race = '" + TB_Race.ToString() + "', " + "age = " + TB_Age.ToString() + ", " + "prix = '" + TB_Prix.ToString() + "', " + "sexe = '" + RB_Sexe.ToString() + "', " + "photoguid = '" + FileUpload1.FileName.ToString() + "' " + "where ID = " + TB_IDCheval; if (ExecuteCommande(commandesql) > 0) { ViewBag.Reussi = "Cheval Modifié !"; } else { ViewBag.NonReussi = "Erreur dans la modifcation du cheval !"; } } } else { ViewBag.ErreurVide = "Tout les champs doivent être remplis et au moins une photo doit être choisi."; } } else if (btn == "Supprimer") { string commandesql = "DELETE from Chevaux where id = " + TB_IDCheval; if (ExecuteCommande(commandesql) > 0) { return RedirectToAction("Index", "Home"); } else { ViewBag.NonReussi = "Erreur dans la suppression du cheval !"; } } return View(new PoneySeller.Models.Jumbotron()); }
int ExecuteCommande(string cmd) { int LigneModifie = 0; PoneySeller.Models.Users desUsagers = new PoneySeller.Models.Users(Session["MyPonies"]); LigneModifie = desUsagers.ExecuteCommandIntReturn(cmd); return LigneModifie; }
public ActionResult Profil() { if ((bool)Session["UserValid"]) { PoneySeller.Models.Users desUsagers = new PoneySeller.Models.Users(Session["MyPonies"]); desUsagers.SQLTableName = "Usagers"; desUsagers.SelectByFieldName("Email", Session["Username"].ToString()); desUsagers.Next(); ModelState.SetModelValue("TB_Fullname", new ValueProviderResult(desUsagers.usager.NomComplet, string.Empty, new CultureInfo("en-US"))); ModelState.SetModelValue("TB_Adresse", new ValueProviderResult(desUsagers.usager.Adresse, string.Empty, new CultureInfo("en-US"))); ModelState.SetModelValue("TB_Ville", new ValueProviderResult(desUsagers.usager.Ville, string.Empty, new CultureInfo("en-US"))); ModelState.SetModelValue("TB_Telephone", new ValueProviderResult(desUsagers.usager.Telephone, string.Empty, new CultureInfo("en-US"))); ModelState.SetModelValue("TB_Password", new ValueProviderResult(desUsagers.usager.Password, string.Empty, new CultureInfo("en-US"))); ModelState.SetModelValue("TB_PasswordConfirm", new ValueProviderResult(desUsagers.usager.Password, string.Empty, new CultureInfo("en-US"))); } else { return RedirectToAction("Index", "Home"); } return View(new PoneySeller.Models.Jumbotron()); }
public ActionResult Profil(String TB_Fullname, String TB_Adresse, String TB_Ville, String TB_Telephone, String TB_Password, String TB_PasswordConfirm) { PoneySeller.Models.Users desUsagers = new PoneySeller.Models.Users(Session["MyPonies"]); desUsagers.SQLTableName = "Usagers"; desUsagers.SelectByFieldName("Email", Session["Username"].ToString()); desUsagers.Next(); if (TB_Fullname != "" && TB_Adresse != "" && TB_Ville != "" && TB_Telephone != "" && TB_Password != "" && TB_PasswordConfirm != "") { desUsagers.usager.NomComplet = TB_Fullname; desUsagers.usager.Adresse = TB_Adresse; desUsagers.usager.Ville = TB_Ville; desUsagers.usager.Telephone = TB_Telephone; desUsagers.usager.Password = TB_Password; desUsagers.Update(); ViewBag.UpdateSuccess = "Votre compte a été modifié"; } else { ViewBag.ErreurVide = "Tout les champs doivent être remplis et au moins une photo doit être choisi."; } return View(new PoneySeller.Models.Jumbotron()); }