public async Task <AdditionalWork> ReadAsync(int id)
{
return(await Task.Run(() =>
{
using (MaintenanceScheduleContext dbContext = new MaintenanceScheduleContext("ProbLoc"))
{
return dbContext.AdditionalWorks
.Include(x => x.Substation.Team)
.Include(x => x.MaintenanceRecords.Select(t => t.PlannedMaintenanceType))
.Include(x => x.Devices.Select(m => m.MaintenanceRecords.Select(t => t.PlannedMaintenanceType)))
.Include(x => x.NormalMaintenanceCycle)
.Include(x => x.NormalMaintenanceCycle.MaintenanceYears.Select(y => y.MaintenanceType))
.Include(x => x.ReducedMaintenanceCycle)
.First(x => x.MaintainedEquipmentId == id);
}
}));
}
public async Task <Substation> ReadAsync(int id)
{
return(await Task.Run(() =>
{
using (MaintenanceScheduleContext dbContext = new MaintenanceScheduleContext("ProbLoc"))
{
return dbContext.Substations
.Include(x => x.Team)
.Include(x => x.TransformerType)
.Include(x => x.DistrictElectricalNetwork)
.Include(x => x.InspectionsFrequency)
.Include(x => x.Attachments.Select(m => m.ManagementOrganization))
.Include(x => x.Attachments.Select(m => m.VoltageClass))
.Include(x => x.MaintenanceRecords)
.Include(x => x.AdditionalWorks.Select(m => m.MaintenanceRecords
.Select(t => t.PlannedMaintenanceType)))
.First(x => x.MaintainedEquipmentId == id);
}
}));
}
public async Task <RelayDevice> ReadAsync(int id)
{
return(await Task.Run(() =>
{
using (MaintenanceScheduleContext dbContext = new MaintenanceScheduleContext("ProbLoc"))
{
return dbContext.RelayDevices
.Include(x => x.Attachment.Substation.Team)
.Include(x => x.Attachment.ManagementOrganization)
.Include(x => x.Act)
.Include(x => x.Manufacturer)
.Include(x => x.ElementBase)
.Include(x => x.DeviceType)
.Include(x => x.NormalMaintenanceCycle)
.Include(x => x.NormalMaintenanceCycle.MaintenanceYears.Select(y => y.MaintenanceType))
.Include(x => x.ReducedMaintenanceCycle)
.Include(x => x.MaintenanceRecords.Select(m => m.PlannedMaintenanceType))
.Include(x => x.CombineDevices.Select(m => m.MaintenanceRecords.Select(t => t.PlannedMaintenanceType)))
.First(x => x.MaintainedEquipmentId == id);
}
}));
}
public SubstationRepository(MaintenanceScheduleContext context)
{
this.context = context;
}
public InspectionsFrequencyRepository(MaintenanceScheduleContext context)
{
this.context = context;
}
public AdditionalWorkRepository(MaintenanceScheduleContext context)
{
this.context = context;
}
public MaintainedEquipmentRepository(MaintenanceScheduleContext context)
{
this.context = context;
}
public TransformerTypeRepository(MaintenanceScheduleContext context)
{
this.context = context;
}
public EFUnitOfWork(string name)
{
context = new MaintenanceScheduleContext(name);
}
public DeviceTypeRepository(MaintenanceScheduleContext context)
{
this.context = context;
}
public ManagementOrganizationRepository(MaintenanceScheduleContext context)
{
this.context = context;
}
public VoltageClassRepository(MaintenanceScheduleContext context)
{
this.context = context;
}
public DistrictElectricalNetworkRepository(MaintenanceScheduleContext context)
{
this.context = context;
}
public MaintenanceRecordRepository(MaintenanceScheduleContext context)
{
this.context = context;
}
public ActRepository(MaintenanceScheduleContext context)
{
this.context = context;
}
public ManufacturerRepository(MaintenanceScheduleContext context)
{
this.context = context;
}
public ElementBaseRepository(MaintenanceScheduleContext context)
{
this.context = context;
}
