public ActionResult FilterRecords()
{
AdFilter ad = new AdFilter();
List <string> genres = getAllGenres();
ViewBag.slgen = new List <SelectListItem>();
foreach (string item in genres)
{
ViewBag.slgen.Add(new SelectListItem {
Text = item, Value = item
});
}
List <string> artists = getAllArtists();
ViewBag.slart = new List <SelectListItem>();
foreach (string item in artists)
{
ViewBag.slart.Add(new SelectListItem {
Text = item, Value = item
});
}
return(View(ad));
}
public ActionResult SearchRecords(AdFilter ad)
{
Dictionary <string, object> queryDict = new Dictionary <string, object>();
List <Ad> ads = new List <Ad>();
AdFilter adf = new AdFilter();
string searchWord = ad.inputUser + ".*";
string new1 = searchWord.ToLower();
queryDict.Add("new1", new1);
var query = new Neo4jClient.Cypher.CypherQuery("match (r:Record) where toLower(r.Title)=~{new1} return r", queryDict, CypherResultMode.Set);
List <Record> records = ((IRawGraphClient)client).ExecuteGetCypherResults <Record>(query).ToList();
foreach (Record rec in records)
{
var q = client.Cypher.Match("(r:Record {Id:'" + rec.Id + "'})<-[RELEASE]-(l:Label),(r:Record {Id:'" + rec.Id + "'})<-[OWNS]-(a:Artist),(r:Record {Id:'" + rec.Id + "'})<-[s:SELLING]-(u:User),(r:Record {Id:'" + rec.Id + "'})-[BELONGS_TO]->(g:Genre) ").Return((l, a, u, s, g) => new { Label = l.As <Label>(), Artist = a.As <Artist>(), User = u.As <User>(), Condition = s.As <Condition>(), Genre = g.As <Genre>() });;
foreach (var result in q.Results)
{
ads.Add(new Ad {
Artist = result.Artist, Record = rec, Label = result.Label, User = result.User, Condition = result.Condition, Genre = result.Genre
});
}
}
adf.ads = ads.DistinctBy(x => x.Record.Id).ToList();
adf.inputUser = ad.inputUser;
return(View(adf));
}
public AdController(
IAdService adService,
ICityService cityService,
IProductModelsService productModelsService,
IAdViewsService adViewsService)
{
_adService = adService;
_prepearingModel = new PrepearingModelHelper(_adService);
_adFilter = new AdFilter(_prepearingModel);
_cityService = cityService;
_productModelsService = productModelsService;
_adViewsService = adViewsService;
}
public void List(AdFilter filter, IParser parser)
{
var cards = new List <CardResult>();
var extractor = new CardsMultiResultExtractor(cards);
dapper
.ResetParameter()
.AddParameter("@id", filter.id)
.AddParameter("@guid", filter.Guid)
.AddParameter("@idOwner", filter.idOwner)
.AddParameter("@adStatusList", filter.StringStatusList)
.AddParameter("@ownerStatusActive", filter.idOwnerStatus)
.ExecuteMultiple("card_get", extractor);
parser.Set(cards.Cast <BaseResult>().ToList());
}
public CardRegisterDTO Get(Guid guid)
{
if (!guid.Equals(Guid.Empty))
{
var filter = new AdFilter()
{
Guid = guid,
idOwner = idOwner,
StatusList = new List <int> {
(int)AD_STATUS.PUBLISHED,
(int)AD_STATUS.PAUSED,
(int)AD_STATUS.FINISHED
}
};
cardService.Get(filter, cardRegisterDTOParser);
}
var dto = (CardRegisterDTO)cardRegisterDTOParser.Get();
return(dto);
}
public virtual void Dispose(bool disposing)
{
if (!this.disposed)
{
if (disposing)
{
_adService.Dispose();
_prepearingModel.Dispose();
_cityService.Dispose();
_productModelsService.Dispose();
_adViewsService.Dispose();
_adService = null;
_prepearingModel = null;
_adFilter = null;
_cityService = null;
_productModelsService = null;
_adViewsService = null;
}
this.disposed = true;
}
}
public MyAdDTO MyAdListView()
{
var filter = new AdFilter
{
idOwner = idOwner,
StatusList = new List <int> {
(int)AD_STATUS.PUBLISHED,
(int)AD_STATUS.PAUSED,
(int)AD_STATUS.FINISHED
}
};
var response = new MyAdDTO();
cardService.Get(filter, cardDetailDTOParser);
response.Cards = cardDetailDTOParser.List()
.Cast <CardDetailDTO>()
.ToList();
response.Status = Status();
return(response);
}
public ActionResult SearchRecords()
{
AdFilter ad = new AdFilter();
return(View(ad));
}
public ActionResult FilterRecords(AdFilter ad)
{
string genre = ad.genre;
string artist = ad.artist;
List <Record> records = new List <Record>();
List <Ad> ads = new List <Ad>();
AdFilter adf = new AdFilter();
if (!genre.IsNullOrWhiteSpace() & !artist.IsNullOrWhiteSpace())
{
var query1 = new Neo4jClient.Cypher.CypherQuery("match (a{Name:'" + artist + "'})-[OWNS]->(record)-[BELONGS_TO]->(g{genre:'" + genre + "'}) return record", new Dictionary <string, object>(), CypherResultMode.Set);
records = ((IRawGraphClient)client).ExecuteGetCypherResults <Record>(query1).ToList();
}
else if (!genre.IsNullOrWhiteSpace() & artist.IsNullOrWhiteSpace())
{
var query1 = new Neo4jClient.Cypher.CypherQuery("match (a)-[OWNS]->(record)-[BELONGS_TO]->(g{genre:'" + genre + "'}) return record", new Dictionary <string, object>(), CypherResultMode.Set);
records = ((IRawGraphClient)client).ExecuteGetCypherResults <Record>(query1).ToList();
}
else if (genre.IsNullOrWhiteSpace() & !artist.IsNullOrWhiteSpace())
{
var query1 = new Neo4jClient.Cypher.CypherQuery("match (a{Name:'" + artist + "'})-[OWNS]->(record)-[BELONGS_TO]->(g) return record", new Dictionary <string, object>(), CypherResultMode.Set);
records = ((IRawGraphClient)client).ExecuteGetCypherResults <Record>(query1).ToList();
}
else
{
var query1 = new Neo4jClient.Cypher.CypherQuery("match (a:Artist)-[OWNS]->(record)-[BELONGS_TO]->(g:Genre) return record", new Dictionary <string, object>(), CypherResultMode.Set);
records = ((IRawGraphClient)client).ExecuteGetCypherResults <Record>(query1).ToList();
}
foreach (var rec in records)
{
var q = client.Cypher.Match("(r:Record {Id:'" + rec.Id + "'})<-[RELEASE]-(l:Label),(r:Record {Id:'" + rec.Id + "'})<-[OWNS]-(a:Artist),(r:Record {Id:'" + rec.Id + "'})<-[s:SELLING]-(u:User),(r:Record {Id:'" + rec.Id + "'})-[BELONGS_TO]->(g:Genre) ").Return((l, a, u, s, g) => new { Label = l.As <Label>(), Artist = a.As <Artist>(), User = u.As <User>(), Condition = s.As <Condition>(), Genre = g.As <Genre>() });;
foreach (var result in q.Results)
{
ads.Add(new Ad {
Artist = result.Artist, Record = rec, Label = result.Label, User = result.User, Condition = result.Condition, Genre = result.Genre
});
}
}
adf.ads = ads.DistinctBy(x => x.Record.Id).ToList();
List <string> genres = getAllGenres();
ViewBag.slgen = new List <SelectListItem>();
foreach (string item in genres)
{
ViewBag.slgen.Add(new SelectListItem {
Text = item, Value = item
});
}
List <string> artists = getAllArtists();
ViewBag.slart = new List <SelectListItem>();
foreach (string item in artists)
{
ViewBag.slart.Add(new SelectListItem {
Text = item, Value = item
});
}
return(View(adf));
}
public void Get(AdFilter filter, IParser parser)
{
cardDAL.Get(filter, parser);
}
public void List(AdFilter filter, IParser parse)
{
cardDAL.Get(filter, parse);
}
public AdModule()
{
Filter = new AdFilter();
FillForm();
}
public void Get(AdFilter filter, IParser parser)
{
List(filter, parser);
}
