private async void SendRequisitionAssignedMail(TblRequisition tblRequisition)
{
EmailTemplate emailTemplate = new EmailTemplate();
StringBuilder stringBuilder = new StringBuilder();
TblEmployees tblEmployees = dbContext.TblEmployees.AsNoTracking().Where(r => r.EmployeeId == tblRequisition.CreatedBy).FirstOrDefault();
stringBuilder.AppendLine(tblEmployees.EmployeeName + "- has raised Requisition");
stringBuilder.AppendLine("Requisition Title : " + tblRequisition.Title);
stringBuilder.AppendLine("Skills : " + string.Join(",", dbContext.TblSkillMaster.Where(q => q.SkillId == tblRequisition.RequistionId).Select(x => x.SkillName).ToArray()));
stringBuilder.AppendLine("Department : " + tblRequisition.Department.Department);
stringBuilder.AppendLine("Designation : " + tblRequisition.Designation.Designation);
stringBuilder.AppendLine("Years Of Experience : " + tblRequisition.YearsofExperience);
stringBuilder.AppendLine("Joining Tenure(Months) : " + tblRequisition.JoiningTenure);
stringBuilder.AppendLine("No Of Positions : " + tblRequisition.NoofPositions);
stringBuilder.AppendLine("Location : " + tblRequisition.Location);
stringBuilder.AppendLine("Comments : " + tblRequisition.Comments);
stringBuilder.AppendLine("Manager Comments : " + tblRequisition.ManagerComments);
stringBuilder.AppendLine("Recruiter Comments : " + tblRequisition.RecruiterComment);
emailTemplate.Body = stringBuilder.ToString();
emailTemplate.Subject = "Requisition has been Assigned to you";
emailTemplate.EmailFromDisplayName = tblEmployees.EmployeeName;
string[] MailIds = new string[tblRequisition.TblRequisitionRecruiterMapping.Count + 1];
for (int i = 0; tblRequisition.TblRequisitionRecruiterMapping.Count > i; i++)
{
TblRequisitionRecruiterMapping recruiter = tblRequisition.TblRequisitionRecruiterMapping.ElementAt(i);
MailIds[i] = dbContext.TblEmployees.AsNoTracking().Where(r => r.EmployeeId == recruiter.EmployeeId).FirstOrDefault().EmailId;
}
MailIds[MailIds.Length - 1] = dbContext.TblEmployees.AsNoTracking().Where(r => r.EmployeeId == tblRequisition.CreatedBy).FirstOrDefault().EmailId;
emailTemplate.ToEmailAddress = MailIds;
await EmailHelper.SendMailWithoutCalendarInvite(emailTemplate);
}
public int DeleteEmployees(int key)
{
TblEmployees employees = dbContext.TblEmployees.Where(x => x.EmployeeId == key).FirstOrDefault();
employees.IsActive = false;
dbContext.TblEmployees.Update(employees);
return(dbContext.SaveChanges());
}
// PUT api/<controller>/5
public void Put(int id, [FromBody] TblEmployees employee)
{
var entity = dbContext.TblEmployees.Find(employee.Id);
if (entity == null)
{
return;
}
dbContext.Entry(entity).CurrentValues.SetValues(employee);
dbContext.SaveChanges();
}
public int UpdateEmployees(TblEmployees employees)
{
var Cond = dbContext.TblEmployees.Where(e => e.IsActive == true && employees.IsActive == true).Count() > 0;
if (Cond)
{
dbContext.TblEmployees.Update(employees);
return(dbContext.SaveChanges());
}
else
{
return(0);
}
}
public IActionResult Get()
{
var employeeId = JwtHelper.GetUser(HttpContext.User.Claims);
try
{
TblEmployees employee = _context.TblEmployees
.Where(emp => emp.EmployeeLogin.Equals(employeeId))
.Single();
employee.UsrPassword = null;
return(new ObjectResult(employee));
} catch (InvalidOperationException e) {
Console.WriteLine(e);
return(NotFound());
}
}
public IActionResult Login([FromBody] LoginModel login)
{
IActionResult response = Unauthorized();
TblEmployees employee = _context.TblEmployees.FirstOrDefault(emp => emp.EmployeeLogin.Equals(login.Username));
string loginId = employee?.EmployeeLogin;
string password = employee?.UsrPassword;
if (loginId.Equals(login.Username) && password.Equals(login.Password))
{
var tokenString = BuildToken(login);
response = Ok(new { token = tokenString });
}
return(response);
}
public EmployeeDTO SearchEmployee(int Empid, ApiContext apiContext)
{
_context = (MICAUMContext)DbManager.GetContext(apiContext.ProductType, apiContext.ServerType);
var _emp = _context.TblEmployees.SingleOrDefault(x => x.Empid == Empid);
if (_emp != null)
{
TblEmployees _tblUserDetails = _mapper.Map <TblEmployees>(_emp);
_context.TblEmployees.Find(_emp.Empid);
var emplDTOs = _mapper.Map <EmployeeDTO>(_emp);
return(emplDTOs);
}
else
{
return(null);
}
}
public async Task <IActionResult> OnPostAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
TblEmployees = await _context.TblEmployees.FindAsync(id);
if (TblEmployees != null)
{
_context.TblEmployees.Remove(TblEmployees);
await _context.SaveChangesAsync();
}
return(RedirectToPage("./Index"));
}
public async Task <IActionResult> OnGetAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
TblEmployees = await _context.TblEmployees
.Include(t => t.Department)
.Include(t => t.Gender).FirstOrDefaultAsync(m => m.EmployeeId == id);
if (TblEmployees == null)
{
return(NotFound());
}
return(Page());
}
public async Task <IActionResult> OnGetAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
TblEmployees = await _context.TblEmployees
.Include(t => t.Department)
.Include(t => t.Gender).FirstOrDefaultAsync(m => m.EmployeeId == id);
if (TblEmployees == null)
{
return(NotFound());
}
ViewData["DepartmentId"] = new SelectList(_context.TblDepartment, "Id", "DepartmentName");
ViewData["GenderId"] = new SelectList(_context.TblGender, "Id", "Sex");
return(Page());
}
// POST api/<controller>
public PostResult Post(TblEmployees employee)
{
// TODO: server validation
if (ModelState.IsValid)
{
// Save employee to data base
dbContext.TblEmployees.Add(employee);
dbContext.SaveChanges();
}
else
{
return(new PostResult()
{
State = ModelState
});
}
return(new PostResult()
{
ResultValue = employee.Id
});
}
private async void SendRequisitionApprovedMail(TblRequisition tblRequisition)
{
EmailTemplate emailTemplate = new EmailTemplate();
StringBuilder stringBuilder = new StringBuilder();
TblEmployees tblEmployees = dbContext.TblEmployees.AsNoTracking().Where(r => r.EmployeeId == tblRequisition.CreatedBy).FirstOrDefault();
stringBuilder.AppendLine(tblEmployees.EmployeeName + "- has raised Requisition");
stringBuilder.AppendLine("Requisition Title : " + tblRequisition.Title);
stringBuilder.AppendLine("Skills : " + string.Join(",", dbContext.TblSkillMaster.Where(q => q.SkillId == tblRequisition.RequistionId).Select(x => x.SkillName).ToArray()));
stringBuilder.AppendLine("Department : " + tblRequisition.Department.Department);
stringBuilder.AppendLine("Designation : " + tblRequisition.Designation.Designation);
stringBuilder.AppendLine("Years Of Experience : " + tblRequisition.YearsofExperience);
stringBuilder.AppendLine("Joining Tenure(Months) : " + tblRequisition.JoiningTenure);
stringBuilder.AppendLine("No Of Positions : " + tblRequisition.NoofPositions);
stringBuilder.AppendLine("Location : " + tblRequisition.Location);
stringBuilder.AppendLine("Comments : " + tblRequisition.Comments);
stringBuilder.AppendLine("Manager Comments : " + tblRequisition.ManagerComments);
emailTemplate.Body = stringBuilder.ToString();
emailTemplate.Subject = "Requisition Approved";
emailTemplate.EmailFromDisplayName = tblEmployees.EmployeeName;
emailTemplate.ToEmailAddress = dbContext.TblEmployees.AsNoTracking().Where(r => r.Role.RoleName == RoleConstants.RecruiterLeadRole && r.EmployeeId == tblRequisition.CreatedBy).AsNoTracking().ToList().Select(r => r.EmailId).ToArray();
await EmailHelper.SendMailWithoutCalendarInvite(emailTemplate);
}
public IActionResult Employees(int id, [FromBody] TblEmployees employees)
{
int result = _imasters.UpdateEmployees(employees);
return(Ok(result));
}
public int Edit(TblEmployees employee)
{
return(objEmployee.UpdateEmployee(employee));
}
public int CreateEmployees(TblEmployees employees)
{
return(MastersDAL.CreateEmployees(employees));
}
public int UpdateEmployees(TblEmployees employees)
{
return(MastersDAL.UpdateEmployees(employees));
}
public int Create(TblEmployees employee)
{
return(objEmployee.AddEmployee(employee));
}
