public void insertOption(string idQues)
{
string queryInsertOption = string.Format("insert into Options values(N'{0}',{1},{2},{3})",
RgEx.isNullOrEmpty(Contents), RgEx.isNullOrEmpty(idQues), RgEx.isNullOrEmpty(isImages), RgEx.isNullOrEmpty(isCorrect));
ReturnClass.ExcuteNonQuery(queryInsertOption);
}
public void InsertQuestion()
{
string query = string.Format("insert into questions values (N'{0}','{1}',{2},'{3}',{4},'{5}')",
RgEx.isNullOrEmpty(q_title), RgEx.isNullOrEmpty(q_addeddate), RgEx.isNullOrEmpty(q_fk_ex),
RgEx.isNullOrEmpty(ad_add), RgEx.isNullOrEmpty(isImage), this.explain);
ReturnClass.ExcuteNonQuery(query, ReturnClass.Status.insert);
query = string.Format("select top 1 q_id from questions order by q_id desc");
string id_Ques = ReturnClass.scalarReturn(query);
options.ForEach
(
x => x.insertOption(id_Ques)
);
}
public void updateOption()
{
if (string.IsNullOrEmpty(this.id))
{
insertOption(id_Qus); return;
}
if (RgEx.isEmpty(Contents))
{
DeleteOption(); return;
}
string queryInsertOption = string.Format("update Options set Contents = N'{0}', isImages = {1},isCorrect = {2} where id_Qus = {3} and id ={4}",
RgEx.isNullOrEmpty(Contents), RgEx.isNullOrEmpty(isImages), RgEx.isNullOrEmpty(isCorrect),
RgEx.isNullOrEmpty(id_Qus), RgEx.isNullOrEmpty(id));
ReturnClass.ExcuteNonQuery(queryInsertOption);
}