public ActionResult AllUsersReqAssign(int id1, int id2) { DataBaseFuncController db = new DataBaseFuncController(); ACTOR_PROJECT act_proj = new ACTOR_PROJECT() { ACTOR_ID = id1, PROJECT_ID = id2 }; db.AddProjectActor(act_proj); return(Json(new { result = 12 }, JsonRequestBehavior.AllowGet)); }
public String AddProjectActor(ACTOR_PROJECT act_proj) { using (IA_ProjectEntities _entities = new IA_ProjectEntities()) { try { _entities.ACTOR_PROJECT.Add(act_proj); _entities.SaveChanges(); return("Done, Updated"); } catch (Exception ex) { return(ex.ToString()); } } }
public ActionResult AcceptReq(int id) { DataBaseFuncController db = new DataBaseFuncController(); ACTOR_PROJECT x = new ACTOR_PROJECT() { AssignStatus = true }; if (db.UpdateActorProject(id, x) == 1) { return(Json(12, JsonRequestBehavior.AllowGet)); } else { return(Json(13, JsonRequestBehavior.AllowGet)); } }
public int UpdateActorProject(int id, ACTOR_PROJECT act) { using (IA_ProjectEntities _entities = new IA_ProjectEntities()) { try { var obj = _entities.ACTOR_PROJECT.FirstOrDefault(c => c.ACTOR_ID == id); if (obj == null) { return(0); } obj.AssignStatus = act.AssignStatus; _entities.SaveChanges(); return(1); } catch (Exception ex) { return(0); } } }