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));
}
