private void EditServiceman_Load(object sender, EventArgs e) { if (_id != -1) { Serviceman name = _db.GetServiceman(_id); if (name == null) { ShowErrorMessageBox("No serviceman with this ID!"); return; } } }
public Serviceman GetServiceman(int id) { SqlCommand command = new SqlCommand($"SELECT * FROM Servicemans WHERE Id_Serviceman = {id}", _connection); SqlDataReader reader = command.ExecuteReader(); Serviceman result = null; if (reader.Read()) { result = new Serviceman() { Id_Serviceman = (int)reader["Id_Serviceman"], Last_Name = reader["Last_Name"].ToString(), First_Name = reader["First_Name"].ToString(), Pathronymic = reader["Pathronymic"].ToString(), Age = (int)reader["Age"], Id_rank = (int)reader["Id_rank"], Branches_id_Branch = (int)reader["Branches_id_Branch"] }; } reader.Close(); return(result); }