public ActionResult GetDetails(int?id)
{
IStructuredetailRepository repo = new StructuredetailRepository();
IDepartmentRepository deprepo = new DepartmentRepository();
var data = (from d in repo.GetVacancies()
join dep in deprepo.GetAll() on d.DepartmentId equals dep.DepartmentId
where d.VacancyId == id
select new
{
d.VacancyId,
d.VacancyName,
d.JobLevel,
dep.DepartmentName,
d.CityName,
d.RequiredQualification
}).Select(c => new VacancyVM()
{
VacancyId = c.VacancyId,
JobLevel = (int)(c.JobLevel),
VacancyName = c.VacancyName,
CityName = c.CityName,
DepartmentName = c.DepartmentName,
RequiredQualification = c.RequiredQualification
}).FirstOrDefault();
return(PartialView("JobDetailsPartial", data));
}
public ActionResult GetIdonConfirm(int?id)
{
IRepository obj = new ApplicantRepository();
IStructuredetailRepository repo = new StructuredetailRepository();
IDepartmentRepository deprepo = new DepartmentRepository();
var result = (from d in obj.GetAll()
join s in repo.GetVacancies() on d.VacancyId equals s.VacancyId
join dep in deprepo.GetAll() on s.DepartmentId equals dep.DepartmentId
where d.ApplicationId == id
select new
{
d.ApplicationId,
d.Email,
d.Appliedfor,
dep.DepartmentName,
d.ApplicantName
}).Select(c => new CandidateEmployeeVM()
{
ApplicationId = (int)(c.ApplicationId),
Email = c.Email,
Position = c.Appliedfor,
DepartmentName = c.DepartmentName,
EmployeeName = c.ApplicantName
}).FirstOrDefault();
return(PartialView("ConfirmPartial", result));
}
public ActionResult Apply(int?id)
{
IStructuredetailRepository obj = new StructuredetailRepository();
var Data = obj.GetVacancies()
.Select(x => new ApplyVM {
VacancyId = x.VacancyId, Appliedfor = x.VacancyName
})
.Where(x => x.VacancyId == id).FirstOrDefault();
return(View(Data));
}
public ActionResult GetSlCandidates(int?id)
{
IRepository obj = new ApplicantRepository();
IStructuredetailRepository repo = new StructuredetailRepository();
IDepartmentRepository deprepo = new DepartmentRepository();
var Emp = (from d in obj.GetAll()
join s in repo.GetVacancies() on d.VacancyId equals s.VacancyId
join dep in deprepo.GetAll() on s.DepartmentId equals dep.DepartmentId
join pos in repo.Getpos() on s.PositionId equals pos.Id
where d.ApplicationId == id
select new
{
d.ApplicantName,
d.Gender,
s.DepartmentId,
s.PositionId,
d.Dob,
d.Phone,
d.Email,
d.Address,
d.ApplicationId,
dep.DepartmentName,
pos.Position,
pos.BasicPay
}).Select(c => new CandidateEmployeeVM()
{
ApplicationId = (int)(c.ApplicationId),
EmployeeName = c.ApplicantName,
Gender = c.Gender,
DepartmentId = (int)(c.DepartmentId),
DepartmentName = c.DepartmentName,
PositionId = (int)c.PositionId,
DateofBirth = (DateTime)c.Dob,
Contact = c.Phone,
Email = c.Email,
Address = c.Address,
Position = c.Position,
Salary = (decimal)c.BasicPay,
PosSalary = (decimal)c.BasicPay
}).FirstOrDefault();
return(PartialView("HireEmployee", Emp));
}
public ActionResult Getcreatedvaclist()
{
IStructuredetailRepository repo = new StructuredetailRepository();
IDepartmentRepository objrepo = new DepartmentRepository();
var Data = (from u in repo.GetVacancies()
join a in objrepo.GetAll() on u.DepartmentId equals a.DepartmentId
join b in repo.Getpos() on u.PositionId equals b.Id
select new
{
a.DepartmentName,
b.Position,
u.JobLevel,
u.MarksCriteria,
u.Testpaper,
}).ToList();
return(Json(new { data = Data }, JsonRequestBehavior.AllowGet));
}
public ActionResult GetConfirmation(int?id)
{
IRepository obj = new ApplicantRepository();
IStructuredetailRepository repo = new StructuredetailRepository();
IDepartmentRepository deprepo = new DepartmentRepository();
var Data = (from d in obj.GetAll()
join s in repo.GetVacancies() on d.VacancyId equals s.VacancyId
where d.ApplicationId == id
select new
{
d.ApplicantName,
d.Gender,
s.DepartmentId,
s.PositionId,
d.Dob,
d.Phone,
d.Email,
d.Address,
d.ApplicationId,
d.JoiningDate,
s.CityName,
d.Salary
}).Select(c => new CandidateEmployeeVM()
{
ApplicationId = (int)(c.ApplicationId),
EmployeeName = c.ApplicantName,
Gender = c.Gender,
DepartmentId = (int)(c.DepartmentId),
PositionId = (int)c.PositionId,
DateofBirth = (DateTime)c.Dob,
Contact = c.Phone,
Email = c.Email,
Address = c.Address,
JoiningDate = (Nullable <DateTime>)c.JoiningDate,
CityName = c.CityName,
PosSalary = c.Salary
}).FirstOrDefault();
return(PartialView("ConfirmEmployeePartial", Data));
}