/// <summary>
/// Delete Question from the DataBase
/// </summary>
/// <param name="QuestionNumber"> the primary key of the selected question </param>
public void DeletedQuestion(int QuestionNumber)
{
DAL.DataAccessLayer data = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter(@"Question_Number", SqlDbType.Int);
param[0].Value = QuestionNumber;
data.executeCommand("DeleteQuestions", param);
}
/// <summary>
/// Insert Question on the DataBase
/// </summary>
public void InsertData()
{
DAL.DataAccessLayer data = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter(@"Question", SqlDbType.VarChar, 3000);
param[0].Value = this.question;
param[1] = new SqlParameter(@"Answer", SqlDbType.VarChar, 3000);
param[1].Value = this.answer;
param[2] = new SqlParameter(@"Kind", SqlDbType.VarChar, 100);
param[2].Value = this.kind;
param[3] = new SqlParameter(@"Levels", SqlDbType.Int);
param[3].Value = this.level;
data.executeCommand("InsertQuestions", param);
}
/// <summary>
/// Delete All Questions from the DataBase
/// </summary>
public void DeletedAllQuestions()
{
DAL.DataAccessLayer data = new DAL.DataAccessLayer();
data.executeCommand("DeleteAllQuestions", null);
}