//debut partie utilisateur
public JsonResult GetUsers()
{
using (iBoutiqureDBEntities4 dc = new iBoutiqureDBEntities4())
{
var users = dc.Users.OrderBy(a => a.nom).ToList();
return(Json(new { data = users }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Save(int id)
{
using (iBoutiqureDBEntities4 dc = new iBoutiqureDBEntities4())
{
var u = dc.Users.Where(a => a.idUser == id).FirstOrDefault();
return(View(u));
}
}
public ActionResult LoginAdmin(Admin admin)
{
iBoutiqureDBEntities4 db = new iBoutiqureDBEntities4();
db.Admins.Add(admin);
db.SaveChanges();
ViewBag.message = "connexion avec succes";
return(View());
}
public ActionResult Delete(int id)
{
using (iBoutiqureDBEntities4 dc = new iBoutiqureDBEntities4())
{
var v = dc.Users.Where(a => a.idUser == id).FirstOrDefault();
if (v != null)
{
return(View(v));
}
else
{
return(HttpNotFound());
}
}
}
public static List <SelectListItem> GetDropDown()
{
iBoutiqureDBEntities4 dc = new iBoutiqureDBEntities4();
List <SelectListItem> ls = new List <SelectListItem>();
lm = dc.Marques;
foreach (var temp in lm)
{
ls.Add(new SelectListItem()
{
Text = temp.libelleMarque, Value = temp.idMarque.ToString()
});
}
return(ls);
}
public ActionResult DeleteUser(int id)
{
bool status = false;
using (iBoutiqureDBEntities4 dc = new iBoutiqureDBEntities4())
{
var v = dc.Users.Where(a => a.idUser == id).FirstOrDefault();
if (v != null)
{
dc.Users.Remove(v);
dc.SaveChanges();
status = true;
}
}
return(RedirectToAction("ListeUsers", "home/ListeUsers"));
// return new JsonResult { Data = new { status = status } };
}
public ActionResult RegisterAdmin(Admin admin)
{
iBoutiqureDBEntities4 db = new iBoutiqureDBEntities4();
//var userloggedIn = db.Users.SingleOrDefault(x => x.login == admin.login && x.mdp == admin.mdp);
//if(userloggedIn !=null)
//{
// ViewBag.massage = "Vous etes connecté";
// ViewBag.triedOnce = "yes";
return(RedirectToAction("index", "home/index"));
//else
//{
// ViewBag.triedOnce = "yes";
// return View();
//}
}
public ActionResult Deletem(int id)
{
using (iBoutiqureDBEntities4 db = new iBoutiqureDBEntities4())
{
{
Commande cmd = db.Commandes.Where(x => x.idCommande == id).FirstOrDefault <Commande>();
db.Commandes.Remove(cmd);
db.SaveChanges();
return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet));
}
//Commande cmd = db.Commandes.Where(x => x.idCommande == id).FirstOrDefault<Commande>();
//iBoutiqureDBEntities2 db = new iBoutiqureDBEntities2();
// var cmd=db.supprimer(id);
//return Ok(cmd);
}
}
//public ActionResult Panier()
//{
// iBoutiqureDBEntities4 db = new iBoutiqureDBEntities4();
// return View(db.fun_affichep());
//}
//public ActionResult Panier()
//{
// return View();
//}
public ActionResult Panier()
{
iBoutiqureDBEntities4 db = new iBoutiqureDBEntities4();
List <LigneCommande> list = db.LigneCommandes.ToList();
LigneCommandeViewModel lcvm = new LigneCommandeViewModel();
List <LigneCommandeViewModel> licmd = list.Select(x => new LigneCommandeViewModel {
idlignecommande = x.idlignecommande,
// idcommande=x.idcommande,
qtecmde = x.qtecmde,
idarticle = x.idarticle,
libelleArticle = x.Article.libelleArticle,
cheminImage = x.Article.cheminImage,
prix = x.Article.prix,
idUser = (int)x.Commande.idUser,
//descriptionCmd=x.Commande.descriptionCmd
}).ToList();
return(View(licmd.Where(x => x.idUser == 2)));
}
public JsonResult GetArticles()
{
iBoutiqureDBEntities4 dc = new iBoutiqureDBEntities4();
List <ArticleViewModel> articles = dc.Articles.Select(x => new ArticleViewModel
{
idArticle = x.idArticle,
refArticle = x.refArticle,
libelleArticle = x.libelleArticle,
prix = x.prix,
description = x.description,
disponibilite = x.disponibilite,
nbpieces = x.nbpieces,
libelleMarque = x.Marque.libelleMarque,
libelleType = x.Type.libelleType,
libelleCatgorie = x.Categorie.libelleCatgorie,
couleur = x.couleur,
taille = x.taille
}
).ToList();
return(Json(new { data = articles }, JsonRequestBehavior.AllowGet));
}
public ActionResult Save(User us)
{
bool status = false;
if (ModelState.IsValid)
{
using (iBoutiqureDBEntities4 dc = new iBoutiqureDBEntities4())
{
if (us.idUser > 0)
{
//edit
var v = dc.Users.Where(a => a.idUser == us.idUser).FirstOrDefault();
if (v != null)
{
v.nom = us.nom;
v.prenom = us.prenom;
v.email = us.email;
v.tel = us.tel;
v.ville = us.ville;
v.adresse = us.adresse;
v.codePostal = us.codePostal;
v.datenaissance = us.datenaissance;
}
}
else
{
//save
dc.Users.Add(us);
}
dc.SaveChanges();
status = true;
}
}
return(RedirectToAction("ListeUsers", "home/ListeUsers"));
//new JsonResult { Data = new { status = status } };
}
public ActionResult Commande()
{
iBoutiqureDBEntities4 db = new iBoutiqureDBEntities4();
return(View(db.fun_display1()));
}
