public IPagedList GetPagedList(string search, long endPointID, long ioTypeID, int pageNumber, int recordsPerPage)
{
var query = from q in db.EndPointIOs
where q.Valu.Contains(search)
select q;
if (endPointID != 0)
{
query = query.Where(i => i.EndPointID == endPointID);
}
if (ioTypeID != 0)
{
query = query.Where(i => i.IOTypeID == ioTypeID);
}
PagedList.IPagedList ios = query.OrderByDescending(i => i.ExecTimeStamp)
.Take(1000).ToList().ToPagedList(pageNumber, recordsPerPage);
//PagedList.IPagedList ios = db.EndPointIOs
// .Where( i => i.Valu.Contains(search)
// //i => i.Endpoint.ID == endPointID
// && (i.EndPointID != null && i.EndPointID == endPointID)
// && (i.IOTypeID != null && i.IOTypeID == ioTypeID)
// //&& i.ExecTimeStamp > fromDate
// //&& i.ExecTimeStamp < toDate
// )
// .OrderByDescending(i => i.TimeStamp).Take(1000).ToList()
// .ToPagedList(pageNumber, recordsPerPage);
return(ios);
}
public PartialViewResult GetListPV(string searchfor = null, int page = 1, int recordsperpage = 2)
{
PagedList.IPagedList devs = db.Devices
.Where(e => searchfor == null || e.Title.Contains(searchfor))
.OrderBy(e => e.Title).ToList()
.ToPagedList(page, Helpers.Configs.validateRecordsPerMaster(recordsperpage));
return(PartialView("_List", devs));
}
public IPagedList GetPagedList(Guid deviceGUID, int pageNumber, int recordsPerPage)
{
PagedList.IPagedList ios = db.DeviceIOs
.Where(i => i.Device.GUID == deviceGUID)
.OrderByDescending(i => i.TimeStamp).Take(100).ToList()
.ToPagedList(pageNumber, recordsPerPage);
return(ios);
}
public IPagedList GetPagedList(long endPointID, int pageNumber, int recordsPerPage)
{
PagedList.IPagedList ios = db.EndPointIOs.Include("IOType")
.Where(i => i.Endpoint.ID == endPointID)
.OrderByDescending(i => i.TimeStamp).Take(100).ToList()
.ToPagedList(pageNumber, recordsPerPage);
return(ios);
}
public IPagedList GetPagedList(string search, Guid endPointGUID, DateTime fromDate, DateTime toDate, int pageNumber, int recordsPerPage)
{
PagedList.IPagedList ios = db.EndPointIOs
.Where(i => i.Endpoint.GUID == endPointGUID &&
i.Valu.Contains(search) &&
i.ExecTimeStamp > fromDate &&
i.ExecTimeStamp < toDate
)
.OrderByDescending(i => i.TimeStamp).Take(1000).ToList()
.ToPagedList(pageNumber, recordsPerPage);
return(ios);
}
public PartialViewResult ListPV(string searchfor = null, int page = 1, int recordsperpage = 0)
{
PagedList.IPagedList ends = uof_repos.repoEndpoints.GetPagedList(searchfor, page, Helpers.Configs.validateRecordsPerMaster(recordsperpage));
return(PartialView("_List", ends));
}
public PartialViewResult LookupListPV(string searchfor = null, int page = 1, int recordsperpage = 0)
{
PagedList.IPagedList ends = uof_repos.repoEndpoints.GetPagedList(searchfor, page, Config.DefaultRecordsPerChild);
return(PartialView("lookup/List", ends));
}
public PartialViewResult LookupPV(string searchfor = null, int page = 1, int recordsperpage = 0)
{
PagedList.IPagedList ends = uof_repos.repoEndpoints.GetPagedList("", 1, 10);
return(PartialView("lookup/Index", ends));
}
public PartialViewResult EndPointCommandsListByEndPointIDPV(string searchfor = null, long EndPointID = 0, int page = 1, int recordsperpage = 0)
{
PagedList.IPagedList cmds = uof_repos.repoEndPointCommands.GetPagedListByEndPointID(searchfor, EndPointID, page, Helpers.Configs.validateRecordsPerMaster(recordsperpage));
return(PartialView("_Details_Commands", cmds));
}
public PartialViewResult AlertUsersListPV(long alertID, string searchfor = null, int page = 1, int recordsperpage = 0)
{
PagedList.IPagedList usrs = uof_repos.repoAlerts.GetUsersPagedList(alertID, searchfor, page, Helpers.Configs.validateRecordsPerMaster(recordsperpage));
return(PartialView("_AlertUsers_List", usrs));
}
public PartialViewResult LookupListPV(string searchfor = null, int page = 1, int recordsperpage = 0)
{
PagedList.IPagedList locs = UnitOfWork_Repositories.repoDevices.GetPagedList(searchfor, page, Config.DefaultRecordsPerChild);
return(PartialView("lookup/List", locs));
}
public PartialViewResult LookupPV(string searchfor = null, int page = 1, int recordsperpage = 0)
{
PagedList.IPagedList locs = UnitOfWork_Repositories.repoDevices.GetPagedList("", 1, 10);
return(PartialView("lookup/Index", locs));
}
public PartialViewResult ListPV(string searchfor = null, int page = 1, int recordsperpage = 0)
{
PagedList.IPagedList tngs = Data.Repositories.UnitOfWork_Repositories.repoThings.GetPagedList(searchfor, page, Helpers.Configs.validateRecordsPerMaster(recordsperpage));
return(PartialView("_List", tngs));
}
public PartialViewResult LookupPV(string searchfor = null, int page = 1, int recordsperpage = 0)
{
PagedList.IPagedList ends = Data.Repositories.UnitOfWork_Repositories.repoThings.GetPagedList("", 1, 10);
return(PartialView("lookup/Index", ends));
}
public PartialViewResult GetListPV(string searchfor = null, int page = 1, int recordsperpage = 2)
{
PagedList.IPagedList devs = uof_repos.repoDevices.GetPagedList(searchfor, page, Helpers.Configs.validateRecordsPerMaster(recordsperpage));
return(PartialView("_List", devs));
}
