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