public List <ReportDetailViewModel> GetDetail(int Id, ReportBindingModel model) { var engines = _inspection.GetFilteredList( new InspectionsBindingModel { UserId = Id, Selected = model.Selected }); var list = new List <ReportDetailViewModel>(); foreach (var engine in engines) { var record = new ReportDetailViewModel { Name = engine.Name, Details = new List <Tuple <string, decimal> >(), }; foreach (var detail in engine.costInspections) { record.Details.Add(new Tuple <string, decimal>(_cost.GetElement(new CostBindingModel { Id = detail.Key }).Name, detail.Value)); } list.Add(record); } return(list); }
public List <GuideViewModel> GetAllGuidesStatistics(ReportBindingModel model, int _OperatorID) { using (var context = new TourFirmDatabase()) { var guides = from tour in context.Tours where tour.OperatorID != _OperatorID join travelTours in context.TravelTours on tour.ID equals travelTours.TourID 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 join guideExcursion in context.GuideExcursions on guide.ID equals guideExcursion.GuideID join excursion in context.Excursions on guideExcursion.ExcursionID equals excursion.ID select new GuideViewModel { Surname = guide.Surname, Name = guide.Name, PhoneNumber = guide.PhoneNumber }; return(guides.ToList()); } }
public List <Tuple <string, int> > GetExcursionDurationStatistic(ReportBindingModel model) { var listExcursions = implementer.GetAllExcursionStatistics(model); var excursions = new List <string>(); int s = 0; int m = 0; int h = 0; foreach (var elem in listExcursions) { if (elem.Duration <= 2) { excursions.Add("малая длительность - 0-2 часа"); s++; } if (elem.Duration >= 3 && elem.Duration <= 5) { excursions.Add("средняя длительность - 3-5 часов"); m++; } if (elem.Duration > 6) { excursions.Add("большая стоимость - 6+ часов"); h++; } } var result = new List <Tuple <string, int> >(); result.Add(new Tuple <string, int>("малая длительность - 0-2 часа", s)); result.Add(new Tuple <string, int>("средняя длительность - 3-5 часов", m)); result.Add(new Tuple <string, int>("большая стоимость - 6+ часов", h)); return(result); }
public List <RequestViewModel> GetRequestsList(ReportBindingModel model) { return(context.Requests .Where(rec => rec.Date >= model.DateFrom && rec.Date <= model.DateTo) .Select(rec => new RequestViewModel { Id = rec.Id, Price = rec.Price, Date = rec.Date.ToString(), RequestProducts = context.RequestProducts .Where(recPR => recPR.RequestId == rec.Id) .Select( recPC => new RequestProductViewModel { Id = recPC.Id, RequestId = recPC.RequestId, ProductId = recPC.ProductId, ProductName = recPC.Product.Name, ProductPrice = recPC.Product.Price, Count = recPC.Count } ) .ToList() }) .ToList()); }
public List <ReportViewModel> GetPlayers(ReportBindingModel model) { var Players = Player.Read(new PlayerBindingModel { DateFrom = model.DateFrom, DateTo = model.DateTo }); var list = new List <ReportViewModel>(); foreach (var rec in Players) { var record = new ReportViewModel { PlayerName = rec.PlayerName, Name = Game.Read(new GameBindingModel { Id = rec.GameId })[0].Name, DateDeath = rec.DateDeath, Score = rec.Score, DateCreate = Game.Read(new GameBindingModel { Id = rec.GameId })[0].DateCreate }; list.Add(record); } return(list); }
public List <Tuple <string, int> > GetExcursionCostStatistic(ReportBindingModel model) { var listExcursions = implementer.GetAllExcursionStatistics(model); var excursions = new List <string>(); int s = 0; int m = 0; int h = 0; foreach (var elem in listExcursions) { if (elem.Price < 1500) { excursions.Add("низкая стоимость - 0-1499"); s++; } if (elem.Price >= 1500 && elem.Price <= 5000) { excursions.Add("средняя стоимость - 1500-5000"); m++; } if (elem.Price > 5000) { excursions.Add("высокая стоимость - 5001+"); h++; } } var result = new List <Tuple <string, int> >(); result.Add(new Tuple <string, int>("низкая стоимость - 0-1499", s)); result.Add(new Tuple <string, int>("средняя стоимость - 1500-5000", m)); result.Add(new Tuple <string, int>("высокая стоимость - 5001+", h)); return(result); }
public List <ServiceViewModel> GetServicesList(ReportBindingModel model) { return(context.Services .Select( rec => new ServiceViewModel { ServiceName = rec.ServiceName, Price = rec.Price, ServiceDrugs = context.ServiceDrugs .Where(recPR => recPR.Id == rec.Id) .Select( recPC => new ServiceDrugViewModel { Id = recPC.Id, ServiceId = recPC.ServiceId, DrugId = recPC.DrugId, DrugName = recPC.Drug.DrugName, DrugPrice = recPC.Drug.Price, Count = recPC.Count } ) .ToList() } ) .ToList()); }
public List <ReportViewModel> GetPayments(ReportBindingModel model) { var cl = paymentLogic.Read(new PaymentBindingModel { DateFrom = model.DateFrom, DateTo = model.DateTo, }); List <ReportViewModel> rm = new List <ReportViewModel>(); foreach (var payment in cl) { string clientFIO = clientLogic.Read(new ClientBindingModel { Id = payment.ClientId }) .FirstOrDefault(rec => rec.Id == payment.ClientId).ClientFIO; rm.Add(new ReportViewModel { ClientFIO = clientFIO, DatePayment = payment.DatePayment, OrderId = payment.OrderId, Sum = payment.Sum }); } return(rm); }
public List <ExcursionViewModel> GetAllExcursionStatistics(ReportBindingModel model) { using (var context = new TourFirmDatabase()) { var excursions = from tour in context.Tours join travelTours in context.TravelTours on tour.ID equals travelTours.TourID 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 join guideExcursion in context.GuideExcursions on guide.ID equals guideExcursion.GuideID join excursion in context.Excursions on guideExcursion.ExcursionID equals excursion.ID select new ExcursionViewModel { Price = excursion.Price, Duration = excursion.Duration }; return(excursions.ToList()); } }
public List <ReportClientViewModel> GetClientInfo(ReportBindingModel model) { using (var context = new TravelAgencyContext()) { var client = context.Client.Include(x => x.Contract).ThenInclude(x => x.Hotel) .Include(x => x.Contract).ThenInclude(x => x.Route) .FirstOrDefault(x => x.Clientid == model.ClientId); if (client == null) { throw new Exception("Клиент не найден"); } return(client.Contract.Select(x => new ReportClientViewModel { ClientFIO = client.Nameclient, ClientId = client.Clientid, Datebirthday = client.Datebithday, Phonenumber = client.Phonenumber, RouteNameFrom = x.Route.Сityfrom, RouteNameTo = x.Route.Cityto, HotelName = x.Hotel.Hotelname, StartDate = x.Datetotravel, EndDate = x.Datefromtravel }).ToList()); } }
public List <ClientOrdersViewModel> GetClientOrders(ReportBindingModel model, int clientId) { return(context.Orders .Where(rec => rec.DateCreate >= model.DateFrom && rec.DateCreate <= model.DateTo && rec.ClientId == clientId) .Select(rec => new ClientOrdersViewModel { ClientName = rec.Client.ClientFIO, DateCreateOrder = SqlFunctions.DateName("dd", rec.DateCreate) + " " + SqlFunctions.DateName("mm", rec.DateCreate) + " " + SqlFunctions.DateName("yyyy", rec.DateCreate), TotalSum = rec.TotalSum, StatusOrder = rec.OrderStatus.ToString(), OrderCars = context.OrderCars.Where(recPC => recPC.OrderId == rec.Id) .Select(recPC => new OrderCarViewModel { Id = recPC.Id, CarId = recPC.CarId, OrderId = recPC.OrderId, CarName = recPC.Car.CarName, Amount = recPC.Amount }) .ToList() }) .ToList()); }
public void SaveClientOrders(ReportBindingModel model, int clientId) { if (!File.Exists("TIMCYR.TTF")) { File.WriteAllBytes("TIMCYR.TTF", Properties.Resources.TIMCYR); } FileStream fs = new FileStream(model.FileName, FileMode.OpenOrCreate, FileAccess.Write); var document = new Document(); PdfWriter writer = PdfWriter.GetInstance(document, fs); baseFont = BaseFont.CreateFont("TIMCYR.TTF", BaseFont.IDENTITY_H, BaseFont.NOT_EMBEDDED); document.Open(); PrintHeader($"Заказы клиента за период с {string.Format("{0:dd.MM.yyyy}", model.DateFrom)} по {string.Format("{0:dd.MM.yyyy}", model.DateTo)}", document); var cb = writer.DirectContent; var clientOrders = GetClientOrders(model, clientId); foreach (var order in clientOrders) { PrintHeader("Информация по заказу", document); PrintOrderInfo(order, document); DrawLine(cb, document, writer); } document.Close(); fs.Close(); }
public List <LoadOrderReportViewModel> GetDetailsOrder(ReportBindingModel model) { List <LoadOrderReportViewModel> cars = context.Cars .Select(rec => new LoadOrderReportViewModel { CarName = rec.CarName, CarId = rec.Id, Details = context.CarDetails.Where(r => r.CarId == rec.Id).ToList().Select(rs => new CarDetailViewModel { CarId = rs.CarId, Amount = rs.Amount, DetailId = rs.DetailId, DetailName = context.Details.FirstOrDefault(d => d.Id == rs.DetailId).DetailName }).ToList() }) .ToList(); List <LoadOrderReportViewModel> orders = context.Orders .Where(rec => rec.DateImplement >= model.DateFrom && rec.DateImplement <= model.DateTo) .Select(rec => new LoadOrderReportViewModel { DateCreate = rec.DateImplement.ToString(), OrderId = rec.Id }) .ToList(); List <OrderCar> orderCars = context.OrderCars.ToList(); List <LoadOrderReportViewModel> Details = new List <LoadOrderReportViewModel>(); foreach (var element in orderCars) { LoadOrderReportViewModel save = new LoadOrderReportViewModel(); foreach (var order in orders) { if (element.OrderId == order.OrderId) { save.DateCreate = order.DateCreate; save.OrderId = order.OrderId; break; } } foreach (var car in cars) { if (element.CarId == car.CarId && save.OrderId == element.OrderId) { save.CarName = car.CarName; save.CarAmount = element.Amount; save.Details = car.Details; break; } } Details.Add(save); } return(Details); }
public List <ReportClientViewModel> GetClientInfo(ReportBindingModel model) { if (model == null || !model.ClientId.HasValue) { return(null); } return(storage.GetClientInfo(model)); }
public IActionResult ReportOnView([Bind("DateTo,DateFrom")] ReportBindingModel model) { model.UserId = Program.User.Id; model.FileName = @"..\UrskiyPeriodUserAPP\wwwroot\report\Report.pdf"; APIUser.PostRequest("api/report/MakePdf", model); ViewBag.Report = model.FileName; return(View("Email")); }
public List <ReportClientRoute> GetClientRoutes(ReportBindingModel model) { if (model == null || !model.ClientId.HasValue) { return(null); } return(storage.GetClientRoute(model)); }
public List <ReportAccountingViewModel> GetAccountingInfo(ReportBindingModel model) { if (model == null || !model.DateFrom.HasValue || !model.DateTo.HasValue) { return(null); } return(storage.GetAccountingInfo(model)); }
public IActionResult SendMail([Bind("DateTo,DateFrom")] ReportBindingModel model) { model.UserId = Program.User.Id; model.UserEmail = Program.User.Email; model.FileName = @"..\UrskiyPeriodUserAPP\wwwroot\report\Report.pdf"; APIUser.PostRequest("api/report/SendMail", model); return(Redirect("~/Home/Index")); }
public IActionResult MakeReport([Bind("DateTo,DateFrom")] ReportBindingModel model) { model.FileName = @".\wwwroot\list\SocietiesList.pdf"; model.ClientId = Program.Client.Id; _reportLogic.SaveSocietiesToPdfFile(model); ViewBag.CheckingReport = model.FileName; return(View("Index")); }
public void SaveToExcelFile(ReportBindingModel model) { SaveToExcel.CreateDoc(new ExcelInfo { FileName = model.FileName, Title = "Список дисциплин", Disciplines = GetDisciplines(model) }); }
public List <StudyingStatusViewModel> GetStatus(ReportBindingModel model) { return(studyingStatusStorage.GetFilteredList(new StudyingStatusBindingModel { DateFrom = model.DateFrom, DateTo = model.DateTo, ProviderId = model.ProviderId })); }
// Сохранение компонент с указаеним продуктов в файл-Excel public void SaveDetailToExcelFile(ReportBindingModel model) { SaveToExel.CreateDoc(new Info { FileName = model.FileName, Title = model.Title, InspectionsCost = GetDetail((int)model.User.Id, model) }); }
/// <summary> /// Сохранение компонент с указаеним продуктов в файл-Pdf /// </summary> /// <param name="model"></param> public void SaveKomlectComponentToPdfFile(ReportBindingModel model) { SaveToPdf.CreateDoc(new PdfInfo { FileName = model.FileName, Title = "Список изделий с компонентами", KomlectComponents = GetKomlectComponent() }); }
/// <summary> /// Сохранение кондитерских изделий с ценой в файл-Word /// </summary> /// <param name="model"></param> public void SaveProductsToWord(ReportBindingModel model) { SaveToWord.CreateDoc(new WordInfo { FileName = model.FileName, Title = "Список кондитерских изделий", Products = productLogic.Read(null) }); }
/// <summary> /// Сохранение кондитерских изделий c расшифровкой по ингредиентам в файл-Pdf /// </summary> /// <param name="model"></param> public void SaveProductIngredientToPdfFile(ReportBindingModel model) { SaveToPdf.CreateDoc(new PdfInfo { FileName = model.FileName, Title = "Список кондитерских изделий с расшифровкой по ингредиентам", ProductIngredient = GetProductIngredient() }); }
public void SaveReceiptListToExcelFile(ReportBindingModel model) { SaveToExcel.CreateDoc(new ExcelInfoDoctor { FileName = model.FileName, Title = "Сведения по рецептам", Receipts = GetReceiptList(model) }); }
public void SaveRequestToWordFile(ReportBindingModel model) { SaveToWord.CreateDoc(new WordInfo { FileName = model.FileName, Title = "Список заявок", RequestFlowers = GetRequestPlaces() }); }
/// <summary> /// Сохранение компонент в файл-Word /// </summary> /// <param name="model"></param> public void SaveKomlectsToWordFile(ReportBindingModel model) { SaveToWord.CreateDoc(new WordInfo { FileName = model.FileName, Title = "Список изделий", Komlects = KomlectLogic.Read(null) }); }
public List <RouteViewModel> GetRoutes(ReportBindingModel model) { return(_routeStorage.GetFilteredByDateList(new RouteBindingModel { UserId = model.UserId, DateFrom = model.DateFrom, DateTo = model.DateTo }).ToList()); }
/// <summary> /// Сохранение заказов в файл-Excel /// </summary> /// <param name="model"></param> public void SaveOrdersToExcelFile(ReportBindingModel model) { SaveToExcel.CreateDoc(new ExcelInfo { FileName = model.FileName, Title = "Список заказов", Orders = GetOrders(model) }); }