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 Edit(int Id) { MakePaymentModel model = new MakePaymentModel(); model = ser.GetMakePaymentDetail(Id); model.CashGivenToDate = TimeFormat.DateFormat(model.CashGivenToDepositDate.ToString()); model.ChequeDate = TimeFormat.DateFormat(model.ChequeIssueDate.ToString()); model.DraftDate = TimeFormat.DateFormat(model.DraftDepositDate.ToString()); model.CashDate = TimeFormat.DateFormat(model.CashDepositDate.ToString()); model.BankTransferDate = TimeFormat.DateFormat(model.BankTransferDepositDate.ToString()); model.RTGSDate = TimeFormat.DateFormat(model.RTGSDepositDate.ToString()); ViewData["Bank"] = new SelectList(ser.AllBank(), "BankId", "BankName"); ViewData["BankBranch"] = new SelectList(ser.AllBankBranch(model.BankId), "BankBranchId", "BranchName"); ViewData["ChequeDrawnOnBank"] = new SelectList(ser.GetBank(), "BankId", "BankName"); model.ChequeCurrencyList = new SelectList(ser.GetCurrenciesList(), "Value", "Text"); model.DraftCurrencyList = new SelectList(ser.GetCurrenciesList(), "Value", "Text"); model.CashCurrencyList = new SelectList(ser.GetCurrenciesList(), "Value", "Text"); model.BankTransferCurrencyList = new SelectList(ser.GetCurrenciesList(), "Value", "Text"); model.RTGSCurrencyList = new SelectList(ser.GetCurrenciesList(), "Value", "Text"); model.CashGivenToCurrencyList = new SelectList(ser.GetCurrenciesList(), "Value", "Text"); model.SalesAgentList = ser.GetAllGetSalesAgentList(); model.AgentList = new CreditLimitProvider().GetAllAgentList(); return(View(model)); }
public ActionResult Index(ExportModel Expmodel, PendingBookingModel model, FormCollection frm, int?page) { int defaultPageSize = 30; int currentPageIndex = page.HasValue ? page.Value : 1; // model.PendingBookingList model.PendingBookingList = ser.ListPendingBookintReport(model.AgentId, model.FromDate, model.ToDate).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 { Brach_Office = m.BranchOfficeName, Distributor = m.DistributorName, 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(ser.GetAgentsList(), "AgentId", "AgentName"); return(View(model)); }
public ActionResult Index(ExportModel Expmodel, PNRReportModel model, FormCollection frm) { var ts = (TravelSession)Session["TravelPortalSessionInfo"]; _modObj.PNRReportList = _provider.GetAirRetrievePNRInfoList(model); //export 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 = _modObj.PNRReportList.Select(m => new { Booked_Date = TimeFormat.DateFormat(m.CreatedDate.ToString()), GDS_PNR = m.GDSRefrenceNumber, Airlines_PNR = m.ServiceProviderName, Airline = m.AirlineCode, Sector = m.Sector, Class = m.Class, Fare = m.BaseFare, Tax = m.TotalTax, Comm = m.CommissionOnBF, Service_Charge = m.ServiceCharge, Total_Fare = m.TotalFare, Status = m.ticketStatusName }); App_Class.AppCollection.Export(Expmodel, exportData, "RetrievePNR"); } catch { } } GetViewModelList(_modObj); return(View(_modObj)); }
public ActionResult Index(ExportModel Expmodel, AgentReportModel model, FormCollection frm, int?page) { int currentPageIndex = 1; //page.HasValue ? page.Value : 1; int defaultPageSize = 1000000; //30; model.AgentDetailList = ser.GetAgentInfo().ToPagedList(currentPageIndex, defaultPageSize); //export BookedTicket.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.AgentDetailList.Select(m => new { Branch_Name = m.BranchName, Distributor_Name = m.DistributorName, Agent_Name = m.AgentName, Agent_Code = m.AgentCode, MEs_Name = m.MEsName, Address = m.Address, Email = m.Email, Phone = m.Phone, Mobile = m.mobile, Zone_Name = m.zonename, District_Name = m.districtname, Signup_By = m.signupby, Signup_Date = TimeFormat.DateFormat(m.SignupDate.ToString()), Reg_By = m.Type == -1 ? "Admin" : "Self" }); App_Class.AppCollection.Export(Expmodel, exportData, "Agent Information"); } catch { } } return(View(model)); }
public ActionResult Index(ExportModel Expmodel, SectorSalesModel model, FormCollection frm, int?pageNo, int?flag) { model.SectorSalesList = ser.SectorSalesList(model.FromDate, model.ToDate, model.CurrencyId); //export 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.SectorSalesList.Select(m => new { MPNRId = m.MPNRId, GDS_Ref = m.GDSReferenceNumber, Service_Provider = m.ServiceProviderName, Airline = m.AirlineCode, Sector = m.Sector, Class = m.Class, Ticket_Number = m.TicketNumber, Admin_Amount = m.AdminAmount, Agent_Amount = m.AgentAmount, Branch_Amount = m.BranchAmount, Distributor_Amount = m.DistributorAmount, Booked_Date = TimeFormat.DateFormat(m.CreatedDate.ToString()), }); App_Class.AppCollection.Export(Expmodel, exportData, "SectorSales "); } catch { } } ViewData["Currencies"] = new SelectList(ser.GetCurrenciesList(), "CurrencyId", "CurrencyCode"); return(View(model)); }
public ActionResult Index(ExportModel Expmodel, TopUpModel model, FormCollection frm) { model.ddlServiceProviderList = ser.ddlServiceProviderList(); model.ddlTypeList = ser.ddlTypeList(); model.ddlStatusList = ser.ddlStatusList(); model.ListTopUp = ser.List(model); 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.ListTopUp.Select(m => new { Tran_Id = m.SalesTranId, Date = TimeFormat.DateFormat(m.SalesDate.ToString()), Mobile_No = m.MobileNo, Amount = m.RechargeAmount, }); App_Class.AppCollection.Export(Expmodel, exportData, "Mobile TopUp "); } catch { } } return(View(model)); }
public ActionResult Index(ExportModel Expmodel, B2CUserManagementModel model, FormCollection frm) { model.ListB2CUsers = ser.GetAllB2CUserList().ToPagedList(1, int.MaxValue); //export bktctrl.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.ListB2CUsers.Select(m => new { Name = m.FullName, User_Name = m.UserName, Email = m.Email, Address = m.Address, Mobile = m.Mobile, Phone = m.Phone, Created_Date = TimeFormat.DateFormat(m.CreatedDate.ToString()) }); App_Class.AppCollection.Export(Expmodel, exportData, "User_List"); } catch { } } return(View(model)); }
public void SendCanceledEmail(long Pnrid, string PNR, string PassengerName, string AgentName, string City, DateTime BookedOn) { try { int agentid = ent.PNRs.Where(x => x.PNRId == Pnrid).Select(y => y.AgentId).FirstOrDefault(); string agentemailaddress = ent.Agents.Where(x => x.AgentId == agentid).Select(y => y.Email).FirstOrDefault(); string subject = "Cancellation Notification:" + " " + PNR + " " + PassengerName; StringBuilder st = new StringBuilder(); st.AppendFormat(@"<p> Dear {0} ,<br /> <br /> The following reservation has been cancelled by the airline:</p> <div style='background-color: #521831; padding: 0.5% 2%; font-family: Arial, Helvetica, sans-serif; width: 94%; margin: 0px 1%; text-align: center; color: #fff;'> <h2> Ticket Cancel Notification</h2> <table width='100%' cellpadding='' cellspacing='' style='border: 1px solid #fff; background-color: #eaeaea; text-align: left; color: #000;'> <tbody> <tr> <td> <strong>Agency</strong></td> <td> {1} </td> </tr> <tr> <td> <strong>PNR Name</strong> </td> <td> {2} </td> </tr> <tr> <td> <strong>Sector</strong> </td> <td> {3} </td> </tr> <tr> <td> <strong>Booking Ref. No</strong> </td> <td> {4} </td> </tr> <tr> <td> <strong>Booked Date</strong></td> <td> {5}</td> </tr> </tbody> </table> </div> ", AgentName, AgentName, PassengerName, City, PNR, TimeFormat.DateFormat(BookedOn.ToString())); ent.CORE_SendEmails(agentemailaddress, string.Empty, string.Empty, subject, st.ToString(), "HTML", "HIGH"); } catch { } }
public ActionResult Index1(ExportModel Expmodel, SalesReportModel model, FormCollection frm, int?pageNo, int?flag) { var ts = SessionStore.GetTravelSession(); var agentId = frm["SalesAgentId"]; if (agentId != "") { model.AgentId = int.Parse(frm["SalesAgentId"]); } else { model.AgentId = null; } var fromdate = frm["SalesFromDate"]; if (fromdate != "") { model.FromDate = DateTime.Parse(frm["SalesFromDate"]); } else { model.FromDate = null; } var todate = frm["SalesToDate"]; if (todate != "") { model.ToDate = DateTime.Parse(frm["SalesToDate"]); } else { model.ToDate = null; } var currency = frm["SalesCurrency"]; if (currency != "") { model.Currency = int.Parse(frm["SalesCurrency"]); } else { model.Currency = null; } var detailsSummary = ser.GetSalesReportSummary(model.AgentId, model.FromDate, model.ToDate, model.AirlineTypesId, model.Currency); model.salesReportSummary = detailsSummary; var details = ser.GetSalesReportSummaryDetails(model.AgentId, model.FromDate, model.ToDate, model.AirlineTypesId, model.Currency); model.salesReportDetails = details; //export ctrlBKT.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.salesReportDetails.Select(m => new { Code = m.AirlineCode, Agent_Name = m.AgentName, Ticket_No = m.TicketNumber, Issued_Date = TimeFormat.DateFormat(m.IssuedDate.ToString()), Cash = m.Cash, Tax = m.Tax, Comm = m.Commission, Payable = m.Payable, Service_Provider = m.serviceProviderName, Issued_From = m.issueFrom }); App_Class.AppCollection.Export(Expmodel, exportData, "SalesReport"); } catch (Exception ex) { TempData["ActionResponse"] = ex.Message; } } var agents = defaultProvider.GetAgentList().Where(x => x.CreatedBy == ts.AppUserId); ViewData["AgentList"] = new SelectList(agents, "AgentId", "AgentName"); ViewData["AirlineTypes"] = new SelectList(ser.GetAirlineTypesList(), "AirineTypeId", "TypeName"); 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)); }
public ActionResult Index1(ExportModel Expmodel, SalesReportModel model, FormCollection frm, int?pageNo, int?flag) { var ts = (TravelSession)Session["TravelPortalSessionInfo"]; var agentId = frm["SalesAgentId"]; if (agentId != "") { model.AgentId = int.Parse(frm["SalesAgentId"]); } else { model.AgentId = null; } var fromdate = frm["SalesFromDate"]; if (fromdate != "") { model.FromDate = DateTime.Parse(frm["SalesFromDate"]); } else { model.FromDate = null; } var todate = frm["SalesToDate"]; if (todate != "") { model.ToDate = DateTime.Parse(frm["SalesToDate"]); } else { model.ToDate = null; } var currency = frm["SalesCurrency"]; if (currency != "") { model.Currency = int.Parse(frm["SalesCurrency"]); } else { model.Currency = null; } model.salesReportSummary = ser.GetIndianLccSalesReport(model.AgentId, model.FromDate, model.ToDate, model.AirlineTypesId, 3); model.salesReportDetails = ser.GetIndianLccSalesReportDetails(model.AgentId, model.FromDate, model.ToDate, model.AirlineTypesId, 3); //export ctrlBKT.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.salesReportDetails.Select(m => new { Code = m.AirlineCode, Name = m.AgentName, Issued_Date = TimeFormat.DateFormat(m.IssuedDate.ToString()), Cash = m.Cash, Tax = m.Tax, Comm = m.Commission, Payable = m.Payable, }); App_Class.AppCollection.Export(Expmodel, exportData, "SalesReport"); } catch (Exception ex) { TempData["ActionResponse"] = ex.Message; } } ViewData["AgentList"] = new SelectList(defaultProvider.GetAgentList(), "AgentId", "AgentName"); ViewData["AirlineTypes"] = new SelectList(ser.GetAirlineTypesList(), "AirineTypeId", "TypeName"); return(View(model)); }
public ActionResult Index(ExportModel Expmodel, PendingBookingModel model, FormCollection frm, int?page) { int defaultPageSize = 30; int currentPageIndex = page.HasValue ? page.Value : 1; var ts = SessionStore.GetTravelSession(); //var agentsByDistributor = distributorManagementProvider.GetAllAgentsByDistributorId(ts.AppUserId); //var details = ser.ListPendingBookintReport(model.AgentId, model.FromDate, model.ToDate); //var result = agentsByDistributor.SelectMany(b => details.Where(x => x.AgentId == b.AgentId).ToList()); var details = ser.ListPendingBookintReport(model.AgentId, model.FromDate, model.ToDate); var result = details.Where(x => x.DistributorId == 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; } } //var agents = ser.GetAgentsList().Where(x => x.CreatedBy == ts.AppUserId); var agents = ser.GetAgentsList().Where(x => x.DistributorId == ts.LoginTypeId); ViewData["Agents"] = new SelectList(agents, "AgentId", "AgentName"); return(View(model)); }