public GridViewDataSetLoadedData <ValorLongitudViewModel> GetDataByLongitud(IGridViewDataSetLoadOptions gridViewDataSetOptions)
{
// var queryable = GetQueryable(15);
var queryable = GetQueryableDetailListLongitudes();
return(queryable.GetDataFromQueryable(gridViewDataSetOptions));
}
public GridViewDataSetLoadedData <ReportGeneralViewModel> GetData(IGridViewDataSetLoadOptions gridViewDataSetOptions)
{
// var queryable = GetQueryable(15);
var queryable = GetQueryableApoyosAllApoyos(Ciudad_Id, Empresa_Id).Result;
return(queryable.GetDataFromQueryable(gridViewDataSetOptions));
}
private GridViewDataSetLoadedData <CustomerData> GetData(IGridViewDataSetLoadOptions gridViewDataSetLoadOptions)
{
var queryable = FakeDb();
// NOTE: Apply Pagign and Sorting options.
return(queryable.GetDataFromQueryable(gridViewDataSetLoadOptions));
}
public GridViewDataSetLoadedData <ElementoReportViewModel> GetDataElementos(IGridViewDataSetLoadOptions gridViewDataSetOptions)
{
// var queryable = GetQueryable(15);
var queryable = GetQueryableElementos().Result;
return(queryable.GetDataFromQueryable(gridViewDataSetOptions));
}
private GridViewDataSetLoadedData <Data> GetData(IGridViewDataSetLoadOptions gridViewDataSetLoadOptions)
{
CallDelegateCounter++;
var queryable = TestDB(ItemsCount);
return(queryable.GetDataFromQueryable(gridViewDataSetLoadOptions));
}
public GridViewDataSetLoadedData <VideoListDTO> GetAllVideos(IGridViewDataSetLoadOptions gridViewDataSetLoadOptions, bool loadmobile, int specific, string culture)
{
using (var db = new myDb())
{
IQueryable <Video> query = db.Videos.Where(x => x.AllowMain == true);
if (specific == 0) //nejnovejsi
{
query = query.OrderByDescending(x => x.Id);
if (loadmobile) //videa pouze pro mobil
{
query = query.Where(p => p.Url.Contains("pornhub"));
}
}
else //nejsledovanejsi videa
{
query = query.OrderByDescending(x => x.Views);
if (loadmobile) // nejsledovanejsi videa pouze pro mobil
{
query = query.Where(p => p.Url.Contains("pornhub"));
}
}
IQueryable <VideoListDTO> finalquery;
if (culture == "cs-CZ")
{
finalquery = query // finalni poskladana query
.Select(a => new VideoListDTO
{
Id = a.Id,
Img = "Admin/Previews/" + a.Img,
Title = a.Title,
Duration = a.Duration,
HD = a.HD,
Preview = "Admin/Previews/" + a.Preview,
Views = a.Views,
TimeStamp = a.TimeStamp
}).AsQueryable();
}
else
{
finalquery = query // finalni poskladana query
.Select(a => new VideoListDTO
{
Id = a.Id,
Img = "Admin/Previews/" + a.Img,
Title = a.Title_en,
Duration = a.Duration,
HD = a.HD,
Preview = "Admin/Previews/" + a.Preview,
Views = a.Views,
TimeStamp = a.TimeStamp
}).AsQueryable();
}
return(finalquery.GetDataFromQueryable(gridViewDataSetLoadOptions));
}
}
public GridViewDataSetLoadedData <VideoListDTO> GetVideosByCategory(IGridViewDataSetLoadOptions gridViewDataSetLoadOptions, int Id, int specific, bool loadmobile, string culture)
{
using (var db = new myDb())
{
IQueryable <Video> query = db.Videos.Where(x => x.Categories.Select(p => p.Id).Contains(Id));
if (specific == 0) //nejnovejsi
{
query = query.OrderByDescending(x => x.Id);
if (loadmobile) //videa pouze pro mobil
{
query = query.Where(p => p.Url.Contains("pornhub"));
}
}
else //nejsledovanejsi videa
{
query = query.OrderByDescending(x => x.Views);
if (loadmobile) // nejsledovanejsi videa pouze pro mobil
{
query = query.Where(p => p.Url.Contains("pornhub"));
}
}
IQueryable <VideoListDTO> finalquery;
if (culture == "cs-CZ")
{
finalquery = query.Select(x => new VideoListDTO()
{
Id = x.Id,
Img = "Admin/Previews/" + x.Img,
Title = x.Title,
Duration = x.Duration,
HD = x.HD,
Preview = "Admin/Previews/" + x.Preview,
}).AsQueryable();
return(finalquery.GetDataFromQueryable(gridViewDataSetLoadOptions));
}
else
{
finalquery = query.Select(x => new VideoListDTO()
{
Id = x.Id,
Img = "Admin/Previews/" + x.Img,
Title = x.Title_en,
Duration = x.Duration,
HD = x.HD,
Preview = "Admin/Previews/" + x.Preview,
}).AsQueryable();
return(finalquery.GetDataFromQueryable(gridViewDataSetLoadOptions));
}
}
}
public GridViewDataSetLoadedData <CategoryDTO> GetAllCategories(IGridViewDataSetLoadOptions gridViewDataSetLoadOptions, string username)
{
using (var db = new myDb())
{
IQueryable <Category> query = db.Categories;
if (username != "kelt" && username != "brych")
{
query = query.Where(x => x.User.Username == username);
}
var finalQuery = query
.Select(p => new CategoryDTO()
{
Id = p.Id,
Name = p.Name,
Name_en = p.Name_en
}).OrderByDescending(a => a.Id).AsQueryable();
return(finalQuery.GetDataFromQueryable(gridViewDataSetLoadOptions));
}
}
public GridViewDataSetLoadedData <ElementoReportViewModel> GetData(IGridViewDataSetLoadOptions gridViewDataSetOptions)
{
if (Limpiar)
{
var queryable = GetQueryableElementosEmpty();
return(queryable.GetDataFromQueryable(gridViewDataSetOptions));
}
if (ReportType == "General")
{
var queryable = GetQueryableElementosGeneral();
return(queryable.GetDataFromQueryable(gridViewDataSetOptions));
}
else
{
var queryable = GetQueryableElementosDetallado();
return(queryable.GetDataFromQueryable(gridViewDataSetOptions));
}
}
public GridViewDataSetLoadedData <VideoListAdminDTO> GetAllVideos(IGridViewDataSetLoadOptions gridViewDataSetLoadOptions, string username)
{
using (var db = new myDb())
{
IQueryable <Video> query = db.Videos;
if (username != "kelt" && username != "brych")
{
query = query.Where(x => x.User.Username == username);
}
var finalQuery = query.Select(x => new VideoListAdminDTO()
{
Id = x.Id,
Img = "Admin/Previews/" + x.Img,
Title = x.Title,
Preview = "Admin/Previews/" + x.Preview,
}).OrderByDescending(p => p.Id).AsQueryable();
return(finalQuery.GetDataFromQueryable(gridViewDataSetLoadOptions));
}
}
public GridViewDataSetLoadedData <Customer> GetData(IGridViewDataSetLoadOptions gridViewDataSetOptions)
{
var queryable = GetQueryable(15);
return(queryable.GetDataFromQueryable(gridViewDataSetOptions));
}
public static GridViewDataSetLoadedData <T> GetDataFromQueryable <T>(this IQueryable <T> queryable, IGridViewDataSetLoadOptions options)
{
return((GridViewDataSetLoadedData <T>)options.GetDataFromQueryable(queryable));
}
private async Task <GridViewDataSetLoadedData <Data> > GetDataAsync(IGridViewDataSetLoadOptions gridViewDataSetLoadOptions)
{
var queryable = FakeDB(ItemsInDatabaseCount);
return(await Task.Run(() => queryable.GetDataFromQueryable(gridViewDataSetLoadOptions)));
}
private GridViewDataSetLoadedData <Data> GetData(IGridViewDataSetLoadOptions gridViewDataSetLoadOptions)
{
var queryable = FakeDB(ItemsInDatabaseCount);
return(queryable.GetDataFromQueryable(gridViewDataSetLoadOptions));
}
public GridViewDataSetLoadedData <Empresa> GetData2(IGridViewDataSetLoadOptions gridViewDataSetOptions)
{
var queryable2 = GetQueryable2(15).Result;
return(queryable2.GetDataFromQueryable(gridViewDataSetOptions));
}
public GridViewDataSetLoadedData <VideoListDTO> GetSearchResult(IGridViewDataSetLoadOptions gridViewDataSetLoadOptions, string search, bool loadmomobile, int specific, string culture)
{
using (var db = new myDb())
{
IQueryable <Video> query = db.Videos;
if (specific == 0) // nejnovejsi
{
query = query.OrderByDescending(x => x.Id);
if (loadmomobile) // videa pouze pro mobil
{
query = query.Where(p => p.Url.Contains("pornhub"));
}
}
else // nejsledovanejsi
{
query = query.OrderByDescending(x => x.Views);
if (loadmomobile) // nejsledovanejsi videa pouze pro mobil
{
query = query.Where(p => p.Url.Contains("pornhub"));
}
}
IQueryable <VideoListDTO> finalquery;
if (culture == "cs-CZ")
{
query = query.Where(x => x.Title
.Contains(search) || x.Categories
.Any(p => p.Name.Contains(search)) || x.Categories
.Any(o => o.Name_en.Contains(search)));
finalquery = query // finalni poskladana query
.Select(a => new VideoListDTO
{
Id = a.Id,
Img = "Admin/Previews/" + a.Img,
Title = a.Title,
Duration = a.Duration,
HD = a.HD,
Preview = "Admin/Previews/" + a.Preview,
Views = a.Views
}).AsQueryable();
}
else
{
query = query.Where(x => x.Title_en
.Contains(search) || x.Categories
.Any(p => p.Name.Contains(search)) || x.Categories
.Any(o => o.Name_en.Contains(search)));
finalquery = query // finalni poskladana query
.Select(a => new VideoListDTO
{
Id = a.Id,
Img = "Admin/Previews/" + a.Img,
Title = a.Title_en,
Duration = a.Duration,
HD = a.HD,
Preview = "Admin/Previews/" + a.Preview,
Views = a.Views
}).AsQueryable();
}
return(finalquery.GetDataFromQueryable(gridViewDataSetLoadOptions));
}
}
public GridViewDataSetLoadedData <ValorLongitudViewModel> GetDataOcupacionesLongitud(IGridViewDataSetLoadOptions gridViewDataSetOptions)
{
var queryable = GetQueryableOcupacionesLongitudGeneral();
return(queryable.GetDataFromQueryable(gridViewDataSetOptions));
}
public GridViewDataSetLoadedData <CantidadLongitudPostesViewModel> GetDataLongitud(IGridViewDataSetLoadOptions gridViewDataSetOptions)
{
var queryable = GetQueryablePostesLongitud();
return(queryable.GetDataFromQueryable(gridViewDataSetOptions));
}
public GridViewDataSetLoadedData <ElementoViewModel> GetData(IGridViewDataSetLoadOptions gridViewDataSetOptions)
{
var queryable = GetQueryable(50).Result;
return(queryable.GetDataFromQueryable(gridViewDataSetOptions));
}
private GridViewDataSetLoadedData <Employee> GetData(IGridViewDataSetLoadOptions gridViewDataSetLoadOptions)
{
return(employeesApi.GetAll().GetDataFromQueryable(gridViewDataSetLoadOptions));
}
