public ActionResult Remove(int ProjectID)
{
Society_Projects society_Project = myDbContext.Society_Projects.FirstOrDefault(s => s.ProjectID == ProjectID);
if (society_Project != null)
{
myDbContext.Society_Projects.Remove(society_Project);
myDbContext.SaveChanges();
}
IEnumerable <Society_Projects> society_Projects = from sp in myDbContext.Society_Projects.ToList()
where
sp.SocietyID == society_Project.SocietyID
select sp;
IEnumerable <Project> Allprojects = myDbContext.Projects.ToList();
var projects =
from p in Allprojects
join sp in society_Projects on p.ProjectID equals sp.ProjectID
select p;
ViewBag.Projects = projects;
Society society = myDbContext.Societies.FirstOrDefault(s => s.SocietyID == society_Project.SocietyID);
return(View("Details", society));
}
public ActionResult SaveProject(int ProjectID)
{
int idSociete = int.Parse(TempData["SocietyID"].ToString());
if (!myDbContext.Society_Projects.Any(s => s.ProjectID == ProjectID && s.SocietyID == idSociete))
{
Society_Projects society_Projects = new Society_Projects();
society_Projects.ProjectID = ProjectID;
society_Projects.SocietyID = idSociete;
myDbContext.Society_Projects.Add(society_Projects);
myDbContext.SaveChanges();
}
ViewBag.Projects = myDbContext.Projects.ToList();
return(RedirectToAction("Societies"));
}
