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 GetPromotedEmpSalary(int?Id)
{
IStructuredetailRepository repo = new StructuredetailRepository();
var data = (from emp in repo.Getemp()
join pos in repo.Getpos() on emp.PositionId equals pos.Id
select new
{
emp.EmployeeId,
emp.EmployeeName,
emp.PositionId,
pos.Position,
pos.BasicPay,
pos.Experience,
emp.Email
}).Where(x => x.EmployeeId == Id).Select(c => new PositionVM()
{
EmployeeName = c.EmployeeName,
EmployeeId = (int)c.EmployeeId,
PositionId = (int)c.PositionId,
Position = c.Position,
BasicPay = (decimal)c.BasicPay,
Description = "Congratulations, " + c.EmployeeName + " based on your Performance and " + c.Experience + " Experience You have Been Promoted to " + c.Position + " Position and your Basic Salary is increased to " + c.BasicPay + ". Regards",
Email = c.Email
}).FirstOrDefault();
return(PartialView("EmployeePromotionSalaryPartial", data));
}
public ActionResult RemoveTable(int?Id)
{
IStructuredetailRepository repo = new StructuredetailRepository();
IDepartmentRepository deprepo = new DepartmentRepository();
var data = (from emp in repo.Getemp()
join pos in repo.Getpos() on emp.PositionId equals pos.Id
select new
{
emp.EmployeeId,
emp.EmployeeName,
emp.PositionId,
emp.CityName,
emp.Contact,
emp.Email,
emp.DateofBirth,
emp.Gender,
pos.Position,
pos.Experience
}).Where(x => x.PositionId != Id).Select(c => new PositionVM()
{
EmployeeName = c.EmployeeName,
EmployeeId = (int)c.EmployeeId,
Gender = c.Gender,
Experience = c.Experience,
CityName = c.CityName,
Contact = c.Contact,
Email = c.Email,
DateofBirth = (DateTime)c.DateofBirth,
PositionId = (int)c.PositionId,
Position = c.Position
});
return(Json(data, JsonRequestBehavior.AllowGet));
}
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));
}
public ActionResult GetEmployeeforpro(int?Id)
{
IStructuredetailRepository repo = new StructuredetailRepository();
var data = (from emp in repo.Getemp()
join pos in repo.Getpos() on emp.PositionId equals pos.Id
select new
{
emp.EmployeeId,
emp.EmployeeName,
emp.PositionId,
emp.CityName,
emp.Contact,
emp.Email,
emp.DateofBirth,
emp.Gender,
pos.Position,
pos.Experience,
emp.DepartmentId,
pos.JobLevel
}).Where(x => x.EmployeeId == Id).Select(c => new PositionVM()
{
EmployeeName = c.EmployeeName,
EmployeeId = (int)c.EmployeeId,
Gender = c.Gender,
Experience = c.Experience,
CityName = c.CityName,
Contact = c.Contact,
Email = c.Email,
DateofBirth = (DateTime)c.DateofBirth,
PositionId = (int)c.PositionId,
Position = c.Position,
JobLevel = (int)c.JobLevel,
DepartmentId = (int)c.DepartmentId
}).FirstOrDefault();
return(PartialView("EmployeePromotionPartial", data));
}