public TabModel Execute(int tabID)
{
return(_db.FindBy(t => t.Id == tabID).Select(t => new TabModel()
{
Artist = t.Artist,
Author = t.Author,
FileName = t.FileName,
Id = t.Id,
IsApproved = t.IsApproved,
Style = t.Style,
Tags = t.Tags,
Title = t.Title,
Alias = _stringService.GenerateSlug(t.Title)
}).FirstOrDefault());
}
List <TabModel> IGetTabsListLastQuery.Execute(int top)
{
var tabs = _db.FindBy(t => t.IsApproved).OrderByDescending(t => t.Id).Take(top).Select(t => new TabModel()
{
Id = t.Id,
Title = t.Title,
Artist = t.Artist,
Author = t.Author,
FileName = t.FileName,
Style = t.Style,
Tags = t.Tags,
IsApproved = t.IsApproved,
Alias = _stringService.GenerateSlug(t.Title)
});
return(tabs.ToList());
}
public List <TabModel> Execute(string artist)
{
artist = artist.Replace("-", " ");
var tabs = _db.FindBy(t => t.Artist.ToUpper().Contains(artist.ToUpper()) && t.IsApproved).Select(t => new TabModel()
{
Id = t.Id,
Title = t.Title,
Artist = t.Artist,
Author = t.Author,
FileName = t.FileName,
Style = t.Style,
Tags = t.Tags,
IsApproved = t.IsApproved,
Alias = _stringService.GenerateSlug(t.Title)
});
return(tabs.OrderBy(x => x.Title).ToList());
}