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