public void IdResbyTdTest(int id) { try { SqlConnection conn = new SqlConnection(SqlConn.ConnectionString.defaultString); SqlCommand command = new SqlCommand("IdResbyTdTest", conn); command.Parameters.AddWithValue("@idT", id); command.CommandType = System.Data.CommandType.StoredProcedure; conn.Open(); SqlDataReader result = command.ExecuteReader(); while (result.Read()) { Models.ResultModel idres = new Models.ResultModel( (int)result["ID_Result"] ); listIdRes.Add(idres); } conn.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void FillList(string user) { SqlConnection conn = new SqlConnection(SqlConn.ConnectionString.defaultString); SqlCommand command = new SqlCommand("GetIdResultByLogin", conn); command.Parameters.AddWithValue("@login", user); command.CommandType = System.Data.CommandType.StoredProcedure; conn.Open(); SqlDataReader result = command.ExecuteReader(); while (result.Read()) { Models.ResultModel idres = new Models.ResultModel( (int)result["ID_RESULTH"] ); Id.Add(idres); } // list.ItemsSource = Id; conn.Close(); GetTestId(); GetNameTest(); }
public void IdQResultIdTest(int id)//получаем список ид результатов по ИД теста { try { SqlCommand command = new SqlCommand("IdQResultIdTest", conn); command.Parameters.AddWithValue("@idTest", id); command.CommandType = System.Data.CommandType.StoredProcedure; conn.Open(); SqlDataReader result = command.ExecuteReader(); while (result.Read()) { Models.ResultModel idres = new Models.ResultModel( (int)result["ID_Result"] ); listIdR.Add(idres); } conn.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }