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