public IActionResult TestCase1(int id)
{
MySqlHandler sqlhander = new MySqlHandler();
Product product = sqlhander.GetProductJoinProductTypeById(id);
return(Ok(product));
}
public IActionResult TestCase10(int lower, int upper)
{
MySqlHandler sqlhander = new MySqlHandler();
var product = sqlhander.GetProductJoinProductTypeById(lower, upper);
return(Ok(product));
}
public List <Product> TestCase16MySql(int lower, int upper)
{
MySqlHandler sqlhander = new MySqlHandler();
var product = sqlhander.GetProductJoinProductTypeById(lower, upper);
return(product);
}
public Product TestCase13MySql(int id)
{
MySqlHandler sqlhander = new MySqlHandler();
var product = sqlhander.GetProductJoinProductTypeById(id);
return(product);
}
public Query(Db database)
{
Field <ProductObjType>(
Product.product,
arguments: new QueryArguments(
new QueryArgument <IdGraphType> {
Name = "id"
}
),
resolve: context =>
{
var id = context.GetArgument <int>("id");
if (database == Db.Mongo)
{
MongoHandler mongo = new MongoHandler();
return(mongo.GetProductById(id));
}
else
{
MySqlHandler mySql = new MySqlHandler();
return(mySql.GetProductById(id));
}
}
);
Field <ListGraphType <ProductObjType> >(
"products",
arguments: new QueryArguments(
new QueryArgument <IdGraphType> {
Name = "lower"
},
new QueryArgument <IdGraphType> {
Name = "upper"
}
),
resolve: context =>
{
var lower = context.GetArgument <int>("lower");
var upper = context.GetArgument <int>("upper");
if (database == Db.Mongo)
{
MongoHandler mongo = new MongoHandler();
return(mongo.GetProductById(lower, upper));
}
else
{
MySqlHandler mySql = new BachelorProjectBackend.Repository.MySqlHandler();
return(mySql.GetProductById(lower, upper));
}
});
Field <ProductObjType>(
"productAndType",
arguments: new QueryArguments(
new QueryArgument <IdGraphType> {
Name = "id"
}
),
resolve: context =>
{
var id = context.GetArgument <int>("id");
if (database == Db.Mongo)
{
MongoHandler mongo = new MongoHandler();
return(mongo.GetProductJoinProductTypeById(id));
}
else
{
MySqlHandler mySql = new MySqlHandler();
return(mySql.GetProductJoinProductTypeById(id));
}
}
);
Field <ListGraphType <ProductObjType> >(
"productsAndTypes",
arguments: new QueryArguments(
new QueryArgument <IdGraphType> {
Name = "lower"
},
new QueryArgument <IdGraphType> {
Name = "upper"
}
),
resolve: context =>
{
var lower = context.GetArgument <int>("lower");
var upper = context.GetArgument <int>("upper");
if (database == Db.Mongo)
{
MongoHandler mongo = new MongoHandler();
return(mongo.GetProductJoinProductTypeById(lower, upper));
}
else
{
MySqlHandler mySql = new BachelorProjectBackend.Repository.MySqlHandler();
return(mySql.GetProductJoinProductTypeById(lower, upper));
}
});
Field <ProductObjType>(
"productAndTypeAndCompany",
arguments: new QueryArguments(
new QueryArgument <IdGraphType> {
Name = "id"
}
),
resolve: context =>
{
var id = context.GetArgument <int>("id");
if (database == Db.Mongo)
{
MongoHandler mongo = new MongoHandler();
return(mongo.GetProductJoinProductTypeAndCompanyById(id));
}
else
{
MySqlHandler mySql = new BachelorProjectBackend.Repository.MySqlHandler();
return(mySql.GetProductJoinProductTypeAndCompanyById(id));
}
});
Field <ListGraphType <ProductObjType> >(
"productsAndTypesAndCompanys",
arguments: new QueryArguments(
new QueryArgument <IdGraphType> {
Name = "lower"
},
new QueryArgument <IdGraphType> {
Name = "upper"
}
),
resolve: context =>
{
var lower = context.GetArgument <int>("lower");
var upper = context.GetArgument <int>("upper");
if (database == Db.Mongo)
{
MongoHandler mongo = new MongoHandler();
return(mongo.GetProductJoinProductTypeAndCompanyById(lower, upper));
}
else
{
MySqlHandler mySql = new BachelorProjectBackend.Repository.MySqlHandler();
return(mySql.GetProductJoinProductTypeAndCompanyById(lower, upper));
}
});
Field <CompanyObjType>(
Company.company,
resolve: context =>
{
if (database == Db.Mongo)
{
return(null);
}
else
{
return(null);
}
});
Field <DepartmentObjType>(
Department.department,
resolve: context =>
{
if (database == Db.Mongo)
{
return(null);
}
else
{
return(null);
}
});
Field <PersonObjType>(
Person.person,
resolve: context =>
{
if (database == Db.Mongo)
{
return(null);
}
else
{
return(null);
}
});
Field <ProductTypeObjType>(
ProductType.productType,
arguments: new QueryArguments(
new QueryArgument <IdGraphType> {
Name = "id"
}
),
resolve: context =>
{
var id = context.GetArgument <int>("id");
if (database == Db.Mongo)
{
MongoHandler mongo = new MongoHandler();
return(mongo.GetProductJoinProductTypeById(id));
}
else
{
MySqlHandler mySql = new MySqlHandler();
return(mySql.GetProductJoinProductTypeById(id));
}
});
}
