public JsonResult SaveDataInDatabase(ArticleViewModel model)
{
var result = false;
try
{
if (model.idArticle > 0)
{
Article art = dc.Articles.SingleOrDefault(x => x.disponibilite == true && x.idArticle == model.idArticle);
art.description = model.description;
art.refArticle = model.refArticle;
art.libelleArticle = model.libelleArticle;
art.prix = model.prix;
art.nbpieces = model.nbpieces;
art.couleur = model.couleur;
art.taille = model.taille;
art.idCategorie = model.idCategorie;
art.idType = model.idType;
art.idMarque = model.idMarque;
dc.SaveChanges();
result = true;
}
else
{
Article art = new Article();
art.description = model.description;
art.refArticle = model.refArticle;
art.libelleArticle = model.libelleArticle;
art.prix = model.prix;
art.nbpieces = model.nbpieces;
art.couleur = model.couleur;
art.taille = model.taille;
art.idCategorie = model.idCategorie;
art.idType = model.idType;
art.idMarque = model.idMarque;
art.disponibilite = false;
dc.Articles.Add(art);
dc.SaveChanges();
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult LoginAdmin(Admin admin)
{
iBoutiqureDBEntities4 db = new iBoutiqureDBEntities4();
db.Admins.Add(admin);
db.SaveChanges();
ViewBag.message = "connexion avec succes";
return(View());
}
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 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 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 } };
}