protected void BtnSave_Click(object sender, EventArgs e) { try { SYS_Division = new SYS_Division(); BAL_SYS_Division = new SYS_Division_BLogic(); SYS_Division.division = txtDivision.Text; SYS_Division.description = txtDescription.Text; SYS_Division.createdby = Convert.ToInt32(Session["EmpolyeeID"]); SYS_Division.modifiedby = Convert.ToInt32(Session["EmpolyeeID"]); status = BAL_SYS_Division.BAL_SYS_Division_Insert(SYS_Division, "Insert"); if (status == 1) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Message", "<script> alert('Record successfully inserted.')</script>", false); } else { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Message", "<script> alert('Record not inserted.')</script>", false); } RefreshPageControls(); pnlSearch.CssClass = "Visible"; } catch (Exception ex) { throw ex; } ////finally ////{ } }
protected void ddlStandard_SelectedIndexChanged(object sender, EventArgs e) { if ((ddlBoard != null && ddlBoard.SelectedIndex > 0) && (ddlMedium != null && ddlMedium.SelectedIndex > 0) && (ddlStandard != null && ddlStandard.SelectedIndex > 0)) { SYS_Division_BLogic obj_DivBlogic = new SYS_Division_BLogic(); int param_boardsid = int.Parse(ddlBoard.SelectedValue); int param_mediumid = int.Parse(ddlMedium.SelectedValue); int param_standardid = int.Parse(ddlStandard.SelectedValue); ViewState["BMSID"] = obj_DivBlogic.BAL_SYS_SelectBMSID(param_boardsid, param_mediumid, param_standardid); if (ViewState["BMSID"] != null) { DataAccess da = new DataAccess(); DataTable dt_StudentList = da.GetDataTable("select StudentID,FirstName+ ' ' + LastName+ ' > '+ LoginId as StudentName from Student where BMSID=" + ViewState["BMSID"] + " AND IsActive='true'"); if (dt_StudentList != null && dt_StudentList.Rows.Count > 0) { ddlStudents.DataSource = dt_StudentList; ddlStudents.DataTextField = "StudentName"; ddlStudents.DataValueField = "StudentID"; ddlStudents.DataBind(); ddlStudents.Items.Insert(0, "Select Student"); ddlStudents.Enabled = true; } else { ddlStudents.Enabled = false; } } } }
private void bindgrvSYS_Divisiondetail() { SYS_Division = new SYS_Division(); BAL_SYS_Division = new SYS_Division_BLogic(); DataSet dsSelect = new DataSet(); dsSelect = BAL_SYS_Division.BAL_SYS_Division_Select(SYS_Division, "SelectAll"); if (dsSelect.Tables.Count > 0) { string searchCondition = string.Empty; if (txtDivisionSearch.Text != string.Empty) { searchCondition = "Division like '%" + txtDivisionSearch.Text + "%'"; } if (txtDescriptionSearch.Text != string.Empty) { if (searchCondition != string.Empty) { searchCondition = searchCondition + " and "; } searchCondition = searchCondition + " Description like '%" + txtDescriptionSearch.Text + "%'"; } if (rlstActive.SelectedValue == "0") { if (searchCondition != string.Empty) { searchCondition = searchCondition + " and "; } searchCondition = searchCondition + " IsActive = 0"; } else if (rlstActive.SelectedValue == "1") { if (searchCondition != string.Empty) { searchCondition = searchCondition + " and "; } searchCondition = searchCondition + " IsActive = 1"; } DataView dv = new DataView(dsSelect.Tables[0]); dv.RowFilter = searchCondition; DataSet dsSelectSub = new DataSet(); dsSelectSub.Tables.Add(dv.ToTable()); GridViewOperations GrvOperation = new GridViewOperations(); GrvOperation.BindGridWithSorting(grvSYS_Divisiondetail, dsSelectSub, this.SortField, this.SortDirection); } else { grvSYS_Divisiondetail.DataSource = null; grvSYS_Divisiondetail.DataBind(); } }
protected void ddlStandard_SelectedIndexChanged(object sender, EventArgs e) { if ((ddlBoard != null && ddlBoard.SelectedIndex > 0) && (ddlMedium != null && ddlMedium.SelectedIndex > 0) && (ddlStandard != null && ddlStandard.SelectedIndex > 0)) { SYS_Division_BLogic obj_DivBlogic = new SYS_Division_BLogic(); int param_boardsid = int.Parse(ddlBoard.SelectedValue); int param_mediumid = int.Parse(ddlMedium.SelectedValue); int param_standardid = int.Parse(ddlStandard.SelectedValue); ViewState["BMSID"] = obj_DivBlogic.BAL_SYS_SelectBMSID(param_boardsid, param_mediumid, param_standardid); } }
private void BindDivision(DropDownList ddlDivision) { if (ddlStandard.SelectedIndex != 0) { DivisionBLogic = new SYS_Division_BLogic(); DataSet dsResult = new DataSet(); dsResult = DivisionBLogic.BAL_SYS_Division_SelectByBMSID(Convert.ToInt32(ddlBoard.SelectedValue), Convert.ToInt32(ddlMedium.SelectedValue), Convert.ToInt32(ddlSchool.SelectedValue), Convert.ToInt32(Session["SchoolID"])); DdlFilling = new DropDownFill(); DdlFilling.BindDropDownByTable(ddlDivision, dsResult.Tables[0], "Division", "DivisionID"); ddlDivision.Items.Insert(Convert.ToInt32(EnumFile.AssignValue.Zero), "-- Select --"); ddlDivision.Items[0].Value = Convert.ToString((int)EnumFile.AssignValue.Zero); } }
private void BindDDlDivision() { SYS_Division_BLogic BAL_SYS_Division = new SYS_Division_BLogic(); DataSet dsSelect = new DataSet(); dsSelect = BAL_SYS_Division.BAL_SYS_Division_SelectAllActive("Active"); if (dsSelect.Tables.Count > 0) { DropDownFill DdlFilling = new DropDownFill(); DdlFilling.BindDropDownByTable(ddlDivision, dsSelect.Tables[0], "Division", "DivisionID"); ddlDivision.Items.Insert(Convert.ToInt32(EnumFile.AssignValue.Zero), "-- Select --"); ddlDivision.Items[0].Value = Convert.ToString((int)EnumFile.AssignValue.Zero); } }
private void BindGroupName(DropDownList ddlGroupName) { if (ddlMedium.SelectedIndex != 0) { DivisionBLogic = new SYS_Division_BLogic(); DataSet dsResult = new DataSet(); dsResult = DivisionBLogic.BAL_SYS_GroupName_SelectByBMSID(); DdlFilling = new DropDownFill(); // DdlFilling.BindDropDownByTable(ddlGroupName, dsResult.Tables[0], "GroupName", "StudentAgeGroupID"); DdlFilling.BindDropDownByGroupName(ddlGroupName, dsResult.Tables[0], "GroupName"); ddlGroupName.Items.Insert(Convert.ToInt32(EnumFile.AssignValue.Zero), "-- Select --"); ddlGroupName.Items[0].Value = Convert.ToString((int)EnumFile.AssignValue.Zero); Session["ReportGroupName"] = Convert.ToInt32(ddlGroupName.SelectedValue); Session["GroupName"] = ddlGroupName.SelectedItem.ToString(); } }
protected void BtnUpdate_Click(object sender, EventArgs e) { SYS_Division = new SYS_Division(); BAL_SYS_Division = new SYS_Division_BLogic(); SYS_Division.divisionid = Convert.ToInt32(ViewState["divisionid"].ToString()); SYS_Division.division = txtDivisionEdit.Text; SYS_Division.description = txtDescriptionEdit.Text; SYS_Division.createdby = Convert.ToInt32(Session["EmpolyeeID"]); SYS_Division.modifiedby = Convert.ToInt32(Session["EmpolyeeID"]); status = BAL_SYS_Division.BAL_SYS_Division_Update(SYS_Division, "Update"); if (status == 1) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Message", "<script> alert('Record successfully updated.')</script>", false); } else { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Message", "<script> alert('Record not updated.')</script>", false); } RefreshPageControls(); }
protected void BtnActDeactSub_Click(object sender, EventArgs e) { int CountChecked = 0; string DivisionIDStr = string.Empty; foreach (GridViewRow gr in grvSYS_Divisiondetail.Rows) { CheckBox chk = new CheckBox(); chk = (CheckBox)gr.FindControl("chkSelect"); if (chk.Checked == true) { if (CountChecked == 0) { DivisionIDStr = grvSYS_Divisiondetail.DataKeys[gr.RowIndex]["DivisionID"].ToString(); } else { DivisionIDStr = DivisionIDStr + "," + grvSYS_Divisiondetail.DataKeys[gr.RowIndex]["DivisionID"].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 { SYS_Division = new SYS_Division(); BAL_SYS_Division = new SYS_Division_BLogic(); SYS_Division.divisionidStr = DivisionIDStr; if (rbActive.Checked == true) { SYS_Division.isactive = true; } if (rbDeactive.Checked == true) { SYS_Division.isactive = false; } status = BAL_SYS_Division.BAL_SYS_Division_Delete(SYS_Division, "UpdateStatus"); string status1 = string.Empty; if (status == 1) { if (rbActive.Checked == true) { status1 = "Active."; } else if (rbDeactive.Checked == true) { status1 = "Deactive."; } string message = string.Format("Selected records successfully {0}", status1); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Message", "<script> alert('" + message + "')</script>", false); } else { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Message", "<script> alert('Selected record not Active/Deactive.')</script>", false); } RefreshPageControls(); } }