public ActionResult CreateProjectEdit(PostProjectModel PostProjectModel, string Selectskills) { var post = _postservice.GetByID(PostProjectModel.PostId); post.Data.Description = PostProjectModel.Description; post.Data.EndTime = PostProjectModel.EndTime; post.Data.StartTime = PostProjectModel.StartTime; post.Data.Members = PostProjectModel.Members; post.Data.Price = PostProjectModel.Price; post.Data.ProjectName = PostProjectModel.ProjectName; _postservice.Save(post.Data); var skills = _projectSkillService.GetAll().Data.Where(d => d.PostId == PostProjectModel.PostId).Select(m => m.SkillName).ToList(); string[] tokens = Selectskills.Split(','); String[] array = skills.ToArray(); foreach (var t in tokens) { if (!array.Contains(t)) { var ongToSave = new ProjectSkills(); ongToSave.PostId = PostProjectModel.PostId; ongToSave.SkillName = t; _projectSkillService.Save(ongToSave); } } return(RedirectToAction("ProjectDetails", "Owner", new { id = PostProjectModel.PostId })); }
public XElement ToXmlElement() { return(new XElement("ProjectAbility", new XAttribute("ProjectType", (int)ProjType), new XAttribute("TechType", (int)Techtype), new XElement("Skills", ProjectSkills.Select(skill => skill.ToXmlElement())))); }
public Result <ProjectSkills> Save(ProjectSkills userinfo) { var result = new Result <ProjectSkills>(); try { var objtosave = _context.projectSkillses.FirstOrDefault(u => u.ProjectSkillId == userinfo.ProjectSkillId); if (objtosave == null) { objtosave = new ProjectSkills(); _context.projectSkillses.Add(objtosave); } objtosave.SkillName = userinfo.SkillName; objtosave.PostId = userinfo.PostId; if (!IsValid(objtosave, result)) { return(result); } _context.SaveChanges(); } catch (Exception ex) { result.HasError = true; result.Message = ex.Message; } return(result); }
public bool IsValid(ProjectSkills obj, Result <ProjectSkills> result) { if (!ValidationHelper.IsStringValid(obj.SkillName)) { result.HasError = true; result.Message = "Invalid SkillID"; return(false); } return(true); }
public ActionResult CreateProject(PostProjectModel PostProjectModel, string Selectskills) { try { string[] tokens = Selectskills.Split(','); PostProjectModel p = new PostProjectModel(); var result = _postservice.Save(p.Insert(PostProjectModel)); var last = _postservice.GetLastId(); foreach (var x in PostProjectModel.SectionName) { var projectsection = new ProjectSection(); projectsection.SectionName = x; projectsection.PostId = last.Data.PostId; var result1 = _sectionservice.Save(projectsection); } //foreach (var skillid in PostProjectModel.SkillName) //{ // var projectskill = new ProjectSkills(); // projectskill.SkillName = skillid; // projectskill.PostId = last.Data.PostId; // var result2 = _proskillservice.Save(projectskill); //} PostProjectModel.PostId = last.Data.PostId; foreach (var str in tokens) { var objToSave = new ProjectSkills(); objToSave.SkillName = str; objToSave.PostId = PostProjectModel.PostId; _projectSkillService.Save(objToSave); } if (result.HasError) { ViewBag.Message = result.Message; return(View("CreateProject")); } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(RedirectToAction("ProjectDetails", "Owner", new { id = PostProjectModel.PostId })); }
public ActionResult ProjectList(ProjectSkills skill) { ProjectListModel projectListModel = new ProjectListModel(); var result = projectSkillDao.GetAllskill(skill.SkillID); foreach (var projectSkillse in result) { var result2 = postProjectDao.GetByID(projectSkillse.PostID); projectListModel.PostAProjects.Add(result2.Data); } var result3 = skillsDao.GetAll(); projectListModel.Skills = result3; return(View(projectListModel)); }
public ActionResult CreateProject(PostProjectModel PostProjectModel) { if (!ModelState.IsValid) { return(View("CreateProject", PostProjectModel)); } try { var postAProject = new PostAProject(); postAProject.ProjectName = PostProjectModel.ProjectName; postAProject.Description = PostProjectModel.Description; postAProject.Price = PostProjectModel.Price; postAProject.StartTime = PostProjectModel.StartTime; postAProject.EndTime = PostProjectModel.EndTime; postAProject.Members = PostProjectModel.Members; var result = postProjectDao.Save(postAProject); foreach (var x in PostProjectModel.SectionName) { var projectsection = new ProjectSection(); projectsection.SectionName = x; var result1 = projectSectionDao.Save(projectsection); } foreach (var skillid in PostProjectModel.SkillId) { var projectskill = new ProjectSkills(); projectskill.SkillID = skillid; var result2 = projectSkillDao.Save(projectskill); } if (result.HasError) { ViewBag.Message = result.Message; return(View("CreateProject", PostProjectModel)); } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(RedirectToAction("CreateProject")); }
public async Task <ProjectDto> AddProject(ProjectDto projectDto) { using (var _context = new DatabaseContext()) { using (DbContextTransaction trx = _context.Database.BeginTransaction()) { try { Project project = new Project() { ClientId = projectDto.clientId, ProjectManagerId = projectDto.projectManagerId, Name = projectDto.projectName, StartDate = projectDto.startDate, Comments = projectDto.comments }; _context.Project.Add(project); int x = (_context.SaveChanges()); Console.WriteLine("x=" + x); ProjectSkills projectSkills = new ProjectSkills(); { projectSkills.ProjectId = project.Id; projectSkills.PrimarySkillIds = string.Join(",", projectDto.primarySkillIds.Select(z => z.Id)); projectSkills.SecondarySkillIds = string.Join(",", projectDto.secondarySkillIds.Select(z => z.Id)); }; // TODO ProjectResource resource = new ProjectResource() _context.ProjectSkills.Add(projectSkills); int y = (_context.SaveChanges()); trx.Commit(); return(projectDto); } catch (Exception) { trx.Rollback(); throw; } } } }
public async Task <ProjectDto> UpdateProject(ProjectDto projectDto) { try { using (var _context = new DatabaseContext()) { Project project = await _context.Project.Where(x => x.Id == projectDto.id).FirstOrDefaultAsync <Project>(); { project.ClientId = projectDto.clientId; project.ProjectManagerId = projectDto.projectManagerId; project.Name = projectDto.projectName; project.StartDate = projectDto.startDate; project.Comments = projectDto.comments; }; int x1 = await(_context.SaveChangesAsync()); Console.WriteLine("x=" + x1); ProjectSkills projectSkills = await _context.ProjectSkills.Where(x => x.ProjectId == projectDto.id).FirstOrDefaultAsync <ProjectSkills>(); if (projectSkills == null) { projectSkills = new ProjectSkills(); } { //projectSkills.ProjectId = project.Id; projectSkills.PrimarySkillIds = string.Join(",", projectDto.primarySkillIds.Select(z => z.Id)); projectSkills.SecondarySkillIds = string.Join(",", projectDto.secondarySkillIds.Select(z => z.Id)); }; // TODO ProjectResource resource = new ProjectResource() if (projectSkills == null) { _context.ProjectSkills.Add(projectSkills); } int y = await(_context.SaveChangesAsync()); } return(projectDto); } catch (Exception) { throw; } }
public async Task <IActionResult> RemoveManyProjectSkills(int[] skills, int projectID, string disciplineSearchString) { var currentUser = this.User.FindFirstValue(ClaimTypes.NameIdentifier); if (currentUser != null) { foreach (var skill in skills) { ProjectSkills projectSkills = (_context.ProjectSkills.Where(i => i.ProjectID == projectID && i.SkillID == skill).FirstOrDefault()); if (projectSkills != null) { _context.Remove(projectSkills); await _context.SaveChangesAsync(); } } } return(RedirectToAction("Edit", "Projects", new { disciplineSearchString = disciplineSearchString, id = projectID })); }
public ActionResult ProjectList(ProjectSkills skill) { ProjectListModel projectListModel = new ProjectListModel(); var result = _proskillservice.GetAll().Data.Where(d => d.SkillName.Contains(skill.SkillName)).ToList(); foreach (var projectSkillse in result) { var result2 = _postservice.GetByID(projectSkillse.PostId); var select = _selectedWorkerService.GetAll().Data.Where(d => d.PostId == result2.Data.PostId).ToList(); if (select.Count != result2.Data.Members) { projectListModel.PostAProjects.Add(result2.Data); } } var result3 = _skillservice.GetAll(); projectListModel.Skills = result3.Data; return(View(projectListModel)); }
public async Task <ProjectDto> Get(int projectID) { ProjectDto projectDto = null; Project project = null; try { using (var _context = new DatabaseContext()) { project = await _context.Project.Where(x => x.Id == projectID).FirstOrDefaultAsync <Project>(); projectDto = mapProjectToProjectDto(project); projectDto.primarySkillIds = new List <SkillSet>(); projectDto.secondarySkillIds = new List <SkillSet>(); ProjectSkills projectSkills = new ProjectSkills(); projectSkills = await _context.ProjectSkills.Where(x => x.ProjectId == projectID).FirstOrDefaultAsync <ProjectSkills>(); String[] primary = projectSkills.PrimarySkillIds.Split(','); String[] secondary = projectSkills.SecondarySkillIds.Split(','); foreach (String id in primary) { SkillSet skill = await skillSetService.Get(Int32.Parse(id)); projectDto.primarySkillIds.Add(skill); } foreach (String id in secondary) { SkillSet skill = await skillSetService.Get(Int32.Parse(id)); projectDto.secondarySkillIds.Add(skill); } } return(projectDto); } catch (Exception) { throw; } }
public async Task <List <Project> > GetProjectsBySkillId(Guid skillId) { ProjectSkills skill = await _adminRepository.GetProjectSkillById(skillId); return(await _context.Projects.Where(x => x.SkillsUsed.Contains(skill)).OrderByDescending(p => p.CreatedAt).ToListAsync()); }
public async Task <List <ProjectDto> > GetProjects() { List <ProjectDto> projects = null; try { using (var _context = new DatabaseContext()) { var prjs = await _context.Project.Include(x => x.Client).ToListAsync <Project>(); projects = (from p in prjs select new ProjectDto { id = p.Id, projectName = p.Name, clientId = p.ClientId, clientName = p.Client.Name, projectManagerId = p.ProjectManagerId, startDate = p.StartDate, comments = p.Comments }).ToList(); EmployeeDto emp = new EmployeeDto(); foreach (ProjectDto p in projects) { emp = await employeeService.GetById(p.projectManagerId); if (emp != null) { p.projectManager = emp.Name; } else { p.projectManager = "No Manager"; } } ProjectSkills projectSkills = new ProjectSkills(); foreach (ProjectDto pd in projects) { pd.primarySkillIds = new List <SkillSet>(); pd.secondarySkillIds = new List <SkillSet>(); projectSkills = await _context.ProjectSkills.Where(x => x.ProjectId == pd.id).FirstOrDefaultAsync <ProjectSkills>(); if (projectSkills != null) { String[] primary = projectSkills.PrimarySkillIds.Split(','); String[] secondary = projectSkills.SecondarySkillIds.Split(','); foreach (String id in primary) { SkillSet skill = await skillSetService.Get(Int32.Parse(id)); pd.primarySkillIds.Add(skill); } foreach (String id in secondary) { SkillSet skill = await skillSetService.Get(Int32.Parse(id)); pd.secondarySkillIds.Add(skill); } } } } return(projects); } catch (Exception) { throw; } }