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);
}
