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));
}
