public ActionResult UpdateBK_MAN_LEDGER(BK_MAN_LEDGER BK) { if (ModelState.IsValid) { db.Entry(BK).State = EntityState.Modified; db.SaveChanges(); return(Json("true")); } return(Json("false")); }
public JsonResult DeletePJ(int MovementID) { BK_MAN_LEDGER bk = (from mvt in db.BK_MAN_LEDGER where mvt.MOVEMENT_ID == MovementID select mvt).First(); bk.PJ = null; db.SaveChanges(); return(Json(bk.PJ, JsonRequestBehavior.AllowGet)); }
public JsonResult Verifier(int MovementID, bool b) { BK_MAN_LEDGER bk = (from mvt in db.BK_MAN_LEDGER where mvt.MOVEMENT_ID == MovementID select mvt).First(); bk.MAN_Reception = b; db.SaveChanges(); return(Json(bk.MAN_Reception, JsonRequestBehavior.AllowGet)); }
public JsonResult RattacherPJ(string fileName, int MovementID, string Matricule) { BK_MAN_LEDGER bk = (from mvt in db.BK_MAN_LEDGER where mvt.MOVEMENT_ID == MovementID select mvt).First(); bk.PJ = fileName; //bk.MAN_Reception = true; bk.MAN_USER_Recp = Matricule; db.SaveChanges(); return(Json(fileName, JsonRequestBehavior.AllowGet)); }
public ActionResult Reviser(int id, string Matricule, int MovementID, string commentaire) { BK_MAN_LEDGER bk = (from mvt in db.BK_MAN_LEDGER where mvt.MOVEMENT_ID == MovementID select mvt).First(); // BK_MAN_LEDGER mvt; int?id_pj = bk.ID_PJ; if (ModelState.IsValid) { //db.Entry(mvt).State = EntityState.Modified; var dbResult = db.SP_WFC(id, Matricule, id_pj, commentaire); // return Json(dbResult, JsonRequestBehavior.AllowGet); db.SaveChanges(); return(Json("true")); } return(Json("false")); }
public JsonResult Enregistrer(int MovementID, bool app, int id_rev, string Matricule) { BK_MAN_LEDGER bk = (from mvt in db.BK_MAN_LEDGER where mvt.MOVEMENT_ID == MovementID select mvt).First(); /*bk.MAN_Approbation = app; * if (app == true) * { * * bk.Validé = true; * bk.Date_Approbation = DateTime.Now;//.ToString("yyyy-MM-ddThh:mm:sszzz"); * bk.MAN_Approbation = true; * bk.MAN_Date_Approbation = DateTime.Now; * bk.MAN_USER_App = Matricule; * * } * else * { * * bk.Validé = false; * bk.Date_Approbation = null;//.ToString("yyyy-MM-ddThh:mm:sszzz"); * bk.MAN_Approbation = false; * bk.MAN_Date_Approbation = null; * } * * if (id_rev > 0) * { * bk.Id_Revision = id_rev; * bk.MAN_Date_Approbation = null; * bk.Validé = false; * bk.Date_Approbation = null; * bk.MAN_Approbation = false; * bk.MAN_USER_App = Matricule; * } * * db.SaveChanges();*/ return(Json(bk.MAN_Reception, JsonRequestBehavior.AllowGet)); }
public JsonResult Enregistrer(int MovementID, bool app, int id_rev, string Matricule, int id_group) { BK_MAN_LEDGER bk = (from mvt in db.BK_MAN_LEDGER where mvt.MOVEMENT_ID == MovementID select mvt).First(); bk.MAN_Approbation = app; bk.Id_Groupe_Utilisateur = id_group; if (app == true) { bk.Validé = true; bk.Date_Approbation = DateTime.Now;//.ToString("yyyy-MM-ddThh:mm:sszzz"); bk.MAN_Approbation = true; bk.MAN_Date_Approbation = DateTime.Now; bk.MAN_USER_App = Matricule; } else { bk.Validé = false; bk.Date_Approbation = null;//.ToString("yyyy-MM-ddThh:mm:sszzz"); bk.MAN_Approbation = false; bk.MAN_Date_Approbation = null; } if (id_rev > 0) { bk.Id_Revision = id_rev; bk.MAN_Date_Approbation = null; bk.Validé = false; bk.Date_Approbation = null; bk.MAN_Approbation = false; bk.MAN_USER_App = Matricule; } db.SaveChanges(); return(Json(bk.MAN_Reception, JsonRequestBehavior.AllowGet)); }