public TravelAndTrainingRequestRepository.RequestViewDataTable GetAllRequests()
{
using (TravelAndTrainingRequestRepository repository = new TravelAndTrainingRequestRepository())
{
using (RequestViewTableAdapter adapter = new RequestViewTableAdapter())
{
repository.RequestView.BeginLoadData();
adapter.Fill(repository.RequestView);
repository.RequestView.EndLoadData();
return repository.RequestView;
}
}
}
public TravelAndTrainingRequestRepository.RequestViewDataTable GetRequestsByRequestorAndStatus(string requestor, string status)
{
using (TravelAndTrainingRequestRepository repository = new TravelAndTrainingRequestRepository())
{
using (RequestViewTableAdapter adapter = new RequestViewTableAdapter())
{
repository.RequestView.BeginLoadData();
adapter.FillByRequestorStatus(repository.RequestView, requestor, status);
repository.RequestView.EndLoadData();
return repository.RequestView;
}
}
}
public TravelAndTrainingRequestRepository.RequestViewDataTable GetRequestsByPendingReviewer(string reviewer)
{
using (TravelAndTrainingRequestRepository repository = new TravelAndTrainingRequestRepository())
{
using (RequestViewTableAdapter adapter = new RequestViewTableAdapter())
{
repository.RequestView.BeginLoadData();
adapter.FillByPendingReviewer(repository.RequestView, reviewer);
repository.RequestView.EndLoadData();
return repository.RequestView;
}
}
}
