/// <summary>
/// HTTP GET endpoint for "/Staff/Details/<paramref name="id"/>". <para/>
/// Shows the details of a <see cref="Staff"/> member via the <see cref="StaffDetailsViewModel"/> view model.
/// This includes a <see cref="System.Collections.Generic.List{T}"/> (T is <see cref="EventDetailsViewModel"/>) for
/// the events that the staff member in.
/// </summary>
/// <returns>Directs the user to the <see cref="Details(int?)"/> view.</returns>
public async Task <IActionResult> Details(int?id)
{
if (id == null)
{
return(NotFound());
}
var staff = await _context.Staff
.FirstOrDefaultAsync(m => m.Id == id);
if (staff == null)
{
return(NotFound());
}
var events = await _context.EventStaff.Include(x => x.Event).Where(x => x.StaffId == staff.Id && !x.Event.Cancelled).ToListAsync();
StaffDetailsViewModel staffEventViewModel = new StaffDetailsViewModel()
{
Id = id.Value,
Name = staff.Name,
Events = events.Select(x => new EventDetailsViewModel()
{
Id = x.Event.Id,
Duration = x.Event.Duration,
Date = x.Event.Date,
Title = x.Event.Title
}).ToList(),
FirstAider = staff.FirstAider,
Email = staff.Email
};
return(View(staffEventViewModel));
}
public StaffDetails(int primarykey)
{
InitializeComponent();
objviewmodel = new StaffDetailSearchViewModel(primarykey);
//objStudentSearchViewModel = new StudentSearchViewModel();
this.DataContext = objviewmodel;
string dir = System.Environment.CurrentDirectory;
}
// GET: Staff/Details/5
public ActionResult Details(int id)
{
StaffDetailsViewModel staffDetailsVM = new StaffDetailsViewModel();
staffDetailsVM.Staff = adminWebDB.GetStaffByID(id);
staffDetailsVM.Transactions = adminWebDB.GetAllTransactionsForUser(id);
return(View(staffDetailsVM));
}
public ActionResult Details(int id)
{
StaffMember staffMember = _context.Staff.SingleOrDefault(s => s.Id == id);
List <Class> classes = _context.Classes.Include("course").Where(c => c.Instructor.Id == staffMember.Id).ToList();
StaffDetailsViewModel model = new StaffDetailsViewModel()
{
staffMember = staffMember,
classes = classes
};
return(View(model));
}
public List <StaffDetailsViewModel> GetData()
{
var conString = ConfigurationManager.ConnectionStrings["EJIntegralConnection"].ConnectionString;
using (SqlConnection con = new SqlConnection(conString))
{
var dt = new DataTable();
var details = new List <StaffDetailsViewModel>();
var cmd = new SqlCommand("GetEmployeeInfo", con)
{
CommandType = CommandType.StoredProcedure
};
using (var da = new SqlDataAdapter(cmd))
{
da.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
var obj = new StaffDetailsViewModel();
obj.StaffId = dr["StaffId"].ToString();
obj.Fullname = dr["Fullname"].ToString();
obj.DateOfBirth = Convert.ToDateTime(dr["DateOfBirth"].ToString());
obj.ContactNumber = dr["ContactNumber"].ToString();
obj.DepartmentName = dr["DepartmentName"].ToString();
obj.EntryDesignation = dr["EntryDesignation"].ToString();
obj.EntryGradeLevel = dr["EntryGradeLevel"].ToString();
obj.EntryStep = Convert.ToInt32(dr["EntryStep"].ToString());
obj.CurrentGradeLevel = dr["CurrentGradeLevel"].ToString();
obj.CurrentStep = Convert.ToInt32(dr["CurrentStep"].ToString());
obj.EntryQualification = dr["EntryQualification"].ToString();
obj.AdditionalQualification = dr["AdditionalQualification"].ToString();
obj.DateOfFirstAppt = Convert.ToDateTime(dr["DateOfFirstAppt"].ToString());
details.Add(obj);
}
}
return(details);
}
}
public async Task <IActionResult> OnGet()
{
if (Id == Guid.Empty)
{
return(RedirectToPage("/Admin/Staffs"));
}
ViewModel = new StaffDetailsViewModel();
ViewModel.User = new IdentityUser();
ViewModel.AppUser = new ApplicationUser();
ViewModel.TimeLines = new List <TimeLine>();
ViewModel.User = await _userManager.GetUserAsync(User);
ViewModel.AppUser = await _user.GetUserAsync(Id);
ViewModel.TimeLines = ViewModel.AppUser.TimeLines.ToList();
return(Page());
}
public ActionResult StaffDetails(int id)
{
var staff = _context.Staff.SingleOrDefault(s => s.Id == id);
if (staff == null)
{
return(HttpNotFound());
}
var userId = User.Identity.GetUserId();
var currentStaffId = 0;
var currentUser = _context.Staff.SingleOrDefault(x => x.UserId == userId);
if (currentUser != null)
{
currentStaffId = currentUser.Id;
}
var certificates = _context.TrainingCertificates.Where(c => c.StaffId == id).ToList();
var courses = _context.TrainingCourses.ToList();
var statuses = _context.TrainingStatuses.ToList();
var viewModel = new StaffDetailsViewModel
{
Staff = staff,
TrainingCertificates = certificates,
TrainingCourses = courses,
TrainingStatuses = statuses,
CurrentStaffId = currentStaffId
};
return(View(viewModel));
}
public void Include(StaffDetailsViewModel vm)
{
var vm1 = new StaffDetailsViewModel();
}
protected override void Init(Bundle savedInstanceState)
{
ViewModel = ViewModelLocator.StaffDetails;
ViewModel.Init(_args);
}
public StaffSearch()
{
InitializeComponent();
objViewModel = new StaffDetailSearchViewModel();
this.DataContext = objViewModel;
}
