public int UpdateRequisitionToApplicant(TblApplicantRequisition tblApplicantRequisition)
{
tblApplicantRequisition.ModifiedBy = CurrentContext.EmployeeID;
tblApplicantRequisition.ModifiedDate = DateTime.Now;
tblApplicantRequisition.Applicant = null;
dbContext.Entry(tblApplicantRequisition).State = EntityState.Modified;
dbContext.TblApplicantRequisition.Update(tblApplicantRequisition);
dbContext.SaveChanges();
dbContext.Entry(tblApplicantRequisition).State = EntityState.Detached;
TblApplicants tblApplicants = dbContext.TblApplicants.AsNoTracking().Where(r => r.ApplicantId == tblApplicantRequisition.ApplicantId).FirstOrDefault();
if (tblApplicantRequisition.Status == InterviewStatus.BlackListed)
{
tblApplicants.Status = ApplicantStatus.BlackListed;
}
else if (tblApplicantRequisition.Status == InterviewStatus.Selected)
{
tblApplicants.Status = ApplicantStatus.Selected;
}
else
{
tblApplicants.Status = ApplicantStatus.Available;
}
dbContext.Entry(tblApplicants).State = EntityState.Modified;
dbContext.TblApplicants.Update(tblApplicants);
dbContext.SaveChanges();
dbContext.Entry(tblApplicants).State = EntityState.Detached;
return(1);
}
public int ResumeImport(string path, ResumeUpload resumeUpload)
{
ResumeProcessor resumeProcessor = new ResumeProcessor();
var model = resumeProcessor.ProcessModel(path);
TblApplicants tblApplicants = new TblApplicants();
tblApplicants.Name = model.Name;
tblApplicants.EmailAddress = model.EmailAddress;
// tblApplicants.
if (resumeUpload.SourceId == 1)
{
tblApplicants.Source = "Direct";
}
else if (resumeUpload.SourceId == 2)
{
tblApplicants.Source = "Vendor";
}
else if (resumeUpload.SourceId == 3)
{
tblApplicants.Source = "Portal";
}
else if (resumeUpload.SourceId == 4)
{
tblApplicants.Source = "Internal";
}
tblApplicants.VendorId = resumeUpload.VendorId;
tblApplicants.PortalId = resumeUpload.PortalId;
tblApplicants.EmailAddress = resumeUpload.EmployeeEmailId;
return(ApplicantDAL.CreateApplicants(tblApplicants));
}
public int DeleteApplicants(int key)
{
TblApplicants applicants = dbContext.TblApplicants.Where(x => x.ApplicantId == key).FirstOrDefault();
dbContext.TblApplicants.Remove(applicants);
return(dbContext.SaveChanges());
}
public int UpdateApplicants(TblApplicants tblApplicants)
{
dbContext.Entry(tblApplicants).State = EntityState.Modified;
dbContext.TblApplicants.Update(tblApplicants);
int result = dbContext.SaveChanges();
dbContext.Entry(tblApplicants).State = EntityState.Detached;
return(result);
}
public int CreateApplicants(TblApplicants tblApplicants)
{
dbContext.Entry(tblApplicants).State = EntityState.Added;
dbContext.TblApplicants.Add(tblApplicants);
int result = dbContext.SaveChanges();
dbContext.Entry(tblApplicants).State = EntityState.Detached;
return(result);
}
public int UpdateApplicants(TblApplicants tblApplicants)
{
if (dbContext.TblApplicants.Where(r => r.PanNo.ToUpper() == tblApplicants.PanNo.ToUpper() && r.EmailAddress.ToUpper() == tblApplicants.EmailAddress.ToUpper() && r.Dob == tblApplicants.Dob).Count() > 0)
{
return(-1);
}
dbContext.Entry(tblApplicants).State = EntityState.Modified;
dbContext.TblApplicants.Update(tblApplicants);
int result = dbContext.SaveChanges();
dbContext.Entry(tblApplicants).State = EntityState.Detached;
return(result);
}
public int MapRequisitionToApplicant(long RequisitionID, long ApplicantID)
{
dbContext.Add(new TblApplicantRequisition()
{
ApplicantId = ApplicantID, RequisitionId = RequisitionID, Status = InterviewStatus.NotAssigned, CreatedBy = CurrentContext.EmployeeID, CreatedDate = DateTime.Now
});
dbContext.SaveChanges();
TblApplicants tblApplicants = dbContext.TblApplicants.AsNoTracking().Where(r => r.ApplicantId == ApplicantID).FirstOrDefault();
tblApplicants.Status = ApplicantStatus.Blocked;
tblApplicants.ShortlistedBy = RequisitionStatus.Internal;
dbContext.Entry(tblApplicants).State = EntityState.Modified;
dbContext.TblApplicants.Update(tblApplicants);
dbContext.SaveChanges();
dbContext.Entry(tblApplicants).State = EntityState.Detached;
return(1);
}
public int UpdateApplicants(TblApplicants tblApplicants)
{
return(ApplicantDAL.UpdateApplicants(tblApplicants));
}
public int CreateApplicants(TblApplicants tblApplicants)
{
return(ApplicantDAL.CreateApplicants(tblApplicants));
}
private int SaveApplicants(TblApplicants tblApplicants)
{
dbContext.TblApplicants.Add(tblApplicants);
return(dbContext.SaveChanges());
}
public IActionResult Applicants(int id)
{
TblApplicants result = _applicant.GetApplicantsByCriteria(id);
return(Ok(result));
}
public IActionResult UpdateApplicant([FromBody] TblApplicants tblApplicants)
{
int result = _applicantstaffing.UpdateApplicants(tblApplicants);
return(Ok(result));
}
public async Task <IActionResult> Applicants(int id)
{
TblApplicants result = await _applicantstaffing.GetApplicantsByCriteria(id);
return(Ok(result));
}
