//for pagination//
public IQueryable <SectorSalesModel> GetSectorSalesReportByPagination(SectorSalesModel m, int pageNo, out int currentPageNo, out int numberOfPages, int?flag)
{
int pageSize = 30; //(int)AirLines.Helpers.PageSize.JePageSize;
int rowCount = m.SectorSalesList.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 <SectorSalesModel> pagingdata = m.SectorSalesList.OrderByDescending(x => x.CreatedDate).Skip(rowsToSkip).Take(pageSize).AsQueryable();
return(pagingdata.AsQueryable());
}
public List <SectorSalesModel> SectorSalesList(DateTime fromdate, DateTime todate, int?CurrencyId)
{
var data = ent.Air_GetSectorSales(fromdate, todate, CurrencyId);
List <SectorSalesModel> model = new List <SectorSalesModel>();
foreach (var item in data.Select(x => x))
{
var SectorSalesModel = new SectorSalesModel
{
MPNRId = item.MPNRId,
AgentId = item.AgentId,
BranchOfficeId = item.BranchOfficeId,
DistributorId = item.DistributorId,
CreatedDate = item.CreatedDate,
GDSReferenceNumber = item.GDSRefrenceNumber,
ServiceProviderName = item.ServiceProviderName,
AirlineCode = item.AirlineCode,
Sector = item.Sector,
Class = item.Class,
TicketNumber = item.TicketNumber,
AdminAmount = item.AdminAmount,
AgentAmount = item.AgentAmount,
BranchAmount = item.BranchAmount,
DistributorAmount = item.DistributorAmount,
};
model.Add(SectorSalesModel);
}
return(model.OrderByDescending(x => x.CreatedDate).ToList());
}
public ActionResult Index(int?pageNo, int?flag)
{
var ts = (TravelSession)Session["TravelPortalSessionInfo"];
ViewData["Currencies"] = new SelectList(ser.GetCurrenciesList(), "CurrencyId", "CurrencyCode");
SectorSalesModel model = new SectorSalesModel();
model.FromDate = DateTime.Now.AddDays(-15);
model.ToDate = DateTime.Now;
return(View(model));
}
public ActionResult Index(ExportModel Expmodel, SectorSalesModel model, FormCollection frm, int?pageNo, int?flag)
{
model.SectorSalesList = ser.SectorSalesList(model.FromDate, model.ToDate, model.CurrencyId);
//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.SectorSalesList.Select(m => new
{
MPNRId = m.MPNRId,
GDS_Ref = m.GDSReferenceNumber,
Service_Provider = m.ServiceProviderName,
Airline = m.AirlineCode,
Sector = m.Sector,
Class = m.Class,
Ticket_Number = m.TicketNumber,
Admin_Amount = m.AdminAmount,
Agent_Amount = m.AgentAmount,
Branch_Amount = m.BranchAmount,
Distributor_Amount = m.DistributorAmount,
Booked_Date = TimeFormat.DateFormat(m.CreatedDate.ToString()),
});
App_Class.AppCollection.Export(Expmodel, exportData, "SectorSales ");
}
catch
{
}
}
ViewData["Currencies"] = new SelectList(ser.GetCurrenciesList(), "CurrencyId", "CurrencyCode");
return(View(model));
}
