public ActionResult Create(Vetement vetement, string image1 = "", string image2 = "", string image3 = "", string image4 = "" , IEnumerable <HttpPostedFileBase> files = null) { tdonnee = new TraitementDonnees(); tdate = new Tdate(); Sough.Helpers.ImagesActions.ImagesModel <Vetement>(ref vetement, ref image1, ref image2, ref image3, ref image4, ref files); tdate.SaveDate <Vetement>(ref vetement); db.Vetements.Add(vetement); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edite(FormCollection param) { try { string key = param["key"]; string pass = param["password"]; tdonnee = new TraitementDonnees(); if (!tdonnee.StringIsValid(key)) { ViewBag.err = "err1"; ViewBag.op = "edit"; return View("~/Views/Voiture/PutPass.cshtml"); } long id = Int64.Parse(key); if (id <= 0) { ViewBag.Key = key; ViewBag.err = "err1"; ViewBag.op = "edit"; return View("~/Views/Voiture/PutPass.cshtml"); } Voiture v = db.Voitures.Find(id); if (v == null) { ViewBag.Key = key; ViewBag.err = "err1"; ViewBag.op = "edit"; return View("~/Views/Voiture/PutPass.cshtml"); } pass = tdonnee.GetMd5(pass); if (v.password != pass) { ViewBag.Key = key; ViewBag.err = "err2"; ViewBag.op = "edit"; return View("~/Views/Voiture/PutPass.cshtml"); } return View("~/Views/Voiture/Edit.cshtml", v); } catch (Exception e) { ViewBag.ex = "Erreur sur le passage de donnees"; return View("~/Views/Error/Exception.cshtml"); } }
public ActionResult Delete(FormCollection param) { string key = param["key"]; string why = param["why"]; string pass = param["password"]; tdonnee = new TraitementDonnees(); if (!tdonnee.StringIsValid(key) || !tdonnee.StringIsValid(why) || !tdonnee.StringIsValid(pass)) { ViewBag.ex = "Erreur sur le passage de donnees"; return View("~/Views/Error/Exception.cshtml"); } long Id = Int64.Parse(key); if (Id == 0) { ViewBag.ex = "Erreur sur le passage de donnees"; return View("~/Views/Error/Exception.cshtml"); } Voiture voiture = db.Voitures.Find(Id); if (voiture == null) { ViewBag.err = "err1"; return View(); } tdonnee = new TraitementDonnees(); pass = tdonnee.GetMd5(pass); //System.Diagnostics.Debug.WriteLine("hash password:"******"err2"; ViewBag.op = "del"; return View("~/Views/Voiture/PutPass.cshtml"); } }
public ActionResult Create([Bind(Include = "prix, marque, Modele,ville,kilometrage,BoiteDeVitesse,carburant," + "trader_name,Email,phone,color,car_shape,trader_facebook,trader_instagram,password" )]Voiture voiture, string EstNeuf="", string image1 = "", string image2 = "", string image3 = "", string image4 = "" , IEnumerable<HttpPostedFileBase> files = null ) { try { tdonnee = new TraitementDonnees(); tdate = new Tdate(); Voiture _voiture = new Voiture(); string model = ""; string email = ""; string face = ""; string insta = ""; long prix = voiture.prix; string marque = voiture.marque.Trim().ToString(); if (voiture.Modele.Trim().ToString().Length > 1) model = voiture.Modele.Trim().ToString(); string ville = voiture.ville.Trim().ToString(); long kilometrage = voiture.kilometrage; string boiteDeVitesse = voiture.BoiteDeVitesse.Trim().ToString(); string carburant = voiture.carburant.Trim().ToString(); string tname = ""; string color = voiture.color.Trim().ToString(); string car_shape = setCarType(voiture.car_shape.Trim().ToString()); string st_pass = voiture.password.Trim().ToString(); string est_neuf = EstNeuf; if (!tdonnee.NumberIsValid(voiture.prix) || !tdonnee.StringIsValid(marque) || !tdonnee.StringIsValid(model) || !tdonnee.StringIsValid(est_neuf) || !tdonnee.StringIsValid(ville) || !tdonnee.NumberIsValid(kilometrage) || !tdonnee.StringIsValid(boiteDeVitesse) || !tdonnee.StringIsValid(carburant) || car_shape.Equals("null") || color.Equals("null") || !tdonnee.StringIsValid(st_pass)) { System.Diagnostics.Debug.WriteLine("modele not valide"); TempData["return"] = "nook"; return RedirectToAction("Create"); } if (tdonnee.StringIsValid(voiture.trader_name)) tname = voiture.trader_name.Trim().ToString(); if (tdonnee.StringIsValid(voiture.email)) email = voiture.email.Trim().ToString(); if (tdonnee.StringIsValid(voiture.trader_facebook)) face = voiture.trader_facebook.Trim().ToString(); if (tdonnee.StringIsValid(voiture.trader_instagram)) insta = voiture.trader_instagram.Trim().ToString(); /* Images */ Sough.Helpers.ImagesActions.ImagesModel<Voiture>(ref _voiture, ref image1, ref image2, ref image3, ref image4, ref files); /* P@$$W0RD */ tdonnee.Tmd5<Voiture>(st_pass, ref _voiture); /* Date */ tdate.SaveDate<Voiture>(ref _voiture); _voiture.prix = prix; _voiture.marque = marque; _voiture.Modele = model; _voiture.EstNeuf = est_neuf; _voiture.ville = ville; _voiture.kilometrage = kilometrage; _voiture.BoiteDeVitesse = boiteDeVitesse; _voiture.carburant = carburant; _voiture.trader_name = tname; _voiture.email = email; _voiture.color = color; _voiture.car_shape = car_shape; _voiture.trader_facebook = face; _voiture.trader_instagram = insta; string phone = voiture.phone.Trim().ToString(); _voiture.phone = phone; db.Voitures.Add(_voiture); db.SaveChanges(); _voiture = null; //Gallerie1 glr = new Gallerie1(); //long id = _voiture.Id; //glr.ModelId = id; //glr.ModelName = "Voiture"; //db.Gallerie1.Add(glr); //db.SaveChanges(); //return View(_voiture); TempData["return"] = "ok"; return RedirectToAction("Create"); } catch (Exception e) { ViewBag.ex = e.Message; return View("~/Views/Error/Exception.cshtml"); } }
public ActionResult Ads(FormCollection param, int page = 1) { try { tdonnee = new TraitementDonnees(); string cat = tdonnee.splitStrSM(param["cat"].Trim()); if (!cat.Equals("Voitures")) { string view = tdonnee.GetAdsView(cat); } Vsql = new VoitureHelp(); string pmn_s = tdonnee.splitStrSM(param["pmn"].Trim()); string pmx_s = tdonnee.splitStrSM(param["pmx"].Trim()); string marque = tdonnee.splitStrSM(param["marque"].Trim()); string m_audi = tdonnee.splitStrSM(param["model_audi"].Trim()); string m_bmw = tdonnee.splitStrSM(param["model_bmw"].Trim()); string m_mercedes = tdonnee.splitStrSM(param["model_mercedes"].Trim()); string m_nissan = tdonnee.splitStrSM(param["model_nissan"].Trim()); string m_reault = tdonnee.splitStrSM(param["model_renault"].Trim()); string m_toyota = tdonnee.splitStrSM(param["model_toyota"].Trim()); string km_min = tdonnee.splitStrSM(param["km_min"].Trim()); string km_max = tdonnee.splitStrSM(param["km_max"].Trim()); string boite = tdonnee.splitStrSM(param["boite"].Trim()); string carburant = tdonnee.splitStrSM(param["carburant"].Trim()); string car_shape1 = tdonnee.splitStrSM(param["car_shape1"].Trim()); string car_shape2 = tdonnee.splitStrSM(param["car_shape2"].Trim()); string car_shape3 = tdonnee.splitStrSM(param["car_shape3"].Trim()); string car_shape4 = tdonnee.splitStrSM(param["car_shape4"].Trim()); string color1 = tdonnee.splitStrSM(param["color1"].Trim()); string color2 = tdonnee.splitStrSM(param["color2"].Trim()); string color3 = tdonnee.splitStrSM(param["color3"].Trim()); string color4 = tdonnee.splitStrSM(param["color4"].Trim()); string color5 = tdonnee.splitStrSM(param["color5"].Trim()); string color6 = tdonnee.splitStrSM(param["color6"].Trim()); string color7 = tdonnee.splitStrSM(param["color7"].Trim()); string color8 = tdonnee.splitStrSM(param["color8"].Trim()); string ville = tdonnee.splitStrSM(param["ville"].Trim()); string neuf = tdonnee.splitStrSM(tdonnee.NullToString(param["neuf"])); string occ = tdonnee.splitStrSM(tdonnee.NullToString(param["occ"])); string query = "SELECT * FROM " + cat; ArrayList fields = new ArrayList(); string query_modele = Vsql.GetQueryModele(m_audi, m_bmw, m_mercedes, m_nissan, m_reault, m_toyota); string query_shape = ""; int cpt_car_shape = 0; query_shape = Vsql.GetQueryShape(car_shape1, car_shape2, car_shape3, car_shape4); cpt_car_shape = Vsql.GetCptShape(); string query_color = ""; int cpt_color = 0; query_color = Vsql.GetQueryColor(color1, color2, color3, color4, color5, color6, color7, color8); cpt_color = Vsql.GetCptColor(); if (!ville.Equals("all") && ville.Length > 1) fields.Add("ville = '" + ville + "'"); tdonnee.Prixmm(ref fields, pmn_s, pmx_s); if (marque.Length > 0) fields.Add("marque = '" + marque + "'"); if (query_modele != null) fields.Add("Modele = '" + query_modele + "'"); if (km_min.Length > 0) fields.Add("kilometrage >= " + km_min); if (km_max.Length > 0) fields.Add("kilometrage <= " + km_max); if (boite.Length > 0) fields.Add("BoiteDeVitesse = '" + boite + "'"); if (carburant.Length > 0) fields.Add("carburant = '" + carburant + "'"); if (cpt_color > 0) fields.Add(query_color); if (cpt_car_shape > 0) fields.Add(query_shape); if (neuf.Length > 1 && occ.Length < 1) { fields.Add("EstNeuf = '" + neuf + "'"); } else if (neuf.Length < 1 && occ.Length > 1) { fields.Add("EstNeuf = '" + occ + "'"); } for (int i = 0; i < fields.Count; i++) { if (i == 0 && fields.Count > 0) query += " WHERE "; query += fields[i]; if (i < (fields.Count - 1)) query += " AND "; } query += " ;"; //System.Diagnostics.Debug.WriteLine(query); ViewBag.ville = ville; ViewBag.cat = cat; setCat(cat); if(AdHelper.trie == 1) listVoitures = db.Voitures.SqlQuery(query).OrderByDescending(v => v.temps).ThenBy(v => v.Id).ToList(); else listVoitures = db.Voitures.SqlQuery(query).OrderBy(a => a.prix).ThenBy(a => a.Id).ToList(); VoitureHelp.lastResult = listVoitures; PagedList<Voiture> model = new PagedList<Voiture>(listVoitures, page, PageSize); return PartialView("~/Views/Voiture/_CarsList.cshtml", model); } catch (Exception e) { ViewBag.donnees = "error"; return PartialView("~/Views/Voiture/_CarsList.cshtml"); } }
public ActionResult Edit([Bind(Include = "Id,prix, marque, Modele,ville,kilometrage,BoiteDeVitesse,carburant," + "trader_name,Email,phone,color,car_shape,trader_facebook,trader_instagram,password" )]Voiture voiture, string EstNeuf = "") { try { tdonnee = new TraitementDonnees(); string query = ""; if (!(voiture.Id > 0)) { ViewBag.err = "err1"; return View(); } tdonnee.GetQueryEdite(ref query, "trader_name", voiture.trader_name); tdonnee.GetQueryEdite(ref query, "email", voiture.email); tdonnee.GetQueryEdite(ref query, "trader_facebook", voiture.trader_facebook); tdonnee.GetQueryEdite(ref query, "trader_instagram", voiture.trader_instagram); if (tdonnee.StringIsValid(voiture.phone)) { tdonnee.GetQueryEdite(ref query, "phone", voiture.phone); } if (tdonnee.StringIsValid(voiture.marque)) { tdonnee.GetQueryEdite(ref query, "marque", voiture.marque); } if (tdonnee.StringIsValid(voiture.Modele)) { tdonnee.GetQueryEdite(ref query, "Modele", voiture.Modele); } if (tdonnee.StringIsValid(voiture.EstNeuf)) { tdonnee.GetQueryEdite(ref query, "EstNeuf", voiture.EstNeuf); } if (voiture.kilometrage >= 0) { tdonnee.GetQueryEdite(ref query, "kilometrage", Convert.ToString(voiture.kilometrage)); } if (tdonnee.StringIsValid(voiture.carburant)) { tdonnee.GetQueryEdite(ref query, "carburant", voiture.carburant); } if (tdonnee.StringIsValid(voiture.color)) { tdonnee.GetQueryEdite(ref query, "color", voiture.color); } if (tdonnee.StringIsValid(voiture.car_shape)) { voiture.car_shape = setCarType(voiture.car_shape.Trim().ToString()); tdonnee.GetQueryEdite(ref query, "car_shape", voiture.car_shape); } if (tdonnee.StringIsValid(voiture.BoiteDeVitesse)) { tdonnee.GetQueryEdite(ref query, "BoiteDeVitesse", voiture.BoiteDeVitesse); } if (tdonnee.StringIsValid(voiture.ville)) { tdonnee.GetQueryEdite(ref query, "ville", voiture.ville); } if (voiture.prix >= 400000) { tdonnee.GetQueryEdite(ref query, "prix", Convert.ToString(voiture.prix)); } if (tdonnee.StringIsValid(voiture.password)) { tdonnee.Tmd5<Voiture>(voiture.password, ref voiture); tdonnee.GetQueryEdite(ref query, "password", voiture.password); } string sql = "UPDATE Voitures SET " + query + " WHERE Id = " + voiture.Id +" ;"; //System.Diagnostics.Debug.WriteLine(sql); db.Database.ExecuteSqlCommand(sql); db.SaveChanges(); return RedirectToAction("ShowWare", new { id = voiture.Id }); } catch (Exception e) { ViewBag.ex = e.Message; return View("~/Views/Error/Exception.cshtml"); } }