//for pagination//
public IQueryable <BookedTicketModels> GetBookedTicketReportByPagination(BookedTicketModels m, int pageNo, out int currentPageNo, out int numberOfPages, int?flag)
{
int pageSize = 30; //(int)AirLines.Helpers.PageSize.JePageSize;
int rowCount = m.BookedTicketList.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 <BookedTicketModels> pagingdata = m.BookedTicketList.OrderByDescending(x => x.BookedOn).Skip(rowsToSkip).Take(pageSize).AsQueryable();
return(pagingdata.AsQueryable());
}
public ActionResult Issue(long Id, int AgentId, DateTime FromDate, DateTime ToDate, int AType)
{
var ts = SessionStore.GetTravelSession();
BookedTicketModels model = new BookedTicketModels();
ViewData["AirlineTypes"] = new SelectList(ser.GetAirlineTypesList(), "AirineTypeId", "TypeName");
ViewData["AgentList"] = new SelectList(defaultProvider.GetDistributorList(ts.LoginTypeId), "DistributorId", "DistributorName");
ser.Issue(Id, ts.AppUserId);
model.AgentId = AgentId;
model.FromDate = FromDate;
model.ToDate = ToDate;
model.AirlineTypesId = AType;
//var agentsByBranchOffice = branchOfficeManagementProvider.GetAllAgentsByBranchOfficeId(ts.AgentId);
//var details = ser.ListBookedReport(model.AgentId, model.FromDate, model.ToDate);
//var result = agentsByBranchOffice.SelectMany(b => details.Where(x => x.AgentId == b.AgentId).ToList());
var details = ser.ListBookedReport(model.AgentId, model.FromDate, model.ToDate);
var result = details.Where(x => x.BranchOfficeId == ts.LoginTypeId);
model.BookedTicketList = result;
return(View("Index", model));
}
public ActionResult Index(int?pageNo, int?flag)
{
var ts = SessionStore.GetTravelSession();
var agentsByBranchOffice = branchOfficeManagementProvider.GetAllAgentsByBranchOfficeId(ts.LoginTypeId);
ViewData["AgentList"] = new SelectList(defaultProvider.GetDistributorList(ts.LoginTypeId), "DistributorId", "DistributorName");
ViewData["AirlineTypes"] = new SelectList(ser.GetAirlineTypesList(), "AirineTypeId", "TypeName");
BookedTicketModels model = new BookedTicketModels();
model.FromDate = DateTime.Now.AddDays(-15);
model.ToDate = DateTime.Now;
//var details = ser.ListBookedReport(model.AgentId, model.FromDate, model.ToDate);
//var result = agentsByBranchOffice.SelectMany(b => details.Where(x => x.AgentId == b.AgentId).ToList());
//model.BookedTicketList = result;
var details = ser.ListBookedReport(model.AgentId, model.FromDate, model.ToDate);
var result = details.Where(x => x.BranchOfficeId == ts.LoginTypeId);
model.BookedTicketList = result;
return(View(model));
}
public ActionResult Index(int?pageNo, int?flag, DateTime?FromDate, DateTime?ToDate, int?id)
{
ViewData["AgentList"] = new SelectList(defaultProvider.GetAgentList(), "AgentId", "AgentName");
ViewData["AirlineTypes"] = new SelectList(ser.GetAirlineTypesList(), "AirineTypeId", "TypeName");
BookedTicketModels model = new BookedTicketModels();
if (FromDate == null && ToDate == null)
{
model.FromDate = DateTime.Now.AddDays(-15);
model.ToDate = DateTime.Now;
model.BookedTicketList = ser.ListBookedReport(model.AgentId, model.FromDate, model.ToDate);
}
else
{
model.FromDate = FromDate;
model.ToDate = ToDate;
model.BookedTicketList = ser.ListBookedReport(id, model.FromDate, model.ToDate);
}
//int currentPageNo = 0; int numberOfPage = 0;
//if (pageNo == null)
// pageNo = 1;
//model.BookedTicketList = ser.GetBookedTicketReportByPagination(model, pageNo.Value, out currentPageNo, out numberOfPage, flag);
//ViewData["TotalPages"] = numberOfPage;
//ViewData["CurrentPage"] = currentPageNo;
return(View(model));
}
public ActionResult Index(ExportModel Expmodel, BookedTicketModels model, FormCollection frm, int?pageNo, int?flag)
{
var ts = SessionStore.GetTravelSession();
//var agentsByDistributor = distributorManagementProvider.GetAllAgentsByDistributorId(ts.AppUserId);
//var details = ser.ListBookedReport(model.AgentId, model.FromDate, model.ToDate);
//var result = agentsByDistributor.SelectMany(b => details.Where(x => x.AgentId == b.AgentId).ToList());
var details = ser.ListBookedReport(model.AgentId, model.FromDate, model.ToDate);
var result = details.Where(x => x.DistributorId == ts.LoginTypeId);
model.BookedTicketList = result;
model.BookedTicketList = result;
//export
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.BookedTicketList.Select(m => new
{
Agent_Name = m.AgentName,
GDSReferenceNumber = m.GDSRefrenceNumber,
PassengerName = m.PassengerName,
Sector = m.Sector,
Flight_Date = m.FlightDate,
BookedOn = m.BookedOn,
BookedBy = m.BookedBy
});
App_Class.AppCollection.Export(Expmodel, exportData, "Booked Ticket");
}
catch
{
}
}
ViewData["AirlineTypes"] = new SelectList(ser.GetAirlineTypesList(), "AirineTypeId", "TypeName");
//var agents = defaultProvider.GetAgentList().Where(x => x.CreatedBy == ts.AppUserId);
var agents = defaultProvider.GetAgentList().Where(x => x.DistributorId == ts.LoginTypeId);
ViewData["AgentList"] = new SelectList(agents, "AgentId", "AgentName");
return(View(model));
}
public ActionResult Index(ExportModel Expmodel, BookedTicketModels model, FormCollection frm, int?pageNo, int?flag)
{
var ts = (TravelSession)Session["TravelPortalSessionInfo"];
model.BookedTicketList = ser.ListBookedReport(model.AgentId, model.FromDate, model.ToDate);
// model.BookedTicketList = ser.ListBookedReport(model.AgentId, model.FromDate, model.ToDate, model.AirlineTypesId);
//int currentPageNo = 0; int numberOfPage = 0;
//if (pageNo == null)
// pageNo = 1;
//model.BookedTicketList = ser.GetBookedTicketReportByPagination(model, pageNo.Value, out currentPageNo, out numberOfPage, flag);
//ViewData["TotalPages"] = numberOfPage;
//ViewData["CurrentPage"] = currentPageNo;
//export
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.BookedTicketList.Select(m => new
{
Brach_Office = m.BranchOfficeName,
Distributor = m.DistributorName,
Agent_Name = m.AgentName,
GDSReferenceNumber = m.GDSRefrenceNumber,
PassengerName = m.PassengerName,
Sector = m.Sector,
Flight_Date = m.FlightDate,
BookedOn = m.BookedOn,
BookedBy = m.BookedBy
});
App_Class.AppCollection.Export(Expmodel, exportData, "Booked Ticket");
}
catch
{
}
}
ViewData["AirlineTypes"] = new SelectList(ser.GetAirlineTypesList(), "AirineTypeId", "TypeName");
ViewData["AgentList"] = new SelectList(defaultProvider.GetAgentList(), "AgentId", "AgentName");
return(View(model));
}
public ActionResult Issue(long Id, int AgentId, DateTime FromDate, DateTime ToDate, int AType)
{
BookedTicketModels model = new BookedTicketModels();
ViewData["AirlineTypes"] = new SelectList(ser.GetAirlineTypesList(), "AirineTypeId", "TypeName");
ViewData["AgentList"] = new SelectList(defaultProvider.GetAgentList(), "AgentId", "AgentName");
var ts = (TravelSession)Session["TravelPortalSessionInfo"];
ser.Issue(Id, ts.AppUserId);
model.AgentId = AgentId;
model.FromDate = FromDate;
model.ToDate = ToDate;
model.AirlineTypesId = AType;
model.BookedTicketList = ser.ListBookedReport(model.AgentId, model.FromDate, model.ToDate);
return(View("Index", model));
}
public List <BookedTicketModels> ListBookedReport(int?AgentId, DateTime?fromdate, DateTime?todate)
{
var data = ent.Air_GetBookedTicket(AgentId, fromdate, todate);
List <BookedTicketModels> model = new List <BookedTicketModels>();
foreach (var item in data.Select(x => x))
{
var BookedTicketModel = new BookedTicketModels
{
PNRId = item.PNRId,
PassengerName = item.PassengerName,
Sector = item.Sector,
BookedOn = (DateTime)item.BookedOn,
BookedBy = item.BookedBy,
GDSRefrenceNumber = item.GDSRefrenceNumber,
AgentName = item.AgentName,
FlightDate = item.FlightDate,
ServiceProviderId = item.ServiceProviderId,
AgentId = item.AgentId,
DistributorId = item.DistributorId,
BranchOfficeId = item.BranchOfficeId,
AgentCode = GetAgentCodeById(item.AgentId),
};
var distributor = distributorManagementProvider.GetDistributorByDistributorId(item.DistributorId);
if (distributor != null)
{
BookedTicketModel.DistributorName = distributor.DistributorName + "(" + distributor.DistributorCode + ")";
}
var branchOffice = branchOfficeManagementProvider.GetBranchOfficeInfo(item.BranchOfficeId);
if (branchOffice != null)
{
BookedTicketModel.BranchOfficeName = branchOffice.BranchOfficeName + "(" + branchOffice.BranchOfficeCode + ")";
}
model.Add(BookedTicketModel);
}
return(model.OrderByDescending(x => x.BookedOn).ToList());
}
public ActionResult Cancel(long id, string PNR, string PassName, string AgentName, string City, DateTime BookedDate, DateTime FromDate, DateTime ToDate, int AgentId)
{
var ts = SessionStore.GetTravelSession();
BookedTicketModels model = new BookedTicketModels();
PNRsDetailsModel pnrdetails = new PNRsDetailsModel();
pnrdetails.pnrmodel = _provider.GetPNRDetail((int)id);
pnrdetails.pnrsegemnetmodel = _provider.GetPNRSegmentList((int)id);
pnrdetails.pnrpassengermodel = _provider.GetPassengersList((int)id);
_provider.CancelPNR(id, ts.AppUserId);
ser.SendCanceledEmail(id, PNR, PassName, AgentName, City, BookedDate);
model.PNRId = id;
model.GDSRefrenceNumber = PNR;
model.PassengerName = PassName;
model.AgentName = AgentName;
model.Sector = City;
model.BookedOn = BookedDate;
model.FromDate = FromDate;
model.ToDate = ToDate;
model.AgentId = AgentId;
model.BookedTicketList = ser.ListBookedReport(model.AgentId, model.FromDate, model.ToDate);
ViewData["AirlineTypes"] = new SelectList(ser.GetAirlineTypesList(), "AirineTypeId", "TypeName");
ViewData["AgentList"] = new SelectList(defaultProvider.GetAgentList(), "AgentId", "AgentName");
// return View("Index", model);
return(RedirectToAction("Index", new { FromDate = model.FromDate, ToDate = model.ToDate, id = model.AgentId }));
// return RedirectToAction("Index");
}
