public List <ReportGuidesViewModel> GetFullListGuides(ReportTourBindingModel model, int _OperatorID)
{
using (var context = new TourFirmDatabase())
{
var guides = from tour in context.Tours
join travelTours in context.TravelTours
on tour.ID equals travelTours.TourID
where tour.OperatorID == _OperatorID
join travel in context.Travels
on travelTours.TravelID equals travel.ID
where travel.DateStart >= model.DateFrom
where travel.DateEnd <= model.DateTo
join tourguide in context.TourGuides
on tour.ID equals tourguide.TourID
join guide in context.Guides
on tourguide.GuideID equals guide.ID
where guide.OperatorID == _OperatorID
join guideExcursion in context.GuideExcursions
on guide.ID equals guideExcursion.GuideID
join excursion in context.Excursions
on guideExcursion.ExcursionID equals excursion.ID
select new ReportGuidesViewModel
{
DateStartTravel = travel.DateStart,
GuideSurname = guide.Surname,
GuideName = guide.Name,
GuideWorkPlace = guide.WorkPlace,
ExcursionName = excursion.Name,
TourName = tour.Name
};
return(guides.ToList());
}
}
public void SaveTourExcurionToExcelFile(ReportTourBindingModel model)
{
OperatorSaveToExcel.CreateDoc(new OperatorExcelInfo
{
FileName = model.FileName,
Title = "Список экскурсий по указанным турам",
TourExcursions = GetTourExcursions(model.Tours)
});
}
public void SaveGuidesToPdfFile(ReportTourBindingModel model, int _OperatorID)
{
OperatorSaveToPdf.CreateDoc(new OperatorPdfInfo
{
FileName = model.FileName,
Title = "Список гидов",
DateFrom = model.DateFrom.Value,
DateTo = model.DateTo.Value,
Guides = GetGuides(model, _OperatorID)
});
}
// Получение списка смен гидов за определенный период с указанием туров и экскурсий
public List <ReportGuidesViewModel> GetGuides(ReportTourBindingModel model, int _OperatorID)
{
var list = reportStorage.GetFullListGuides(model, _OperatorID);
return(list);
}
