public void UpdatePendingProject(SidejobEntities context) { var t = (from c in context.Projects where c.StatusInt == 2 select c).ToList(); foreach (var t1 in t) { var exist = (from c in context.PendingProjects where c.ProjectID == t1.ProjectID select c).ToList(); if (exist.Count == 0) { var existprojectrequirement = (from c in context.ProjectRequirements where c.ProjectID == t1.ProjectID select c).FirstOrDefault(); if (existprojectrequirement != null) { var newpendingproject = new PendingProject { ProjectID = existprojectrequirement.ProjectID, LCID = existprojectrequirement.LCID, JobTitle = existprojectrequirement.JobTitle, StartDate = existprojectrequirement.StartDate, EndDate = existprojectrequirement.EndDate, Description = existprojectrequirement.Description, SpecialNotes = existprojectrequirement.SpecialNotes, Address = existprojectrequirement.Address, DatePosted = existprojectrequirement.DatePosted }; context.AddToPendingProjects(newpendingproject); context.SaveChanges(); } } } }