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