//for pagination//
public IQueryable <WaitListRequestModel> GetWaitListRequestByPagination(WaitListRequestModel m, int pageNo, out int currentPageNo, out int numberOfPages, int?flag)
{
int pageSize = 30; //(int)AirLines.Helpers.PageSize.JePageSize;
int rowCount = m.WaitListRequestList.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 <WaitListRequestModel> pagingdata = m.WaitListRequestList.Skip(rowsToSkip).Take(pageSize).AsQueryable();
return(pagingdata.AsQueryable());
}
public ActionResult Index(ExportModel Expmodel, WaitListRequestModel model, FormCollection frm, int?pageNo, int?flag)
{
model.WaitListRequestList = ser.WaitListRequestList();
int currentPageNo = 0; int numberOfPage = 0;
if (pageNo == null)
{
pageNo = 1;
}
model.WaitListRequestList = ser.GetWaitListRequestByPagination(model, pageNo.Value, out currentPageNo, out numberOfPage, flag);
ViewData["TotalPages"] = numberOfPage;
ViewData["CurrentPage"] = currentPageNo;
//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 = model.WaitListRequestList.Select(m => new
{
GDSReferenceNumber = m.GDSRefrenceNumber,
PassengerName = m.PassengerName,
Sector = m.Sector,
BookedOn = m.BookedOn,
BookedBy = m.BookedBy
});
App_Class.AppCollection.Export(Expmodel, exportData, "WaitListRequest");
}
catch
{
}
}
return(View());
}
public ActionResult Confirm(long Id)
{
WaitListRequestModel model = new WaitListRequestModel();
var ts = (TravelSession)Session["TravelPortalSessionInfo"];
ser.Confirm(Id, ts.AppUserId);
model.WaitListRequestList = ser.WaitListRequestList();
return(View("Index", model));
}
public ActionResult Index(int?pageNo, int?flag)
{
WaitListRequestModel model = new WaitListRequestModel();
model.WaitListRequestList = ser.WaitListRequestList();
int currentPageNo = 0; int numberOfPage = 0;
if (pageNo == null)
{
pageNo = 1;
}
model.WaitListRequestList = ser.GetWaitListRequestByPagination(model, pageNo.Value, out currentPageNo, out numberOfPage, flag);
ViewData["TotalPages"] = numberOfPage;
ViewData["CurrentPage"] = currentPageNo;
return(View(model));
}
public List <WaitListRequestModel> WaitListRequestList()
{
var data = ent.Air_GetWaitListRequest(null);
List <WaitListRequestModel> model = new List <WaitListRequestModel>();
foreach (var item in data.Select(x => x))
{
var WaitListRequestModel = new WaitListRequestModel
{
PNRId = item.PNRId,
PassengerName = item.PassengerName,
Sector = item.Sector,
BookedOn = item.BookedOn.Value,
BookedBy = item.BookedBy,
GDSRefrenceNumber = item.GDSRefrenceNumber,
TicketStatusName = item.ticketStatusName,
AgentName = item.AgentName
};
model.Add(WaitListRequestModel);
}
return(model);
}