public ActionResult Valider(int NbrProPanier, int PrixTotal)
{
// ViewBag.M1 = NbrProPanier;
// ViewBag.M2 = PrixTotal;
try
{
int nbrLigne = 0;
DataTable dt = new DataTable();
using (SqlConnection SqlCon = new SqlConnection(connectionString))
{
SqlCon.Open();
string query = "SELECT * FROM PANIER";
SqlDataAdapter SqlDa = new SqlDataAdapter(query, SqlCon);
SqlDa.Fill(dt);
}
nbrLigne = Convert.ToInt32(dt.Rows.Count.ToString());
int val = 1;
if (dt.Rows.Count == 0)
{
using (SqlConnection SqlCon = new SqlConnection(connectionString))
{
SqlCon.Open();
string query = "INSERT INTO PANIER (IdPanier, NbrProPanier,DateAchat, PrixTotal) VALUES ('" + val + "', '" + NbrProPanier + "','" + DateTime.Now.ToShortDateString() + "','" + PrixTotal + "')";
SqlCommand SqlCom = new SqlCommand(query, SqlCon);
//SqlCom.Parameters.AddWithValue("@IdPanier", val);
//SqlCom.Parameters.AddWithValue("@NbrProPanier", NbrProPanier);
//SqlCom.Parameters.AddWithValue("@DateAchat",DateTime.Now.ToShortDateString() );
//SqlCom.Parameters.AddWithValue("@PrixTotal", PrixTotal);
SqlCom.ExecuteNonQuery();
ViewBag.Message = "Avec succès1";
return(RedirectToAction("Acheteur"));
}
//UPDATE PANIER SET IdUser='******' where IdPanier='1'
}
else
{
using (SqlConnection SqlCon = new SqlConnection(connectionString))
{
SqlCon.Open();
MyStoreEntities4 D = new MyStoreEntities4();
PANIER px = new PANIER();
px = D.PANIER.ToList().Last();
val = px.IdPanier + 1;
string query = "INSERT INTO PANIER (IdPanier, NbrProPanier,DateAchat, PrixTotal) VALUES ('" + val + "', '" + NbrProPanier + "','" + DateTime.Now.ToShortDateString() + "','" + PrixTotal + "')";
SqlCommand SqlCom = new SqlCommand(query, SqlCon);
//SqlCom.Parameters.AddWithValue("@IdPanier", val);
//SqlCom.Parameters.AddWithValue("@NbrProPanier", NbrProPanier);
//SqlCom.Parameters.AddWithValue("@DateAchat", DateTime.Now.ToShortDateString());
//SqlCom.Parameters.AddWithValue("@PrixTotal", PrixTotal);
SqlCom.ExecuteNonQuery();
SqlCon.Close();
ViewBag.Message = "Avec succès 2";
return(RedirectToAction("Acheteur"));
}
}
}
catch
{
return(RedirectToAction("HttpNotFoun", "ACCUEIL"));
}
// return View();
}
public ActionResult Acheteur(ACHETEUR1 ACHETEURS)
{
//ViewBag.S1 = ACHETEURS.Nom;
//ViewBag.S2 = ACHETEURS.Prenom;
//ViewBag.S3 = ACHETEURS.DateNaiss;
try
{
int nbrLigne = 0;
DataTable dt = new DataTable();
using (SqlConnection SqlCon = new SqlConnection(connectionString))
{
SqlCon.Open();
string query = "SELECT * FROM ACHETEUR";
SqlDataAdapter SqlDa = new SqlDataAdapter(query, SqlCon);
SqlDa.Fill(dt);
}
nbrLigne = Convert.ToInt32(dt.Rows.Count.ToString());
int val = 1;
if (dt.Rows.Count == 0)
{
ViewBag.S1 = nbrLigne;
using (SqlConnection SqlCon = new SqlConnection(connectionString))
{
SqlCon.Open();
// INSERT INTO ACHETEUR(IdUser, Nom, Prenom, DateNaiss) VALUES('1', 'exempl', 'exemple', '2018')
string query = "INSERT INTO ACHETEUR (IdUser, Nom,Prenom,DateNaiss,Adresse,NumTel,Email) VALUES ('" + val + "', '" + ACHETEURS.Nom + "','" + ACHETEURS.Prenom + "','" + ACHETEURS.DateNaiss + "','" + ACHETEURS.Adresse + "','" + ACHETEURS.NumTel + "','" + ACHETEURS.Email + "')";
SqlCommand SqlCom = new SqlCommand(query, SqlCon);
SqlCom.ExecuteNonQuery();
double liv;
if (ACHETEURS.Livraison == "livrer" && ACHETEURS.Adresse == "Antananarivo")
{
liv = 2000;
}
else if (ACHETEURS.Livraison == "livrer")
{
liv = 5000;
}
else
{
liv = 0;
}
MyStoreEntities4 db8 = new MyStoreEntities4();
PANIER PanLisL = new PANIER();
PanLisL = db8.PANIER.Where(x => x.IdPanier == IDPANIER).First();
double privLiv = Convert.ToDouble(PanLisL.PrixTotal) + liv;
string query1 = "UPDATE PANIER SET IdUser='******',PrixTotal='" + privLiv + "' ,Livraison='" + liv + "' where IdPanier='" + IDPANIER + "'";
SqlCommand SqlCom1 = new SqlCommand(query1, SqlCon);
SqlCom1.ExecuteNonQuery();
string query2 = "UPDATE GENRE SET IdUser1='" + val + "' where IdPanier='" + IDPANIER + "'";
SqlCommand SqlCom2 = new SqlCommand(query2, SqlCon);
SqlCom2.ExecuteNonQuery();
//return RedirectToAction("Acheteur", new { m = "vb" });
return(RedirectToAction("Index", "Paypal"));
}
}
else
{
using (SqlConnection SqlCon = new SqlConnection(connectionString))
{
SqlCon.Open();
MyStoreEntities4 xx = new MyStoreEntities4();
ACHETEUR cc = new ACHETEUR();
cc = xx.ACHETEUR.ToList().Last();
val = cc.IdUser + 1;
string query = "INSERT INTO ACHETEUR (IdUser, Nom,Prenom,DateNaiss,Adresse,NumTel,Email) VALUES ('" + val + "', '" + ACHETEURS.Nom + "','" + ACHETEURS.Prenom + "','" + ACHETEURS.DateNaiss + "','" + ACHETEURS.Adresse + "','" + ACHETEURS.NumTel + "','" + ACHETEURS.Email + "')";
SqlCommand SqlCom = new SqlCommand(query, SqlCon);
SqlCom.ExecuteNonQuery();
int liv;
if (ACHETEURS.Livraison == "livrer" && ACHETEURS.Adresse == "Antananarivo")
{
liv = 2000;
}
else if (ACHETEURS.Livraison == "livrer")
{
liv = 5000;
}
else
{
liv = 0;
}
MyStoreEntities4 db8 = new MyStoreEntities4();
PANIER PanLisL = new PANIER();
PanLisL = db8.PANIER.Where(x => x.IdPanier == IDPANIER).First();
double privLiv = Convert.ToDouble(PanLisL.PrixTotal) + liv;
string query1 = "UPDATE PANIER SET IdUser='******',PrixTotal='" + privLiv + "' ,Livraison='" + liv + "' where IdPanier='" + IDPANIER + "'";
SqlCommand SqlCom1 = new SqlCommand(query1, SqlCon);
SqlCom1.ExecuteNonQuery();
string query2 = "UPDATE GENRE SET IdUser1='" + val + "' where IdPanier='" + IDPANIER + "'";
SqlCommand SqlCom2 = new SqlCommand(query2, SqlCon);
SqlCom2.ExecuteNonQuery();
SqlCon.Close();
ViewBag.Message = ACHETEURS.Livraison;
// return RedirectToAction("Acheteur",new {m="vb" });
return(RedirectToAction("Index", "Paypal"));
}
}
}
catch
{
return(RedirectToAction("HttpNotFoun", "ACCUEIL"));
}
}
//public ActionResult Panier()
//{
// DataTable dt = new DataTable();
// using (SqlConnection SqlCon = new SqlConnection(connectionString))
// {
// SqlCon.Open();
// string query = "SELECT * FROM PANIER";
// SqlDataAdapter SqlDa = new SqlDataAdapter(query, SqlCon);
// SqlDa.Fill(dt);
// }
// return RedirectToAction("Terminer", new { III = IDPANIER });
//}
public ActionResult Panier(int IdGenre, int?NbrGenre)
{
try
{
int nbrLigne = 0;
DataTable dt = new DataTable();
using (SqlConnection SqlCon = new SqlConnection(connectionString))
{
SqlCon.Open();
string query = "SELECT * FROM PANIER";
SqlDataAdapter SqlDa = new SqlDataAdapter(query, SqlCon);
SqlDa.Fill(dt);
}
nbrLigne = Convert.ToInt32(dt.Rows.Count.ToString());
int val = 1;
if (dt.Rows.Count == 0)
{
// ViewBag.Gen = IdGenre;
using (SqlConnection SqlCon = new SqlConnection(connectionString))
{
SqlCon.Open();
MyStoreEntities4 b = new MyStoreEntities4();
GENRE g = new GENRE();
//g = b.GENRE.Where(x => x.IdGenre == IdGenre).First();
//int NbrGenre1 = (Convert.ToInt32(g.NbrGenre) - Convert.ToInt32(NbrGenre));
//string query = "UPDATE GENRE SET IdPanier='" + val + "',NbrGenre='" + NbrGenre1 + "',NbrAch='" + NbrGenre + "' where IdGenre='" + IdGenre + "' ";
g = b.GENRE.Where(x => x.IdGenre == IdGenre).First();
int NbrGenre1 = (Convert.ToInt32(g.NbrGenre) - Convert.ToInt32(NbrGenre));
string query = "UPDATE GENRE SET IdPanier='" + val + "' where IdGenre='" + IdGenre + "' ";
SqlCommand SqlCom = new SqlCommand(query, SqlCon);
IDPANIER = val;
ViewBag.MonParam1 = IDPANIER;
ANDRANA.IDPANIER = IDPANIER;
SqlCom.ExecuteNonQuery();
}
return(RedirectToAction("Terminer", new { III = IDPANIER, N = NbrGenre }));
}
else
{
MyStoreEntities4 b = new MyStoreEntities4();
PANIER p1 = new PANIER();
p1 = b.PANIER.ToList().Last();
val = p1.IdPanier + 1;
using (SqlConnection SqlCon = new SqlConnection(connectionString))
{
SqlCon.Open();
GENRE g = new GENRE();
g = b.GENRE.Where(x => x.IdGenre == IdGenre).First();
//int NbrGenre1=(Convert.ToInt32(g.NbrGenre) - Convert.ToInt32(NbrGenre));
// string query = "UPDATE GENRE SET IdPanier='"+val+"',NbrGenre='"+ NbrGenre1 + "',NbrAch='"+NbrGenre+"' where IdGenre='" + IdGenre + "' ";
int NbrGenre1 = (Convert.ToInt32(g.NbrGenre) - Convert.ToInt32(NbrGenre));
string query = "UPDATE GENRE SET IdPanier='" + val + "' where IdGenre='" + IdGenre + "' ";
SqlCommand SqlCom = new SqlCommand(query, SqlCon);
IDPANIER = val;
ViewBag.MonParam1 = IDPANIER;
ANDRANA.IDPANIER = IDPANIER;
SqlCom.ExecuteNonQuery();
}
ViewBag.K = IdGenre;
ViewBag.S = NbrGenre;
//return View();
return(RedirectToAction("Terminer", new { III = IDPANIER, N = NbrGenre }));
}
}
catch
{
return(RedirectToAction("HttpNotFoun", "ACCUEIL"));
}
}
