public ActionResult Index(BusPNRModel model, int?page, ExportModel Expmodel, FormCollection frm) { Session["FromDate"] = model.FromDate; Session["ToDate"] = model.ToDate; BusPNRModel _model = new BusPNRModel(); UnIssuedTicketRepository _rep = new UnIssuedTicketRepository(); BusGeneralRepository.SetRequestPageRow(); try { var ts = (TravelSession)Session["TravelPortalSessionInfo"]; ViewData["AgentList"] = new SelectList(defaultProvider.GetDistributorAgentList(ts.LoginTypeId), "AgentId", "AgentName"); _model.TabularList = _rep.GetDistributorPagedIssueList(page, model.FromDate, model.ToDate, model.AgentId, ts.LoginTypeId); } catch (Exception ex) { _model.Message = BusGeneralRepository.CatchException(ex); } //export 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.TabularList.Select(m => new { Passenger_Name = m.FullName, Operator_Name = m.BusMasterName, DepartureDate = TimeFormat.DateFormat(m.DepartureDate.ToString()), DepartureTime = TimeFormat.GetAMPMTimeFormat(m.DepartureTime.ToString()), Category = m.BusCategoryName, Type = m.Type }); App_Class.AppCollection.Export(Expmodel, exportData, "Issued Ticket"); } catch { } } _model.Message = _res; return(View(_model)); }
public ActionResult Index(ExportModel Expmodel, AgentCLApprovedModel model, FormCollection frm, int?pageNo, int?flag, int?page) { var ts = (TravelSession)Session["TravelPortalSessionInfo"]; int currentPageIndex = page.HasValue ? page.Value : 1; int defaultPageSize = 50; //export BookedTicketReportController crtBKT = new BookedTicketReportController(); crtBKT.GetExportTypeClicked(Expmodel, frm); if (Expmodel != null && (Expmodel.ExportTypeExcel != null || Expmodel.ExportTypeWord != null || Expmodel.ExportTypeCSV != null || Expmodel.ExportTypePdf != null)) { model.AgentCLApprovedListExport = agentReceiptsProvider.GetAgentCLApprovedList(model.FromDate, model.ToDate, model.UserID, model.DistributorID, model.AgentId); 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.AgentCLApprovedListExport.Select(m => new { BranchOffice_Name = m.BranchOfficeName, Distributor_Name = m.DistributorName, Agent_Name = m.AgentName, Agent_Code = m.AgentCode, Currency = m.Currency, Amount = m.Amount, Narration = m.Comments, VoucherNo = m.VoucherNo, CreatedBy = m.CheckedBy, CreatedDate = m.CheckerDate }); App_Class.AppCollection.Export(Expmodel, exportData, "Agent Receipts"); } catch { } } model.AgentReceiptList = agentReceiptsProvider.GetAgentCLApprovedList(model.FromDate, model.ToDate, model.UserID, model.DistributorID, model.AgentId).ToPagedList(currentPageIndex, defaultPageSize); model.UsersOption = new SelectList(defaultProvider.GetUserList(), "AppUserId", "FullName"); model.BranchOfficeOption = new SelectList(branchOfficeManagementProvider.GetAll(), "BranchOfficeId", "BranchOfficeName", model.BranchOfficeId); model.DistributorOption = new SelectList(agentclaapprovedprovider.GetAllDistributorsByBranchOfficeId(model.BranchOfficeId ?? 0), "DistributorId", "DistributorName"); model.AgentOption = new SelectList(agentclaapprovedprovider.GetAgentsByDistributorId(model.DistributorID ?? 0), "AgentId", "AgentName", model.AgentId); return(View(model)); }
public ActionResult Index(ExportModel Expmodel, AgentCLApprovedModel model, FormCollection frm, int?pageNo, int?flag) { var ts = (TravelSession)Session["TravelPortalSessionInfo"]; if (ts.UserTypeId == 6) { model.DistributorID = ts.LoginTypeId; } model.AgentCLApprovedListExport = agentCLApprovedProvider.GetAgentCLApprovedList(model.FromDate, model.ToDate, model.UserID, model.DistributorID, model.AgentId); //export 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.AgentCLApprovedListExport.Select(m => new { Brach_Office = m.BranchOfficeName, Distributor = m.DistributorName, Agent_Name = m.AgentName, Agent_Code = m.AgentCode, Currency = m.Currency, Amount = m.Amount, Type = m.Type, Requestion = m.Requestion, Checker_Date = m.CheckerDate, CheckerBy = m.CheckedBy }); App_Class.AppCollection.Export(Expmodel, exportData, "Issued Ticket"); } catch { } } model.UsersOption = new SelectList(agentCLApprovedProvider.GetDistributorUsers(model.DistributorID), "AppUserId", "FullName"); model.AgentOption = new SelectList(agentCLApprovedProvider.GetAgentsByDistributorId(model.DistributorID ?? 0), "AgentId", "AgentName", model.AgentId); return(View(model)); }
public ActionResult Index(ExportModel Expmodel, AgentCLApprovedModel model, FormCollection frm, int?pageNo, int?flag) { var ts = (TravelSession)Session["TravelPortalSessionInfo"]; model.AgentCLApprovedListExport = agentCLApprovedProvider.GetAgentCLApprovedList(model.FromDate, model.ToDate, model.UserID, model.DistributorID, model.AgentId); //export 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.AgentCLApprovedListExport.Select(m => new { Brach_Office = m.BranchOfficeName, Distributor = m.DistributorName, Agent_Name = m.AgentName, Agent_Code = m.AgentCode, Currency = m.Currency, Amount = m.Amount, Type = m.Type, Requestion = m.Requestion, Checker_Date = m.CheckerDate, CheckerBy = m.CheckedBy, Comments = m.Comments, Effective_From = m.EffectiveFrom, ExpireOn = m.ExpireOn }); App_Class.AppCollection.Export(Expmodel, exportData, "Agent Credit Limit"); } catch { } } model.UsersOption = new SelectList(defaultProvider.GetUserList(), "AppUserId", "FullName"); model.BranchOfficeOption = new SelectList(branchOfficeManagementProvider.GetAll(), "BranchOfficeId", "BranchOfficeName", model.BranchOfficeId); model.DistributorOption = new SelectList(agentCLApprovedProvider.GetAllDistributorsByBranchOfficeId(model.BranchOfficeId ?? 0), "DistributorId", "DistributorName"); model.AgentOption = new SelectList(agentCLApprovedProvider.GetAgentsByDistributorId(model.DistributorID ?? 0), "AgentId", "AgentName", model.AgentId); return(View(model)); }
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)); }