public ActionResult MettreEnVente(Encher encher) { if (ModelState.IsValid) { encher.Id = Utility.IdGenerator.getEncherenId(); encher.Etat = -1; EnchereRequette.insertEncher(encher); string formatString = "yyyyMMddHHmmss"; string sample1 = "20180524121900"; string sample2 = "20180917102230"; DateTime dt1 = DateTime.ParseExact(sample1, formatString, null); DateTime dt2 = DateTime.ParseExact(sample2, formatString, null); StartScheduler sch1 = new StartScheduler(); ObjetRequette.setObjetEnVente(encher.IdObjet, 1); //Encher en = EnchereRequette.getEnchereById(encher.Id); //en.Etat = 0; //EnchereRequette.updateEnchere(en); //sch1.Start(encher.DateDepart, encher.IdObjet, encher.Id); sch1.Start(dt1, encher.IdObjet, encher.Id); FinishScheduler sch2 = new FinishScheduler(); //sch2.Start(encher.DateFin, encher.IdObjet, encher.Id); sch2.Start(dt2, encher.IdObjet, encher.Id); return(RedirectToAction("gestionObjetMembre", "Objet")); } return(View(encher)); }
public static Encher getEnchereById(string Id) { string connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; SqlConnection connection = new SqlConnection(connectionString); string request = "SELECT * FROM Enchere WHERE Id = '" + Id.Trim() + "'"; SqlCommand command = new SqlCommand(request, connection); try { connection.Open(); SqlDataReader reader = command.ExecuteReader(); Encher en = null; if (reader.Read()) { en = new Encher((string)reader["Id"], (string)reader["IdObjet"], (string)reader["IdVendeur"], (string)reader["IdAcheteur"], (decimal)reader["PrixAchat"], (decimal)reader["PasDePrix"], (DateTime)reader["DateDepart"], (DateTime)reader["DateFin"], (int)reader["Etat"]); } reader.Close(); return(en); } catch (Exception e) { System.Console.WriteLine(e.Message); } finally { connection.Close(); } return(null); }
public ActionResult MettreEnVente(string idObjet, string idVendeur, bool vente) { Encher en = new Encher("0", idObjet, idVendeur, idVendeur, 0, 0, DateTime.Now, DateTime.Now, 0); // LangueController.CreateCulture(getLangue()); CreateCulture(getLangue()); return(View(en)); }
public ActionResult UpdateEnchere(UpdateEnchereViewModel en) { if (ModelState.IsValid) { Encher model = new Encher(); Encher enOld = EnchereRequette.getEnchereById(en.Id); Objet obj = ObjetRequette.getObjetById(en.IdObjet); if ((enOld.PrixAchat + enOld.PasDePrix) > en.Prix) { ViewBag.err = "Au moins augmenter le prix par " + enOld.PasDePrix + "$!"; return(View(en)); } Historique his = EnchereRequette.getHistorique(en.Id); if (his.Prix > en.Prix + en.PasDePrix) { model.PrixAchat = en.Prix + en.PasDePrix; model.IdAcheteur = his.IdMembre; //// Send Email to en.IdAcheteur } else if (his.Prix >= en.Prix) { model.PrixAchat = his.Prix; model.IdAcheteur = his.IdMembre; //// Send Email to en.IdAcheteur } else { model.PrixAchat = his.Prix + en.PasDePrix; model.IdAcheteur = en.IdAcheteur; //// Send Email to his.IdMembre } Membre mb = MembreRequette.GetUserByNumero(model.IdAcheteur); Utility.Mail.SendEmail(obj.Nom, model.PrixAchat, mb.Adresse); model.Id = en.Id; model.IdObjet = en.IdObjet; //model.IdAcheteur = en.IdAcheteur; model.IdVendeur = en.IdVendeur; //model.PrixAchat = en.Prix; model.PasDePrix = en.PasDePrix; model.DateDepart = en.DateDepart; model.DateFin = en.DateFin; model.Etat = en.Etat; EnchereRequette.updateEnchere(model); his = new Historique(0, en.IdAcheteur, en.Id, en.Prix, DateTime.Now); EnchereRequette.insertHistorique(his); ////// send E_mail to add ////// return(RedirectToAction("Index", "Home")); } return(View(en)); }
public static void updateEnchere(Encher en) { string connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; SqlConnection connection = new SqlConnection(connectionString); string request = "UPDATE Enchere SET IdAcheteur = '" + en.IdAcheteur + "', PrixAchat = '" + en.PrixAchat + "', Etat = " + en.Etat + " WHERE id = '" + en.Id + "'"; SqlCommand command = new SqlCommand(request, connection); try { connection.Open(); command.ExecuteNonQuery(); } catch (Exception e) { System.Console.WriteLine(e.Message); } finally { connection.Close(); } }
public static void insertEncher(Encher encher) { string connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; SqlConnection connection = new SqlConnection(connectionString); string request = "INSERT INTO Enchere VALUES ('" + encher.Id.Trim() + "','" + encher.IdObjet.Trim() + "', '" + encher.IdVendeur.Trim() + "', '" + encher.IdAcheteur.Trim() + "', '" + encher.PrixAchat + "', '" + encher.PasDePrix + "', '" + encher.DateDepart.ToString("yyyy-MM-dd") + "', '" + encher.DateFin.ToString("yyyy-MM-dd") + "', '" + encher.Etat + "')"; SqlCommand command = new SqlCommand(request, connection); try { connection.Open(); command.ExecuteNonQuery(); } catch (Exception e) { System.Console.WriteLine(e.Message); } finally { connection.Close(); } }
public ActionResult Create(Evaluation ev) { if (ModelState.IsValid) { Encher en = EnchereRequette.getEnchereById(ev.IdEnchere); int etat = en.Etat; string id = ""; if (ModelState.IsValid) { if (ev.Id == "acheteur") { if (etat == 1) { EnchereRequette.setEnchereEtat(ev.IdEnchere, 3); } else if (etat == 4) { EnchereRequette.setEnchereEtat(ev.IdEnchere, 5); } id = en.IdVendeur; } else if (ev.Id == "vendeur") { if (etat == 1) { EnchereRequette.setEnchereEtat(ev.IdEnchere, 4); } else if (etat == 3) { EnchereRequette.setEnchereEtat(ev.IdEnchere, 5); } id = en.IdAcheteur; } ev.Id = Utility.IdGenerator.getEvaluationId(); EvaluationRequette.insertEvaluation(ev); Membre mb = MembreRequette.GetUserByNumero(id); mb.Cote += ev.Cote; MembreRequette.UpdateCote(mb); ////// update cote d'utilisateur ///////////////// return(RedirectToAction("Index", "Home")); } } return(View(ev)); }
public ActionResult UpdateEnchere(string id) { // LangueController.CreateCulture(getLangue()); CreateCulture(getLangue()); Membre mb = MembreRequette.GetUserByEmail(@User.Identity.Name); Encher en = EnchereRequette.getEnchereById(id); UpdateEnchereViewModel model = new UpdateEnchereViewModel(); model.Id = en.Id; model.IdObjet = en.IdObjet; model.IdAcheteur = mb.Numero; model.IdVendeur = en.IdVendeur; model.PrixAchat = en.PrixAchat; model.PasDePrix = en.PasDePrix; model.DateDepart = en.DateDepart; model.DateFin = en.DateFin; model.Etat = en.Etat; return(View(model)); }
public ActionResult List(string idEnchere, string op, string rtnUrl) { // LangueController.CreateCulture(getLangue()); CreateCulture(getLangue()); Encher en = EnchereRequette.getEnchereById(idEnchere); Evaluation ev = null; if (op == "acheteur") { ev = EvaluationRequette.getEvaluation(idEnchere, en.IdAcheteur); } else if (op == "vendeur") { ev = EvaluationRequette.getEvaluation(idEnchere, en.IdAcheteur); } ViewBag.rtn = rtnUrl; return(View(ev)); }