public ActionResult Index(ExportModel Expmodel, BookedTicketModels model, FormCollection frm, int?pageNo, int?flag) { var ts = SessionStore.GetTravelSession(); var agentsByBranchOffice = branchOfficeManagementProvider.GetAllAgentsByBranchOfficeId(ts.LoginTypeId); ATLTravelPortal.Areas.Administrator.Repository.DistributorManagementProvider distributorManagentProvider = new ATLTravelPortal.Areas.Administrator.Repository.DistributorManagementProvider(); var details = ser.ListBookedReport(null, model.FromDate, model.ToDate); if (model.AgentId != null) { //int appUserId = branchOfficeManagementProvider.GetAppUserIdByDistributorId(model.AgentId.Value); //var agentsByDistributor = distributorManagentProvider.GetAllAgentsByDistributorId(appUserId); //var result = agentsByDistributor.SelectMany(b => details.Where(x => x.AgentId == b.AgentId).ToList()); //model.BookedTicketList = result; var result = details.Where(x => x.DistributorId == model.AgentId); model.BookedTicketList = result; } else { //var result = agentsByBranchOffice.SelectMany(b => details.Where(x => x.AgentId == b.AgentId).ToList()); //model.BookedTicketList = result; var result = details.Where(x => x.BranchOfficeId == ts.LoginTypeId); model.BookedTicketList = result; } //export 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.BookedTicketList.Select(m => new { Agent_Name = m.AgentName, GDSReferenceNumber = m.GDSRefrenceNumber, PassengerName = m.PassengerName, Sector = m.Sector, Flight_Date = m.FlightDate, BookedOn = m.BookedOn, BookedBy = m.BookedBy }); App_Class.AppCollection.Export(Expmodel, exportData, "Booked Ticket"); } catch { } } ViewData["AirlineTypes"] = new SelectList(ser.GetAirlineTypesList(), "AirineTypeId", "TypeName"); ViewData["AgentList"] = new SelectList(defaultProvider.GetDistributorList(ts.LoginTypeId), "DistributorId", "DistributorName"); return(View(model)); }
public ActionResult Index(ExportModel Expmodel, PendingBookingModel model, FormCollection frm, int?page) { var ts = SessionStore.GetTravelSession(); int defaultPageSize = 30; int currentPageIndex = page.HasValue ? page.Value : 1; var agentsByBranchOffice = branchOfficeManagementProvider.GetAllAgentsByBranchOfficeId(ts.LoginTypeId); ATLTravelPortal.Areas.Administrator.Repository.DistributorManagementProvider distributorManagentProvider = new ATLTravelPortal.Areas.Administrator.Repository.DistributorManagementProvider(); var details = ser.ListPendingBookintReport(null, model.FromDate, model.ToDate); if (model.AgentId != null) { //int appUserId = branchOfficeManagementProvider.GetAppUserIdByDistributorId(model.AgentId.Value); //var agentsByDistributor = distributorManagentProvider.GetAllAgentsByDistributorId(appUserId); //var result = agentsByDistributor.SelectMany(b => details.Where(x => x.AgentId == b.AgentId).ToList()); //model.PendingBookingList = result.ToPagedList(currentPageIndex, defaultPageSize); var result = details.Where(x => x.DistributorId == model.AgentId); model.PendingBookingList = result.ToPagedList(currentPageIndex, defaultPageSize); } else { //var result = agentsByBranchOffice.SelectMany(b => details.Where(x => x.AgentId == b.AgentId).ToList()); //model.PendingBookingList = result.ToPagedList(currentPageIndex, defaultPageSize); var result = details.Where(x => x.BrachOfficeId == ts.LoginTypeId); model.PendingBookingList = result.ToPagedList(currentPageIndex, defaultPageSize); } //export bkt.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.PendingBookingList.Select(m => new { Agent = m.AgentName, Passenger_Name = m.PassegerName, Sector = m.Sector, GDS_PNR = m.GDSReferenceNumber, Flight_Date = m.FlightDate, Booked_On = TimeFormat.DateFormat(m.BookedOn.ToString()), Booked_by = m.BookedBy }); App_Class.AppCollection.Export(Expmodel, exportData, "PendingBooking "); } catch (Exception ex) { ATLTravelPortal.Utility.ErrorLogging.LogException(ex); TempData["ActionResponse"] = ex.Message; } } ViewData["Agents"] = new SelectList(defaultProvider.GetDistributorList(ts.LoginTypeId), "DistributorId", "DistributorName"); return(View(model)); }