public getData updateQuestion(Questions q)
{
getData gd = new getData();
OleDbCommand cmd = new OleDbCommand("UPDATE Questions SET QuestionType=@QTP, Question=@QTN, Option1=@OP1, Option2=@OP2, Option3=@OP3, Option4=@OP4, Answer=@ANS, MaxTime=@MAX, Points=@PTS WHERE ID=" + q.ID, cm);
cmd.Parameters.AddWithValue("@QTP", q.QuestionType);
cmd.Parameters.AddWithValue("@QTN", q.Question);
cmd.Parameters.AddWithValue("@OP1", q.Option1);
cmd.Parameters.AddWithValue("@OP2", q.Option2);
cmd.Parameters.AddWithValue("@OP3", q.Option3);
cmd.Parameters.AddWithValue("@OP4", q.Option4);
cmd.Parameters.AddWithValue("@ANS", q.Answer);
cmd.Parameters.AddWithValue("@MAX", q.MaxTime);
cmd.Parameters.AddWithValue("@PTS", q.Points);
try
{
cm.Open();
gd.Count = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
gd.Message = ex.Message;
}
finally { cm.Close(); }
return(gd);
}
private void btnSave_Click(object sender, EventArgs e)
{
getData gd = new getData();
Questions q = new Questions();
Quiz qz = new Quiz();
q.ID = QID;
q.QuestionType = Convert.ToInt32(lueQTP.EditValue);
q.Question = txtQSTN.Text;
q.Option1 = txtANS1.Text;
q.Option2 = txtANS2.Text;
q.Option3 = txtANS3.Text;
q.Option4 = txtANS4.Text;
q.Answer = txtANS.Text;
q.MaxTime = Convert.ToInt32(txtSEC.EditValue);
q.Points = Convert.ToInt32(txtVAL.EditValue);
if (btnSave.Text == "&Save")
{
gd = qz.addQuestion(q);
if (gd.Count == 1 || gd.Message == "")
{
XtraMessageBox.Show("Question successfully added!");
}
}
else
{
gd = qz.updateQuestion(q);
if (gd.Count == 1 || gd.Message == "")
{
XtraMessageBox.Show("Question successfully updated!");
}
}
}
public getData addQuestion(Questions q)
{
getData gd = new getData();
OleDbCommand cmd = new OleDbCommand("INSERT INTO Questions(QuestionType, Question, Option1, Option2, Option3, Option4, Answer, MaxTime, Points) VALUES (@QTP, @QTN, @OP1, @OP2, @OP3, @OP4, @ANS, @MAX, @PTS)", cm);
cmd.Parameters.AddWithValue("@QTP", q.QuestionType);
cmd.Parameters.AddWithValue("@QTN", q.Question);
cmd.Parameters.AddWithValue("@OP1", q.Option1);
cmd.Parameters.AddWithValue("@OP2", q.Option2);
cmd.Parameters.AddWithValue("@OP3", q.Option3);
cmd.Parameters.AddWithValue("@OP4", q.Option4);
cmd.Parameters.AddWithValue("@ANS", q.Answer);
cmd.Parameters.AddWithValue("@MAX", q.MaxTime);
cmd.Parameters.AddWithValue("@PTS", q.Points);
try
{
cm.Open();
gd.Count = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
gd.Message = ex.Message;
}
finally { cm.Close(); }
return(gd);
}
public ucTeams()
{
InitializeComponent();
gd = q.getAllTeams();
grd.DataSource = gd.DT;
}
public ucDataEntry()
{
InitializeComponent();
getData gd = new getData();
Quiz q = new Quiz();
gd = q.getQuestions();
grd.DataSource = gd.DT;
}
private void bDelete_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
int QID = Convert.ToInt32(grv.GetFocusedRowCellValue(colID));
if (XtraMessageBox.Show("Do you really want to delete this question?", "Confirm delete", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
getData gd = new getData();
Quiz q = new Quiz();
gd = q.deleteQuestion(QID);
//if(gd.Message == "")
}
}
public getData getQuestionTypes()
{
getData gd = new getData();
OleDbCommand cmd = new OleDbCommand("SELECT ID, QuestionType FROM QuestionTypes ORDER BY ID", cm);
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
gd.Count = ds.Tables[0].Rows.Count;
gd.DS = ds;
gd.DT = ds.Tables[0];
return(gd);
}
public frmDataEntry()
{
InitializeComponent();
getData gd = new getData();
Quiz q = new Quiz();
gd = q.getQuestionTypes();
lueQTP.Properties.DataSource = gd.DT;
lueQTP.Properties.DisplayMember = "QuestionType";
lueQTP.Properties.ValueMember = "ID";
lueQTP_EditValueChanged(null, null);
}
public getData getTeams(string Status)
{
getData gd = new getData();
OleDbCommand cmd = new OleDbCommand("SELECT ID, TeamName, Status FROM Teams WHERE Status='" + Status + "'", cm);
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
DataTable dt = ds.Tables[0];
gd.Count = dt.Rows.Count;
gd.DS = ds;
gd.DT = dt;
return(gd);
}
public getData getQuestions(int QID)
{
getData gd = new getData();
OleDbCommand cmd = new OleDbCommand("SELECT q.ID, qt.ID AS QID, qt.QuestionType, q.Question, q.Option1, q.Option2, q.Option3, q.Option4, q.Answer, q.MaxTime, q.Points FROM QuestionTypes qt INNER JOIN Questions q ON qt.ID = q.QuestionType WHERE q.ID = " + QID, cm);
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
DataTable dt = ds.Tables[0];
gd.Count = dt.Rows.Count;
gd.DS = ds;
gd.DT = dt;
return(gd);
}
public frmDataEntry(int ID)
{
InitializeComponent();
QID = ID;
btnSave.Text = "&Update";
getData gd = new getData();
Quiz q = new Quiz();
gd = q.getQuestionTypes();
lueQTP.Properties.DataSource = gd.DT;
lueQTP.Properties.DisplayMember = "QuestionType";
lueQTP.Properties.ValueMember = "ID";
gd = q.getQuestions(QID);
lueQTP.EditValue = gd.DT.Rows[0].ItemArray[1];
txtQSTN.Text = gd.DT.Rows[0].ItemArray[3].ToString();
txtANS1.Text = gd.DT.Rows[0].ItemArray[4].ToString();
txtANS2.Text = gd.DT.Rows[0].ItemArray[5].ToString();
txtANS3.Text = gd.DT.Rows[0].ItemArray[6].ToString();
txtANS4.Text = gd.DT.Rows[0].ItemArray[7].ToString();
if (gd.DT.Rows[0].ItemArray[8].ToString() == gd.DT.Rows[0].ItemArray[4].ToString())
{
rdoANS.SelectedIndex = 0;
}
else if (gd.DT.Rows[0].ItemArray[8].ToString() == gd.DT.Rows[0].ItemArray[5].ToString())
{
rdoANS.SelectedIndex = 1;
}
else if (gd.DT.Rows[0].ItemArray[8].ToString() == gd.DT.Rows[0].ItemArray[6].ToString())
{
rdoANS.SelectedIndex = 2;
}
else
{
rdoANS.SelectedIndex = 3;
}
txtANS.Text = gd.DT.Rows[0].ItemArray[8].ToString();
txtVAL.Text = gd.DT.Rows[0].ItemArray[10].ToString();
txtSEC.Text = gd.DT.Rows[0].ItemArray[9].ToString();
lueQTP_EditValueChanged(null, null);
}
public frmStart()
{
InitializeComponent();
getData gd = new getData();
Quiz q = new Quiz();
gd = q.getTeams("Active");
lueTeam.Properties.DataSource = gd.DT;
lueTeam.Properties.DisplayMember = "TeamName";
lueTeam.Properties.ValueMember = "ID";
gd = q.getQuestionTypes();
lueQType.Properties.DataSource = gd.DT;
lueQType.Properties.DisplayMember = "QuestionType";
lueQType.Properties.ValueMember = "ID";
}
public getData deleteQuestion(int QID)
{
getData gd = new getData();
OleDbCommand cmd = new OleDbCommand("DELETE FROM Questions WHERE ID=" + QID, cm);
try
{
cm.Open();
gd.Count = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
gd.Message = ex.Message;
}
finally { cm.Close(); }
return(gd);
}
