// GET: TrainingPrograms/Details/5
public async Task <IActionResult> Details(int?id)
{
if (id == null)
{
return(NotFound());
}
var trainingProgram = await _context.TrainingProgram
.Include(e => e.TrainingProgramEmployee)
.SingleOrDefaultAsync(m => m.Id == id);
if (trainingProgram == null)
{
return(NotFound());
}
TrainingProgramDetailViewModel TrainingProgramViewModel = new TrainingProgramDetailViewModel();
foreach (var employee in trainingProgram.TrainingProgramEmployee)
{
var Employee = _context.Employee.SingleOrDefault(t => t.Id == employee.EmployeeId);
TrainingProgramViewModel.Employee.Add(Employee);
}
TrainingProgramViewModel.TrainingProgram = trainingProgram;
return(View(TrainingProgramViewModel));
}
// GET: TrainingPrograms/Details/1
public ActionResult Details(int id)
{
var trainingProgram = GetTrainingProgramById(id);
var ProgramEmployees = GetTrainingProgramEmployees(id);
var viewModel = new TrainingProgramDetailViewModel()
{
Id = id,
Name = trainingProgram.Name,
StartDate = trainingProgram.StartDate,
EndDate = trainingProgram.EndDate,
MaxAttendees = trainingProgram.MaxAttendees,
Employees = ProgramEmployees
};
return(View(viewModel));
}
// GET: TrainingPrograms/Details/5
public ActionResult Details(int id)
{
var employeesInTraining = GetEmployeesInTraining(id);
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"SELECT * FROM TrainingProgram
WHERE Id = @id";
cmd.Parameters.Add(new SqlParameter("@id", id));
var reader = cmd.ExecuteReader();
if (reader.Read())
{
var trainingProgram = new TrainingProgram
{
Id = reader.GetInt32(reader.GetOrdinal("Id")),
Name = reader.GetString(reader.GetOrdinal("Name")),
StartDate = reader.GetDateTime(reader.GetOrdinal("StartDate")),
EndDate = reader.GetDateTime(reader.GetOrdinal("EndDate")),
MaxAttendees = reader.GetInt32(reader.GetOrdinal("MaxAttendees"))
};
reader.Close();
var viewModel = new TrainingProgramDetailViewModel
{
TrainingProgram = trainingProgram,
EmployeesInTraining = employeesInTraining
};
reader.Close();
return(View(viewModel));
}
reader.Close();
return(NotFound());
}
}
}
