public void UpdateEmployeeToProject(EmployeeToProjectEntity employeeToProjectEntity) { EmployeeToProject employeeToProject = new EmployeeToProject(); employeeToProject.Id = employeeToProjectEntity.Id; employeeToProject.EmpId = employeeToProjectEntity.EmpId; employeeToProject.ProjectId = employeeToProjectEntity.ProjectId; _repositoryEmployeeToProject.Update(employeeToProject); _repositoryEmployeeToProject.SaveChanges(); }
public void InsertEmployeeToProject(EmployeeToProjectEntity employeeToProjectEntity) { EmployeeToProject employeeToProject = new EmployeeToProject(); employeeToProject.Id = employeeToProjectEntity.Id; employeeToProject.EmpId = employeeToProjectEntity.EmpId; employeeToProject.ProjectId = employeeToProjectEntity.ProjectId; if (!_repositoryEmployeeToProject.Table.Any(x => x.ProjectId == employeeToProject.ProjectId && x.EmpId == employeeToProject.EmpId)) { _repositoryEmployeeToProject.Insert(employeeToProject); _repositoryEmployeeToProject.SaveChanges(); } }
public async Task <JsonResult> AddEmployee(EmployeeDetailsViewModel model) { try { if (ModelState.IsValid) { if (model.EmployeeId != null) { var employee = await _context.Employees.Where(p => p.Id == model.EmployeeId).FirstOrDefaultAsync(); if (employee != null) { employee.FirstName = model.FirstName; employee.LastName = model.LastName; employee.JoiningDate = DateTime.ParseExact(model.JoiningDate, "dd/MM/yyyy", CultureInfo.InvariantCulture); await _context.SaveChangesAsync(HttpContext.User.Identity.Name); return(Json(new { Success = true })); } else { return(Json(new { Error = true })); } } else { var project = await _context.Projects.Where(p => p.Id == model.ProjectId).FirstOrDefaultAsync(); if (project != null) { var employee = new Employee { FirstName = model.FirstName, LastName = model.LastName, JoiningDate = DateTime.ParseExact(model.JoiningDate, "dd/MM/yyyy", CultureInfo.InvariantCulture) }; _context.Employees.Add(employee); await _context.SaveChangesAsync(HttpContext.User.Identity.Name); var empProjectMapping = new EmployeeToProject { ProjectId = project.Id, EmployeeId = employee.Id }; _context.EmployeeToProjects.Add(empProjectMapping); await _context.SaveChangesAsync(HttpContext.User.Identity.Name); return(Json(new { Success = true })); } return(Json(new { Error = true })); } } return(Json(new { Error = true })); } catch (Exception ex) { return(Json(new { Error = true })); } }