protected void btn_Submit_Click(object sender, EventArgs e)
{
string sql, cnt;
sql = " SELECT Count(*) FROM tbl_Member WHERE EmailId='" + txt_EmailId.Text + "'";
cnt = c1.SelectScalar(sql);
if (Convert.ToInt32(cnt) == 1)
{
lbl_Msg_Reg.Text = "This EmailId is Already Registered.";
}
else
{
sql = " INSERT INTO tbl_Member (MemberName, EmailId, ContactNo, Password, RegDate,EnableStatus) VALUES (";
sql = sql + " '" + txt_MemberName.Text + "',";
sql = sql + " '" + txt_EmailId.Text + "',";
sql = sql + " '" + txt_ContactNo.Text + "',";
sql = sql + " '" + txt_Password.Text + "',";
sql = sql + " '" + DateTime.Now.ToShortDateString() + "',1)";
c1.ExecuteQry(sql);
//c1.SetLoginDetails(txt_EmailId.Text);
txt_ContactNo.Text = "";
txt_EmailId.Text = "";
txt_MemberName.Text = "";
txt_Password.Text = "";
txt_ConfirmPassword.Text = "";
lbl_Msg_Reg.Text = "Registration Completed Successfully.";
}
}
public void FillGridTopic()
{
string str;
str = "select CPhone from tbl_CompanyInfo ";
txt_Phone.Content = c1.SelectScalar(str);
str = "select CEmail from tbl_CompanyInfo ";
txt_Email.Content = c1.SelectScalar(str);
str = "select CAddress from tbl_CompanyInfo ";
txt_Address.Content = c1.SelectScalar(str);
}
public void FillDetails()
{
string str;
str = "select * from tbl_AboutUs ";
txt_Editor.Content = c1.SelectScalar(str);
}
protected void btn_Submit_Click(object sender, EventArgs e)
{
string id;
string sql, cnt, pass, user;
user = c1.Clean(txt_Question_Title.Text);
pass = c1.Clean(txt_Url.Text);
if (lbl_Opr.Text == "Add")
{
sql = "insert into tbl_Notification (Notification,Url,NDate,enablestatus,AdminID) Output Inserted.Id1 values('" + txt_Question_Title.Text + "','" + txt_Url.Text + "','" + txt_Date.Text + "',1,'" + Session["AdminId"].ToString() + "')";
id = c1.SelectScalar(sql);
txt_Question_Title.Text = "";
txt_Url.Text = "";
txt_Date.Text = "";
lbl_Msg.Text = "Admin Added Successfully";
}
else
{
sql = "UPDATE tbl_Notification SET Notification='" + txt_Question_Title.Text + "', Url='" + txt_Url.Text + "',";
sql = sql + " NDate='" + txt_Date.Text + "'";
sql = sql + " WHERE Id1=" + lbl_Id.Text;
c1.ExecuteQry(sql);
txt_Question_Title.Text = "";
txt_Url.Text = "";
txt_Date.Text = "";
FillSubject();
MultiView1.ActiveViewIndex = 0;
}
}
private void FillPaper()
{
int i, n;
string pid, cnt;
string str;
str = "select * FROM tbl_Paper ";
str = str + " WHERE SubjectId=" + Session["SubjectId"].ToString();
//str = str + " AND EnableStatus =1 ";
Repeater1.DataSource = c1.SelectDs(str);
Repeater1.DataBind();
if (Session["MemberId"] != null)
{
n = Repeater1.Items.Count;
for (i = 0; i < n; i++)
{
pid = ((Label)Repeater1.Items[i].FindControl("lblPaperId")).Text;
str = "SELECT Count(*) FROM tbl_Result ";
str = str + " WHERE EmailId='" + Session["EmailId"] + "' and PaperId=" + pid;
cnt = c1.SelectScalar(str);
//if (Convert.ToInt16(cnt) == 0)
//{
// ((ImageButton)Repeater1.Items[i].FindControl("Img_Test")).ImageUrl = "~/img/TakeTest.png";
//}
//else
//{
// if (Session["Retake"].ToString() == "Retake")
// {
// ((ImageButton)Repeater1.Items[i].FindControl("Img_Test")).ImageUrl = "~/img/ReTakeTest.png";
// }
// else
// {
// ((ImageButton)Repeater1.Items[i].FindControl("Img_Test")).Visible = false;
// }
//}
//if (Convert.ToInt16(cnt) == 0)
//{
// ((LinkButton)Repeater1.Items[i].FindControl("lnk_Test")).Text = "Take";
//}
//else
//{
// if (Session["Retake"].ToString() == "Retake")
// {
// ((LinkButton)Repeater1.Items[i].FindControl("lnk_Test")).Text = "Retake";
// }
// else
// {
// ((LinkButton)Repeater1.Items[i].FindControl("lnk_Test")).Text = "";
// }
//}
}
}
}
protected void btn_Submit_Click(object sender, EventArgs e)
{
string sql, fn, path, id, ext;
if (ddl_SubjectAdd.SelectedIndex > 0)
{
if (grd_Category.Rows.Count != 0)
{
if (lbl_Opr.Text == "Add")
{
sql = "insert into tbl_paper (PaperName, SubjectId,InstructionId,FixPaper, Description, MinTime, QuestionMarks, NegativeMarks, EnableStatus, AdminId)";
sql = sql + " Output Inserted.PaperId values('"
+ txt_PaperName.Text + "','" + ddl_SubjectAdd.SelectedValue.ToString() + "','" + ddl_InstructionAdd.SelectedValue.ToString() + "', '"
+ dl_PaperType.SelectedValue.ToString() + "','" + txt_Description.Text + "','" + txt_PaperTime.Text + "', '"
+ txt_QuestionMarks.Text + "','" + txt_NegativeMarks.Text + "', '0','"
+ Session["AdminId"].ToString() + "')";
id = c1.SelectScalar(sql);
savePaperQuestionCategory(id);
clearTextboxes();
grd_Category.DataSource = null;
grd_Category.DataBind();
lbl_Msg.Text = "Paper Added Successfully";
}
else
{
sql = "UPDATE tbl_paper SET PaperName='" + txt_PaperName.Text + "',";
sql = sql + " SubjectId='" + ddl_SubjectAdd.SelectedValue.ToString() + "',";
sql = sql + " FixPaper='" + dl_PaperType.SelectedValue.ToString() + "',";
sql = sql + " Description='" + txt_Description.Text + "',";
sql = sql + " MinTime='" + txt_PaperTime.Text + "',";
sql = sql + " QuestionMarks='" + txt_QuestionMarks.Text + "',";
sql = sql + " InstructionId='" + ddl_InstructionAdd.SelectedValue.ToString() + "',";
sql = sql + " NegativeMarks='" + txt_NegativeMarks.Text + "'";
sql = sql + " WHERE paperId=" + lbl_Id.Text;
c1.ExecuteQry(sql);
savePaperQuestionCategory(lbl_Id.Text);
clearTextboxes();
grd_Category.DataSource = null;
grd_Category.DataBind();
FillPaper();
MultiView1.ActiveViewIndex = 0;
}
}
else
{
lbl_Msg.Text = "Please Insert Q Section";
}
}
else
{
lbl_Msg.Text = "Please Select Category/Subcategory";
}
}
protected void btn_Submit_Click(object sender, EventArgs e)
{
string sql, cnt;
if (lbl_Opr.Text == "Edit")
{
sql = "UPDATE tbl_Member SET ";
sql = sql + " MemberName='" + txt_MemberName.Text + "',";
sql = sql + " EmailId='" + txt_EmailID.Text + "',";
sql = sql + " ContactNo='" + txt_ContactNo.Text + "'";
sql = sql + " WHERE MemberId=" + lbl_Id.Text;
c1.ExecuteQry(sql);
txt_ContactNo.Text = "";
txt_EmailID.Text = "";
txt_MemberName.Text = "";
txt_Password.Text = "";
MultiView1.ActiveViewIndex = 0;
}
if (lbl_Opr.Text == "Add")
{
sql = " SELECT Count(*) FROM tbl_Member WHERE EmailId='" + txt_EmailID.Text + "'";
cnt = c1.SelectScalar(sql);
if (Convert.ToInt32(cnt) == 1)
{
lbl_Msg_Reg.Text = "This EmailId is Already Registered.";
}
else
{
sql = " INSERT INTO tbl_Member (EnableStatus,MemberName, EmailId,Password,ContactNo,RegDate)";
sql = sql + "VALUES ( 0,";
sql = sql + " '" + txt_MemberName.Text + "',";
sql = sql + " '" + txt_EmailID.Text + "',";
sql = sql + " '" + txt_Password.Text + "',";
sql = sql + " '" + txt_ContactNo.Text + "',";
sql = sql + " '" + DateTime.Now.ToShortDateString() + "')";
c1.ExecuteQry(sql);
txt_ContactNo.Text = "";
txt_EmailID.Text = "";
txt_MemberName.Text = "";
txt_Password.Text = "";
FillSubject();
MultiView1.ActiveViewIndex = 0;
}
}
}
protected void btn_Submit_Click(object sender, EventArgs e)
{
string sql, cnt;
sql = " SELECT Count(*) FROM tbl_Member WHERE MemberId='" + Session["MemberId"].ToString() + "'";
cnt = c1.SelectScalar(sql);
if (Convert.ToInt32(cnt) == 1)
{
sql = " Update tbl_Member set MemberName='" + txt_Name.Text + "',";
sql = sql + "ContactNo='" + txt_ContactNo.Text + "'";
sql = sql + " Where MemberId='" + Session["MemberId"].ToString() + "'";
c1.ExecuteQry(sql);
lbl_Msg.Text = "Profil Update SucessFully";
}
}
protected void btn_Submit_Click1(object sender, EventArgs e)
{
string sql, cnt, pass, user;
user = c1.Clean(txt_Email_Id.Text);
pass = c1.Clean(txt_Password.Text);
sql = "SELECT count(*) FROM tbl_AdminLogin WHERE LoginId='" + user + "' AND Password='******'";
cnt = c1.SelectScalar(sql);
if (Convert.ToInt32(cnt) == 0)
{
lbl_Msg.Text = "Either Login Id or Password is Wrong";
}
else
{
c1.SetAdminLoginDetails(user);
Response.Redirect("Admin_Home.aspx");
}
}
protected void btn_Submit_Click(object sender, EventArgs e)
{
string sql, cnt;
sql = "SElECT count(*) from tbl_Member WHERE EmailId='" + Session["EmailId"] + "' AND Password='******' ";
cnt = c1.SelectScalar(sql);
if (Convert.ToInt32(cnt) == 1)
{
sql = "UPDATE tbl_Member SET Password='******'";
sql = sql + " WHERE MemberId=" + Session["MemberId"];
c1.ExecuteQry(sql);
lbl_Msg.Text = "Your Password Has Changed.";
txt_OldPassword.Text = "";
txt_ConfirmPassword.Text = "";
txt_NewPassword.Text = "";
}
else
{
lbl_Msg.Text = "Somthing Wrong! Pasword Can't be Changed.";
}
}
protected void btn_Submit_Click(object sender, EventArgs e)
{
string sql, fn, path, id, ext;
string isQueImage = "No";
string isQueText = "No";
string isExpImage = "No";
string isExpText = "No";
if (lbl_Opr.Text == "Add")
{
if (opt_QuestionType.SelectedIndex == 0)
{
isQueImage = "Yes";
isQueText = "No";
}
else
{
isQueImage = "No";
isQueText = "Yes";
}
if (opt_ExplanationType.SelectedIndex == 0)
{
isExpImage = "Yes";
isExpText = "No";
}
else
{
isExpImage = "No";
isExpText = "Yes";
}
if (isQueImage == "Yes")
{
if (!FU_Question.HasFile)
{
lbl_Msg.Text = "Select Question Image";
return;
}
}
if (isExpImage == "Yes")
{
if (!FU_Explanation.HasFile)
{
lbl_Msg.Text = "Select Explanation Image";
return;
}
}
sql = "insert into tbl_Question (Question_Type, Explanation_Type, Question_Text, Explanation_Text, QuestionCategoryId,Answer,Question_Title) Output Inserted.QuestionId values ";
sql = sql + " ('Text','Text','" + c1.Clean(txt_QuestionText.Content) + "','" + c1.Clean(txt_Explanation.Content) + "',";
sql = sql + " '" + ddl_CategoryAdd.SelectedValue.ToString() + "','" + txt_Answer.Text + "','" + txt_QuestionNo.Text + "')";
id = c1.SelectScalar(sql);
if (isQueImage == "Yes")
{
if (FU_Question.HasFile)
{
UploadPhoto(FU_Question, id, "tbl_Question", "Question_Url", "Questions", "Question_Type");
}
}
if (isExpImage == "Yes")
{
if (FU_Explanation.HasFile)
{
UploadPhoto(FU_Explanation, id, "tbl_Question", "Explanation_Url", "QuestionExplain", "Explanation_Type");
}
}
txt_QuestionText.Content = "";
txt_Explanation.Content = "";
txt_QuestionNo.Text = "";
txt_Answer.Text = "";
lbl_Msg.Text = "Question Added Successfully";
}
else
{
id = lbl_Id.Text;
if (opt_QuestionType.SelectedIndex == 0)
{
isQueText = "No";
if (FU_Question.HasFile)
{
UploadPhoto(FU_Question, id, "tbl_Question", "Question_Url", "Questions", "Question_Type");
sql = "UPDATE tbl_Question set Question_Text='' ";
sql = sql + " where QuestionId=" + lbl_Id.Text;
c1.ExecuteQry(sql);
}
else
{
lbl_Msg.Text = "Select Question Image ";
}
}
else
{
isQueText = "Yes";
}
if (opt_ExplanationType.SelectedIndex == 0)
{
isExpText = "No";
if (FU_Explanation.HasFile)
{
UploadPhoto(FU_Explanation, id, "tbl_Question", "Explanation_Url", "QuestionExplain", "Explanation_Type");
sql = "UPDATE tbl_Question set Explanation_Text='' ";
sql = sql + " where QuestionId=" + lbl_Id.Text;
c1.ExecuteQry(sql);
}
else
{
lbl_Msg.Text = "Select Explanation Image ";
}
}
else
{
isExpText = "Yes";
}
sql = "UPDATE tbl_Question set ";
sql = sql + " QuestionCategoryId='" + ddl_CategoryAdd.SelectedValue.ToString() + "', ";
sql = sql + " Question_Title='" + txt_QuestionNo.Text + "', ";
sql = sql + " Answer='" + txt_Answer.Text + "' ";
if (isQueText == "Yes")
{
sql = sql + " ,Question_Type='Text', Question_Url='', Question_Text ='" + txt_QuestionText.Content + "' ";
}
if (isExpText == "Yes")
{
sql = sql + " ,Explanation_Type='Text', Explanation_Url='', Explanation_Text ='" + txt_Explanation.Content + "' ";
}
sql = sql + " where QuestionId=" + lbl_Id.Text;
c1.ExecuteQry(sql);
}
}
protected void btn_Submit_Click(object sender, EventArgs e)
{
{
string sql, fn, path, id, ext;
if (lbl_Opr.Text == "Add")
{
if (opt_QuestionType.SelectedIndex == 0)
{
if (FU_Question.HasFile)
{
sql = "insert into tbl_TestInstruction (InstructionType,Title,AdminId) values ";
sql = sql + " ('Image','" + txt_Title.Text + "','" + Session["AdminId"].ToString() + "') ";
c1.ExecuteQry(sql);
sql = "SELECT MAX(Id1) FROM tbl_TestInstruction ";
id = c1.SelectScalar(sql);
fn = FU_Question.FileName;
ext = fn.Substring(fn.LastIndexOf("."), fn.Length - fn.LastIndexOf("."));
fn = id + ext;
path = Server.MapPath("../TestInstruction");
path = path + "\\" + id + ext;
FU_Question.SaveAs(path);
sql = "UPDATE tbl_TestInstruction SET PhotoUrl ='TestInstruction/" + id + ext + "' ";
sql = sql + " WHERE Id1=" + id;
c1.ExecuteQry(sql);
txt_QuestionText.Content = "";
txt_Title.Text = "";
lbl_Msg.Text = "Instruction Added Successfully";
}
else
{
lbl_Msg.Text = "Select File to Upload";
}
}
else
{
sql = "insert into tbl_TestInstruction (InstructionType,TestInstruction,Title,AdminId) values(";
sql = sql + "'Text','" + c1.Clean(txt_QuestionText.Content) + "','" + txt_Title.Text + "','" + Session["AdminId"].ToString() + "') ";
c1.ExecuteQry(sql);
txt_QuestionText.Content = "";
txt_Title.Text = "";
lbl_Msg.Text = "Question Added Successfully";
}
}
else
{
if (opt_QuestionType.SelectedIndex == 0)
{
if (FU_Question.HasFile)
{
id = lbl_Id.Text;
fn = FU_Question.FileName;
ext = fn.Substring(fn.LastIndexOf("."), fn.Length - fn.LastIndexOf("."));
fn = id + ext;
path = Server.MapPath("../TestInstruction");
path = path + "\\" + id + ext;
FU_Question.SaveAs(path);
sql = "UPDATE tbl_TestInstruction set ";
sql = sql + " InstructionType='Image',TestInstruction='', ";
sql = sql + " PhotoUrl ='TestInstruction/" + id + ext + "', ";
sql = sql + " Title='" + txt_Title.Text + "'";
sql = sql + " where Id1=" + lbl_Id.Text;
c1.ExecuteQry(sql);
}
else
{
sql = "UPDATE tbl_TestInstruction set ";
sql = sql + " Title='" + txt_Title.Text + "'";
sql = sql + " where Id1=" + lbl_Id.Text;
c1.ExecuteQry(sql);
}
}
else
{
sql = "UPDATE tbl_TestInstruction set ";
sql = sql + " InstructionType='Text',PhotoUrl='',";
sql = sql + " TestInstruction ='" + c1.Clean(txt_QuestionText.Content) + "', ";
sql = sql + " Title='" + txt_Title.Text + "'";
sql = sql + " where Id1=" + lbl_Id.Text;
c1.ExecuteQry(sql);
}
txt_QuestionText.Content = "";
txt_Title.Text = "";
FillPaper();
MultiView1.ActiveViewIndex = 0;
}
}
}
protected void btn_Submit_Click(object sender, EventArgs e)
{
string sql, cnt;
int TotalRows = 0, i, j, TotalCols = 0, k, TotalQuestionRequired, QNo;
DataTable ds = new DataTable();
TotalRows = grd_Category.Rows.Count;
TotalCols = 3;
sql = "Select Count(PaperId) from tbl_PaperSet where PaperId=" + ddl_PaperAdd.SelectedValue.ToString();
cnt = c1.SelectScalar(sql);
if (Convert.ToInt32(cnt) > 0)
{
lbl_Msg.Text = "Paper Already Created";
}
else
{
for (i = 0; i < TotalRows; i++)
{
for (j = 1; j <= 3; j++)
{
TotalQuestionRequired = Convert.ToInt32(grd_Category.Rows[i].Cells[j].Text);
lstAllQuestion.Items.Clear();
//1=Easy 2=Medium 3=diff
sql = " select QuestionId from tbl_Question where SubjectId=" + ddl_SubjectAdd.SelectedValue.ToString();
sql = sql + " and QuestionCategoryId=" + grd_Category.DataKeys[i].Value.ToString();
sql = sql + " and DifficultyLevel=" + j.ToString();
ds = c1.SelectDT(sql);
lstAllQuestion.DataSource = ds;
lstAllQuestion.DataTextField = "QuestionId";
lstAllQuestion.DataValueField = "QuestionId";
lstAllQuestion.DataBind();
if (ds.Rows.Count < TotalQuestionRequired)
{
lbl_Msg.Text = "Less Questions can not create paper";
break;
}
else
{
Random r = new Random();
for (k = 0; k < TotalQuestionRequired; k++)
{
QNo = r.Next(0, lstAllQuestion.Items.Count);
lstSelectedQuestion.Items.Add(lstAllQuestion.Items[QNo].Text);
lstAllQuestion.Items.RemoveAt(QNo);
}
}
}
}
int lstcnt = Convert.ToInt32(lstSelectedQuestion.Items.Count);
for (i = 0; i < lstcnt; i++)
{
sql = " INSERT INTO tbl_PaperSet (PaperId,QuestionId) VALUES (";
sql = sql + " '" + ddl_PaperAdd.SelectedValue.ToString() + "','" + lstSelectedQuestion.Items[i] + "')";
c1.ExecuteQry(sql);
}
lstAllQuestion.Items.Clear();
lstSelectedQuestion.Items.Clear();
ddl_StreamAdd.SelectedIndex = -1;
ddl_SubjectAdd.Items.Clear();
ddl_PaperAdd.Items.Clear();
grd_Category.DataSource = "";
grd_Category.DataBind();
}
}
private void GenerateResult()
{
int Right = 0, Wrong = 0, NotAttampt = 0, i, n;
float RightMarks = 0, WrongMarks = 0, TotalMarks = 0, ObtainedMarks = 0, per = 0;
string sql, ResultId;
float NegativeMarks = Convert.ToSingle(lbl_NegativeMarks.Text);
int QuestionMarks = Convert.ToInt32(lbl_MarksPerQuestion.Text);
DataTable dt = Session["AllQuestion"] as DataTable;
n = dt.Rows.Count;
for (i = 0; i < n; i++)
{
if (dt.Rows[i]["SelectedAnswer"].ToString() == "0")
{
NotAttampt++;
}
else if (dt.Rows[i]["SelectedAnswer"].ToString() != dt.Rows[i]["Answer"].ToString())
{
Wrong++;
dt.Rows[i]["Result"] = "0";
}
else if (dt.Rows[i]["SelectedAnswer"].ToString() == dt.Rows[i]["Answer"].ToString())
{
Right++;
dt.Rows[i]["Result"] = "1";
}
}
// 1 Marks for Each Question
TotalMarks = n * QuestionMarks;
RightMarks = Right * QuestionMarks;
WrongMarks = (float)Wrong * NegativeMarks;
ObtainedMarks = RightMarks - WrongMarks;
per = (ObtainedMarks / TotalMarks) * 100;
//sql = " DELETE FROM tbl_Result WHERE EmailId='" + Session["EmailId"].ToString() + "'";
//sql = sql + " AND PaperId=" + Session["PaperId"].ToString();
//c1.ExecuteQry(sql);
sql = " INSERT INTO tbl_Result(EmailId, ExamDate, Correct, Wrong, NotAttempt,Marks, per) VALUES ";
sql = sql + " ('" + Session["EmailId"].ToString() + "',";
sql = sql + " '" + DateTime.Now.ToShortDateString() + "',";
sql = sql + " " + Right + "," + Wrong + "," + NotAttampt + "," + ObtainedMarks.ToString() + "," + per.ToString() + ")";
c1.ExecuteQry(sql);
sql = "SELECT MAX(ResultId) FROM tbl_Result";
ResultId = c1.SelectScalar(sql);
sql = " INSERT INTO tbl_ResultDetails(ResultId,QuestionId,Answer,Status) VALUES ";
for (i = 0; i < n; i++)
{
sql = sql + "(" + ResultId + "," + dt.Rows[i]["QuestionId"].ToString() + ",";
sql = sql + dt.Rows[i]["SelectedAnswer"].ToString() + "," + dt.Rows[i]["Result"].ToString() + "),";
}
sql = sql.Substring(0, sql.Length - 1);
c1.ExecuteQry(sql);
Response.Redirect("MyAccount_Results.aspx");
}
