///////INTERVENTION Type////////////// public FactInterventionType(cindy_okino_dbContext db) { Name = "Intervention"; Field(x => x.Id); Field(x => x.BuildingId, nullable: true); Field(x => x.StartDateIntervention, nullable: true); Field(x => x.EndDateIntervention, nullable: true); Field <BuildingType>( "building", arguments: new QueryArguments( new QueryArgument <IntGraphType> { Name = "id" }), resolve: context => { var building = db.Buildings .Include(_ => _.Address) //.Include(_ => _.Customer) .FirstOrDefault(i => i.Id == context.Source.BuildingId); return(building); }); }
public ElevatorType(cindy_okino_dbContext _db) { Name = "Elevator"; Field(x => x.Id); Field(x => x.SerialNumber); Field(x => x.Model); Field(x => x.DateLastInspection, nullable: true); Field(x => x.DateCommissioning, nullable: true); Field(x => x.TypeBuilding); Field(x => x.Status); Field(x => x.CertOpe); Field(x => x.ColumnId, nullable: true); Field <CustomerType>( "customer", arguments: new QueryArguments( new QueryArgument <IntGraphType> { Name = "id" }), resolve: context => { var column = _db.Columns .FirstOrDefault(i => i.Id == context.Source.ColumnId); var customer = _db.Customers .FirstOrDefault(i => i.Id == column.Battery.Building.CustomerId); return(customer); }); Field <ColumnType>( "column", arguments: new QueryArguments( new QueryArgument <IntGraphType> { Name = "id" }), resolve: context => { var column = _db.Columns .FirstOrDefault(i => i.Id == context.Source.ColumnId); return(column); }); }
public EmployeesController(cindy_okino_dbContext context) { _context = context; }
public FactInterventionQuery(cindy_okino_warehouseContext db, cindy_okino_dbContext _db) { Field <FactInterventionType>( "interventionQuery", arguments: new QueryArguments( new QueryArgument <IdGraphType> { Name = "id" }), resolve: context => { var id = context.GetArgument <long>("id"); var intervention = db .FactInterventions .FirstOrDefault(i => i.Id == id); return(intervention); }); Field <EmployeeType>( "employeeQuery", arguments: new QueryArguments( new QueryArgument <IdGraphType> { Name = "id" }), resolve: context => { var id = context.GetArgument <long>("id"); var employee = _db .Employees .ToListAsync(); return(employee); }); Field <ListGraphType <EmployeeType> >( "allemployeesQuery", //arguments:// new QueryArguments( // new QueryArgument<IdGraphType> { Name = "id"}), resolve: context => { //var id = context.GetArgument<long>("id"); var employees = _db .Employees .ToListAsync(); return(employees); }); Field <BuildingType>( "buildingQuery", arguments: new QueryArguments( new QueryArgument <IdGraphType> { Name = "id" }), resolve: context => { var id = context.GetArgument <long>("id"); var building = _db .Buildings .Include(x => x.Address) //.Include(x => x.Customer) .FirstOrDefault(i => i.Id == id); return(building); }); Field <ListGraphType <ElevatorType> >( "elevatorQuery", arguments: new QueryArguments( new QueryArgument <IdGraphType> { Name = "id" }), resolve: context => { var id = context.GetArgument <long>("id"); var elevators = _db .Elevators .Where(_ => _.ColumnId == id) .ToListAsync(); return(elevators); }); Field <ListGraphType <ColumnType> >( "columnQuery", arguments: new QueryArguments( new QueryArgument <IdGraphType> { Name = "id" }), resolve: context => { var id = context.GetArgument <long>("id"); var columns = _db .Columns .Where(_ => _.BatteryId == id) .ToListAsync(); return(columns); }); Field <ListGraphType <BatteryType> >( "batteryQuery", arguments: new QueryArguments( new QueryArgument <IdGraphType> { Name = "id" }), resolve: context => { var id = context.GetArgument <long>("id"); var batteries = _db .Batteries .Where(_ => _.BuildingId == id) .ToListAsync(); return(batteries); }); Field <CustomerType>( "customerQuery", arguments: new QueryArguments( new QueryArgument <IdGraphType> { Name = "id" }), resolve: context => { var id = context.GetArgument <long>("id"); var customers = _db .Customers .FirstOrDefault(i => i.Id == id); return(customers); }); }
public BuildingType(cindy_okino_warehouseContext _db, cindy_okino_dbContext db) { Name = "Building"; Field(x => x.Id); Field(x => x.TectContactPhone); Field(x => x.TectContactEmail); Field(x => x.TectContactName); Field(x => x.AdmContactPhone); Field(x => x.AdmContactMail); Field(x => x.AdmContactName); Field(x => x.AddressId, nullable: true); Field(x => x.CustomerId, nullable: true); //Field(x => x.Address, type: typeof(AddressType)); Field <AddressType>( "address", arguments: new QueryArguments( new QueryArgument <IntGraphType> { Name = "id" }), resolve: context => { var address = db.Addresses .FirstOrDefault(i => i.Id == context.Source.AddressId); return(address); }); Field <ListGraphType <FactInterventionType> >( "interventions", arguments: new QueryArguments( new QueryArgument <IntGraphType> { Name = "id" }), resolve: context => { var interventions = _db.FactInterventions .Where(ss => ss.BuildingId == context.Source.Id) .ToListAsync(); return(interventions); }); Field <ListGraphType <BatteryType> >( "batteries", // arguments: // new QueryArguments( // new QueryArgument<IntGraphType> { Name = "id" }), resolve: context => { var batteries = db.Batteries .Where(ss => ss.BuildingId == context.Source.Id) .ToListAsync(); return(batteries); }); Field <ListGraphType <BuildingsDetailType> >( "buildingsDetails", arguments: new QueryArguments( new QueryArgument <IntGraphType> { Name = "id" }), resolve: context => { var buildingDetails = db.BuildingsDetails .Where(ss => ss.BuildingId == context.Source.Id) .ToListAsync(); return(buildingDetails); }); }
public ColumnType(cindy_okino_dbContext _db) { Name = "Column"; Field(x => x.Id); Field(x => x.TypeBuilding); Field(x => x.AmountFloorsServed, nullable: true); Field(x => x.Status); Field(x => x.Information); Field(x => x.Notes); Field(x => x.BatteryId, nullable: true); Field <CustomerType>( "customer", arguments: new QueryArguments( new QueryArgument <IntGraphType> { Name = "id" }), resolve: context => { var battery = _db.Batteries .FirstOrDefault(i => i.Id == context.Source.BatteryId); var customer = _db.Customers .FirstOrDefault(i => i.Id == battery.Building.CustomerId); return(customer); }); Field <BatteryType>( "battery", arguments: new QueryArguments( new QueryArgument <IntGraphType> { Name = "id" }), resolve: context => { var battery = _db.Batteries .FirstOrDefault(i => i.Id == context.Source.BatteryId); return(battery); }); Field <ListGraphType <ElevatorType> >( "elevators", arguments: new QueryArguments( new QueryArgument <IntGraphType> { Name = "id" }), resolve: context => { var elevators = _db.Elevators .Where(_ => _.ColumnId == context.Source.Id) .ToListAsync(); return(elevators); }); }
public BatteryType(cindy_okino_dbContext _db) { Name = "Battery"; Field(x => x.Id); Field(x => x.TypeBuilding); Field(x => x.Status); Field(x => x.DateCommissioning, nullable: true); Field(x => x.DateLastInspection, nullable: true); Field(x => x.CertOpe); Field(x => x.BuildingId, nullable: true); Field <CustomerType>( "customer", arguments: new QueryArguments( new QueryArgument <IntGraphType> { Name = "id" }), resolve: context => { var building = _db.Buildings .FirstOrDefault(i => i.Id == context.Source.BuildingId); var customer = _db.Customers.FirstOrDefault(i => i.Id == building.CustomerId); return(customer); }); Field <BuildingType>( "building", arguments: new QueryArguments( new QueryArgument <IntGraphType> { Name = "id" }), resolve: context => { var building = _db.Buildings .FirstOrDefault(i => i.Id == context.Source.BuildingId); return(building); }); Field <ListGraphType <ColumnType> >( "columns", arguments: new QueryArguments( new QueryArgument <IntGraphType> { Name = "id" }), resolve: context => { var columns = _db.Columns .Where(_ => _.BatteryId == context.Source.Id) .ToListAsync(); return(columns); }); }
public CustomerType(cindy_okino_dbContext _db) { Name = "Customer"; Field(x => x.Id); Field(x => x.CpyContactName); Field(x => x.CpyContactPhone); Field(x => x.CpyContactEmail); Field(x => x.CpyDescription); Field(x => x.StaName); Field(x => x.StaPhone); Field(x => x.StaMail); Field <ListGraphType <BuildingType> >( "buildings", arguments: new QueryArguments( new QueryArgument <IntGraphType> { Name = "id" }), resolve: context => { var buildings = _db.Buildings // .Include(_ => _.Batteries) .Where(ss => ss.CustomerId == context.Source.Id) .ToListAsync(); return(buildings); }); Field <ListGraphType <BatteryType> >( "batteries", arguments: new QueryArguments( new QueryArgument <IntGraphType> { Name = "id" }), resolve: context => { var batteries = _db.Batteries .Where(_ => _.Building.CustomerId == context.Source.Id) .ToListAsync(); return(batteries); }); Field <ListGraphType <ColumnType> >( "columns", arguments: new QueryArguments( new QueryArgument <IntGraphType> { Name = "id" }), resolve: context => { var columns = _db.Columns .Where(_ => _.Battery.Building.CustomerId == context.Source.Id) .ToListAsync(); return(columns); }); Field <ListGraphType <ElevatorType> >( "elevators", arguments: new QueryArguments( new QueryArgument <IntGraphType> { Name = "id" }), resolve: context => { var elevators = _db.Elevators .Where(_ => _.Column.Battery.Building.CustomerId == context.Source.Id) .ToListAsync(); return(elevators); }); }