public ActionResult Index(int profile_id = 0)
{
using (var db = new HR_QueryEntities())
{
Employee profileEmployee = (Employee)db.Employees.Select(x => x).Where(x => x.Employee_ID == profile_id).First();
EmployeeProfileModel model = new EmployeeProfileModel();
model.EmployeeID = profileEmployee.Employee_ID;
model.EmployeeFirstName = profileEmployee.First_Name;
model.EmployeeLastName = profileEmployee.Last_Name;
model.DepartmentName = (db.Departments.Select(x => x).Where(x => x.Dept_ID == profileEmployee.Department).First()).Dept_Name;
model.LocationName = (db.Locations.Select(x => x).Where(x => x.Location_ID == profileEmployee.Location).First()).Location_Name;
model.PositionTypeName = (db.Position_Types.Select(x => x).Where(x => x.Position_Type_ID == profileEmployee.Position_Type).First()).Position_Type_Name;
return View(model);
}
}
public ActionResult Delete(EmployeeProfileModel pModel)
{
using (var db = new HR_QueryEntities())
{
List<Request> query = db.Requests.Select(x => x).Where(x => x.Request_Status == true && x.Request_Type_Index == 2).ToList();
foreach (Request r in query)
{
if (r.Employee_ID == pModel.EmployeeID)
return RedirectToAction("Options", "Home");
}
Request newRequest = new Request();
newRequest.Requestor_Name = User.Identity.Name;
newRequest.Request_Status = true;
newRequest.Employee_ID = pModel.EmployeeID;
newRequest.Request_Type_Index = 2;
db.Requests.Add(newRequest);
db.SaveChanges();
return RedirectToAction("Options", "Home");
}
}
