//Item Category #region [Item Category Grid Bind] private void GrdCategoryBind() { try { objEWA.OrgId = Convert.ToInt32(Session["OrgId"]); DataSet ds = objBL.CategoryGridBind_BL(objEWA); if (ds.Tables[0].Rows.Count == 0 || ds == null) { ds.Tables[0].Rows.Add(ds.Tables[0].NewRow()); GrdCategory.DataSource = ds; GrdCategory.DataBind(); int columncount = GrdCategory.Rows[0].Cells.Count; GrdCategory.Rows[0].Cells.Clear(); GrdCategory.Rows[0].Cells.Add(new TableCell()); GrdCategory.Rows[0].Cells[0].ColumnSpan = columncount; GrdCategory.Rows[0].Cells[0].Text = "No Records Found"; } else { GrdCategory.DataSource = ds; GrdCategory.DataBind(); } } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
protected void GrdCategory_RowUpdated(object sender, GridViewUpdatedEventArgs e) { try { GrdCategory.DataBind(); } catch (Exception ex) { TroyLiteExceptionManager.HandleException(ex); } }
protected void lnkBtnAdd_Click(object sender, EventArgs e) { try { GrdCategory.DataBind(); GrdCategory.ShowFooter = true; lnkBtnAdd.Visible = false; } catch (Exception ex) { TroyLiteExceptionManager.HandleException(ex); } }
//Grid Index Changed #region GrdIndexChanged protected void GrdCategory_PageIndexChanging(object sender, GridViewPageEventArgs e) { try { GrdCategory.PageIndex = e.NewPageIndex; GrdCategory.DataSource = objBL.CategoryGridBind_BL(objEWA); GrdCategory.DataBind(); } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
protected void BindAVMaster() { try { DataTable dt = new DataTable(); dt = objBL_ExamMaster.BL_BindAVMaster(objML_ExamMaster); if (dt.Rows.Count > 0) { GrdCategory.DataSource = dt; GrdCategory.DataBind(); } } catch (Exception ex) { ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('" + ex.Message.ToString() + "');", true); } }
private void BindProgramsInfo() { DataTable dt = new DataTable(); objML_StudentProfile.ID = Session["UserName"].ToString(); //objML_StudentProfile.ExamName = Session["ExamName"].ToString(); dt = objBL_StudentProfile.BL_Result(objML_StudentProfile); if (dt.Rows.Count > 0) { GrdCategory.DataSource = dt; GrdCategory.DataBind(); int i = 0; int y = 0; foreach (GridViewRow row in GrdCategory.Rows) { Label lblTick = (Label)row.FindControl("lbl"); Label lblStudentAns = (Label)row.FindControl("StudentAns"); Label lblCorrctAns = (Label)row.FindControl("CorrectAns"); Label lblStudentPreviewAns = (Label)row.FindControl("lblCorrect"); if (lblCorrctAns.Text == lblStudentAns.Text) { lblTick.Text = "✔"; i = i + 1; } else if (lblStudentAns.Text == "") { lblTick.Text = "🏳️"; } else { lblTick.Text = "❌"; lblStudentPreviewAns.Text = lblCorrctAns.Text; y = y + 1; } } lblCorrect.Text = i.ToString(); lblWrong.Text = y.ToString(); lblTotalQus.Text = dt.Rows.Count.ToString(); } }
protected void GrdCategory_RowCommand(object sender, GridViewCommandEventArgs e) { try { if (e.CommandName == "Cancel") { GrdCategory.FooterRow.Visible = false; lnkBtnAdd.Visible = true; } else if (e.CommandName == "Insert") { if (!Page.IsValid) { foreach (IValidator validator in Page.Validators) { if (!validator.IsValid) { //errDisp.AddItem(validator.ErrorMessage, DisplayIcons.Error, true); } } } else { BusinessLogic objBus = new BusinessLogic(); string Username = Request.Cookies["LoggedUserName"].Value; int nextSeq = objBus.GetNextSequence(GetConnectionString(), "Select Max(CategoryID) from tblCategories"); string cateDes = ((TextBox)GrdCategory.FooterRow.FindControl("txtAddDescr")).Text; string catelvl = ((TextBox)GrdCategory.FooterRow.FindControl("txtAddLvl")).Text; if (nextSeq == -1) { return; } string sQl = string.Format("Insert Into tblCategories Values({0},'{1}',{2})", nextSeq + 1, cateDes, catelvl); srcGridView.InsertParameters.Add("sQl", TypeCode.String, sQl); srcGridView.InsertParameters.Add("connection", TypeCode.String, GetConnectionString()); srcGridView.InsertParameters.Add("Usernam", TypeCode.String, Username); srcGridView.InsertParameters.Add("CategoryName", TypeCode.String, cateDes); try { srcGridView.Insert(); System.Threading.Thread.Sleep(1000); GrdCategory.DataBind(); //} //catch (Exception ex) //{ // if (ex.InnerException != null) // { // StringBuilder script = new StringBuilder(); // script.Append("alert('Category with this name already exists, Please try with a different name.');"); // if (ex.InnerException.Message.IndexOf("duplicate values in the index") > -1) // ScriptManager.RegisterStartupScript(Page, Page.GetType(), Guid.NewGuid().ToString(), script.ToString(), true); // return; // } //} } catch (Exception ex) { TroyLiteExceptionManager.HandleException(ex); return; } lnkBtnAdd.Visible = true; } } else if (e.CommandName == "Update") { if (!Page.IsValid) { foreach (IValidator validator in Page.Validators) { if (!validator.IsValid) { //errDisp.AddItem(validator.ErrorMessage, DisplayIcons.Error, true); } } return; } //else //{ // string catDescr = ((TextBox)GrdCategory.HeaderRow.FindControl("txtCatDescr")).Text; // //string catDescr = ((TextBox)GrdCategory.Rows[e.RowIndex].FindControl("txtCatDescr")).Text; // string Username = Request.Cookies["LoggedUserName"].Value; // string catId = GrdCategory.SelectedValue.ToString(); // string catlevel = ((TextBox)GrdCategory.HeaderRow.FindControl("txtCatLvl")).Text; // //string catId = GrdCategory.DataKeys[e.RowIndex].Value.ToString(); // //string catlevel = ((TextBox)GrdCategory.Rows[e.RowIndex].FindControl("txtCatLvl")).Text; // //srcGridView.UpdateMethod = "UpdateCategory"; // srcGridView.UpdateParameters.Add("connection", TypeCode.String, GetConnectionString()); // srcGridView.UpdateParameters.Add("CategoryName", TypeCode.String, catDescr); // srcGridView.UpdateParameters.Add("CategoryID", TypeCode.Int32, catId); // srcGridView.UpdateParameters.Add("CategoryLevel", TypeCode.String, catlevel); // srcGridView.UpdateParameters.Add("Usernam", TypeCode.String, Username); // try // { // srcGridView.Update(); // System.Threading.Thread.Sleep(1000); // GrdCategory.DataBind(); // } // catch (Exception ex) // { // if (ex.InnerException != null) // { // StringBuilder script = new StringBuilder(); // script.Append("alert('Category with this name already exists, Please try with a different name.');"); // if (ex.InnerException.Message.IndexOf("duplicate values in the index") > -1) // ScriptManager.RegisterStartupScript(Page, Page.GetType(), Guid.NewGuid().ToString(), script.ToString(), true); // return; // } // } lnkBtnAdd.Visible = true; } else if (e.CommandName == "Edit") { lnkBtnAdd.Visible = false; } else if (e.CommandName == "Page") { lnkBtnAdd.Visible = true; int intCurIndex = GrdCategory.PageIndex; string Comm = e.CommandArgument.ToString(); switch (Comm) { case "First": GrdCategory.PageIndex = 0; break; case "Prev": GrdCategory.PageIndex = intCurIndex - 1; break; case "Next": GrdCategory.PageIndex = intCurIndex + 1; break; case "Last": GrdCategory.PageIndex = GrdCategory.PageCount; break; } } } catch (Exception ex) { TroyLiteExceptionManager.HandleException(ex); } }
protected void Search(object sender, EventArgs e) { try { if (ddlExamName.SelectedValue == "Select Exam") { throw new Exception("Select Exam Name"); } DataTable dt = new DataTable(); objML_StudentProfile.StudentName = Session["UserName"].ToString(); objML_StudentProfile.ID = txtSearch.Text != "" ? txtSearch.Text : null; if (objML_StudentProfile.ID == null) { objML_StudentProfile.ID = ""; } objML_StudentProfile.ExamName = ddlExamName.SelectedItem.Value != "" ? ddlExamName.SelectedItem.Value : null; if (rbtnMultiple.Checked == true) { objML_StudentProfile.doctype = rbtnMultiple.Text; } else { objML_StudentProfile.doctype = rbtnIndividual.Text; } dt = objBL_StudentProfile.BL_SerachQuestionInfo(objML_StudentProfile); if (dt.Rows.Count > 0) { GrdCategory.DataSource = dt; GrdCategory.DataBind(); int i = 0; int y = 0; foreach (GridViewRow row in GrdCategory.Rows) { Label lblTick = (Label)row.FindControl("lbl"); Label lblStudentAns = (Label)row.FindControl("StudentAns"); Label lblCorrctAns = (Label)row.FindControl("CorrectAns"); if (lblCorrctAns.Text == lblStudentAns.Text) { lblTick.Text = "✔"; i = i + 1; } else { lblTick.Text = "❌"; y = y + 1; } } lblCorrect.Text = i.ToString(); lblWrong.Text = y.ToString(); lblTotalQus.Text = dt.Rows.Count.ToString(); GrdCategory.Visible = true; } else { GrdCategory.DataSource = dt; GrdCategory.Visible = false; ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('No Data Found')", true); } } catch (Exception ex) { ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('" + ex.Message.ToString() + "');", true); } }