public static Tech GetTechDataByID(string id) { SqlConnection sqlConnection = new SqlConnection(ConnectionAdres); Tech tech = null; SqlCommand nameComand = new SqlCommand($"SELECT * FROM technic WHERE ID = '{id}';", sqlConnection); sqlConnection.Open(); SqlDataReader reader = nameComand.ExecuteReader(); reader.Read(); if (reader.HasRows) { var type = reader.GetString(1); var company = reader.GetString(2); var model = reader.GetString(3); var businessNumber = reader.GetString(4); var serialNumber = reader.GetString(5); tech = new Tech { type = type, company = company, model = model, businessNumber = businessNumber, serialNumber = serialNumber }; } reader.Close(); sqlConnection.Close(); return(tech); }
private void Button_Click_1(object sender, RoutedEventArgs e) { if (techID.Text != "") { Tech tech = Querys.GetTechDataByID(techID.Text); if (tech != null) { typeBox.Text = tech.type; firmBox.Text = tech.company; modelNumber.Text = tech.model; sirialNumber.Text = tech.serialNumber; buisnesNumber.Text = tech.businessNumber; } } else { errorLabel.Content = "Поле должно быть заполненно"; } }