public ActionResult PromotionDetails(int?Id)
{
IStructuredetailRepository repo = new StructuredetailRepository();
var Data = (from emp in repo.Getemp()
join empdet in repo.Getempdet() on emp.EmployeeId equals empdet.EmployeeId
join pos in repo.Getpos() on emp.PositionId equals pos.Id
select new
{
emp.EmployeeId,
emp.EmployeeName,
emp.PositionId,
pos.Position,
empdet.EmployeeSalary,
empdet.DateofPromotion
}).Where(x => x.EmployeeId == Id).Select(c => new PositionVM()
{
EmployeeName = c.EmployeeName,
EmployeeId = (int)c.EmployeeId,
Position = c.Position,
Employeesalary = (decimal)c.EmployeeSalary,
DateofPromotion = (DateTime)c.DateofPromotion
}).FirstOrDefault();
return(View(Data));
}
public ActionResult GetPromotedEmployeesList()
{
IStructuredetailRepository repo = new StructuredetailRepository();
var Data = (from emp in repo.Getemp()
join empdetail in repo.Getempdet() on emp.EmployeeId equals empdetail.EmployeeId
join pos in repo.Getpos() on emp.PositionId equals pos.Id
select new
{
emp.EmployeeId,
emp.EmployeeName,
empdetail.DateofPromotion,
empdetail.IsSalaryset,
pos.Position,
pos.BasicPay
}).Where(a => a.IsSalaryset == false).ToList();
return(Json(new { data = Data }, JsonRequestBehavior.AllowGet));
}