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"); }