public ActionResult Index() { PNRReportModel model = new PNRReportModel(); var viewModel = GetViewModelList(model); return(View(viewModel)); }
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 IEnumerable <PNRReportModel> GetAirRetrievePNRInfoList(PNRReportModel m) { m.PNRId = (m.PNRId.ToString() == "")? null : m.PNRId; m.AgentId = (m.AgentId.ToString() == "") ? null : m.AgentId; m.GDSRefrenceNumber = string.IsNullOrEmpty(m.GDSRefrenceNumber) ? null : m.GDSRefrenceNumber; m.FullName = string.IsNullOrEmpty(m.FullName) ? null : m.FullName; var result = _ent.Air_RetrievePNRInfo(m.PNRId, m.AgentId, m.GDSRefrenceNumber, m.FullName); List <PNRReportModel> model = new List <PNRReportModel>(); foreach (var item in result) { PNRReportModel obj = new PNRReportModel { AgentName = item.AgentName, FullName = item.FullName, Address = item.Address, CreatedDate = item.CreatedDate, GDSRefrenceNumber = item.GDSRefrenceNumber, ServiceProviderName = item.GDSRefrenceNumber, AirlineCode = item.AirlineCode, Sector = item.Sector, Class = item.Class, BaseFare = item.BaseFare, SurCharge = item.SurCharge, CommissionOnBF = item.CommissionOnBF, ServiceCharge = item.ServiceCharge, TotalTax = item.TotalTax, TotalFare = item.TotalFare, ticketStatusName = item.ticketStatusName, }; model.Add(obj); } return(model.AsEnumerable()); }
private PNRReportModel GetViewModelList(PNRReportModel model) { _modObj.ddlAgentIdList = defaultProvider.GetAgentSelectOptionList(); _modObj.PNRReportList = _provider.GetAirRetrievePNRInfoList(model); return(_modObj); }