private void StudentFeedbackQuestionBind(GridView dvFeedback, TextBox Feedback) { DataTable dt = new DataTable(); Feedback_BLogic objFeedback = new Feedback_BLogic(); Obj_TeacherActivityFeedback.SchoolID = AppSessions.SchoolID; Obj_TeacherActivityFeedback.BMSSCTID = Convert.ToInt32(Session["DEMOBMSSCTID"]); Obj_TeacherActivityFeedback.StudentID = AppSessions.StudentID; Obj_TeacherActivityFeedback.DivisionID = AppSessions.DivisionID; Obj_TeacherActivityFeedback.CreatedBy = AppSessions.StudentID; dt = objFeedback.GetFeedbackDetailStudent(Obj_TeacherActivityFeedback); if (dt.Rows.Count > 0) { Feedback.Text = dt.Rows[0]["Feedback"].ToString(); dvFeedback.DataSource = dt; dvFeedback.DataBind(); } else { dvFeedback.DataSource = null; dvFeedback.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { BindAllDDLSchool(); lblPer.Text = ""; } DataTable dt = new DataTable(); Feedback_BLogic objFeedback = new Feedback_BLogic(); Obj_TeacherActivityFeedback.SchoolID = AppSessions.SchoolID; Obj_TeacherActivityFeedback.BMSSCTID = Convert.ToInt32(31); Obj_TeacherActivityFeedback.StudentID = AppSessions.StudentID; Obj_TeacherActivityFeedback.DivisionID = AppSessions.DivisionID; Obj_TeacherActivityFeedback.CreatedBy = 2; dt = objFeedback.GetFeedbackDetailStudent(Obj_TeacherActivityFeedback); if (dt.Rows.Count > 0) { //Feedback.Text = dt.Rows[0]["Feedback"].ToString(); grdFeedback1.DataSource = dt; grdFeedback1.DataBind(); } else { } //modalpop.Show(); }
private DataTable TeacherFeedbackQuestionBind(string EmployeeID, string division) { DataTable dt = new DataTable(); Feedback_BLogic objFeedback = new Feedback_BLogic(); Obj_TeacherActivityFeedback.SchoolID = Convert.ToInt32(ddlSchool.SelectedValue); Obj_TeacherActivityFeedback.BMSSCTID = Convert.ToInt32(ViewState["BMSSCTID"].ToString()); Obj_TeacherActivityFeedback.EmployeeID = Convert.ToInt32(EmployeeID); Obj_TeacherActivityFeedback.DivisionID = Convert.ToInt32(division); Obj_TeacherActivityFeedback.CreatedBy = Convert.ToInt32(EmployeeID); dt = objFeedback.GetFeedbackDetail(Obj_TeacherActivityFeedback); //if (ddlDivision.SelectedIndex != 0) //{ // Obj_TeacherActivityFeedback.DivisionID = Convert.ToInt32(ddlDivision.SelectedValue.ToString()); // dt = objFeedback.GetFeedbackDetail(Obj_TeacherActivityFeedback); //} //else //{ // dt = objFeedback.GetFeedbackDetail1(Obj_TeacherActivityFeedback); //} return(dt); }
private DataTable StudentFeedbackQuestionBind(string StudentID, string DivisionID) { DataTable dt = new DataTable(); Feedback_BLogic objFeedback = new Feedback_BLogic(); Obj_TeacherActivityFeedback.SchoolID = Convert.ToInt32(ddlSchool.SelectedValue); Obj_TeacherActivityFeedback.BMSSCTID = Convert.ToInt32(ViewState["BMSSCTID"].ToString()); Obj_TeacherActivityFeedback.StudentID = Convert.ToInt32(StudentID); Obj_TeacherActivityFeedback.DivisionID = Convert.ToInt32(DivisionID); Obj_TeacherActivityFeedback.CreatedBy = Convert.ToInt32(StudentID); //if (ddlDivision.SelectedIndex != 0) //{ dt = objFeedback.GetFeedbackDetailStudent(Obj_TeacherActivityFeedback); //} //else //{ // dt = objFeedback.GetFeedbackDetailStudent1(Obj_TeacherActivityFeedback); //} //if (dt.Rows.Count > 0) //{ // //Feedback.Text = dt.Rows[0]["Feedback"].ToString(); // return dt; // //this.mp1.Show(); // //grdFeedback1.DataSource = dt; // //grdFeedback1.DataBind(); // //grdFeedback1.Visible = true; // // this.mp1.Show(); //} return(dt); }
private void BindFeedbackDetails() { try { BAL_Feedback = new Feedback_BLogic(); dsResult = new DataSet(); dsResult = BAL_Feedback.GetFeedbackQuestionDetail(); if (dsResult.Tables.Count > 0) { string SearchCondition = string.Empty; if (txtFeedbackSearch.Text != string.Empty) { SearchCondition = "FeedbackQuestion like '%" + txtFeedbackSearch.Text + "%'"; } else { if (txtFeedbackSearch.Text == string.Empty) { if (rlstActive.SelectedValue == "1") { SearchCondition = SearchCondition + "IsActive ='Yes'"; } else if (rlstActive.SelectedValue == "0") { SearchCondition = SearchCondition + "IsActive ='No'"; } } else { if (rlstActive.SelectedValue == "1") { SearchCondition = SearchCondition + " AND IsActive ='Yes'"; } else if (rlstActive.SelectedValue == "0") { SearchCondition = SearchCondition + " AND IsActive ='No'"; } } } DataView dv = new DataView(dsResult.Tables[0]); dv.RowFilter = SearchCondition; DataSet dsFeedback = new DataSet(); dsFeedback.Tables.Add(dv.ToTable()); grvSYS_Feedbackdetail.DataSource = dsFeedback; grvSYS_Feedbackdetail.DataBind(); } } catch (Exception ex) { throw ex; } }
protected void btnActDeactSub_Click(object sender, EventArgs e) { int CountChecked = 0; int FeedbackQuestionIDStr = 0; foreach (GridViewRow gr in grvSYS_Feedbackdetail.Rows) { CheckBox chk = new CheckBox(); chk = (CheckBox)gr.FindControl("chkSelect"); if (chk.Checked == true) { if (CountChecked == 0) { FeedbackQuestionIDStr = Convert.ToInt32(grvSYS_Feedbackdetail.DataKeys[gr.RowIndex]["FeedbackQuestionID"].ToString()); } CountChecked = CountChecked + 1; } } if (CountChecked == 0) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Message", "<script> alert(' Please select one record to Active/Deactive.')</script>", false); } else { BAL_Feedback = new Feedback_BLogic(); bool Active = false; if (rbActive.Checked == true) { Active = true; } if (rbDeactive.Checked == true) { Active = false; } int Status = BAL_Feedback.BAL_SYS_FeedbackStatus(FeedbackQuestionIDStr, Active); if (Status == 1) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Message", "<script> alert(' Record updated successfully.')</script>", false); BindFeedbackDetails(); ClearAllControls(); } else { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Message", "<script> alert(' Record not updated successfully.')</script>", false); } } }
protected void btnUpdate_Click(object sender, EventArgs e) { try { BAL_Feedback = new Feedback_BLogic(); int Feedback = BAL_Feedback.InsertUpdateFeedbackQuestion("Update", txtFeedbackEdit.Text, Convert.ToInt32(ViewState["FeedbackQuestionID"]), Convert.ToInt32(AppSessions.EmpolyeeID)); if (Feedback == 1) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Message", "<script> alert('Feedback question updated successfully.')</script>", false); BindFeedbackDetails(); ClearAllControls(); pnlSearch.CssClass = "Visible"; } else { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Message", "<script> alert('Feedback question not update.')</script>", false); } } catch (Exception ex) { throw ex; } }
protected void btnshowpopup_Click(object sender, EventArgs e) { modalpop.Show(); DataTable dt = new DataTable(); Feedback_BLogic objFeedback = new Feedback_BLogic(); Obj_TeacherActivityFeedback.SchoolID = AppSessions.SchoolID; Obj_TeacherActivityFeedback.BMSSCTID = Convert.ToInt32(31); Obj_TeacherActivityFeedback.StudentID = AppSessions.StudentID; Obj_TeacherActivityFeedback.DivisionID = AppSessions.DivisionID; Obj_TeacherActivityFeedback.CreatedBy = 2; dt = objFeedback.GetFeedbackDetailStudent(Obj_TeacherActivityFeedback); if (dt.Rows.Count > 0) { //Feedback.Text = dt.Rows[0]["Feedback"].ToString(); grdFeedback1.DataSource = dt; grdFeedback1.DataBind(); } else { } }