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