public ActionResult Edit([Bind(Include = "NumArticle,Designation,PrixU,Stock,Photo,RefCat")] Article article)
{
db.Entry(article).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult ConfirmPay(int id)
{
if (Session["email"] == null)
{
return(RedirectToAction("WelcomeHome", "user"));
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Product product = db.Products.Find(id); //DB product
tempProduct p = products.SingleOrDefault(pp => pp.ID == id); // temp DB
if (product == null)
{
return(HttpNotFound());
}
product.Quantity = product.Quantity - p.Pcounter;
db.SaveChanges();
tempProduct PDelete = products.SingleOrDefault(pp => pp.ID == id);
products.Remove(PDelete);
return(RedirectToAction("shop"));
}
public ActionResult Create([Bind(Include = "RefCat,NomCat")] Categorie categorie)
{
if (ModelState.IsValid)
{
db.Categories.Add(categorie);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(categorie));
}
public ActionResult Create(Categorie categorie)
{
if (ModelState.IsValid)
{
db.Categories.Add(categorie);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(categorie));
}
public ActionResult Create([Bind(Include = "NumClient,Login,MotDePasse,Nom,Prenom,Email,Ville,Tel")] Client client)
{
if (ModelState.IsValid)
{
db.Clients.Add(client);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(client));
}
public ActionResult Create([Bind(Include = "NumArticle,Designation,PrixU,Stock,Photo,RefCat")] Article article)
{
if (ModelState.IsValid)
{
db.Articles.Add(article);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.RefCat = new SelectList(db.Categories, "RefCat", "NomCat", article.RefCat);
return(View(article));
}
public ActionResult Create([Bind(Include = "NumCmd,DateCmd,NumClient,NumArticle,QteArticle")] Commande commande)
{
if (ModelState.IsValid)
{
db.Commandes.Add(commande);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.NumArticle = new SelectList(db.Articles, "NumArticle", "Designation", commande.NumArticle);
ViewBag.NumClient = new SelectList(db.Clients, "NumClient", "Login", commande.NumClient);
return(View(commande));
}
public IActionResult AddOrder(Order NewOrder, int quantity, int ProductId)
{
Product Orderupdate = _context.Products.SingleOrDefault(Product => Product.ProductId == ProductId);
if (quantity > Orderupdate.quantity)
{
TempData["invalidorder"] = "Cannot Order more than";
return(RedirectToAction("Orders"));
}
Orderupdate.quantity -= quantity;
_context.Add(NewOrder);
_context.SaveChanges();
return(RedirectToAction("Orders"));
}
public ActionResult Register([Bind(Include = "ID,Name,Email,Password,CPassword")] User users)
{
if (ModelState.IsValid)
{
var u = db.Users.SingleOrDefault(user => user.Email == users.Email);
if (u == null)
{
db.Users.Add(users);
db.SaveChanges();
Session["Email"] = users.Email;
return(RedirectToAction("Shop", "Products"));
}
else
{
return(View(users));
}
}
return(View(users));
}
public ActionResult Create([Bind(Include = "NumCmd,DateCmd,NumClient,NumArticle,QteArticle")] Commande commande)
{
if (ModelState.IsValid)
{
// Numero du client est recuperré a partir de la session
commande.NumClient = Session["ConnecedClientId"] != null?Int32.Parse(Session["ConnecedClientId"].ToString()) : 0;
commande.DateCmd = DateTime.Now.ToString();
db.Commandes.Add(commande);
// Mettre a jour le stock
Article article = db.Articles.Where(a => a.NumArticle == commande.NumArticle).SingleOrDefault();
if (article.Stock >= commande.QteArticle)
{
article.Stock -= commande.QteArticle;
db.SaveChanges();
}
return(RedirectToAction("Create"));
}
return(View(commande));
}
public IActionResult NewProduct(Product model)
{
if (ModelState.IsValid)
{
Product product = new Product {
Name = model.Name,
Description = model.Description,
ImageUrl = "/images/" + model.ImageUrl + ".jpg",
QuantityAvailable = model.QuantityAvailable,
created_at = DateTime.Now,
updated_at = DateTime.Now
};
_context.Add(product);
_context.SaveChanges();
return(RedirectToAction("Products"));
}
return(View("Products"));
}
public IActionResult Register(Customer model)
{
if (ModelState.IsValid)
{
Customer customer = new Customer {
FirstName = model.FirstName,
LastName = model.LastName,
Email = model.Email,
created_at = DateTime.Now,
updated_at = DateTime.Now
};
_context.Add(customer);
_context.SaveChanges();
return(RedirectToAction("Index"));
}
return(View("Index"));
}
public IActionResult NewOrder(Order model)
{
if (ModelState.IsValid)
{
Order order = new Order {
CustomerId = model.CustomerId,
ProductId = model.ProductId,
Quantity = model.Quantity,
created_at = DateTime.Now,
updated_at = DateTime.Now
};
_context.Add(order);
Product RetrievedProduct = _context.Products.SingleOrDefault(p => p.ProductId == model.ProductId);
RetrievedProduct.QuantityAvailable -= model.Quantity;
_context.SaveChanges();
return(RedirectToAction("Orders"));
}
return(View("Orders"));
}
public void Add(TEntity entity)
{
using var context = new E_CommerceContext();
context.Set <TEntity>().Add(entity);
context.SaveChanges();
}
public void Delete(TEntity entity)
{
using var context = new E_CommerceContext();
context.Set <TEntity>().Remove(entity);
context.SaveChanges();
}