public void SetupTests()
{
_graphClient = new GraphClient(new Uri("http://localhost:7474/db/data"));
_graphClient.Connect();
_repository = new EntityRepository(_graphClient);
}
public AdminSQLPanel()
{
InitializeComponent();
dataBase = new DataBaseManager();
string connectionString = "mongodb://192.168.99.100:27017";
mongoclient = new MongoClient(connectionString);
_client = new GraphClient(new Uri("http://192.168.99.100.:7474/db/data"), "neo4j", "password");
_client.Connect();
elasticClient = new ElasticClient(new ConnectionSettings(new Uri("http://192.168.99.100:9200")).DefaultIndex("filmdesc"));
LoadCountryList();
LoadSubscriptionList();
LoadPeopleList();
LoadFilmList();
}
public void Init(string url, string user, string password)
{
// Create graph client
Client = new GraphClient(new Uri(url), user, password);
Client.Connect();
// Check if empty, if so, start setup process
var query = Client.Cypher.Match("(n)")
.Return(n => n.As <object>())
.Limit(1);
if (query.Results.Count() == 0)
{
Setup();
}
}
private void _confirmPayment_Click(object sender, EventArgs e)
{
_client = new GraphClient(new Uri("http://192.168.99.100.:7474/db/data"), "neo4j", "password");
_client.Connect();
User newUser = new User {
id = Convert.ToInt32(userId)
};
_client.Cypher
.Merge("(user:User { id: {id} })")
.OnCreate()
.Set("user = {newUser}")
.WithParams(new {
id = newUser.id,
newUser
})
.ExecuteWithoutResults();
Film newFilm = new Film {
_id = filmId
};
_client.Cypher.Merge("(film:Film { _id: {_id} })")
.OnCreate()
.Set("film = {newFilm}")
.WithParams(new
{
newFilm._id,
newFilm
})
.ExecuteWithoutResults();
var newDate = DateTime.Now.ToString("yyyy-MM-dd");
_client.Cypher
.Match("(user:User)", "(film:Film)")
.Where((User user) => user.id == newUser.id)
.AndWhere((Film film) => film._id == filmId)
.CreateUnique("(user)-[:BUY {date : {newDate}}]->(film)")
.WithParams(new
{
newDate
})
.ExecuteWithoutResults();
MessageBox.Show("Поздравляем с покупкой");
_client.Dispose();
Close();
}
