public ViewSong(SongDraft draft, String user)
{
name = draft.name;
link = draft.link;
content = draft.content;
date = draft.date;
approved = false;
creator = user;
this.artist = draft.artist;
}
//Brise song draft
public void SongDraftDelete(SongDraft draft, String user)
{
Dictionary <string, object> dictionary = new Dictionary <string, object>();
dictionary.Add("user_name", user);
dictionary.Add("draft_name", draft.name);
dictionary.Add("artist_name", draft.artist);
CypherQuery query = new CypherQuery("MATCH (user:User)-[relation:REQUESTED]->(draft:SongDraft) WHERE user.name = {user_name} AND draft.name = {draft_name} AND draft.artist = {artist_name} DETACH DELETE draft",
dictionary, CypherResultMode.Set);
((IRawGraphClient)client).ExecuteCypher(query);
}
//GET /Song/CreateDraft/
public ActionResult CreateDraft(string artist, string song, string content)
{
ViewBag.showNav = false;
PageViewModel pageModel = new PageViewModel();
if (Session["user"] != null && Session["user"].GetType() == (typeof(ViewUser)))
{
pageModel.user = (ViewUser)(Session["user"]);
}
else
{
return(Redirect("/"));
}
Neo4jDataProvider dbNeo4j = new Neo4jDataProvider();
RedisDataProvider dbRedis = new RedisDataProvider();
if (artist == null && song == null && content == null)
{
return(View(pageModel));
}
if (artist == null || song == null || content == null)
{
ViewBag.error = "Data is missing from required fields.";
}
else if (artist.Length < 1 || song.Length < 1 || content.Length < 1)
{
ViewBag.error = "Data is missing from required fields.";
}
if (ViewBag.error != null)
{
return(View(pageModel));
}
SongDraft draft = new SongDraft();
draft.name = song;
draft.artist = artist;
draft.link = "/" + artist + "/" + song;
draft.date = DateTime.Now.ToString("dd-MM-yyyy");
draft.content = content;
dbNeo4j.SongDraftCreate(draft, pageModel.user.name);
dbRedis.AddAdminNotification();
return(Redirect("/User/"));
}
//Vraca draft za potrebe edita i pravljenja pesme
public ViewSong SongDraftRead(String user, String artist, String song)
{
Dictionary <string, object> dictionary = new Dictionary <string, object>();
dictionary.Add("user_name", user);
dictionary.Add("artist", artist);
dictionary.Add("song", song);
CypherQuery query = new CypherQuery("MATCH (user:User)-[relation:REQUESTED]->(draft:SongDraft) WHERE user.name = {user_name} AND draft.artist = {artist} AND draft.name = {song} RETURN draft",
dictionary, CypherResultMode.Set);
List <SongDraft> qres = ((IRawGraphClient)client).ExecuteGetCypherResults <SongDraft>(query).ToList();
if (qres.Count > 0)
{
SongDraft draft = qres.First();
ViewSong result = new ViewSong(draft, user);
return(result);
}
return(null);
}
//GET /Song/DeleteDraft/
public ActionResult DeleteDraft(string user, string artist, string name)
{
//Samo admin brise draft
if (Session["user"] == null || ((ViewUser)Session["user"]).admin == false)
{
return(Redirect("/"));
}
Neo4jDataProvider dbNeo4j = new Neo4jDataProvider();
RedisDataProvider dbRedis = new RedisDataProvider();
SongDraft draft = new SongDraft();
draft.artist = artist;
draft.name = name;
dbNeo4j.SongDraftDelete(draft, user);
dbRedis.ClearAdminNotifications();
return(Redirect("/User/"));
}
//Kreira song draft
public void SongDraftCreate(SongDraft draft, String user)
{
Dictionary <string, object> dictionary = new Dictionary <string, object>();
dictionary.Add("name", draft.name);
dictionary.Add("link", draft.link);
dictionary.Add("content", draft.content);
dictionary.Add("date", draft.date);
dictionary.Add("artist", draft.artist);
//Kreira draft u bazi
CypherQuery query = new CypherQuery("CREATE (song:SongDraft { name: {name}, link: {link}, content: {content}, date: {date}, artist: {artist}})",
dictionary, CypherResultMode.Set);
((IRawGraphClient)client).ExecuteCypher(query);
//Povezuje draft sa korisnikom
dictionary = new Dictionary <string, object>();
dictionary.Add("user_name", user);
dictionary.Add("song_name", draft.name);
query = new CypherQuery("MATCH (user:User{name: {user_name}}),(song:SongDraft{name: {song_name}}) CREATE (user)-[relation:REQUESTED]->(song)",
dictionary, CypherResultMode.Set);
((IRawGraphClient)client).ExecuteCypher(query);
}
public void Initialize()
{
string date = DateTime.Now.ToString("dd-MM-yyyy");
Neo4jDataProvider dbNeo4j = new Neo4jDataProvider();
RedisDataProvider dbRedis = new RedisDataProvider();
StreamReader stream;
//Check is database initialized
if (dbNeo4j.UserExists("admin", "admin"))
{
return;
}
DeleteAllData();
dbRedis.ResetHashCounter();
#region Create users
User admin = new User();
admin.name = "admin";
admin.email = "admin";
admin.password = "******";
admin.admin = true;
admin.date = date;
dbNeo4j.UserCreate(admin);
try
{
stream = new StreamReader(HostingEnvironment.MapPath(userFilePath));
while (!stream.EndOfStream)
{
User user = new User();
user.name = stream.ReadLine();
user.email = stream.ReadLine();
user.password = stream.ReadLine();
user.admin = false;
user.date = date;
stream.ReadLine();
dbNeo4j.UserCreate(user);
}
stream.Close();
}
catch (Exception e)
{
}
#endregion
#region Create genres
try
{
stream = new StreamReader(HostingEnvironment.MapPath(genresFilePath));
while (!stream.EndOfStream)
{
Genre genre = new Genre();
genre.name = stream.ReadLine();
stream.ReadLine();
dbNeo4j.GenreCreate(genre);
}
stream.Close();
}
catch (Exception e)
{
}
#endregion
#region Create artists
try
{
stream = new StreamReader(HostingEnvironment.MapPath(artistFilePath));
while (!stream.EndOfStream)
{
Artist artist = new Artist();
artist.name = stream.ReadLine();
artist.biography = stream.ReadLine();
artist.website = stream.ReadLine();
string genresClean = Regex.Replace(stream.ReadLine(), " *, *", ",");
List <string> genreNames = genresClean.Split(',').ToList();
List <string> checkGenres = dbNeo4j.GenreRead();
List <string> validGenreNames = genreNames.Intersect(checkGenres).ToList();
List <Genre> validGenres = new List <Genre>();
foreach (string genreName in validGenreNames)
{
Genre tmp = new Genre();
tmp.name = genreName;
validGenres.Add(tmp);
}
dbNeo4j.ArtistCreate(artist, validGenres);
stream.ReadLine();
}
stream.Close();
}
catch (Exception e)
{
}
#endregion
#region Create songs
string[] songPaths = Directory.GetFiles(HostingEnvironment.MapPath(songFolderPath));
foreach (string songPath in songPaths)
{
try
{
stream = new StreamReader(songPath);
Song song = new Song();
song.name = stream.ReadLine();
string artist = stream.ReadLine();
string user = stream.ReadLine();
stream.ReadLine();
song.content = stream.ReadToEnd();
song.date = date;
dbNeo4j.SongCreate(song, user, artist);
stream.Close();
}
catch (Exception e)
{
}
}
#endregion
#region Create favorites
try
{
stream = new StreamReader(HostingEnvironment.MapPath(favoritesFilePath));
while (!stream.EndOfStream)
{
string song = stream.ReadLine();
string artist = stream.ReadLine();
string user = stream.ReadLine();
stream.ReadLine();
dbNeo4j.SongAddToFavorites(song, artist, user);
}
stream.Close();
}
catch (Exception e)
{
}
#endregion
#region Create Comments
try
{
stream = new StreamReader(HostingEnvironment.MapPath(commentsFilePath));
while (!stream.EndOfStream)
{
Comment comment = new Comment();
comment.title = stream.ReadLine();
comment.content = stream.ReadLine();
comment.date = date;
string song = stream.ReadLine();
string artist = stream.ReadLine();
string user = stream.ReadLine();
stream.ReadLine();
dbNeo4j.CommentCreate(comment, user, artist, song);
}
stream.Close();
}
catch (Exception e)
{
}
#endregion
#region Create requests
try
{
stream = new StreamReader(HostingEnvironment.MapPath(songRequestFilePath));
while (!stream.EndOfStream)
{
SongRequest songRequest = new SongRequest();
songRequest.author = stream.ReadLine();
songRequest.artist = stream.ReadLine();
songRequest.song = stream.ReadLine();
songRequest.date = date;
stream.ReadLine();
dbNeo4j.SongRequestCreate(songRequest);
}
stream.Close();
}
catch (Exception e)
{
}
#endregion
#region Create songdrafts
string[] songDraftPaths = Directory.GetFiles(HostingEnvironment.MapPath(songDraftFolderPath));
foreach (string songDraftPath in songDraftPaths)
{
try
{
stream = new StreamReader(songDraftPath);
SongDraft songDraft = new SongDraft();
songDraft.name = stream.ReadLine();
songDraft.artist = stream.ReadLine();
string user = stream.ReadLine();
songDraft.content = stream.ReadToEnd();
songDraft.date = date;
dbNeo4j.SongDraftCreate(songDraft, user);
stream.Close();
dbRedis.AddAdminNotification();
}
catch (Exception e)
{
}
}
#endregion
}
//GET /Song/Approve/
public ActionResult Approve(string user, string artist, string name, string content, string approve)
{
ViewBag.showNav = false;
//Samo admin moze da appruvuje
if (Session["user"] == null || ((ViewUser)Session["user"]).admin == false)
{
return(Redirect("/"));
}
PageViewModel pageModel = new PageViewModel();
pageModel.user = (ViewUser)(Session["user"]);
Neo4jDataProvider dbNeo4j = new Neo4jDataProvider();
if (approve != null)
{
//Promenjeni podatci
ViewSong draft = new ViewSong();
draft.creator = user;
draft.name = name;
draft.content = content;
draft.artist = artist;
draft.approved = false;
draft.date = DateTime.Now.ToString("dd-MM-yyyy");
ViewBag.draft = draft;
if (artist == null && name == null && content == null)
{
return(View(pageModel));
}
if (artist == null || name == null || content == null)
{
ViewBag.error = "Data is missing from required fields.";
}
else if (artist.Length < 1 || name.Length < 1 || content.Length < 1)
{
ViewBag.error = "Data is missing from required fields.";
}
if (ViewBag.error != null)
{
return(View(pageModel));
}
//Provera da li postoji Artist
List <string> allArtists = dbNeo4j.ArtistRead();
if (!allArtists.Contains(artist))
{
ViewBag.noArtist = true;
return(View(pageModel));
}
//Kriranje nove pesme
Song song = new Song();
song.name = name;
song.content = content;
song.date = DateTime.Now.ToString("dd-MM-yyyy");
song.link = "/" + artist + "/" + user + "/";
dbNeo4j.SongCreate(song, user, artist);
SongDraft songDraft = new SongDraft();
songDraft.name = name;
songDraft.artist = artist;
dbNeo4j.SongDraftDelete(songDraft, user);
dbNeo4j.SongRequestDelete(artist, name);
return(Redirect("/User/"));
}
ViewBag.draft = dbNeo4j.SongDraftRead(user, artist, name);
return(View(pageModel));
}
