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