/// <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)
{
}
