/// <summary> /// /// </summary> /// <param name="applicant"></param> /// <returns></returns> public Applicant UpdateApplicant(Applicant applicant) { Applicant _applicant; using (var dbCtx = new MagenicManpowerDBContext()) { _applicant = dbCtx.Applicant.FirstOrDefault(a => a.Id.Equals(applicant.Id)); } if (_applicant == null) { throw new KeyNotFoundException("Applicant Id not found."); } _applicant.Firstname = applicant.Firstname; _applicant.Lastname = applicant.Lastname; _applicant.Email = applicant.Email; _applicant.ContactNumber = applicant.ContactNumber; _applicant.CurrentPosition = applicant.CurrentPosition; _applicant.CurrentCompany = applicant.CurrentCompany; _applicant.YearsITExperience = applicant.YearsITExperience; _applicant.YearsForSpecificSkills = applicant.YearsForSpecificSkills; _applicant.Status = applicant.Status; _applicant.DateUpdated = DateTime.Now; _applicant.PrimarySkillId = applicant.PrimarySkillId; _applicant.LevelId = applicant.LevelId; _applicant.NoticePeriod = applicant.NoticePeriod; _applicant.PendingApplication = applicant.PendingApplication; _dbContext.Entry(_applicant).State = _applicant.Id == 0 ? EntityState.Added : EntityState.Modified; _dbContext.SaveChanges(); return(_applicant); }
public ApplicantLevelDTO ToggleActive(int id) { using (var _mydbcontext = new MagenicManpowerDBContext()) { try { var level = _mydbcontext.ApplicantLevel.FirstOrDefault(a => a.Id == id); level.IsActive = !level.IsActive; level.DateUpdated = DateTime.Now; _mydbcontext.Update(level); _mydbcontext.SaveChanges(); return(new ApplicantLevelDTO() { Id = level.Id, Name = level.Name, DateUpdated = level.DateUpdated, IsActive = level.IsActive }); } catch (Exception e) { throw e; } } }
/// <summary> /// gets the user entity by email /// </summary> /// <param name="email"></param> /// <returns></returns> public User GetByEmail(string email) { using (var _newdbContext = new MagenicManpowerDBContext()) { return(_newdbContext.User.Include(a => a.Role).ThenInclude(ar => ar.RolePermission).ThenInclude(a => a.Permission).FirstOrDefault(u => u.Email.ToLower() == email.ToLower())); } }
/// <summary> /// Updates the role permission. /// </summary> /// <param name="roleId">The role identifier.</param> /// <param name="currentPermissions">The role permissions.</param> /// <returns></returns> public IQueryable <Permission> UpdateRolePermission(int roleId, ICollection <RolePermission> currentPermissions) { List <RolePermission> oldPermissions; using (var dbCtx = new MagenicManpowerDBContext()) { oldPermissions = dbCtx.RolePermission.Where(r => r.RoleId.Equals(roleId)).ToList(); } // Delete replaced oldPermissions.ForEach(a => { if (!currentPermissions.Any(b => b.PermissionId.Equals(a.PermissionId))) { _dbContext.Entry(a).State = EntityState.Deleted; } }); // Add new and retain currentPermissions .ToList() .ForEach(a => { _dbContext.Entry(a).State = !oldPermissions.Any(b => b.PermissionId.Equals(a.PermissionId)) ? EntityState.Added : EntityState.Unchanged; }); _dbContext.SaveChanges(); return(_dbContext.Permission .Where(a => currentPermissions .Any(b => b.PermissionId.Equals(a.Id)))); }
public IList <ApplicantLevel> GetApplicantLevelList() { using (var _mydbcontext = new MagenicManpowerDBContext()) { try { return(_mydbcontext.ApplicantLevel.ToList()); } catch (Exception e) { throw e; } } }
public ApplicantLevel GetApplicantLevelByName(string name) { using (var _mydbcontext = new MagenicManpowerDBContext()) { try { return(_mydbcontext.ApplicantLevel.FirstOrDefault(a => a.Name.ToLower() == name.ToLower())); } catch (Exception e) { throw e; } } }
public ApplicantLevel GetApplicantLevelById(int id) { using (var _mydbcontext = new MagenicManpowerDBContext()) { try { return(_mydbcontext.ApplicantLevel.FirstOrDefault(a => a.Id == id)); } catch (Exception e) { throw e; } } }
public ApplicantLevel UpdateApplicantLevel(ApplicantLevel level) { using (var _mydbcontext = new MagenicManpowerDBContext()) { level.DateUpdated = DateTime.Now; try { _mydbcontext.ApplicantLevel.Update(level); _mydbcontext.SaveChanges(); return(level); } catch (Exception e) { throw e; } } }
public ApplicantLevel CreateApplicantLevel(ApplicantLevel level) { using (var _mydbcontext = new MagenicManpowerDBContext()) { level.DateCreated = DateTime.Now; level.DateUpdated = DateTime.Now; level.IsActive = true; try { _mydbcontext.ApplicantLevel.Add(level); _mydbcontext.SaveChanges(); } catch (Exception e) { throw e; } return(level); } }
/// <summary> /// /// </summary> /// <param name="applicantId"></param> /// <param name="hireDate"></param> /// <returns></returns> public bool HireApplicant(int applicantId, DateTime hireDate) { Applicant _applicant; using (var dbCtx = new MagenicManpowerDBContext()) { _applicant = dbCtx.Applicant.FirstOrDefault(a => a.Id.Equals(applicantId)); } if (_applicant == null) { throw new Exception("Applicant Id not found."); } _applicant.Status = (int)ApplicantStatusType.Hired; _applicant.HireDate = hireDate; _dbContext.Update(_applicant); _dbContext.SaveChanges(); return(true); }
/// <summary> /// /// </summary> /// <param name="role"></param> /// <returns></returns> public Role UpdateRole(Role role) { Role _role; using (var dbCtx = new MagenicManpowerDBContext()) { _role = dbCtx.Role.FirstOrDefault(r => r.Id.Equals(role.Id)); } if (_role == null) { throw new KeyNotFoundException("Role Id not found."); } _role.DateUpdated = DateTime.Now; _role.Name = role.Name; _role.IsActive = role.IsActive; _dbContext.Entry(_role).State = _role.Id == 0 ? EntityState.Added : EntityState.Modified; _dbContext.SaveChanges(); return(_role); }
/// <summary> /// Updates the project. /// </summary> /// <param name="project">The project.</param> /// <returns></returns> /// <exception cref="System.Collections.Generic.KeyNotFoundException">Project not found.</exception> public Project UpdateProject(Project project) { Project _project; using (var dbCtx = new MagenicManpowerDBContext()) { _project = dbCtx.Project.FirstOrDefault(r => r.Id.Equals(project.Id)); } if (_project == null) { throw new KeyNotFoundException("Project not found."); } _project.DateUpdated = DateTime.Now; _project.Name = project.Name; _project.Description = project.Description; _project.IsActive = project.IsActive; _dbContext.Entry(_project).State = _project.Id == 0 ? EntityState.Added : EntityState.Modified; _dbContext.SaveChanges(); return(_project); }
public RequestTechnologyRepository(MagenicManpowerDBContext dbContext) : base(dbContext) { }
/// <summary> /// /// </summary> /// <param name="dbContext"></param> public CmDashboardRepository(MagenicManpowerDBContext dbContext) : base(dbContext) { }
public BaseRepository(MagenicManpowerDBContext dbContext) { _dbContext = dbContext; }
public StatusRepository(MagenicManpowerDBContext dbContext) : base(dbContext) { }
/// <summary> /// Initializes a new instance of the <see cref="ReferenceNumberRepository"/> class. /// </summary> /// <param name="dbContext">The database context.</param> public ReferenceNumberRepository(MagenicManpowerDBContext dbContext) : base(dbContext) { }
public ApplicantLevelRepository(MagenicManpowerDBContext dbContext) : base(dbContext) { }
/// <summary> /// /// </summary> /// <param name="dbContext"></param> public UserContextRepository(MagenicManpowerDBContext dbContext) : base(dbContext) { }
public TechnologyDetailRepository(MagenicManpowerDBContext dbContext) : base(dbContext) { }
/// <summary> /// /// </summary> /// <param name="dbContext"></param> public PrimarySkillRepository(MagenicManpowerDBContext dbContext) : base(dbContext) { }
/// <summary> /// Initializes a new instance of the <see cref="ProjectManagementRepository" /> class. /// </summary> /// <param name="dbContext">The database context.</param> public ProjectManagementRepository(MagenicManpowerDBContext dbContext) : base(dbContext) { }
/// <summary> /// /// </summary> public TaggedApplicantRepository(MagenicManpowerDBContext dbContext) : base(dbContext) { }
/// <summary> /// /// </summary> /// <param name="dbContext"></param> public ApplicantsRepository(MagenicManpowerDBContext dbContext, ITaggableRepository taggbleRefNumbersReposity) : base(dbContext) { _taggbleRefNumbersReposity = taggbleRefNumbersReposity; }
/// <summary> /// /// </summary> /// <param name="dbContext"></param> public RoleRepository(MagenicManpowerDBContext dbContext) : base(dbContext) { }
public LookupRepository(MagenicManpowerDBContext dbContext) : base(dbContext) { }
/// <summary> /// /// </summary> /// <param name="dbContext"></param> public RequestContextRepository(MagenicManpowerDBContext dbContext) : base(dbContext) { }