public static Instruction Create(string name)
{
Instruction instruction;
// Insert new instruction
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["SqlServer"].ConnectionString))
{
using (SqlCommand command = new SqlCommand("dbo.Instruction_Insert", connection))
{
command.CommandType = CommandType.StoredProcedure;
//command.Parameters.AddWithValue("@InstructionID", 0).Direction = ParameterDirection.Output;
command.Parameters.Add("@InstructionID", SqlDbType.Int);
command.Parameters["@InstructionID"].Direction = ParameterDirection.Output;
command.Parameters.AddWithValue("@InstructionName", name);
connection.Open();
command.ExecuteNonQuery();
instruction = new Instruction((int)command.Parameters["@InstructionID"].Value, name);
connection.Close();
} // SqlCommand
} // SqlConnection
return instruction;
}
public static Instruction GetInstructionByID(int id)
{
Instruction instruction = null;
// Select instruction
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["SqlServer"].ConnectionString))
{
using (SqlCommand command = new SqlCommand("db_datareader.Instruction_Select", connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@InstructionID", id);
connection.Open();
using (SqlDataReader dataReader = command.ExecuteReader())
{
if (dataReader.HasRows && dataReader.Read())
{
instruction = new Instruction(id,
(string)dataReader["InstructionName"]
);
}
} // SqlDataReader
} // SqlCommand
} // SqlConnection
return instruction;
}
