//for pagination// public IQueryable <IssuedTicketModel> GetIssuedTicketReportByPagination(IssuedTicketModel m, int pageNo, out int currentPageNo, out int numberOfPages, int?flag) { int pageSize = 30; //(int)AirLines.Helpers.PageSize.JePageSize; int rowCount = m.IssuedTicketList.Count(); numberOfPages = (int)Math.Ceiling((decimal)rowCount / (decimal)pageSize); if (flag != null)//Checking for next/Previous { if (flag == 1) { if (pageNo != 1) //represents previous { pageNo -= 1; } } if (flag == 2) { if (pageNo != numberOfPages)//represents next { pageNo += 1; } } } currentPageNo = pageNo; int rowsToSkip = (pageSize * currentPageNo) - pageSize; IQueryable <IssuedTicketModel> pagingdata = m.IssuedTicketList.Skip(rowsToSkip).Take(pageSize).AsQueryable(); return(pagingdata.AsQueryable()); }
public ActionResult Index(int?pageNo, int?flag) { var ts = SessionStore.GetTravelSession(); // var agentsByBranchOffice = branchOfficeManagementProvider.GetAllAgentsByBranchOfficeId(ts.AgentId); IssuedTicketModel model = new IssuedTicketModel(); model.FromDate = DateTime.Now.AddDays(-15); model.ToDate = DateTime.Now; ViewData["AgentList"] = new SelectList(defaultProvider.GetDistributorList(ts.LoginTypeId), "DistributorId", "DistributorName"); ViewData["AirlineTypes"] = new SelectList(ser.GetAirlineTypesList(), "AirineTypeId", "TypeName"); //var details = ser.ListIssuedTicketReport(model.AgentId, model.FromDate, model.ToDate); //var result = agentsByBranchOffice.SelectMany(b => details.Where(x => x.AgentId == b.AgentId).ToList()); //model.IssuedTicketList = result; var details = ser.ListIssuedTicketReport(model.AgentId, model.FromDate, model.ToDate); var result = details.Where(x => x.BracnOfficeId == ts.LoginTypeId); model.IssuedTicketList = result; return(View(model)); }
/// <summary> /// //////////////////////////////For IndianLcc Report///////////////////////////////////////////////////////////// /// </summary> /// <param name="AgentId"></param> /// <param name="fromdate"></param> /// <param name="todate"></param> /// <returns></returns> public List <IssuedTicketModel> ListIndianLccIssuedTicketReport(int?AgentId, DateTime fromdate, DateTime todate) { var data = ent.Air_GetIssuedTicket(AgentId, fromdate, todate).Where(x => x.ServiceProviderId == 5).ToList(); List <IssuedTicketModel> model = new List <IssuedTicketModel>(); foreach (var item in data) { var IssuedTicketModel = new IssuedTicketModel { PNRId = item.PNRId, PassengerName = item.PassengerName, Sector = item.Sector, TicketStatusName = item.ticketStatusName, GDSReferenceNumber = item.GDSRefrenceNumber, IssuedOn = item.IssuedOn, CreatedBy = item.IssuedBy, AgentName = item.AgentName, FlightDate = item.FlightDate, ServiceProviderName = item.ServiceProviderName, IssuedBy = item.IssuedBy, ServiceProviderETicketUrl = "/Airline/LccTicketManagement", isTicketUploaded = item.isTicketUploaded }; model.Add(IssuedTicketModel); } return(model.OrderByDescending(x => x.BookedOn).ToList()); }
public ActionResult Index(ExportModel Expmodel, IssuedTicketModel model, FormCollection frm, int?pageNo, int?flag) { var ts = (TravelSession)Session["TravelPortalSessionInfo"]; model.IssuedTicketList = ser.ListIssuedTicketReport(model.AgentId, model.FromDate, model.ToDate); //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.IssuedTicketList.Select(m => new { Brach_Office = m.BranchOfficeName, Distributor = m.DistributorName, Agent_Name = m.AgentName, Passenger_Name = m.PassengerName, No_of_Pax = m.NoOfPax, Airline_Code = m.AirlineCode, Sector = m.Sector, GDS_PNR = m.GDSReferenceNumber, Flight_Date = m.FlightDate, Issued_On = m.IssuedOn, Issued_By = m.IssuedBy, Service_Provider = m.ServiceProviderName, Created_By = m.CreatedBy, }); App_Class.AppCollection.Export(Expmodel, exportData, "Issued Ticket"); } catch { } } ViewData["AirlineTypes"] = new SelectList(ser.GetAirlineTypesList(), "AirineTypeId", "TypeName"); ViewData["AgentList"] = new SelectList(defaultProvider.GetAgentList(), "AgentId", "AgentName"); return(View(model)); }
public ActionResult Index() { IssuedTicketModel model = new IssuedTicketModel(); var ts = (TravelSession)Session["TravelPortalSessionInfo"]; model.FromDate = DateTime.Now.AddDays(-15); model.ToDate = DateTime.Now; ViewData["AgentList"] = new SelectList(defaultProvider.GetAgentList(), "AgentId", "AgentName"); ViewData["AirlineTypes"] = new SelectList(ser.GetAirlineTypesList(), "AirineTypeId", "TypeName"); model.IssuedTicketList = ser.ListIndianLccIssuedTicketReport(model.AgentId, model.FromDate, model.ToDate); return(View(model)); }
public List <IssuedTicketModel> ListIssuedTicketReport(int?AgentId, DateTime fromdate, DateTime todate) { var data = ent.Air_GetIssuedTicket(AgentId, fromdate, todate); List <IssuedTicketModel> model = new List <IssuedTicketModel>(); foreach (var item in data.Select(x => x)) { var IssuedTicketModel = new IssuedTicketModel { PNRId = item.PNRId, PassengerName = item.PassengerName, Sector = item.Sector, TicketStatusName = item.ticketStatusName, GDSReferenceNumber = item.GDSRefrenceNumber, IssuedOn = item.IssuedOn, CreatedBy = item.IssuedBy, AgentName = item.AgentName, FlightDate = item.FlightDate, ServiceProviderName = item.ServiceProviderName, IssuedBy = item.IssuedBy, ServiceProviderETicketUrl = (item.ServiceProviderId == 5 || item.ServiceProviderId == 4) ? "/Airline/LccTicketManagement" : "/Airline/TicketManagement", //ServiceProviderETicketUrl = "/Airline/LccTicketManagement", isTicketUploaded = item.isTicketUploaded, AgentId = item.AgentId, BracnOfficeId = item.BranchOfficeId, DistributorId = item.DistributorId, AgentCode = new ATLTravelPortal.Areas.Airline.Repository.BookedTicketReportProvider().GetAgentCodeById(item.AgentId), NoOfPax = item.PaxCount, AirlineCode = item.OperatingAirline }; var distributor = distributorManagementProvider.GetDistributorByDistributorId(item.DistributorId); if (distributor != null) { IssuedTicketModel.DistributorName = distributor.DistributorName + "(" + distributor.DistributorCode + ")"; } var branchOffice = branchOfficeManagementProvider.GetBranchOfficeInfo(item.BranchOfficeId); if (branchOffice != null) { IssuedTicketModel.BranchOfficeName = branchOffice.BranchOfficeName + "(" + branchOffice.BranchOfficeCode + ")"; } model.Add(IssuedTicketModel); } return(model.OrderByDescending(x => x.BookedOn).ToList()); }
//public static void Export(WaitListRequestModel model, IEnumerable<dynamic> exportData, string fileName) //{ // if (model != null && (model.ExportTypeExcel != null || model.ExportTypeWord != null || model.ExportTypeCSV != null || model.ExportTypePdf != null)) // { // if (model.ExportTypeExcel != null) // { // App_Class.AppCollection.ExportCore(exportData, 1, fileName); // } // else if (model.ExportTypeWord != null) // { // App_Class.AppCollection.ExportCore(exportData, 3, fileName); // } // else if (model.ExportTypeCSV != null) // { // App_Class.AppCollection.ExportCore(exportData, 4, fileName); // } // else if (model.ExportTypePdf != null && exportData.Count() > 0) // { // App_Class.AppCollection.ExportCore(exportData, 2, fileName); // } // } //} public static void ExportIssuedTicket(IssuedTicketModel model, IEnumerable <dynamic> exportData, string fileName) { if (model != null && (model.ExportTypeExcel != null || model.ExportTypeWord != null || model.ExportTypeCSV != null || model.ExportTypePdf != null)) { if (model.ExportTypeExcel != null) { App_Class.AppCollection.ExportCore(exportData, 1, fileName); } else if (model.ExportTypeWord != null) { App_Class.AppCollection.ExportCore(exportData, 3, fileName); } else if (model.ExportTypeCSV != null) { App_Class.AppCollection.ExportCore(exportData, 4, fileName); } else if (model.ExportTypePdf != null && exportData.Count() > 0) { App_Class.AppCollection.ExportCore(exportData, 2, fileName); } } }
public ActionResult Index(ExportModel Expmodel, IssuedTicketModel 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.ListIssuedTicketReport(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.IssuedTicketList = result; var result = details.Where(x => x.DistributorId == model.AgentId); model.IssuedTicketList = result; } else { //var result = agentsByBranchOffice.SelectMany(b => details.Where(x => x.AgentId == b.AgentId).ToList()); //model.IssuedTicketList = result; var result = details.Where(x => x.BracnOfficeId == ts.LoginTypeId); model.IssuedTicketList = result; } //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.IssuedTicketList.Select(m => new { Agent_Name = m.AgentName, Passenger_Name = m.PassengerName, No_Of_Pax = m.NoOfPax, Airline_Code = m.AirlineCode, Sector = m.Sector, GDS_PNR = m.GDSReferenceNumber, Flight_Date = m.FlightDate, Issued_On = m.IssuedOn, Issued_By = m.IssuedBy, Service_Provider = m.ServiceProviderName, Created_By = m.CreatedBy, }); App_Class.AppCollection.Export(Expmodel, exportData, "Issued Ticket"); } catch { } } ViewData["AirlineTypes"] = new SelectList(ser.GetAirlineTypesList(), "AirineTypeId", "TypeName"); ViewData["AgentList"] = new SelectList(defaultProvider.GetDistributorList(ts.LoginTypeId), "DistributorId", "DistributorName"); return(View(model)); }