public ActionResult Index(ATLTravelPortal.Areas.Airline.Models.ExportModel Expmodel, LedgerTransactionSummaryModel model, FormCollection frm) { model.LedgerTransactionList = ledgerTransactionSummaryProvider.GetSummeryOfLedgerTransactionList(model.ProductId, model.CurrencyId, model.LedgerOf, model.DateFrom, model.DateTo, model.FilterType, model.FilterValue); BookedTicketReportController crtBKT = new BookedTicketReportController(); crtBKT.GetExportTypeClicked(Expmodel, frm); if (Expmodel != null && (Expmodel.ExportTypeExcel != null || Expmodel.ExportTypeWord != null || Expmodel.ExportTypeCSV != null || Expmodel.ExportTypePdf != null)) { try { if (Expmodel.ExportTypeExcel != null) { Expmodel.ExportTypeExcel = Expmodel.ExportTypeExcel; } else if (Expmodel.ExportTypeWord != null) { Expmodel.ExportTypeWord = Expmodel.ExportTypeWord; } else if (Expmodel.ExportTypePdf != null) { Expmodel.ExportTypePdf = Expmodel.ExportTypePdf; } int counter = 1; var exportData = model.LedgerTransactionList.Select(m => new { SN = counter++, Ledger_Id = m.LedgerId, Ledger_Name = m.LedgerName, Opening_Balance = m.OpeningBalance, Dr = m.Dr, Cr = m.Cr, Closing_Balance = m.ClosingBalance }); App_Class.AppCollection.Export(Expmodel, exportData, "Ledger Transaction"); } catch { } } model.ProductsOption = ledgerTransactionSummaryProvider.GetProductOption(); model.CurrencyOption = ledgerTransactionSummaryProvider.GetCurrencyOption(); model.LedgerOfOption = ledgerTransactionSummaryProvider.GetLedgerOfOption(); model.FilterTypeOption = ledgerTransactionSummaryProvider.GerFilterTypeoption(); return(View(model)); }
public ActionResult Index(ATLTravelPortal.Areas.Airline.Models.ExportModel Expmodel, SalesReportModel model, FormCollection frm) { model.InformationList = salesReportProvider.GetInformation(model.ReportOf, model.CurrencyId, model.FromDate, model.ToDate); BookedTicketReportController crtBKT = new BookedTicketReportController(); crtBKT.GetExportTypeClicked(Expmodel, frm); if (Expmodel != null && (Expmodel.ExportTypeExcel != null || Expmodel.ExportTypeWord != null || Expmodel.ExportTypeCSV != null || Expmodel.ExportTypePdf != null)) { try { if (Expmodel.ExportTypeExcel != null) { Expmodel.ExportTypeExcel = Expmodel.ExportTypeExcel; } else if (Expmodel.ExportTypeWord != null) { Expmodel.ExportTypeWord = Expmodel.ExportTypeWord; } else if (Expmodel.ExportTypePdf != null) { Expmodel.ExportTypePdf = Expmodel.ExportTypePdf; } var exportData = model.InformationList.Select(m => new { Name = m.Name, Airline = m.Airline, Hotel = m.Hotel, Mobile = m.Mobile, Bus = m.Bus, Train = m.Train, Total = m.Total }); App_Class.AppCollection.Export(Expmodel, exportData, "Sales Report"); } catch { } } model.ReportsOfOption = salesReportProvider.GetReportof(); model.CurrencyOption = salesReportProvider.Getcurrencylist(); return(View(model)); }
public ActionResult Index(ATLTravelPortal.Areas.Airline.Models.ExportModel Expmodel, DateTime FromDate, DateTime ToDate, FormCollection frm) { TicketStatusHistoryModel model = new TicketStatusHistoryModel(); BookedTicketReportController crtBKT = new BookedTicketReportController(); model.TicketStatusHistoryList = TicketStatusHistoryRepository.GetTicketStatusHistory(FromDate, ToDate); crtBKT.GetExportTypeClicked(Expmodel, frm); if (Expmodel != null && (Expmodel.ExportTypeExcel != null || Expmodel.ExportTypeWord != null || Expmodel.ExportTypeCSV != null || Expmodel.ExportTypePdf != null)) { try { if (Expmodel.ExportTypeExcel != null) { Expmodel.ExportTypeExcel = Expmodel.ExportTypeExcel; } else if (Expmodel.ExportTypeWord != null) { Expmodel.ExportTypeWord = Expmodel.ExportTypeWord; } else if (Expmodel.ExportTypePdf != null) { Expmodel.ExportTypePdf = Expmodel.ExportTypePdf; } var exportData = model.TicketStatusHistoryList.Select(m => new { Branch = m.Branch, Distributor = m.Distributor, Agent = m.Agent, Airline = m.Airline, Sector = m.Sector, Status = m.Status, ServiceProvider = m.ServiceProviderName }); App_Class.AppCollection.Export(Expmodel, exportData, "Sales Report"); } catch { } } return(View(model)); }
public ActionResult Details(ATLTravelPortal.Areas.Airline.Models.ExportModel Expmodel, SalesReportModel model, FormCollection frm) { model.ReportHeading = model.Name; model.InformationList = salesReportProvider.GetLedgerInformation(model.LedgerId, model.ReportOf, model.CurrencyId, model.FromDate, model.ToDate, model.ReportType); BookedTicketReportController crtBKT = new BookedTicketReportController(); crtBKT.GetExportTypeClicked(Expmodel, frm); if (Expmodel != null && (Expmodel.ExportTypeExcel != null || Expmodel.ExportTypeWord != null || Expmodel.ExportTypeCSV != null || Expmodel.ExportTypePdf != null)) { try { if (Expmodel.ExportTypeExcel != null) { Expmodel.ExportTypeExcel = Expmodel.ExportTypeExcel; } else if (Expmodel.ExportTypeWord != null) { Expmodel.ExportTypeWord = Expmodel.ExportTypeWord; } else if (Expmodel.ExportTypePdf != null) { Expmodel.ExportTypePdf = Expmodel.ExportTypePdf; } int counter = 0; if (model.ReportType == 1) { var exportData = model.InformationList.Select(m => new { SN = ++counter, Airline = m.AirlineName, MPNRID = m.MpnrId, ServiceProvider_Name = m.ServiceProviderName, Sector = m.Sector, Issued_Date = TimeFormat.DateFormat(m.IssuedDate.ToString()), Issued_From = m.IssuedFrom, Ticket_Number = m.TicketNumber, Amount = m.Amount }); App_Class.AppCollection.Export(Expmodel, exportData, "Sales Report"); } if (model.ReportType == 2) { var exportData = model.InformationList.Select(m => new { SN = ++counter, Hotel_Name = m.HotelName, Country_Name = m.CountryName, City_Name = m.CityName, ServiceProvider_Name = m.ServiceProviderName, Issued_Date = TimeFormat.DateFormat(m.IssuedDate.ToString()), No_Of_Night = m.NOofNight, No_Of_Room = m.NoofRoom, Amount = m.Amount }); App_Class.AppCollection.Export(Expmodel, exportData, "Sales Report"); } if (model.ReportType == 3) { var exportData = model.InformationList.Select(m => new { SN = ++counter, SalesTranId = m.SalesTranId, ServiceType = m.ServiceType, Customer_MobileNo = m.CustomerMobileNo, ServiceProvider_Name = m.ServiceProviderName, Issued_Date = TimeFormat.DateFormat(m.IssuedDate.ToString()), Created_Date = m.CreatedDate, Amount = m.Amount }); App_Class.AppCollection.Export(Expmodel, exportData, "Sales Report"); } if (model.ReportType == 4) { var exportData = model.InformationList.Select(m => new { SN = ++counter, BusMasterName = m.BusMasterName, BusPNRId = m.BusPNRId, ServiceProvider_Name = m.ServiceProviderName, Passenger_Name = m.PassengerName, Sector = m.Sector, Issued_Date = TimeFormat.DateFormat(m.IssuedDate.ToString()), Amount = m.Amount }); App_Class.AppCollection.Export(Expmodel, exportData, "Sales Report"); } if (model.ReportType == 5) { var exportData = model.InformationList.Select(m => new { SN = ++counter, Passenger_Name = m.PassengerName, TrainNo = m.TrainNo, Sector = m.Sector, Issued_Date = TimeFormat.DateFormat(m.IssuedDate.ToString()), TrainPNRId = m.TrainPNRId, Amount = m.Amount }); App_Class.AppCollection.Export(Expmodel, exportData, "Sales Report"); } } catch { } } return(View(model)); }