Tech Services : June 2017

Online examination system project In Asp.Net with c#, SQL Database including Admin Panel - Download Part 3

StartExam.aspx page code

<%@ Page Title="" Language="C#" MasterPageFile="~/MainPage.Master" AutoEventWireup="true" CodeBehind="StartExam.aspx.cs" Inherits="OnlineExam.StartExam" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">

function validate() {

if (document.getElementById("<%=disclaimer.ClientID%>").Checked == false) {

alert("Please check Terms & Conditions");

return false;

}

</script>

type="text/css" />

<tr>

 </td>

</tr>

<tr>

<td>

<tr>

Student Id :

</td>

<asp:TextBox ID="txt_stdId" runat="server" CssClass="textbox" Width="135px"

ReadOnly="True"></asp:TextBox><%--onkeydown="
 if ( !isAlpha ( event ) ) {
 alert ( 'Oops! Alphabets only please.' );
 return false;
 }"--%>

</td>

</tr>

<tr>

Select Subjuct :

</td>

<asp:DropDownList ID="DdlProgrm" runat="server" Height="23px" Width="133px"

</asp:DropDownList>

<asp:RequiredFieldValidator ID="rfvlname0" runat="server" ControlToValidate="DdlProgrm"

ToolTip="program Required!" ValidationGroup="valid"><img src="images/question.gif" width="15px" height="15px"/></asp:RequiredFieldValidator>

</td>

</tr>

<tr>

 </td>

<asp:ImageButton ID="ImgBtnStartExm" runat="server"

ImageUrl="~/IMAGES/button copy.PNG" onclick="ImgBtnStartExm_Click" />

<br />

</td>

</tr>

<tr>

</td>

 </td>

</tr>

<tr>

    </td>

</tr>

</table>

</td>

</tr>

</table>

</div>

<div class="sysInstText1"

style="height: 99%; width: 100%; overflow: auto; text-align: left;"><div> <br>

<br>

<center style="font-size: large; color: #663300"><b>Please read the instructions carefully

</b></center> </div>

<p style="text-align: left"><strong><u>General Instructions:</u></strong></p>

<ol style="TEXT-ALIGN: left; LIST-STYLE-TYPE: decimal; PADDING-LEFT: 4%; PADDING-TOP: 3px"> <li>Total duration of examination is <span class="completeDuration"></span> </li> <li>The clock will be set at the server. The countdown timer in the top right corner of screen will display the remaining time available for you to complete the examination. When the timer reaches zero, the examination will end by itself. <table class="instruction_area" style="FONT-SIZE: 100%"> <tbody> <tr> <td><span class="not_visited" title="Not Visited">

<asp:Button ID="Button2" runat="server" Text="" class="btn btn-default" Width="40px" /></span></td> <td>    You have not visited the question yet.</td>

</tr> <tr> <td><span class="not_answered" title="Not Answered">

<asp:Button ID="Button3" runat="server" Text="" class="btn btn-info" Width="40px" /></span></td>

<td>    You have not answered the question.</td> </tr> <tr> <td><span class="answered" title="Answered">

<asp:Button ID="Button4" runat="server" Text="" class="btn btn-success" Width="40px" /></span></td>

<td>    You have answered the question.</td> </tr> <tr> <td><span class="review" title="Marked for Review">

<asp:Button ID="Button5" runat="server" Text="" class="btn btn-warning" Width="40px" /></span></td>

<td>    You have NOT answered the question, but marked for review.</td> </tr> <tr>

<asp:Button ID="Button6" runat="server" Text="" class="btn btn-danger" Width="40px" /></span></td>

<td>    You have answered the question, but marked for review.</td> </tr> </tbody> </table> </li>

<li style="LIST-STYLE-TYPE: none">The Marked for Review status for a question simply indicates that you would like to look at that question again.</li>

</ol>

<br> <strong><u>Navigating to a Question:</u></strong><br>

</div>

To answer a question, do the following<ol style="TEXT-ALIGN: left; PADDING-LEFT: 4%; PADDING-TOP: 3px" type="a"> <li>Click on the question number in the Question Palette at the right of your screen to go to that numbered question directly. </li> <li>Click on <b>Save & Next</b> to save your answer for the current question and then go to the next question.</li> <li>Click on <b>Mark for Review & Next</b> to save your answer for the current question, mark it for review, and then go to the next question.</li>

</ol>

</li>

</ol>

<p style="text-align: left"> <b><u>Answering a Question : </u></b></p>

<ol start="5" style="TEXT-ALIGN: left; LIST-STYLE-TYPE: decimal; PADDING-LEFT: 4%; PADDING-TOP: 3px"> <li>Procedure for answering a multiple choice type question:<ol style="TEXT-ALIGN: left; PADDING-LEFT: 4%; PADDING-TOP: 3px" type="a"> <li>To select your answer, click on the button of one of the options</li> <li>To mark the question for review, click on the<b> Mark for Review & Next</b> button.</li>

</ol>

<br>

</li>

</ol>

<p style="text-align: left"> <b><u>Navigating through sections:</u></b></p>

<p>

<span ></span><span ><span style="" class="cusInstText1"><input runat="server" type="checkbox" id="disclaimer" onclick="linkDisp();" style="margin-top:2px;margin-right:10px">I have read and understood the instructions. </span></span></p>

<p>

 </p>

<p>

<asp:Button class="btn btn-primary btn-primary-blue" ID="Button1"

OnClientClick="return validate();" runat="server" Text="I am ready to begin" onclick="Button1_Click" /></p>

<p>

 </p>

</div></div></div>

</asp:Content>

===============================================================

StartExam.aspx.cs page code

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

using System.IO;

namespace OnlineExam

{

public partial class StartExam : System.Web.UI.Page

{

DataSet ds = new DataSet();

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConOnlineExam"].ConnectionString);

SqlDataAdapter adp ;

SqlCommand cmd ;

SqlCommand cmd1;

Dal info = new Dal();

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

if (Session["Username"] == null)

{

Response.Redirect("index.aspx");

}

bindSubjucts();

txt_stdId.Text = Session["Username"].ToString();

divFirst.Visible = true;

divSecond.Visible = false;

}

private void WriteLog(string strError)

{

try

{

string AppPath = AppDomain.CurrentDomain.BaseDirectory;

string strLog = @"LOGS\";

string strFilePath = AppPath + strLog;

if (!(Directory.Exists(strFilePath)))

{

Directory.CreateDirectory(strFilePath);

}

string fn = string.Format("{0}{1}.txt", strFilePath, DateTime.Now.ToString("ddMMyyyy"));

FileStream fs = new FileStream(fn, FileMode.Append, FileAccess.Write, FileShare.ReadWrite);

StreamWriter writer = new StreamWriter(fs);

writer.WriteLine(string.Format("[ {0} ] {1}", DateTime.Now.ToString("HH:mm:ss"), strError));

writer.Close();

fs.Close();

}

finally

{

//nothing

}

private void bindSubjucts()

{

try

{

adp = new SqlDataAdapter("select sid,sname from Subjects order by sname", con);

ds = new DataSet();

adp.Fill(ds);

DdlProgrm.DataSource = ds;

DdlProgrm.DataTextField = "sname";

DdlProgrm.DataValueField = "sid";

DdlProgrm.DataBind();

DdlProgrm.Items.Insert(0, "--Select--");

}

catch (Exception ex)

{

WriteLog(ex.Message);

}

protected void ImgBtnStartExm_Click(object sender, ImageClickEventArgs e)

{

if (DdlProgrm.SelectedIndex == 0)

{

ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Please Select Subjuct', ' Please Select Subjuct', 'Please Select Subjuct ')", true);

return;

}

divFirst.Visible = false;

divSecond.Visible = true;

}

protected void Button1_Click(object sender, EventArgs e)

{

if (disclaimer.Checked == false)

{

ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Please check Terms & Conditions', 'Please check Terms & Conditions', 'Please check Terms & Conditions ')", true);

return;

}

if (Session["Username"] != null)

{

string user = Session["Username"].ToString();

DataSet ds = info.GetQuestions(Convert.ToInt32(DdlProgrm.SelectedValue));

cmd1 = new SqlCommand("select isnull(max(ExamId)+1,1) from ExamHistory where Sid = '" + Convert.ToInt32(DdlProgrm.SelectedValue) + "' and StId ='" + Session["Username"].ToString() + "' ", con);

con.Open();

cmd1.CommandType = CommandType.Text;

int j = Convert.ToInt32(cmd1.ExecuteScalar());

Session["ExamId"] = j;

if (ds.Tables[0].Rows.Count > 0)

{

Session["questionpaper"] = ds;

for (int i = 0; i < ds.Tables[0].Rows.Count; i++)

{

cmd = new SqlCommand("insert into ExamHistory(Sid, StId, ExamId, Qid, CreatedDate, Ans, Choise) values ('" + Convert.ToInt32(DdlProgrm.SelectedValue) + "' , '" + user + "', '" + j + "', '" + Convert.ToInt32(ds.Tables[0].Rows[i]["qid"]) + "', getdate(), '" + Convert.ToInt32(ds.Tables[0].Rows[i]["cans"]) + "' , 0) ", con);

cmd.CommandType = CommandType.Text;

cmd.ExecuteNonQuery();

}

con.Close();

Response.Redirect("Exam.aspx?p=" + Convert.ToInt32(DdlProgrm.SelectedValue));

}

else

{

//logout page

}

==================================================================

Result.aspx page code

<%@ Page Title="" Language="C#" MasterPageFile="~/MainPage.Master" AutoEventWireup="true" CodeBehind="Result.aspx.cs" Inherits="OnlineExam.Result" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">

<tr>

<asp:Image ID="Image1" runat="server" Height="331px" Width="293px"

ImageUrl="~/img/result.jpg" /></td>

<tr>

 </td>

Student ID:          

</td>

<asp:Label ID="lblID" runat="server" Text=""></asp:Label></td>

</tr>

<tr>

Subject:

</td>

<asp:Label ID="lblSUb" runat="server" Text=""></asp:Label></td>

</tr>

<tr>

Starting Time :

</td>

<asp:Label ID="lblStart" runat="server" Text=""></asp:Label></td>

</tr>

<tr>

End Time :

</td>

<asp:Label ID="lblEnd" runat="server" Text=""></asp:Label></td>

</tr>

<tr>

No. of Questions :

</td>

<asp:Label ID="lblNoq" runat="server" Text=""></asp:Label></td>

</tr>

<tr>

Answered :

</td>

<asp:Label ID="lblAns" runat="server" Text=""></asp:Label></td>

</tr>

<tr>

Correct Answers :

</td>

<asp:Label ID="lblCans" runat="server" Text=""></asp:Label></td>

</tr>

<tr>

Un-Answered :

</td>

<asp:Label ID="lblUnans" runat="server" Text=""></asp:Label></td>

</tr>

<tr>

Wrong :

</td>

<asp:Label ID="lblWrong" runat="server" Text=""></asp:Label> </td>

</tr>

<tr>

Un-Answered :

</td>

<asp:Label ID="Label3" runat="server" Text=""></asp:Label></td>

</tr>

</td>

<a href="" id ="Nav" runat="server">VIEW YOUR ANSWERS</a>

</tr></td></tr></table>

</td>

</tr></table>

</asp:Content>

=========================================================================================

Result.aspx.cs page code

using System;

using System.Collections.Generic;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.SqlClient;

using System.Data;

using System.Linq;

using System.Collections;

using System.Configuration;

namespace OnlineExam

{

public partial class Result : System.Web.UI.Page

{ SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConOnlineExam"].ConnectionString);

SqlDataAdapter adp;

DataSet ds;

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

DataSet ds2 = new DataSet();

ds2 = (DataSet)Session["questionpaper"];

adp = new SqlDataAdapter("select * from Exams left join Subjects on Exams.sid=Subjects.sid where Exams.examid ='" + Convert.ToInt32(Request.QueryString["p"]) + "'", con);

ds = new DataSet();

adp.Fill(ds);

if (ds.Tables[0].Rows.Count > 0)

{

lblID.Text=Session["Username"].ToString();

lblSUb.Text=(ds.Tables[0].Rows[0]["sname"]).ToString();

lblNoq.Text=(ds.Tables[0].Rows[0]["noq"]).ToString();

lblAns.Text=(ds.Tables[0].Rows[0]["Answered"]).ToString();

lblCans.Text=(ds.Tables[0].Rows[0]["nocans"]).ToString();

lblUnans.Text=(ds.Tables[0].Rows[0]["unans"]).ToString();

lblWrong.Text=(ds.Tables[0].Rows[0]["wrong"]).ToString();

lblStart.Text = (Session["Stoptime"]).ToString();

lblEnd.Text = (Session["Etime"]).ToString();

}

Nav.HRef = "ViewPaper.aspx?id=" + Convert.ToInt32(ds.Tables[0].Rows[0]["ExamHistid"]);

}

=====================================================================

ViewPaper.aspx page code

<%@ Page Title="" Language="C#" MasterPageFile="~/MainPage.Master" AutoEventWireup="true" CodeBehind="ViewPaper.aspx.cs" Inherits="OnlineExam.ViewPaper" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">

<table>

<tr>

<asp:ImageButton ID="btnExcel" runat="server" ImageUrl="~/img/Excel-icon.png"

onclick="btnExcel_Click" Height="48px" Width="81px" />

<asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="~/img/word.png"

onclick="btnWord_Click" Height="50px" Width="77px" />

</td>

</tr>

<tr>

<td>

<asp:GridView runat="server" ID="gvdetails"

AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False"

Width="954px" style="margin-right: 13px"

onpageindexchanging="gvdetails_PageIndexChanging">

<asp:TemplateField>

Review Questions</h2>

</HeaderTemplate>

<pre>Correct Answer :<%# DataBinder.Eval(Container.DataItem, "Ans")%></pre>

<pre>Your Answer :<%# DataBinder.Eval(Container.DataItem, "Choise")%></pre>

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

</td>

</tr>

</table>

</asp:Content>

==========================================================================================

ViewPaper.aspx.cs page code

using System;

using System.Data;

using System.Configuration;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Data.SqlClient;

using System.Data;

using System.IO;

namespace OnlineExam

{

public partial class ViewPaper : System.Web.UI.Page

{

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConOnlineExam"].ConnectionString);

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

try

{

if (Session["UserName"] == null)

{

Response.Redirect("index.aspx");

}

catch

{

}

bindgrid();

}

private void bindgrid()

{

SqlDataAdapter adp = new SqlDataAdapter("select * from ExamHistory left join Questions on ExamHistory.Qid = Questions.qid where StId = '" + Session["Username"].ToString() + "' and ExamId = '" + Convert.ToInt32(Request.QueryString["id"]) + "' ", con);

DataSet ds = new DataSet();

adp.Fill(ds);

if (ds.Tables[0].Rows.Count > 0)

{

gvdetails.DataSource = ds;

gvdetails.DataBind();

}

public override void VerifyRenderingInServerForm(Control control)

{

/* Verifies that the control is rendered */

}

protected void btnExcel_Click(object sender, ImageClickEventArgs e)

{

Response.ClearContent();

Response.Buffer = true;

Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "Customers.xls"));

Response.ContentType = "application/ms-excel";

StringWriter sw = new StringWriter();

HtmlTextWriter htw = new HtmlTextWriter(sw);

gvdetails.AllowPaging = false;

gvdetails.DataBind();

//Change the Header Row back to white color

gvdetails.HeaderRow.Style.Add("background-color", "#FFFFFF");

//Applying stlye to gridview header cells

for (int i = 0; i < gvdetails.HeaderRow.Cells.Count; i++)

{

gvdetails.HeaderRow.Cells[i].Style.Add("background-color", "#507CD1");

}

int j = 1;

//This loop is used to apply stlye to cells based on particular row

foreach (GridViewRow gvrow in gvdetails.Rows)

{

gvrow.BackColor = System.Drawing.Color.White;

if (j <= gvdetails.Rows.Count)

{

if (j % 2 != 0)

{

for (int k = 0; k < gvrow.Cells.Count; k++)

{

gvrow.Cells[k].Style.Add("background-color", "#EFF3FB");

}

j++;

}

gvdetails.RenderControl(htw);

Response.Write(sw.ToString());

Response.End();

}

protected void btnWord_Click(object sender, ImageClickEventArgs e)

{

gvdetails.AllowPaging = false;

gvdetails.DataBind();

Response.ClearContent();

Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "Customers.doc"));

Response.Charset = "";

Response.ContentType = "application/ms-word";

StringWriter sw = new StringWriter();

HtmlTextWriter htw = new HtmlTextWriter(sw);

gvdetails.RenderControl(htw);

Response.Write(sw.ToString());

Response.End();

}

protected void gvdetails_PageIndexChanging(object sender, GridViewPageEventArgs e)

{

gvdetails.PageIndex = e.NewPageIndex;

bindgrid();

}

Tech Services

Pages

29 Jun 2017

How to form client side authentication through angular 1

How to form client side authentication through angular 1

26 Jun 2017

Improve SQL server query performance on table with millions of records.

Improve SQL server query performance on table with millions of records.

24 Jun 2017

whats the difference between asynchronous and multithreading

whats the difference between asynchronous and multithreading

Changing DIV value using jquery Asp.net MVC

Changing DIV value using jquery Asp.net MVC

21 Jun 2017

Online examination system project In Asp.Net with c#, SQL Database including Admin Panel - Download Part 3

Online examination system project In Asp.Net with c#, SQL Database including Admin Panel - Download Part 3

SHARE IT PLEASE

Recent Posts