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