public JsonResult UpdateOrigin(ArticleOrigin oa) { ArticleOrigin gold = db.ArticleOrigins.Where(ao => ao.articleID == oa.articleID && ao.oeNumber == oa.oeNumber).FirstOrDefault(); db.Entry(gold).CurrentValues.SetValues(oa); db.SaveChanges(); return(Json(gold)); }
public ActionResult RemoveOrigin(int articleId, string originId) { ArticleOrigin aos = db.ArticleOrigins.Where(ao => ao.articleID == articleId && ao.oeNumber == originId).FirstOrDefault(); if (aos != null) { db.ArticleOrigins.Remove(aos); db.SaveChanges(); } return(RedirectToAction("ResRecherche", "Article", new { id = articleId })); }
public ActionResult AssignOrigin(int articleId, string originId) { ArticleOrigin ao = new ArticleOrigin() { articleID = articleId, oeNumber = originId, SortNo = 1 }; _db.ArticleOrigins.Add(ao); _db.SaveChanges(); return(RedirectToAction("ResRecherche", new { id = articleId })); }
public JsonResult assignOrigin(string oeNumber, int articleId) { ArticleOrigin ao = db.ArticleOrigins .Where(g => g.articleID == articleId && g.oeNumber == oeNumber).FirstOrDefault(); if (db.Article.Where(a => a.articleId == articleId).FirstOrDefault() == null) { return(Json("article dont exist")); } else if (db.OriginesOEN.Where(o => o.oeNumber == oeNumber).FirstOrDefault() == null) { return(Json("origin dont exist")); } else if (ao != null) { if (ao.SortNo == 1) { return(Json("exist")); } else { ArticleOrigin gn = ao; gn.SortNo = 1; db.Entry(ao).CurrentValues.SetValues(gn); db.SaveChanges(); return(Json("success")); } } else { ArticleOrigin ga = new ArticleOrigin() { articleID = articleId, oeNumber = oeNumber, SortNo = 1 }; db.ArticleOrigins.Add(ga); db.SaveChanges(); return(Json("success")); } }