public void Create(TestOptionDto testOption, string testId)
{
using (SqlConnection sqlConnection = new SqlConnection(_connectionString))
{
using (SqlCommand sqlCommand = new SqlCommand("AddTestOption", sqlConnection))
{
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add("@testId", SqlDbType.Int).Value = testId;
sqlCommand.Parameters.Add("@name", SqlDbType.NVarChar, 50).Value = testOption.Name;
sqlCommand.Parameters.Add("@isChecked", SqlDbType.Bit).Value = testOption.IsChecked;
sqlConnection.Open();
sqlCommand.ExecuteNonQuery();
}
}
}
public TestOptionDto Get(string id)
{
TestOptionDto testOption = null;
using (SqlConnection sqlConnection = new SqlConnection(_connectionString))
{
using (SqlCommand sqlCommand = new SqlCommand("GetTestOption", sqlConnection))
{
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add("@id", SqlDbType.Int).Value = id;
sqlConnection.Open();
using (SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(CommandBehavior.CloseConnection))
{
while (sqlDataReader.Read())
{
string name = sqlDataReader.GetString(sqlDataReader.GetOrdinal("Name"));
bool isChecked = sqlDataReader.GetBoolean(sqlDataReader.GetOrdinal("IsChecked"));
testOption = new TestOptionDto()
{
Id = id,
IsChecked = isChecked,
Name = name,
};
}
sqlDataReader.Close();
}
}
}
return(testOption);
}
public void Update(TestOptionDto option)
{
testOptionServiceClient.Update(option);
}
public TestOptionDto Get(string id)
{
TestOptionDto option = testOptionServiceClient.Get(id);
return(option);
}
public void Create(TestOptionDto test, string testId)
{
testOptionServiceClient.Create(test, testId);
}
