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