public AdminQueryController( GraphDbContext graphDbContext, SportsShopDBContext sportsShopDBService ) { _graphContext = graphDbContext; _sportsShopDBContext = sportsShopDBService; }
private void ModalProject_Load(object sender, EventArgs e) { GraphDbContext db = new GraphDbContext(); var cl = db.Clients.ToList(); CbClients.ValueMember = "Id"; CbClients.DisplayMember = "Name"; CbClients.DataSource = cl; }
//[InlineData(DbServer.Sqlite)] public async Task BulkInsertOrUpdate_EntityWithNestedObjectGraph_SavesGraphToDatabase(DbServer dbServer) { ContextUtil.DbServer = dbServer; using var db = new GraphDbContext(ContextUtil.GetOptions <GraphDbContext>(databaseName: $"{nameof(EFCoreBulkTest)}_Graph")); await db.Database.EnsureCreatedAsync(); // To ensure there are no stack overflows with circular reference trees, we must test for that. // Set all navigation properties so the base navigation and its inverse both have values foreach (var wos in WorkOrder1.WorkOrderSpares) { wos.WorkOrder = WorkOrder1; } foreach (var wos in WorkOrder2.WorkOrderSpares) { wos.WorkOrder = WorkOrder2; } WorkOrder1.Asset.WorkOrders.Add(WorkOrder1); WorkOrder2.Asset.WorkOrders.Add(WorkOrder2); WorkOrder1.Asset.ParentAsset = WorkOrder2.Asset; WorkOrder2.Asset.ChildAssets.Add(WorkOrder1.Asset); var testData = this.GetTestData(db).ToList(); await db.BulkInsertOrUpdateAsync(testData, new BulkConfig { IncludeGraph = true }); var workOrderQuery = db.WorkOrderSpares .Include(y => y.WorkOrder) .Include(y => y.WorkOrder.Asset) .Include(y => y.Spare); foreach (var wos in workOrderQuery) { Assert.NotNull(wos.WorkOrder); Assert.NotNull(wos.WorkOrder.Asset); Assert.NotNull(wos.Spare); } }
//[InlineData(DbServer.Sqlite)] public async Task BulkInsertOrUpdate_EntityWithNestedObjectGraph_SavesGraphToDatabase(DbServer dbServer) { ContextUtil.DbServer = dbServer; using var db = new GraphDbContext(ContextUtil.GetOptions <GraphDbContext>(databaseName: $"{nameof(EFCoreBulkTest)}_Graph")); var testData = this.GetTestData(db).ToList(); await db.BulkInsertOrUpdateAsync(testData, new BulkConfig { IncludeGraph = true }); var workOrderQuery = db.WorkOrderSpares .Include(y => y.WorkOrder) .Include(y => y.WorkOrder.Asset) .Include(y => y.Spare); foreach (var wos in workOrderQuery) { Assert.NotNull(wos.WorkOrder); Assert.NotNull(wos.WorkOrder.Asset); Assert.NotNull(wos.Spare); } }
public void Dispose() { using var db = new GraphDbContext(ContextUtil.GetOptions <GraphDbContext>(databaseName: $"{nameof(EFCoreBulkTest)}_Graph")); db.Database.EnsureDeleted(); }
public FaceManager(GraphDbContext graphDbContext) { _graphDbContext = graphDbContext; }
public GraphQLController(GraphDbContext db, ISchema schema, IDocumentExecuter documentExecuter) { _schema = schema; _documentExecuter = documentExecuter; }
public PlateManager(GraphDbContext graphDbContext) { _graphDbContext = graphDbContext; }
public MastService(GraphDbContext _dbContext) { dbContext = _dbContext; }
public ActionResult Login(LoginModel model) { if (ModelState.IsValid) { var dao = new UserDao(); var result = dao.Login(model.UserName, Encryptor.MD5Hash(model.Password)); if (result == 1) { var user = dao.GetById(model.UserName); var userSession = new UserLogin(); userSession.UserName = user.UserName; userSession.UserID = user.ID; Session.Add(CommonConstants.USER_SESSION, userSession); List <OnlineShop.Entities.User> data = new UserBL().LoadDataMaster(); // MongoDb try { //mongoDbContext = new MongoDbContext(); //// select //testModel = mongoDbContext.database.GetCollection<OnlineShop.Entities.TestModel>("Test1"); //// select by Key ////var id = new ObjectId(string.Empty); ////var dataItem = testModel.AsQueryable<OnlineShop.Entities.TestModel>().FirstOrDefault(x => x.ID == id); //var dataItem = testModel.AsQueryable<OnlineShop.Entities.TestModel>().ToList(); //// Insert //Entities.TestModel item = new Entities.TestModel(); //testModel.InsertOne(item); //// Edit //// find ==> update //Entities.TestModel dataItemEdit = testModel.AsQueryable<OnlineShop.Entities.TestModel>().SingleOrDefault(x => x.ID == id); //var filter = Builders<Entities.TestModel>.Filter.Eq("_id", ObjectId.Parse(string.Empty)); //var update = Builders<Entities.TestModel>.Update // .Set("MaLop", dataItemEdit.MaLop) // .Set("TenLop", dataItemEdit.TenLop); //var resultData = testModel.UpdateOne(filter, update); //// Delete //testModel.DeleteOne(filter); //List<OnlineShop.Entities.TestModel> listTest = testModel.AsQueryable<OnlineShop.Entities.TestModel>().ToList(); } catch (Exception ex) { throw (ex); } // GraphNeo4J try { graphDbContext = new GraphDbContext(); var query = graphDbContext.GraphClient.Cypher .Match("(m:Movie)") .Return(m => m.As <Entities.Movie>()) .Limit(100); ////You can see the cypher query here when debugging var dataList = query.Results.ToList(); var query1 = graphDbContext.GraphClient.Cypher .Match("p=()-[r:ACTED_IN]->()") .Return(p => p.As <Entities.Movie>()) .Limit(100); ////You can see the cypher query here when debugging var dataList1 = query1.Results.ToList(); } catch (Exception ex) { throw (ex); } // Get data test mongo return(Redirect("/")); } else if (result == 0) { ModelState.AddModelError("", "Tài khoản không tồn tại."); } else if (result == -1) { ModelState.AddModelError("", "Tài khoản đang bị khoá."); } else if (result == -2) { ModelState.AddModelError("", "Mật khẩu không đúng."); } else { ModelState.AddModelError("", "đăng nhập không đúng."); } } return(View(model)); }
public ClientController(GraphDbContext graphDbContext, SportsShopDBContext sportsShopDBService) { _graphContext = graphDbContext; _sportsShopDBContext = sportsShopDBService; }
public OwnerManager(GraphDbContext graphDbContext) { _graphDbContext = graphDbContext; }
public QueryController(GraphDbContext dbContext, MappedSchemaProvider <GraphDbContext> schemaProvider) { _dbContext = dbContext; _schemaProvider = schemaProvider; }
public ActionResult Detail(long id) { var product = new ProductDao().ViewDetail(id); ViewBag.Category = new ProductCategoryDao().ViewDetail(product.CategoryID.Value); List <Model.EF.Product> productList = new ProductDao().ListProducts(); ViewBag.RelatedProducts = new ProductDao().ListRelatedProducts(id); graphDbContext = new GraphDbContext(); var query = graphDbContext.GraphClient.Cypher .Match("(m:Movie)") .Return(m => m.As <Entities.Movie>()) .Limit(100); ////You can see the cypher query here when debugging var dataList = query.Results.ToList(); var result = graphDbContext.GraphClient.Cypher .Match(@"(person: Person)-[:ACTED_IN]->(movie: Movie)") .Where((Entities.Movie movie) => movie.title == product.Name) //.WithParam("nameParam", "Cuba Gooding Jr.") .Return((person, movie) => new { Person = person.As <Entities.Person>(), Movie = movie.As <Entities.Movie>() }).ResultsAsync; var listAll = result.Result.ToList(); List <Entities.Movie> listMovie = new List <Entities.Movie>(); List <Entities.Person> listPerson = new List <Entities.Person>(); foreach (var item in listAll) { if (item.Movie != null) { string tempId = productList.Find(x => x.Name.Contains(item.Movie.title)).ID.ToString(); string temp = item.Movie.title.Replace(' ', '_'); item.Movie.Image = "/assets/client/images/Movie/" + temp + ".jpg"; item.Movie.MetaTitle = temp; item.Movie.Id = tempId == "" ? "1":temp; listMovie.Add(item.Movie); } if (item.Person != null) { //string tempId = productList.Find(x => x.Name == item.Person.name).ID.ToString(); string temp = item.Person.name.Replace(' ', '_'); item.Person.Image = "/assets/client/images/Person/" + temp + ".jpg"; item.Person.MetaTitle = temp; item.Person.Id = "1"; listPerson.Add(item.Person); } } ViewBag.listMovie = listMovie; ViewBag.listPerson = listPerson; return(View(product)); }