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