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