public async Task <IActionResult> OnPostAsync(int?id, string technicianID) { if (id == null || technicianID == null) { return(NotFound()); } Projects = await _context.Project .Include(d => d.Client).ToListAsync(); Projects = Projects.Where(s => s.ID.Equals(id)).ToList();; Project = Projects[0]; TechnicianSelected = await _context.Technician.FindAsync(technicianID); if (Project != null && TechnicianSelected != null) { ProjectAssigned NewProject = new ProjectAssigned(); NewProject.Specialty = Project.Specialty; NewProject.Level = Project.Level; NewProject.Description = Project.Description; NewProject.NHours = Project.NHours; NewProject.Technician = TechnicianSelected; NewProject.Client = Project.Client; _context.ProjectAssigned.Add(NewProject); _context.Project.Remove(Project); await _context.SaveChangesAsync(); } return(RedirectToPage("./Index")); }
public void AssingTechnicianTest() { Technician tec = new Technician(); ProjectAssigned proj1 = new ProjectAssigned(); tec.Name = "Jose Martinez"; proj1.Technician = tec; Assert.Equal("Jose Martinez", proj1.Technician.Name); }
/// <summary> /// To delete project data from the grid view. /// </summary> /// <param name="ID"></param> public void deleteProjectdata(int ID) { ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities(); ProjectAssigned obj = (from a in ent.ProjectAssigneds where a.Id == ID select a).FirstOrDefault(); if (obj != null) { ent.ProjectAssigneds.DeleteObject(obj); ent.SaveChanges(); } }
/// <summary> /// Getting projct Id used for project manager to display own projects. /// </summary> /// <param name="ProMID"></param> /// <returns></returns> public int getProjectId(int ProMID) { ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities(); ProjectAssigned obj = (from a in ent.ProjectAssigneds where a.ProjectManagerId == ProMID select a).FirstOrDefault(); if (obj != null) { return(Convert.ToInt32(obj.ProjectId)); } else { return(0); } }
/// <summary> /// Inserts new project Assigned data. /// </summary> /// <param name="obj"></param> public void InsertData(ProjectAssigned obj) { ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities(); ProjectAssigned objp = (from a in ent.ProjectAssigneds where a.ProjectId == obj.ProjectId && a.ProjectManagerId == obj.ProjectManagerId select a).FirstOrDefault(); if (objp == null) { //objp.ProjectId = obj.ProjectId; //objp.ProjectManagerId = obj.ProjectManagerId; ent.ProjectAssigneds.AddObject(obj); ent.SaveChanges(); } }