protected void btnSubmit_Click(object sender, EventArgs e)
{
CheckAnswer(Convert.ToInt32(ViewState["num"])); //to check last question binded answer with database answer
string Email = Session["Email"].ToString();
int ressubmit = Convert.ToInt32(Session["res"]); //stores final score to insert in db
List <Tuple <string, string> > parametersList = new List <Tuple <string, string> >();
parametersList.Add(new Tuple <string, string>("@email", Email));
parametersList.Add(new Tuple <string, string>("@result", ressubmit.ToString()));
var data = SqlDataBind.SaveDataByStoredProcedure("usp_UpdateResultData", "ConnectionString", parametersList);
if (data > 0)
{
lblresult.Visible = true;
btnNext.Visible = false;
btnSubmit.Visible = false;
lblQuestion.Visible = false;
lblQNumber.Visible = false;
rboption1.Visible = false;
rboption2.Visible = false;
rboption3.Visible = false;
rboption4.Visible = false;
lblresult.Text = "Your Result is: " + ressubmit.ToString() + "/10";
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
SqlConnection sqlConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
sqlConnection.Open();
SqlCommand cmd = new SqlCommand("usp_CheckEmailExists", sqlConnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@email", txtEmail.Text);
int result = (Int32)cmd.ExecuteScalar();
if (result == 1)
{
Session["Email"] = txtEmail.Text;
Response.Redirect("Exam.aspx");
ScriptManager.RegisterStartupScript(this, GetType(), "success", "alert('Logged in successfully');", true);
}
else
{
List <Tuple <string, string> > parametersList = new List <Tuple <string, string> >();
parametersList.Add(new Tuple <string, string>("@email", txtEmail.Text));
var data = SqlDataBind.SaveDataByStoredProcedure("usp_InsertUserData", "ConnectionString", parametersList);
if (data > 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "success", "alert('Logged in successfully');", true);
}
Session["Email"] = txtEmail.Text;
Response.Redirect("Exam.aspx");
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string value;
SqlConnection sqlConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
sqlConnection.Open();
SqlCommand cmd = new SqlCommand("usp_GetCountOfQuestion", sqlConnection);//get count of question
cmd.CommandType = CommandType.StoredProcedure;
int count = (Int32)cmd.ExecuteScalar();
if (count == 10)//check count is less than or equal because not to allow more than 10 questions to add
{
ScriptManager.RegisterStartupScript(this, GetType(), "success", "alert('Only 10 questions allowed');", true);
}
else
{
if (rboption1.Checked)
{
value = "1";
}
else if (rboption2.Checked)
{
value = "2";
}
else if (rboption3.Checked)
{
value = "3";
}
else
{
value = "4";
}
int id = 0;
List <Tuple <string, string> > parametersList = new List <Tuple <string, string> >();
if (!string.IsNullOrWhiteSpace(Request.QueryString["QuestionID"]))
{
id = Convert.ToInt32(Request.QueryString["QuestionID"]);
}
parametersList.Add(new Tuple <string, string>("@Id", id.ToString()));
parametersList.Add(new Tuple <string, string>("@question", txtQuestion.Text.Trim()));
parametersList.Add(new Tuple <string, string>("@option1", txtOption1.Text.Trim()));
parametersList.Add(new Tuple <string, string>("@option2", txtOption2.Text.Trim()));
parametersList.Add(new Tuple <string, string>("@option3", txtOption3.Text.Trim()));
parametersList.Add(new Tuple <string, string>("@option4", txtOption4.Text.Trim()));
parametersList.Add(new Tuple <string, string>("@answer", value.Trim()));
var data = SqlDataBind.SaveDataByStoredProcedure("usp_InsertQuestion", "ConnectionString", parametersList);
ScriptManager.RegisterStartupScript(this, GetType(), "success", "alert('Data saved successfully');", true);
Clear();
BindData();
}
}
//Delete question by its ID
protected void gvBlog_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int QuestionID = (int)e.Keys["QuestionID"];
List <Tuple <string, string> > parameterList = new List <Tuple <string, string> >();
parameterList.Add(new Tuple <string, string>("@Id", QuestionID.ToString()));
var data = SqlDataBind.SaveDataByStoredProcedure("usp_DeleteQuestionById", "ConnectionString", parameterList);
if (data > 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "success", "alert('Data Deleted successfully');", true);
}
BindData();
}
protected void btnLogout_Click(object sender, EventArgs e)
{
CheckAnswer(Convert.ToInt32(ViewState["num"]));
int Number = Convert.ToInt32(ViewState["num"]);
int result = Convert.ToInt32(Session["res"]);
string Email = Session["Email"].ToString();
List <Tuple <string, string> > parametersList = new List <Tuple <string, string> >();
parametersList.Add(new Tuple <string, string>("@session", Number.ToString()));
parametersList.Add(new Tuple <string, string>("@result", result.ToString()));
parametersList.Add(new Tuple <string, string>("@email", Email));
var data = SqlDataBind.SaveDataByStoredProcedure("usp_UpdateSessionData", "ConnectionString", parametersList);//store all values because if this user comes back then get him/her to directly there where he left.
if (data > 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "success", "alert('Logout successfully');", true);
Session["Email"] = null;
Session.Abandon();
Response.Redirect("Login.aspx");
}
}