protected void ddlBoard_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlBoard.SelectedValue != "0")
{
DataSet ds = new DataSet();
SYS_Board_BLogic objSys_Board = new SYS_Board_BLogic();
ds = objSys_Board.BAL_SYS_Medium_BySchoolIDBoardID(Convert.ToInt32(ddlSchool.SelectedValue), Convert.ToInt32(ddlBoard.SelectedValue));
DropDownFill DdlFilling = new DropDownFill();
DdlFilling.BindDropDownByTable(ddlMedium, ds.Tables[0], "Medium", "MediumID");
DDLDisable(ddlMedium, true);
DDLDisable(ddlStandard, false);
DDLDisable(ddlsubject, false);
DDLDisable(ddltopic, false);
DDLDisable(ddlchapter, false);
}
else
{
DDLDisable(ddlMedium, false);
DDLDisable(ddlStandard, false);
DDLDisable(ddlsubject, false);
DDLDisable(ddltopic, false);
DDLDisable(ddlchapter, false);
}
}
protected void ddlSchool_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlSchool.SelectedIndex != 0)
{
DataSet ds = new DataSet();
SYS_Board_BLogic objSys_Board = new SYS_Board_BLogic();
ds = objSys_Board.BAL_SYS_Board_BySchoolID(Convert.ToInt32(ddlSchool.SelectedValue));
DropDownFill DdlFilling = new DropDownFill();
DdlFilling.BindDropDownByTable(ddlBoard, ds.Tables[0], "Board", "BoardID");
ddlBoard.Items.Insert(Convert.ToInt32(EnumFile.AssignValue.Zero), "-- Select --");
ddlBoard.Items[0].Value = Convert.ToString((int)EnumFile.AssignValue.Zero);
Session["SchoolID"] = Convert.ToInt32(ddlSchool.SelectedValue);
Session["SchoolName"] = ddlSchool.SelectedItem.ToString();
ddlDisable(ddlBoard, true);
}
else
{
ddlDisable(ddlBoard, false);
ddlDisable(ddlMedium, false);
ddlDisable(ddlStandard, false);
ddlDisable(ddlDivision, false);
}
}
private void bindgrvSYS_Boarddetail()
{
SYS_Board = new SYS_Board();
BAL_SYS_Board = new SYS_Board_BLogic();
DataSet dsSelect = new DataSet();
dsSelect = BAL_SYS_Board.BAL_SYS_Board_Select(SYS_Board, "SelectAll");
if (dsSelect.Tables.Count > 0)
{
string searchCondition = string.Empty;
if (txtBoardSearch.Text != string.Empty)
{
searchCondition = "Board like '%" + txtBoardSearch.Text + "%'";
}
if (txtCodeSearch.Text != string.Empty)
{
if (searchCondition != string.Empty)
{
searchCondition = searchCondition + " and ";
}
searchCondition = searchCondition + " Code like '%" + txtCodeSearch.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_Boarddetail, dsSelectSub, this.SortField, this.SortDirection);
}
else
{
grvSYS_Boarddetail.DataSource = null;
grvSYS_Boarddetail.DataBind();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
SYS_Board = new SYS_Board();
BAL_SYS_Board = new SYS_Board_BLogic();
SYS_Board.board = txtBoard.Text;
SYS_Board.code = txtCode.Text;
SYS_Board.description = txtDescription.Text;
SYS_Board.createdby = Convert.ToInt32(Session["EmpolyeeID"]);
SYS_Board.modifiedby = Convert.ToInt32(Session["EmpolyeeID"]);
int status = BAL_SYS_Board.BAL_SYS_Board_Insert(SYS_Board, "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);
}
bindgrvSYS_Boarddetail();
RefereshPageControls();
ClearControls();
}
catch (Exception ex)
{
throw ex;
}
////finally
////{ }
}
protected void ddlBoard_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlBoard.SelectedValue != "0")
{
DataSet ds = new DataSet();
SYS_Board_BLogic objSys_Board = new SYS_Board_BLogic();
ds = objSys_Board.BAL_SYS_Medium_BySchoolIDBoardID(Convert.ToInt32(ddlSchool.SelectedValue), Convert.ToInt32(ddlBoard.SelectedValue));
DropDownFill DdlFilling = new DropDownFill();
DdlFilling.BindDropDownByTable(ddlMedium, ds.Tables[0], "Medium", "MediumID");
ddlMedium.Items.Insert(Convert.ToInt32(EnumFile.AssignValue.Zero), "-- Select --");
ddlMedium.Items[0].Value = Convert.ToString((int)EnumFile.AssignValue.Zero);
ddlDisable(ddlMedium, true);
//ddlMedium.Items[0].Value = Convert.ToString((int)EnumFile.AssignValue.Zero);
}
else
{
ddlDisable(ddlMedium, false);
ddlDisable(ddlStandard, false);
ddlDisable(ddlSubject, false);
ddlDisable(ddlChapter, false);
ddlDisable(ddlTopic, false);
ddlDisable(ddlDivision, false);
}
}
private void BindSubjectChapterTopic(int Step)
{
DataSet ds = new DataSet();
SYS_Board_BLogic objSys_Board = new SYS_Board_BLogic();
ds = objSys_Board.BAL_SYS_StdSubChapTopic_BySchoolIDBoardIDMediumid(Convert.ToInt32(ddlSchool.SelectedValue), Convert.ToInt32(ddlBoard.SelectedValue), Convert.ToInt32(ddlMedium.SelectedValue), Convert.ToInt32(ddlStandard.SelectedValue), Convert.ToInt32(ddlsubject.SelectedValue), 0);
DropDownFill DdlFilling = new DropDownFill();
if (Step <= 1)
{
if (ds.Tables.Count > 0)
{
DdlFilling.BindDropDownByTable(ddlStandard, ds.Tables[0], "Standard", "StandardID");
DDLDisable(ddlStandard, true);
}
}
if (Step <= 2)
{
if (ds.Tables.Count > 1)
{
DdlFilling.BindDropDownByTable(ddlsubject, ds.Tables[1], "Subject", "SubjectID");
DDLDisable(ddlsubject, true);
}
}
}
protected void ddlMediumSecond_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlMediumSecond.SelectedIndex != 0)
{
DataSet ds = new DataSet();
SYS_Board_BLogic objSys_Board = new SYS_Board_BLogic();
ds = objSys_Board.BAL_SYS_StdSubChapTopic_BySchoolIDBoardIDMediumid(this.SchoolID, Convert.ToInt32(ddlBoardSecond.SelectedValue), Convert.ToInt32(ddlMediumSecond.SelectedValue), Convert.ToInt32(null), Convert.ToInt32(null), Convert.ToInt32(null));
DropDownFill DdlFilling = new DropDownFill();
if (ds.Tables.Count > 0)
{
DdlFilling.BindDropDownByTable(ddlStandardSecond, ds.Tables[0], "Standard", "StandardID");
if (ds.Tables[0].Rows.Count > 0)
{
ddlStandardSecond.Items.Insert(Convert.ToInt32(EnumFile.AssignValue.Zero), "-- Select --");
ddlStandardSecond.Items[0].Value = Convert.ToString((int)EnumFile.AssignValue.Zero);
ddlDisable(ddlStandardSecond, true);
}
}
}
else
{
ddlDisable(ddlStandardSecond, false);
}
}
private void BindSubjectChapterTopic(int Step)
{
DataSet ds = new DataSet();
SYS_Board_BLogic objSys_Board = new SYS_Board_BLogic();
ds = objSys_Board.BAL_SYS_StdSubChapTopic_BySchoolIDBoardIDMediumid(Convert.ToInt32(ddlSchool.SelectedValue), Convert.ToInt32(ddlBoard.SelectedValue), Convert.ToInt32(ddlMedium.SelectedValue), Convert.ToInt32(ddlStandard.SelectedValue), Convert.ToInt32(ddlSubject.SelectedValue), Convert.ToInt32(ddlChapter.SelectedValue));
DdlFilling = new DropDownFill();
if (Step <= 1)
{
if (ds.Tables.Count > 0)
{
DdlFilling.BindDropDownByTable(ddlStandard, ds.Tables[0], "Standard", "StandardID");
if (ds.Tables[0].Rows.Count > 0)
{
ddlStandard.Items.Insert(Convert.ToInt32(EnumFile.AssignValue.Zero), "-- Select --");
ddlStandard.Items[0].Value = Convert.ToString((int)EnumFile.AssignValue.Zero);
}
}
}
if (Step <= 2)
{
if (ds.Tables.Count > 1)
{
DdlFilling.BindDropDownByTable(ddlSubject, ds.Tables[1], "Subject", "SubjectID");
if (ds.Tables[1].Rows.Count > 0)
{
ddlSubject.Items.Insert(Convert.ToInt32(EnumFile.AssignValue.Zero), "-- Select --");
ddlSubject.Items[0].Value = Convert.ToString((int)EnumFile.AssignValue.Zero);
}
}
}
if (Step <= 3)
{
if (ds.Tables.Count > 2)
{
DdlFilling.BindDropDownByTable(ddlChapter, ds.Tables[2], "Chapter", "ChapterID");
if (ds.Tables[2].Rows.Count > 0)
{
ddlChapter.Items.Insert(Convert.ToInt32(EnumFile.AssignValue.Zero), "-- Select --");
ddlChapter.Items[0].Value = Convert.ToString((int)EnumFile.AssignValue.Zero);
}
}
}
if (Step <= 4)
{
if (ds.Tables.Count > 3)
{
DdlFilling.BindDropDownByTable(ddlTopic, ds.Tables[3], "Topic", "TopicID");
if (ds.Tables[3].Rows.Count > 0)
{
ddlTopic.Items.Insert(Convert.ToInt32(EnumFile.AssignValue.Zero), "-- Select --");
ddlTopic.Items[0].Value = Convert.ToString((int)EnumFile.AssignValue.Zero);
}
}
}
}
private void BindBoardDropdown(DropDownList ddlBoardSecond)
{
DataSet ds = new DataSet();
SYS_Board_BLogic objSys_Board = new SYS_Board_BLogic();
ds = objSys_Board.BAL_SYS_Board_BySchoolID(this.SchoolID);
DropDownFill DdlFilling = new DropDownFill();
DdlFilling.BindDropDownByTable(ddlBoardSecond, ds.Tables[0], "Board", "BoardID");
ddlBoardSecond.Items.Insert(Convert.ToInt32(EnumFile.AssignValue.Zero), "-- Select --");
ddlBoardSecond.Items[0].Value = Convert.ToString((int)EnumFile.AssignValue.Zero);
}
//protected void grdClassroomWiseAttendance_PageIndexChanging(object sender, GridViewPageEventArgs e)
//{
// try
// {
// grdClassroomWiseAttendance.PageIndex = e.NewPageIndex;
// BindClassWiseAttendanceGrid();
// }
// catch (Exception ex)
// {
// WebMsg.Show(ex.Message);
// }
//}
//protected void ddlPageSelector_SelectedIndexChanged(object sender, EventArgs e)
//{
// try
// {
// grdClassroomWiseAttendance.PageIndex = ((DropDownList)sender).SelectedIndex;
// BindClassWiseAttendanceGrid();
// }
// catch (Exception ex)
// {
// WebMsg.Show(ex.Message);
// }
//}
//protected void grdClassroomWiseAttendance_RowCreated(object sender, GridViewRowEventArgs e)
//{
// try
// {
// if (e.Row.RowType == DataControlRowType.Pager)
// {
// GridViewOperations GrvOperation = new GridViewOperations();
// GrvOperation.SetPagerButtonStates(grdClassroomWiseAttendance, e.Row, this.Page);
// }
// }
// catch (Exception ex)
// {
// WebMsg.Show(ex.Message);
// }
//}
//protected void grdClassroomWiseAttendance_Sorting(object sender, GridViewSortEventArgs e)
//{
// try
// {
// if (e.SortExpression.Trim() == this.SortField)
// this.SortDirection = (this.SortDirection == "descending" ? "ascending" : "descending");
// else
// this.SortDirection = "ascending";
// this.SortField = e.SortExpression;
// BindClassWiseAttendanceGrid();
// GridViewOperations GrvOperation = new GridViewOperations();
// GrvOperation.GrvSortingSetImage(e, grdClassroomWiseAttendance, this.SortDirection);
// }
// catch (Exception ex)
// {
// WebMsg.Show(ex.Message);
// }
//}
//protected void grdClassroomWiseAttendance_RowDataBound(object sender, GridViewRowEventArgs e)
//{
// try
// {
// if (e.Row.RowType == DataControlRowType.DataRow)
// {
// for (int i = 1; i < e.Row.Cells.Count; i++)
// {
// e.Row.Cells[i].Text = "<a href='ClassroomAttendance.aspx?BMSID=" + DataBinder.Eval(e.Row.DataItem, "BMSID").ToString() + "&Division=" + DataBinder.Eval(e.Row.DataItem, "Division").ToString() + "&DivisionID=" + DataBinder.Eval(e.Row.DataItem, "DivisionID").ToString() + "&Attendance=" + DataBinder.Eval(e.Row.DataItem, "Attendance").ToString() + "'>" + e.Row.Cells[i].Text + "</a>";
// }
// }
// }
// catch (Exception ex)
// {
// WebMsg.Show(ex.Message.ToString());
// }
// finally
// {
// }
//}
#endregion
#region "User Defined Functions"
private void BindStandard(int Step)
{
DataSet ds = new DataSet();
SYS_Board_BLogic objSys_Board = new SYS_Board_BLogic();
ds = objSys_Board.BAL_SYS_Std_BySchoolIDBoardIDMediumid(Convert.ToInt32(ddlSchool.SelectedValue), Convert.ToInt32(ddlBoard.SelectedValue), Convert.ToInt32(ddlMedium.SelectedValue), Convert.ToInt32(ddlStandard.SelectedValue));
DdlFilling = new DropDownFill();
if (Step <= 1)
{
if (ds.Tables.Count > 0)
{
DdlFilling.BindDropDownByTable(ddlStandard, ds.Tables[0], "Standard", "StandardID");
ddlStandard.Items.Insert(Convert.ToInt32(EnumFile.AssignValue.Zero), "-- Select --");
ddlStandard.Items[0].Value = Convert.ToString((int)EnumFile.AssignValue.Zero);
ddlDisable(ddlStandard, true);
}
}
}
protected void BtnUpdate_Click(object sender, EventArgs e)
{
SYS_Board = new SYS_Board();
BAL_SYS_Board = new SYS_Board_BLogic();
SYS_Board.boardid = Convert.ToInt32(ViewState["boardid"].ToString());
SYS_Board.board = txtBoardEdit.Text;
SYS_Board.code = txtCodeEdit.Text;
SYS_Board.description = txtDescriptionEdit.Text;
SYS_Board.createdby = Convert.ToInt32(Session["EmpolyeeID"]);
SYS_Board.modifiedby = Convert.ToInt32(Session["EmpolyeeID"]);
int status = BAL_SYS_Board.BAL_SYS_Board_Update(SYS_Board, "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);
}
RefereshPageControls();
}
protected void BtnActDeactSub_Click(object sender, EventArgs e)
{
int CountChecked = 0;
string BoardIDStr = string.Empty;
foreach (GridViewRow gr in grvSYS_Boarddetail.Rows)
{
CheckBox chk = new CheckBox();
chk = (CheckBox)gr.FindControl("chkSelect");
if (chk.Checked == true)
{
if (CountChecked == 0)
{
BoardIDStr = grvSYS_Boarddetail.DataKeys[gr.RowIndex]["BoardID"].ToString();
}
else
{
BoardIDStr = BoardIDStr + "," + grvSYS_Boarddetail.DataKeys[gr.RowIndex]["BoardID"].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_Board = new SYS_Board();
BAL_SYS_Board = new SYS_Board_BLogic();
SYS_Board.boardidStr = BoardIDStr;
//////////////////////////////////////////
if (rbActive.Checked == true)
{
SYS_Board.isactive = true;
}
if (rbDeactive.Checked == true)
{
SYS_Board.isactive = false;
}
status = BAL_SYS_Board.BAL_SYS_Board_Delete(SYS_Board, "UpdateStatus");
if (status == 1)
{
string status1 = string.Empty;
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);
}
RefereshPageControls();
}
}
