public ActionResult Article(int?page, int?id, string ms = "") { MyStoreEntities4 db = new MyStoreEntities4(); List <PANIER> PanierList = new List <PANIER>(); PanierList = db.PANIER.Where(x => x.IdUser != null).ToList(); PanierList.Where(x => x.IdUser == id).ToList(); int pageSize = 7; int pageNumber = (page ?? 1); ViewBag.Mon = ms; return(View(PanierList.ToPagedList(pageNumber, pageSize))); }
public ActionResult Index(int?page, string ms = "") { MyStoreEntities4 db = new MyStoreEntities4(); List <VENDEUR> VendeurList = new List <VENDEUR>(); VendeurList = db.VENDEUR.ToList(); int pageSize = 3; int pageNumber = (page ?? 1); ViewBag.Mon = ms; return(View(VendeurList.ToPagedList(pageNumber, pageSize))); }
public ActionResult Notification(int?III, int?page, string m = "") { try { ViewBag.l = m; MyStoreEntities4 Db = new MyStoreEntities4(); List <GENRE> g = new List <GENRE>(); g = Db.GENRE.Where(x => x.IdUser == III).ToList(); int pageSize = 7; int pageNumber = (page ?? 1); g.Reverse(); return(View(g.ToPagedList(pageNumber, pageSize))); } catch { return(RedirectToAction("HttpNotFoun", "ACCUEIL")); } }
public ActionResult Index(int?page, string ms = "") { try { MyStoreEntities4 db = new MyStoreEntities4(); List <VENDEUR> VendeurList = new List <VENDEUR>(); VendeurList = db.VENDEUR.ToList(); int pageSize = 3; int pageNumber = (page ?? 1); ViewBag.Mon = ms; return(View(VendeurList.ToPagedList(pageNumber, pageSize))); } catch { return(RedirectToAction("HttpNotFoun", "ACCUEIL")); } }
public ActionResult Index1(int?page, int?IdCat, int?IdUser, string Pour = "", string Continuer = "false", string r = "") { try { DataTable dt = new DataTable(); using (SqlConnection SqlCon = new SqlConnection(connectionString)) { SqlCon.Open(); SqlDataAdapter SqlData = new SqlDataAdapter("Select IdGenre, NomGenre, Image, Prix,IdProd,Nouveau,Prix1,Date from GENRE ORDER BY IdGenre DESC ", SqlCon); SqlData.Fill(dt); if (dt.Rows.Count != 1) { List <DateTime> Semaine = new List <DateTime>(); DateTime x = Convert.ToDateTime(DateTime.Now.ToShortDateString()); for (int i = 0; i < dt.Rows.Count; i++) { DateTime InTable7 = Convert.ToDateTime(dt.Rows[i][7].ToString()).AddDays(7); DateTime InTable = Convert.ToDateTime(dt.Rows[i][7].ToString()); if (x == Convert.ToDateTime(dt.Rows[i][7].ToString()).AddDays(7)) { string query = "UPDATE GENRE SET Nouveau='false' where Date='" + dt.Rows[i][7].ToString() + "'"; SqlCommand SqlCom = new SqlCommand(query, SqlCon); SqlCom.ExecuteNonQuery(); } } } MyStoreEntities4 db8 = new MyStoreEntities4(); List <PANIER> PanLisL = new List <PANIER>(); List <GENRE> Gq = new List <GENRE>(); PanLisL = db8.PANIER.ToList(); Gq = db8.GENRE.Where(x => x.IdPanier == ANDRANA.IDPANIER).ToList(); ANDRANA.IDPANIER = PanLisL.Count + 1; if (Continuer == "false") { //foreach(var it in Gq) { // int x = Convert.ToInt32(it.NbrGenre) + Convert.ToInt32(it.NbrAch); // int y =0; // string query6 = "UPDATE GENRE SET IdPanier='" + null + "',NbrGenre='"+x+"',NbrAch='"+y+"' where IdPanier='" +it.IdPanier + "'"; //SqlCommand SqlCom6 = new SqlCommand(query6, SqlCon); //SqlCom6.ExecuteNonQuery(); //} } //} } // //ENTITY FRAMEWORK MyStoreEntities4 db = new MyStoreEntities4(); List <GENRE> GenreList = new List <GENRE>(); if (Pour == "" && IdCat == null && IdUser == null && r == "") { GenreList = db.GENRE.ToList(); } else if (Pour != "" && IdCat == null && IdUser == null && r == "") { GenreList = db.GENRE.Where(x => x.Pour == Pour).ToList(); } else if (IdCat != null && Pour == "" && IdUser == null && r == "") { //MAKA CATEGORIE GenreList = db.GENRE.Where(x => x.IdCat == IdCat).ToList(); } else if (IdCat == null && Pour == "" && IdUser != null && r == "") { //MAKA CATEGORIE GenreList = db.GENRE.Where(x => x.IdUser == IdUser).ToList(); } else if (IdCat == null && Pour == "" && IdUser == null && r == "") { //MAKA CATEGORIE GenreList = db.GENRE.Where(x => x.IdUser == IdUser).ToList(); } else if (IdCat == null && Pour == "" && IdUser == null && r != "") { //MAKA CATEGORIE GenreList = db.GENRE.Where(x => x.NomGenre == r).ToList(); } int pageSize = 6; int pageNumber = (page ?? 1); GenreList.Reverse(); // int id = 1; //GENRE gENRE = db.GENRE.Find(id); //gENRE.NomGenre = ViewBag.NomGenre; return(View(GenreList.ToPagedList(pageNumber, pageSize))); } catch { return(RedirectToAction("HttpNotFoun", "ACCUEIL")); } }
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 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 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")); } }
private Payment CreatePayment(APIContext apiContext, string redirectUrl) { MyStoreEntities4 db22 = new MyStoreEntities4(); List <GENRE> PanLisL22 = new List <GENRE>(); PanLisL22 = db22.GENRE.Where(x => x.IdPanier == ANDRANA.IDPANIER).ToList(); GENRE pan = new GENRE(); pan = db22.GENRE.Where(x => x.IdPanier == ANDRANA.IDPANIER).First(); //similar to credit card create itemlist and add item objects to it var itemList = new ItemList() { items = new List <Item>() }; //itemList.items.Add(new Item() //{ // name = "Item Name", // currency = "USD", // price = "5", // quantity = "1", // sku = "sku" //} //); double somme = 0; foreach (var k in PanLisL22) { itemList.items.Add(new Item() { name = "" + k.NomGenre + "", currency = "USD", price = "" + Convertion.convertir(Convert.ToDouble(k.Prix)) + "", quantity = "1", sku = "sku" } ); somme = +Convertion.convertir(Convert.ToDouble(k.Prix)); } System.Nullable <double> total = (from prod in PanLisL22 select(double) prod.Prix) .Sum(); var payer = new Payer() { payment_method = "paypal" }; // Configure Redirect Urls here with RedirectUrls object var redirUrls = new RedirectUrls() { cancel_url = redirectUrl, return_url = redirectUrl }; // similar as we did for credit card, do here and create details object //foreach (var ifg in PanLisL22) //{ // e =+Convert.ToDouble(ifg.Prix); //} var details = new Details() { tax = "1", shipping = "1", subtotal = "" + Convertion.convertir(Convert.ToDouble(total)) + "" //subtotal = "10" //subtotal = "" + Convertion.convertir(Convert.ToDouble(pan.Prix)) * 2 + "" //subtotal="'"+Convert.ToDouble(e) + "'" }; // similar as we did for credit card, do here and create amount object var amount = new Amount() { currency = "USD", /* total = ""+Convertion.AvecTaxe(Convert.ToDouble(pan.Prix)) +"",*/ // Total must be equal to sum of shipping, tax and subtotal. total = "" + Convertion.Plus2(Convertion.convertir(Convert.ToDouble(total))) + "", details = details }; var transactionList = new List <Transaction>(); transactionList.Add(new Transaction() { description = "Transaction description.", invoice_number = "your invoice number", amount = amount, item_list = itemList }); this.payment = new Payment() { intent = "sale", payer = payer, transactions = transactionList, redirect_urls = redirUrls }; // Create a payment using a APIContext return(this.payment.Create(apiContext)); }
public ActionResult Create(VENDEUR1 VENDEURS) { // return View(model); //try //{ // if (VENDEURS.isValid()) // { int nbrLigne = 0; DataTable dt = new DataTable(); using (SqlConnection SqlCon = new SqlConnection(connectionString)) { SqlCon.Open(); string query = "SELECT * FROM VENDEUR"; 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 VENDEUR VALUES (@IdUser,@Nom,@Prenom,@DateNaiss,@Email,@Mdp,@Magasin,@Contact,@Type,@Autorisation,@Lieu)"; SqlCommand SqlCom = new SqlCommand(query, SqlCon); SqlCom.Parameters.AddWithValue("@IdUser", val); SqlCom.Parameters.AddWithValue("@Nom", VENDEURS.Nom); SqlCom.Parameters.AddWithValue("@Prenom", VENDEURS.Prenom); SqlCom.Parameters.AddWithValue("@DateNaiss", VENDEURS.DateNaiss); SqlCom.Parameters.AddWithValue("@Email", VENDEURS.Email); SqlCom.Parameters.AddWithValue("@Mdp", VENDEURS.Mdp); SqlCom.Parameters.AddWithValue("@Magasin", VENDEURS.Magasin); SqlCom.Parameters.AddWithValue("@Contact", VENDEURS.Contact); SqlCom.Parameters.AddWithValue("@Type", "Vendeur"); SqlCom.Parameters.AddWithValue("@Autorisation", "false"); SqlCom.Parameters.AddWithValue("@Lieu", VENDEURS.Lieu); SqlCom.ExecuteNonQuery(); return(RedirectToAction("Create", "LOGIN")); } } else { using (SqlConnection SqlCon = new SqlConnection(connectionString)) { SqlCon.Open(); MyStoreEntities4 GJ = new MyStoreEntities4(); VENDEUR vvn = new VENDEUR(); vvn = GJ.VENDEUR.ToList().Last(); val = vvn.IdUser + 1; string query; if (VENDEURS.Magasin != null) { query = "INSERT INTO VENDEUR (IdUser,Nom,Prenom,DateNaiss,Email,Mdp,Magasin,Contact,Type,Autorisation,Lieu) VALUES (@IdUser,@Nom,@Prenom,@DateNaiss,@Email,@Mdp,@Magasin,@Contact,@Type,@Autorisation,@Lieu)"; SqlCommand SqlCom = new SqlCommand(query, SqlCon); SqlCom.Parameters.AddWithValue("@IdUser", val); SqlCom.Parameters.AddWithValue("@Nom", VENDEURS.Nom); SqlCom.Parameters.AddWithValue("@Prenom", VENDEURS.Prenom); SqlCom.Parameters.AddWithValue("@DateNaiss", VENDEURS.DateNaiss); SqlCom.Parameters.AddWithValue("@Email", VENDEURS.Email); SqlCom.Parameters.AddWithValue("@Mdp", VENDEURS.Mdp); SqlCom.Parameters.AddWithValue("@Magasin", VENDEURS.Magasin); SqlCom.Parameters.AddWithValue("@Contact", VENDEURS.Contact); SqlCom.Parameters.AddWithValue("@Type", "Vendeur"); SqlCom.Parameters.AddWithValue("@Autorisation", "false"); SqlCom.Parameters.AddWithValue("@Lieu", VENDEURS.Lieu); SqlCom.ExecuteNonQuery(); } else { query = "INSERT INTO VENDEUR (IdUser,Nom,Prenom,DateNaiss,Email,Mdp,Contact,Type,Autorisation,Lieu) VALUES (@IdUser,@Nom,@Prenom,@DateNaiss,@Email,@Mdp,@Contact,@Type,@Autorisation,@Lieu)"; SqlCommand SqlCom = new SqlCommand(query, SqlCon); SqlCom.Parameters.AddWithValue("@IdUser", val); SqlCom.Parameters.AddWithValue("@Nom", VENDEURS.Nom); SqlCom.Parameters.AddWithValue("@Prenom", VENDEURS.Prenom); SqlCom.Parameters.AddWithValue("@DateNaiss", VENDEURS.DateNaiss); SqlCom.Parameters.AddWithValue("@Email", VENDEURS.Email); SqlCom.Parameters.AddWithValue("@Mdp", VENDEURS.Mdp); SqlCom.Parameters.AddWithValue("@Contact", VENDEURS.Contact); SqlCom.Parameters.AddWithValue("@Type", "Vendeur"); SqlCom.Parameters.AddWithValue("@Autorisation", "false"); SqlCom.Parameters.AddWithValue("@Lieu", VENDEURS.Lieu); SqlCom.ExecuteNonQuery(); } SqlCon.Close(); return(RedirectToAction("Create", "LOGIN", new { v = "vb" })); } } // return RedirectToAction("Index"); //} //else //{ // ViewBag.Erreur = "Le nouveau mot de passe et le mot de passe de confirmation ne correspondent pas."; // return View(); //} // TODO: Add insert logic here // } //catch //{ // return RedirectToAction("HttpNotFoun", "ACCUEIL"); //} }
public ActionResult Genre2(GENRE1 GENRES) { try { string fileName = Path.GetFileNameWithoutExtension(GENRES.ImageFile.FileName); string extension = Path.GetExtension(GENRES.ImageFile.FileName); fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension; GENRES.Image = "~/Image/" + fileName; fileName = Path.Combine(Server.MapPath("~/Image/"), fileName); GENRES.ImageFile.SaveAs(fileName); //ViewBag.M1= GENRES.Image; // ViewBag.M2 = GENRES.NomGenre; //ViewBag.M3 = ; //ViewBag.M4 = GENRES.Prix; //ViewBag.M5 = GENRES.Taille; //ViewBag.M6 = GENRES.Description; //ViewBag.M7 = GENRES.Couleur; int nbrLigne = 0; DataTable dt = new DataTable(); using (SqlConnection SqlCon = new SqlConnection(connectionString)) { SqlCon.Open(); string query = "SELECT * FROM GENRE"; SqlDataAdapter SqlDa = new SqlDataAdapter(query, SqlCon); SqlDa.Fill(dt); } nbrLigne = Convert.ToInt32(dt.Rows.Count.ToString()); int val = 1; //Base de donnée if (dt.Rows.Count == 0) { using (SqlConnection SqlCon = new SqlConnection(connectionString)) { SqlCon.Open(); string query = "INSERT INTO GENRE (IdGenre, NomGenre,Image, Taille,Prix,Ref,Description,Couleur,NbrGenre,Etat,IdProd,Nouveau,Reduction,Prix1,Pour,Date,IdUser,IdCat,NbrAch) VALUES ('" + val + "', '" + GENRES.NomGenre + "','" + GENRES.Image + "','" + GENRES.Taille + "','" + GENRES.Prix + "','" + val + "/100','" + GENRES.Description + "','" + GENRES.Couleur + "','" + GENRES.NbrGenre + "','false','" + IDPROD + "','true','" + GENRES.Reduction + "','" + GENRES.CalculPrix1() + "','" + GENRES.Pour + "','" + DateTime.Now.ToShortDateString() + "','" + IDUSER + "','" + IDCAT + "','" + 1 + "'); "; SqlCommand SqlCom = new SqlCommand(query, SqlCon); SqlCom.ExecuteNonQuery(); // return RedirectToAction("index"); ViewBag.Mon = "La publication de votre article est effectuée avec succèes!!"; // return RedirectToAction("Genre1", new { III = IDPROD }); return(View()); } } else { MyStoreEntities4 d = new MyStoreEntities4(); GENRE g = new GENRE(); g = d.GENRE.ToList().Last(); val = g.IdGenre + 1; using (SqlConnection SqlCon = new SqlConnection(connectionString)) { SqlCon.Open(); string query = "INSERT INTO GENRE (IdGenre, NomGenre,Image, Taille,Prix,Ref,Description,Couleur,NbrGenre,Etat,IdProd,Nouveau,Reduction,Prix1,Pour,Date,IdUser,IdCat,NbrAch) VALUES ('" + val + "', '" + GENRES.NomGenre + "','" + GENRES.Image + "','" + GENRES.Taille + "','" + GENRES.Prix + "','" + val + "/100','" + GENRES.Description + "','" + GENRES.Couleur + "','" + GENRES.NbrGenre + "','false','" + IDPROD + "','true','" + GENRES.Reduction + "','" + GENRES.CalculPrix1() + "','" + GENRES.Pour + "','" + DateTime.Now.ToShortDateString() + "','" + IDUSER + "','" + IDCAT + "','" + 1 + "'); "; SqlCommand SqlCom = new SqlCommand(query, SqlCon); SqlCom.ExecuteNonQuery(); ViewBag.Mon = "La publication de votre article est effectuée avec succèes!!"; return(View()); } } // return View(); } catch { return(RedirectToAction("HttpNotFoun", "ACCUEIL")); } }
public ActionResult Produit1(PRODUIT1 PRODUITS) { // ViewBag.MonParam5 = iz; try { int nbrLigne = 0; DataTable dt = new DataTable(); using (SqlConnection SqlCon = new SqlConnection(connectionString)) { SqlCon.Open(); string query = "SELECT * FROM PRODUIT"; 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 PRODUIT (IdProd,NomPro,NbrPro,IdCat) VALUES (@IdProd,@NomPro,@NbrPro,@IdCat)"; SqlCommand SqlCom = new SqlCommand(query, SqlCon); SqlCom.Parameters.AddWithValue("@IdProd", val); SqlCom.Parameters.AddWithValue("@NomPro", PRODUITS.NomPro); SqlCom.Parameters.AddWithValue("@NbrPro", 1); SqlCom.Parameters.AddWithValue("@IdCat", IDCAT); IDPROD = val; ANDRANA.IDPROD = IDPROD; SqlCom.ExecuteNonQuery(); // return RedirectToAction("index"); ViewBag.MonParam0 = "Produit est ajouter avec succès"; return(RedirectToAction("Genre2", new { III = IDPROD })); } } else { using (SqlConnection SqlCon = new SqlConnection(connectionString)) { SqlCon.Open(); MyStoreEntities4 d = new MyStoreEntities4(); PRODUIT p1 = new PRODUIT(); p1 = d.PRODUIT.ToList().Last(); val = p1.IdProd + 1; string query = "INSERT INTO PRODUIT (IdProd,NomPro,NbrPro,IdCat) VALUES (@IdProd,@NomPro,@NbrPro,@IdCat)"; SqlCommand SqlCom = new SqlCommand(query, SqlCon); SqlCom.Parameters.AddWithValue("@IdProd", val); SqlCom.Parameters.AddWithValue("@NomPro", PRODUITS.NomPro); SqlCom.Parameters.AddWithValue("@NbrPro", 1); SqlCom.Parameters.AddWithValue("@IdCat", IDCAT); SqlCom.ExecuteNonQuery(); IDPROD = val; ANDRANA.IDPROD = IDPROD; // return RedirectToAction("Index"); ViewBag.MonParam0 = "Produit est ajouter avec succès"; return(RedirectToAction("Genre2", new { III = IDPROD })); } } // return RedirectToAction("Index"); // TODO: Add insert logic here } catch { return(RedirectToAction("HttpNotFoun", "ACCUEIL")); } }
public ActionResult Categorie1(CATEGORIE1 CATEGORIES) { // ViewBag.MonParam5 = iz; try { if (CATEGORIES.NomCat == "autre") { // ViewBag.Vue = true; return(View("Produit")); } int nbrLigne = 0; DataTable dt = new DataTable(); using (SqlConnection SqlCon = new SqlConnection(connectionString)) { SqlCon.Open(); string query = "SELECT * FROM CATEGORIE"; 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 CATEGORIE (IdCat,NomCat,IdUser) VALUES (@IdCat,@NomCat,@IdUser)"; SqlCommand SqlCom = new SqlCommand(query, SqlCon); SqlCom.Parameters.AddWithValue("@IdCat", val); SqlCom.Parameters.AddWithValue("@NomCat", CATEGORIES.NomCat); SqlCom.Parameters.AddWithValue("@IdUser", IDUSER); IDCAT = val; ANDRANA.IDCAT = IDCAT; SqlCom.ExecuteNonQuery(); //string query1 = "INSERT INTO VENDEUR (IdUser,IdCat) VALUES (@IdUser,@IdCat)"; //SqlCommand SqlCom1 = new SqlCommand(query1, SqlCon); //SqlCom1.ExecuteNonQuery(); return(RedirectToAction("Produit1", new { III = IDCAT })); } } else { //VERIFICATION SI CATEGORIE EXISTE (CONDITION) DataTable dt1 = new DataTable(); using (SqlConnection SqlCon = new SqlConnection(connectionString)) { SqlCon.Open(); string query = "SELECT * FROM CATEGORIE WHERE NomCat='" + CATEGORIES.NomCat + "'"; SqlDataAdapter SqlDa = new SqlDataAdapter(query, SqlCon); SqlDa.Fill(dt1); } if (dt1.Rows.Count == 0) { using (SqlConnection SqlCon = new SqlConnection(connectionString)) { SqlCon.Open(); MyStoreEntities4 s = new MyStoreEntities4(); CATEGORIE c = new CATEGORIE(); c = s.CATEGORIE.ToList().Last(); val = c.IdCat + 1; string query = "INSERT INTO CATEGORIE (IdCat,NomCat,IdUser) VALUES (@IdCat,@NomCat,@IdUser)"; SqlCommand SqlCom = new SqlCommand(query, SqlCon); SqlCom.Parameters.AddWithValue("@IdCat", val); SqlCom.Parameters.AddWithValue("@NomCat", CATEGORIES.NomCat); SqlCom.Parameters.AddWithValue("@IdUser", IDUSER); SqlCom.ExecuteNonQuery(); IDCAT = val; ANDRANA.IDCAT = IDCAT; return(RedirectToAction("Produit1", new { III = IDCAT })); } } else { IDCAT = Convert.ToInt32(dt1.Rows[0][0].ToString()); return(RedirectToAction("Produit1", new { III = IDCAT })); } //FIN } } catch { return(RedirectToAction("HttpNotFoun", "ACCUEIL")); } }