public List <ReportTravelsViewModel> GetFullListTravels(ReportTravelBindingModel model, int _TouristID)
{
using (var context = new TourFirmDatabase())
{
var travels = from travel in context.Travels
join travelExcursion in context.TravelExcursions
on travel.ID equals travelExcursion.TravelID
where travel.TouristID == _TouristID
where travel.DateStart >= model.DateFrom
where travel.DateEnd <= model.DateTo
join guideExcursion in context.GuideExcursions
on travelExcursion.ExcursionID equals guideExcursion.ExcursionID
join guide in context.Guides
on guideExcursion.GuideID equals guide.ID
join excursion in context.Excursions
on travelExcursion.ExcursionID equals excursion.ID
select new ReportTravelsViewModel
{
TravelName = travel.Name,
DateStart = travel.DateStart,
DateEnd = travel.DateEnd,
ExcursionName = excursion.Name,
GuideSurname = guide.Surname,
GuideName = guide.Name
};
return(travels.ToList());
}
}
public void SaveTravelGuidesToExcel(ReportTravelBindingModel model)
{
TouristSaveToExcel.CreateDoc(new TouristWordExcelInfo
{
FileName = model.FileName,
Title = "Список гидов по выбранным путешествиям",
TravelGuides = GetTravelGuides(model.Travels)
});
}
public void SaveTravelsExcursionsGuidesToPdf(ReportTravelBindingModel model, int _TouristID)
{
TouristSaveToPdf.CreateDoc(new TouristPdfInfo
{
FileName = model.FileName,
Title = "Список экскурсий и гидов по выбранным путешествиям",
DateFrom = model.DateFrom.Value,
DateTo = model.DateTo.Value,
TravelExcursionsGuides = GetTravelExcursionsGuides(model, _TouristID)
});
}
public List <ReportTravelsViewModel> GetTravelExcursionsGuides(ReportTravelBindingModel model, int _TouristID)
{
var list = reportStorage.GetFullListTravels(model, _TouristID);
return(list);
}
