public static Ventilator_status GetSingleVentilatorStatus(int _statusID) { ObservableCollection <Ventilator_status> status = new ObservableCollection <Ventilator_status>(); DataTable table = new DataTable(); SqlDataAdapter adapter = new SqlDataAdapter("SELECT Ventilator_status.*, Company.*, Ventilator.*, Service_agreement_package.* FROM Ventilator_status INNER JOIN Ventilator ON Ventilator.Ventilator_id = Ventilator_status.FK_Ventilator_id INNER JOIN Company ON Company.Company_id = Ventilator.FK_Company_id INNER JOIN Service_agreement_package ON Ventilator.FK_Service_agreement_package_id = Service_agreement_package.Service_agreement_package_id WHERE Ventilator_status.Ventilator_status_id = @id", connection); adapter.SelectCommand.Parameters.Add(CreateParam("@id", _statusID, SqlDbType.Int)); try { adapter.Fill(table); } catch (Exception) { MessageBox.Show("GetSingleVentilatorStatus failed", "Warning", MessageBoxButton.OK, MessageBoxImage.Error); } foreach (DataRow row in table.Rows) { Company company = new Company(row); Service_agreement_package service_Agreement_Package = new Service_agreement_package(row); Ventilator ventilator = new Ventilator(row, company, service_Agreement_Package); status.Add(new Ventilator_status(row, ventilator)); } Ventilator_status _status = status[0]; return(_status); }
private void Row_DoubleClick_Show_Valid_Status(object sender, MouseButtonEventArgs e) { Ventilator_status selectedVentilatorStatus = (Ventilator_status)validStatus.SelectedItem; Employee selectedEmployee = (Employee)ServiceTechnicians.SelectedItem; ErrorStatus window = new ErrorStatus(selectedVentilatorStatus, selectedEmployee); window.Show(); }
public CorrectError(Ventilator_status _status, Employee _employee, Error_type _errorType) { InitializeComponent(); status = _status; employee = _employee; errorType = _errorType; // Vis fejl type der skal rette nu. lbl_error_header.Content = "Ret fejl - " + _errorType.Type_name; }
private void Row_DoubleClick_Show_Invalid_Status(object sender, MouseButtonEventArgs e) { Employee selectedEmployee = (Employee)ServiceTechnicians.SelectedItem; if (!(selectedEmployee == null)) { Ventilator_status selectedVentilatorStatus = (Ventilator_status)invalidStatus.SelectedItem; window_ErrorStatus = new ErrorStatus(selectedVentilatorStatus, selectedEmployee); window_ErrorStatus.Show(); } else { MessageBox.Show("Vælg service tekniker!", "Manlgende input", MessageBoxButton.OK, MessageBoxImage.Hand); } }
public static void StoreGeneratedStatus(Ventilator_status _newVentilator_status) { int success = 0; SqlCommand command = new SqlCommand("INSERT INTO Ventilator_status([Datetime], Celcius, Hertz, kWh, Amps, Validated, FK_Ventilator_id) VALUES(CURRENT_TIMESTAMP, @Celcius, @Hertz, @kWh, @Amps, NULL, @vent_id)", connection); command.Parameters.Add(CreateParam("@Celcius", _newVentilator_status.Celcius, SqlDbType.Int)); command.Parameters.Add(CreateParam("@Hertz", _newVentilator_status.Hertz, SqlDbType.Int)); command.Parameters.Add(CreateParam("@kWh", _newVentilator_status.kWh, SqlDbType.Int)); command.Parameters.Add(CreateParam("@Amps", _newVentilator_status.Amps, SqlDbType.Int)); command.Parameters.Add(CreateParam("@vent_id", _newVentilator_status.Ventilator.Ventilator_id, SqlDbType.Int)); try { OpenConnection(); success = command.ExecuteNonQuery(); CloseConnection(); } catch (Exception) { MessageBox.Show("GenerateStatus failed", "Warning", MessageBoxButton.OK, MessageBoxImage.Error); } }
public ErrorStatus(Ventilator_status _selectedVentilatorStatus, Employee _selectedEmployee) { InitializeComponent(); GetErrorType(); ventilatorStatus = _selectedVentilatorStatus; employee = _selectedEmployee; lbl_ventilator_id.Content = "#" + _selectedVentilatorStatus.Ventilator.Ventilator_id; lbl_address.Content = _selectedVentilatorStatus.Ventilator.Address + "."; lbl_max_temperatur.Content = _selectedVentilatorStatus.Ventilator.SAP.Celcius + "C"; lbl_max_amps.Content = _selectedVentilatorStatus.Ventilator.SAP.Amps + "A"; lbl_max_hertz.Content = _selectedVentilatorStatus.Ventilator.SAP.Hertz + "Hz"; lbl_max_kwh.Content = _selectedVentilatorStatus.Ventilator.SAP.kWh + "kWh"; lbl_current_temperatur.Content = _selectedVentilatorStatus.Celcius; lbl_current_amps.Content = _selectedVentilatorStatus.Amps; lbl_current_hertz.Content = _selectedVentilatorStatus.Hertz; lbl_current_kwh.Content = _selectedVentilatorStatus.kWh; SetColorSeverity(rec_temperatur, _selectedVentilatorStatus.Celcius, _selectedVentilatorStatus.Ventilator.SAP.Celcius); SetColorSeverity(rec_amps, _selectedVentilatorStatus.Amps, _selectedVentilatorStatus.Ventilator.SAP.Amps); SetColorSeverity(rec_hertz, _selectedVentilatorStatus.Hertz, _selectedVentilatorStatus.Ventilator.SAP.Hertz); SetColorSeverity(rec_kwh, _selectedVentilatorStatus.kWh, _selectedVentilatorStatus.Ventilator.SAP.kWh); }
private void CreateNewVentilatorAndNewVentilatorStatus() { newVentilator_status = new Ventilator_status(); newVentilator = new Ventilator(); }
private void GenerateStatus(Ventilator_status _newVentilator_status) { DB.StoreGeneratedStatus(_newVentilator_status); }