public ObservableCollection <Notes> LoadNotes()
{
ObservableCollection <Notes> list = new ObservableCollection <Notes>();
ILoad <Notes> loadedNotes = new LoadM <Notes>();
ObservableCollection <Notes> notesCollection = loadedNotes.RetriveCollection("Notes");
ILoad <Station> retrivedStation = new LoadM <Station>();
ObservableCollection <Station> stationCollection = retrivedStation.RetriveCollection("Stations");
var query = (from n in notesCollection
join s in stationCollection on n.StationId equals s.StationId
select new Notes()
{
NotesId = n.NotesId,
Note1 = n.Note1,
UserId = n.UserId,
DueDate = n.DueDate,
StationName = s.StationName,
StationId = s.StationId
}).ToList();
foreach (var item in query)
{
list.Add(item);
}
return(list);
}
public ObservableCollection <TaskEquipmentStation> LoadDone()
{
ObservableCollection <TaskEquipmentStation> done = new ObservableCollection <TaskEquipmentStation>();
ILoad <TaskClass> retrivedTask = new LoadM <TaskClass>();
ObservableCollection <TaskClass> taskCollection = retrivedTask.RetriveCollection("Tasks");
ILoad <Station> retrivedStation = new LoadM <Station>();
ObservableCollection <Station> stationCollection = retrivedStation.RetriveCollection("Stations");
ILoad <Equipment> retrivedEquipmnet = new LoadM <Equipment>();
ObservableCollection <Equipment> equipmentCollection = retrivedEquipmnet.RetriveCollection("Equipments");
var query = (from t in taskCollection
join e in equipmentCollection on t.EquipmentId equals e.EquipmentId
join s in stationCollection on e.StationId equals s.StationId
select new TaskEquipmentStation()
{
TaskId = t.TaskId, TaskName = t.TaskName, TaskSchedule = t.TaskSchedule, Registration = t.Registration, DueDate = t.DueDate, DoneDate = t.DoneDate, DoneVar = t.DoneVar, TaskType = t.TaskType, Comment = t.Comment, EquipmentId = t.EquipmentId, EquipmentName = e.EquipmentName, StationName = s.StationName
}).ToList();
foreach (var item in query)
{
if (item.DoneVar == "Y")
{
done.Add(item);
}
}
return(done);
}
public ObservableCollection <Station> LoadStation()
{
ILoad <Station> retrivedStation = new LoadM <Station>();
ObservableCollection <Station> stationCollection = retrivedStation.RetriveCollection("Stations");
var query = (from s in stationCollection
select new Station()
{
StationName = s.StationName, StationId = s.StationId
}).ToList();
foreach (var item in query)
{
stationCollection.Add(item);
}
return(stationCollection);
}
public ObservableCollection <TaskEquipmentStation> EquipmentStationsCollection()
{
ObservableCollection <TaskEquipmentStation> list = new ObservableCollection <TaskEquipmentStation>();
ILoad <Equipment> retrievedEquipments = new LoadM <Equipment>();
ObservableCollection <Equipment> equipmentsCollection = retrievedEquipments.RetriveCollection("Equipments");
ILoad <Station> retrivedStations = new LoadM <Station>();
ObservableCollection <Station> stationsCollection = retrivedStations.RetriveCollection("Stations");
var query = (from e in equipmentsCollection
join s in stationsCollection on e.StationId equals s.StationId
select new TaskEquipmentStation()
{
EquipmentId = e.EquipmentId, EquipmentName = e.EquipmentName, StationName = s.StationName
}).ToList();
foreach (var item in query)
{
list.Add(item);
}
return(list);
}