public void AddUser(UserLableDTO u)
{
using (var client = new GraphClient(new Uri(_conn), _login, _pass))
{
client.Connect();
client.Cypher.Create("(u:User { UserId: {p1},UserLogin: {p2}})")
.WithParam("p1", u.UserId)
.WithParam("p2", u.UserLogin)
.ExecuteWithoutResults();
}
}
public void DeleteUser(UserLableDTO u)
{
using (var client = new GraphClient(new Uri(connectionString), login, pass))
{
client.Connect();
client.Cypher
.Match("(user1:User)-[r:Friends]-()")
.Where("user1.User_Id = {p_id}")
.WithParam("p_id", u.User_Id)
.Delete("r,user1")
.ExecuteWithoutResults();
}
}
public void AddUser(UserLableDTO u)
{
using (var client = new GraphClient(new Uri(connectionString), login, pass))
{
client.Connect();
client.Cypher.Create("(u:User { User_Id: {p1},UserLogin: {p2},FisrtName: {p3},LastName: {p4} })")
.WithParam("p1", u.User_Id)
.WithParam("p2", u.User_Login)
.WithParam("p3", u.User_Name)
.WithParam("p4", u.User_Last_Name)
.ExecuteWithoutResults();
}
}
public void AddUser(UserLableDTO u)
{
using (var client = new GraphClient(new Uri(connectionString), login, pass))
{
client.Connect();
client.Cypher.Create("(u:User { UserID: {i},UserEmail: {e},FisrtName: {f},SurName: {s} })")
.WithParam("i", u.User_Id)
.WithParam("e", u.User_Email)
.WithParam("f", u.User_Name)
.WithParam("s", u.User_Surname)
.ExecuteWithoutResults();
}
}
public void DeleteRelationship(UserLableDTO u1, UserLableDTO u2)
{
using (var client = new GraphClient(new Uri(connectionString), login, pass))
{
client.Connect();
client.Cypher
.Match("(user1:User)-[r:Friends]-(user2:User)")
.Where("user1.User_Id = {p_id1}")
.AndWhere("user2.User_Id = {p_id2}")
.WithParam("p_id1", u1.User_Id)
.WithParam("p_id2", u2.User_Id)
.Delete("r")
.ExecuteWithoutResults();
}
}
public void DeleteAllRelationships(UserLableDTO u1, UserLableDTO u2)
{
using (var client = new GraphClient(new Uri(_conn), _login, _pass))
{
client.Connect();
client.Cypher
.Match("(user1:User)-[r:Follower]-(user2:User)")
.Where("user1.UserId = {p1}")
.AndWhere("user2.UserId = {p2}")
.WithParam("p1", u1.UserId)
.WithParam("p2", u2.UserId)
.Delete("r")
.ExecuteWithoutResults();
}
}
public void AddFollow(UserLableDTO from, UserLableDTO to)
{
using (var client = new GraphClient(new Uri(_conn), _login, _pass))
{
client.Connect();
client.Cypher
.Match("(user1:User),(user2:User)")
.Where("user1.UserId = {from}")
.AndWhere("user2.UserId = {to}")
.WithParam("from", from.UserId)
.WithParam("to", to.UserId)
.Create("(user1)-[:Follower]->(user2)")
.ExecuteWithoutResults();
}
}
public bool HasRelationship(UserLableDTO u1, UserLableDTO u2)
{
using (var client = new GraphClient(new Uri(connectionString), login, pass))
{
client.Connect();
var is_friends = client.Cypher
.Match("(user1:User)-[r:Friends]-(user2:User)")
.Where((UserLableDTO user1) => user1.User_Id == u1.User_Id)
.AndWhere((UserLableDTO user2) => user2.User_Id == u2.User_Id)
.Return(r => r.As <Friends>()).Results; // how to know type of relationship?
if (is_friends.Count() > 0)
{
return(true);
}
return(false);
}
}
public bool HasAnyRelationship(UserLableDTO u1, UserLableDTO u2)
{
using (var client = new GraphClient(new Uri(_conn), _login, _pass))
{
client.Connect();
var is_friends = client.Cypher
.Match("(user1:User)-[r:Follower]-(user2:User)")
.Where((UserLableDTO user1) => user1.UserId == u1.UserId)
.OrWhere((UserLableDTO user2) => user2.UserId == u2.UserId)
.Return(r => r.As <FollowerDTO>()).Results;
if (is_friends.Count() > 0)
{
return(true);
}
return(false);
}
}
public UserLableDTO GetUserById(int id)
{
using (var client = new GraphClient(new Uri(_conn), _login, _pass))
{
client.Connect();
var user = client.Cypher
.Match("(u:User)")
.Where((UserLableDTO u) => u.UserId == id)
.Return(u => u.As <UserLableDTO>())
.Results;
UserLableDTO to_ret = new UserLableDTO()
{
UserId = id
};
foreach (var u in user)
{
to_ret.UserId = u.UserId;
to_ret.UserLogin = u.UserLogin;
}
return(to_ret);
}
}
public UserLableDTO GetUser(int id)
{
using (var client = new GraphClient(new Uri(connectionString), login, pass))
{
client.Connect();
var user = client.Cypher
.Match("(u:User)")
.Where((UserLableDTO u) => u.User_Id == id)
.Return(u => u.As <UserLableDTO>())
.Results;
UserLableDTO to_ret = new UserLableDTO()
{
User_Id = id
};
foreach (var u in user)
{
to_ret.User_Id = u.User_Id;
to_ret.User_Login = u.User_Login;
to_ret.User_Name = u.User_Name;
to_ret.User_Last_Name = u.User_Last_Name;
}
return(to_ret);
}
}
public int MinPathBetween(UserLableDTO u1, UserLableDTO u2)
{
return(this.MinPathBetween(u1.User_Id, u2.User_Id));
}
public int PathBetween(UserLableDTO u1, UserLableDTO u2)
{
_userNeoDal.MinPathBetween(u1, u2);
}
public bool Relationship(UserLableDTO u1, UserLableDTO u2)
{
_userNeoDal.HasRelationship(u1, u2);
}
public void Follow(UserLableDTO u1, UserLableDTO u2)
{
_userNeoDal.AddRelationship(u1, u2);
}