public IActionResult CommandeUSer() { string sql = "Select user_id from users where enabled=0"; _currentid = st.getCurrentIdOrVisiteur(sql); Console.WriteLine("Commande du client"); int vistorornot = 0; string sqls = "Select user_id from users where user_id=@id AND username=@name "; MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = sqls; cmd.Parameters.AddWithValue("@id", _currentid); cmd.Parameters.AddWithValue("@name", "visiteur"); vistorornot = st.LookIfNotAVisitor(cmd); if (vistorornot == 0) { menu.Connected = true; } else { menu.Connected = false; } /* * String getpanier = "http://localhost:8090/server/user/panier/"+id; * HttpResponseMessage responseMessage = _httpClient.GetAsync(getpanier).Result; * String response = responseMessage.Content.ReadAsStringAsync().Result; * int cart = JsonSerializer.Deserialize<int>(response); */ String path = "http://localhost:8090/server/panier/" + _currentid; HttpResponseMessage message = _httpClient.GetAsync(path).Result; String r = message.Content.ReadAsStringAsync().Result; CartReponse cartR = JsonSerializer.Deserialize <CartReponse>(r); if (_currentid != 0) { if (cartR.Liste != null) { ViewData["CartReponse"] = cartR; ViewData["ReponseMenu"] = menu; return(View()); } } return(View("Error")); }
public IActionResult RecapView() { menu.Connected = true; ViewData["ReponseMenu"] = menu; String path = "http://*****:*****@id"; AllInformationAboutUser(sql, _currentid); String getprice = "http://localhost:8090/server/order/prix/" + _currentorder; HttpResponseMessage messageprice = _httpClient.GetAsync(getprice).Result; String rprice = messageprice.Content.ReadAsStringAsync().Result; if (messageprice.IsSuccessStatusCode == false) { error.NomService = "Order Service"; ViewData["ReponseError"] = error; return(View("ErrorView")); } double pricewithtransport = JsonSerializer.Deserialize <double>(rprice); cartR.PrixTotal = pricewithtransport; montanttotal = pricewithtransport; if (_currentid != 0) { if (cartR.Liste != null) { ViewData["CartReponse"] = cartR; ViewData["UserReponse"] = user; return(View()); } } ViewData["ReponseError"] = error; return(View("ErrorView")); }
public IActionResult CheckOutView(int id) { menu.Connected = true; string sql = "Select user_id from users where enabled=0 "; _currentid = st.getCurrentIdOrVisiteur(sql); String path = "http://localhost:8090/server/panier/" + _currentid; HttpResponseMessage message = _httpClient.GetAsync(path).Result; String r = message.Content.ReadAsStringAsync().Result; CartReponse cartR = JsonSerializer.Deserialize <CartReponse>(r); if (_currentid != 0) { if (cartR.Liste != null) { ViewData["CartReponse"] = cartR; ViewData["ReponseMenu"] = menu; return(View()); } } return(View("Error")); }
public ActionResult Log() { int vistorornot = 0; string sqls = "Select user_id from users where user_id=@id AND username=@name "; MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = sqls; cmd.Parameters.AddWithValue("@id", _currentid); cmd.Parameters.AddWithValue("@name", "visiteur"); vistorornot = LookIfNotAVisitor(cmd); if (vistorornot == 0) { menu.Connected = true; } else { menu.Connected = false; } int newid = 0; string sql = "SELECT user_id from users WHERE username = @name AND password=@password"; newid = ExistInDbUser(sql, HttpContext.Request.Form["name"], HttpContext.Request.Form["pwd"]); if (newid == 0) { Console.WriteLine("Pas le bon user"); return(View("Error")); } int cart = CurrentPanier(_currentid); String cartnbre = "http://*****:*****@enabled where user_id = @id"; string sqlN = "Update users set enabled = @enabled where user_id = @id"; Update(sqlA, _currentid, 1); Update(sqlA, newid, 0); _currentid = newid; return(RedirectToAction("Index", "Stock", new RouteValueDictionary( new { controller = "Stock", action = "Index" }))); }