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