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);
}
}
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);
}
}
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);
}
}
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);
}
}
private void GetDDLBMSDetails()
{
try
{
DropDownFill DdlFilling = new DropDownFill();
SYS_BMSBLogic = new SYS_BMS_BLogic();
DataSet dsselectBMS = new DataSet();
dsselectBMS = SYS_BMSBLogic.BAL_SYS_BMS_SelectAll();
if (dsselectBMS.Tables.Count > ((int)EnumFile.AssignValue.Zero))
{
if (dsselectBMS.Tables[0].Rows.Count > 0)
{
ddlBoardMediumStandard.Items.Clear();
ddlBoardMediumStandard.Items.Insert(0, "-- Select --");
ddlBoardMediumStandard.Items[0].Value = "0";
ddlBoardMediumStandard.DataSource = dsselectBMS.Tables[0];
ddlBoardMediumStandard.DataTextField = "BMS";
ddlBoardMediumStandard.DataValueField = "BMSID";
ddlBoardMediumStandard.DataBind();
}
else
{
ddlBoardMediumStandard.Items.Clear();
ddlBoardMediumStandard.DataBind();
ddlBoardMediumStandard.Items.Insert(Convert.ToInt32(EnumFile.AssignValue.Zero), "-- Select --");
ddlBoardMediumStandard.Items[0].Value = Convert.ToString((int)EnumFile.AssignValue.Zero);
}
}
}
catch (Exception ex)
{
}
}
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);
}
}
}
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 ClearControls()
{
DropDownFill objddl = new DropDownFill();
objddl.ClearDropDownListRef(ddlBoard);
this.GetBoardsBothDDL();
objddl.ClearDropDownListRef(ddlMedium);
objddl.ClearDropDownListRef(ddlStandard);
rlstAddSemester.ClearSelection();
}
private void ClearControlsEdit()
{
this.AllPanelInvisible();
pnlSearch.CssClass = "Visible";
DropDownFill objddl = new DropDownFill();
objddl.ClearDropDownListRef(ddlBoardEdit);
this.GetBoardsBothDDL();
objddl.ClearDropDownListRef(ddlMediumEdit);
objddl.ClearDropDownListRef(ddlStandardEdit);
rlstUpdateActive.ClearSelection();
}
protected void GetBMS()
{
DropDownFill DdlFilling = new DropDownFill();
DataSet dsBMS = new DataSet();
dsBMS = BSysBMS.BAL_SYS_BMS_SelectAll();
if (dsBMS.Tables[0].Rows.Count > 0)
{
DdlFilling.BindDropDownByTable(ddlBMS, dsBMS.Tables[0], "BMS", "BMSID");
ddlBMS.Items.Insert(Convert.ToInt32(EnumFile.AssignValue.Zero), "-- Select --");
ddlBMS.Items[0].Value = Convert.ToString((int)EnumFile.AssignValue.Zero);
ddlBMS.Enabled = true;
}
}
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);
}
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);
}
}
public void Get_Boards()
{
DropDownFill DdlFilling = new DropDownFill();
DataSet dsBoard = new DataSet();
dsBoard = BSysBMS.Get_AllBoards();
if (dsBoard.Tables[0].Rows.Count > 0)
{
ddlBoard.DataSource = dsBoard;
ddlBoard.DataTextField = "Board";
ddlBoard.DataValueField = "BoardID";
ddlBoard.DataBind();
ddlBoard.Items.Insert(0, "Select Board");
}
}
/// <summary>
/// Bind Admission Grade dropdown with BMS assigned to school
/// </summary>
private void BindAdmissionGrageDropDown()
{
DropDownFill DdlFilling = new DropDownFill();
SYS_BMS_BLogic SYS_BMSBLogic = new SYS_BMS_BLogic();
DataSet dsselectBMS = new DataSet();
dsselectBMS = SYS_BMSBLogic.BAL_SYS_BMS_SelectAllBySchoolID(AppSessions.SchoolID);
if (dsselectBMS.Tables.Count > ((int)EnumFile.AssignValue.Zero))
{
DdlFilling.BindDropDownByTable(DdlAdmissionGrade, dsselectBMS.Tables[0], "BMS", "BMSID");
}
else
{
DdlFilling.ClearDropDownListRef(DdlAdmissionGrade);
}
}
private void FillSchoolDropdown(DropDownList ddlSchool)
{
SchoolBLogic = new School_BLogic();
DataTable dt = new DataTable();
dt = SchoolBLogic.BAL_SchoolAllNameWithID("Normal").Tables[0];
if (dt != null)
{
if (dt.Rows.Count > 0)
{
DdlFilling = new DropDownFill();
DdlFilling.BindDropDownByTable(ddlSchool, dt, "Name", "SchoolID");
ddlSchool.Items.Insert(Convert.ToInt32(EnumFile.AssignValue.Zero), "-- Select --");
ddlSchool.Items[0].Value = Convert.ToString((int)EnumFile.AssignValue.Zero);
}
}
}
private void BindTagDropDown()
{
DropDownFill DdlFilling = new DropDownFill();
Admission oAdmission = new Admission();
Admission_BLogic oAdmission_BLogic = new Admission_BLogic();
DataSet odsTag = oAdmission_BLogic.AdmissionTagMaster_Select_All();
if (odsTag.Tables.Count > ((int)EnumFile.AssignValue.Zero))
{
DdlFilling.BindDropDownByTable(DdlTag, odsTag.Tables[0], "ValueField", "DisplayTag");
}
else
{
DdlFilling.ClearDropDownListRef(DdlTag);
}
}
protected void GetBoardsBothDDL()
{
try
{
DataSet dsBoards = new DataSet();
PBoard.boardid = ((int)EnumFile.AssignValue.Zero);
dsBoards = this.BLBoard.BAL_SYS_Board_Select(PBoard, "Select");
DropDownFill objddlfill = new DropDownFill();
objddlfill.BindDropDownByTable(ddlBoard, dsBoards.Tables[0], "Board", "BoardID");
objddlfill.BindDropDownByTable(ddlBoardEdit, dsBoards.Tables[0], "Board", "BoardID");
ddlMedium.Enabled = false;
ddlStandard.Enabled = false;
}
catch (Exception)
{
}
}
private void BindChkBoxSubject()
{
DropDownFill DdlFilling = new DropDownFill();
Subject_Blogic = new SYS_Subject_BLogic();
DataSet dsselect = Subject_Blogic.BAL_SYS_Subject_SelectByBMSID(Convert.ToInt64(ddlBoardMediumStandard.SelectedValue.ToString()));
if (dsselect.Tables.Count > ((int)EnumFile.AssignValue.Zero))
{
DdlFilling.BindCheckBoxListByTable(clstSubject, dsselect.Tables[0], "Subject", "SubjectID");
}
else
{
clstSubject.Items.Clear();
clstSubject.DataBind();
}
}
public void FillDivisionDropDown(DropDownList ddlDivision, int i)
{
SchoolBLogic = new School_BLogic();
DataTable dt = new DataTable();
SYS_BMS_BLogic SYS_BMSBLogic = new SYS_BMS_BLogic();
DataSet dsselectBMS = new DataSet();
if (i == 1)
{
dsselectBMS = SYS_BMSBLogic.BAL_SYS_Division_SelectAllBySchoolID(Convert.ToInt64(ddlschool.SelectedValue), Convert.ToInt64(ddlBMS.SelectedValue));
if (dsselectBMS.Tables[0].Rows.Count > 0)
{
ddldiv.Enabled = true;
}
else
{
ddldiv.Enabled = false;
}
}
else
{
dsselectBMS = SYS_BMSBLogic.BAL_SYS_Division_SelectAllBySchoolID(Convert.ToInt64(ddlschool.SelectedValue), Convert.ToInt64(ddlnextyearBMS.SelectedValue));
if (dsselectBMS.Tables[0].Rows.Count > 0)
{
ddldivision.Enabled = true;
}
else
{
ddldivision.Enabled = false;
}
}
dt = dsselectBMS.Tables[0];
if (dt != null)
{
if (dt.Rows.Count > 0)
{
DdlFilling = new DropDownFill();
DdlFilling.BindDropDownByTable(ddlDivision, dt, "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();
}
}
/// <summary>
/// This method used for bind BMS Dropdown based on SchoolID
/// </summary>
protected void GetDDLBMSDetails()
{
DropDownFill DdlFilling = new DropDownFill();
this.SYS_BMSBLogic = new SYS_BMS_BLogic();
DataSet dsselectBMS = new DataSet();
dsselectBMS = this.SYS_BMSBLogic.BAL_SYS_BMS_SelectAllBySchoolID(Convert.ToInt64(this.Session["SchoolID"]));
if (dsselectBMS.Tables.Count > ((int)EnumFile.AssignValue.Zero))
{
DdlFilling.BindDropDownByTable(this.ddlBoardMediumStandard, dsselectBMS.Tables[0], "BMS", "BMSID");
ddlBoardMediumStandard.Items.Insert((int)EnumFile.AssignValue.Zero, "ALL");
ddlBoardMediumStandard.Items[0].Value = ((int)EnumFile.AssignValue.Zero).ToString();
}
else
{
DdlFilling.ClearDropDownListRef(this.ddlBoardMediumStandard);
}
}
//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);
}
}
}
private void FillBMSDropdown(DropDownList ddlBMS)
{
SchoolBLogic = new School_BLogic();
DataTable dt = new DataTable();
SYS_BMS_BLogic SYS_BMSBLogic = new SYS_BMS_BLogic();
DataSet dsselectBMS = new DataSet();
dsselectBMS = SYS_BMSBLogic.BAL_SYS_BMS_SelectAllBySchoolID(Convert.ToInt64(ddlschool.SelectedValue));
dt = dsselectBMS.Tables[0];
if (dt != null)
{
if (dt.Rows.Count > 0)
{
DdlFilling = new DropDownFill();
DdlFilling.BindDropDownByTable(ddlBMS, dt, "BMS", "BMSID");
//ddlBMS.Items.Insert(Convert.ToInt32(EnumFile.AssignValue.Zero), "-- Select --");
//ddlBMS.Items[0].Value = Convert.ToString((int)EnumFile.AssignValue.Zero);
}
}
}
protected void GetBMS()
{
DropDownFill DdlFilling = new DropDownFill();
DataSet dsBMS = new DataSet();
dsBMS = BSysBMS.BAL_SYS_BMS_SelectAllBySchoolID(Convert.ToInt64(ViewState["SchoolID"]));
if (dsBMS.Tables[0].Rows.Count > 0)
{
DdlFilling.BindDropDownByTable(ddlBMSAdd, dsBMS.Tables[0], "BMS", "BMSID");
ddlBMSAdd.Items.Insert(Convert.ToInt32(EnumFile.AssignValue.Zero), "-- Select --");
ddlBMSAdd.Items[0].Value = Convert.ToString((int)EnumFile.AssignValue.Zero);
ddlBMSAdd.Enabled = true;
DdlFilling.BindDropDownByTable(ddlBMSEdit, dsBMS.Tables[0], "BMS", "BMSID");
ddlBMSEdit.Items.Insert(Convert.ToInt32(EnumFile.AssignValue.Zero), "-- Select --");
ddlBMSEdit.Items[0].Value = Convert.ToString((int)EnumFile.AssignValue.Zero);
ddlBMSEdit.Enabled = true;
DdlFilling.BindDropDownByTable(ddlBMSSearch, dsBMS.Tables[0], "BMS", "BMSID");
ddlBMSSearch.Items.Insert(Convert.ToInt32(EnumFile.AssignValue.Zero), "-- Select --");
ddlBMSSearch.Items[0].Value = Convert.ToString((int)EnumFile.AssignValue.Zero);
ddlBMSSearch.Enabled = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DateTime startOfMonth = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
DateTime endOfMonth = startOfMonth.AddMonths(1).AddDays(-1);
txtfromdate.Text = string.Format("{0:dd-MMM-yyyy}", startOfMonth);
txttodate.Text = string.Format("{0:dd-MMM-yyyy}", endOfMonth);
BindAllDDLSchool();
switch (AppSessions.RoleID)
{
case (int)EnumFile.Role.S_Admin:
ddlSchool.SelectedIndex = ddlSchool.Items.IndexOf(ddlSchool.Items.FindByValue(AppSessions.SchoolID.ToString()));
ddlSchool.Enabled = false;
ddlSchool_SelectedIndexChanged(ddlSchool, e);
break;
case (int)EnumFile.Role.Teacher:
ddlSchool.SelectedIndex = ddlSchool.Items.IndexOf(ddlSchool.Items.FindByValue(AppSessions.SchoolID.ToString()));
ddlSchool.Enabled = false;
ddlSchool_SelectedIndexChanged(ddlSchool, e);
break;
case (int)EnumFile.Role.Student:
ddlSchool.SelectedIndex = ddlSchool.Items.IndexOf(ddlSchool.Items.FindByValue(AppSessions.SchoolID.ToString()));
ddlSchool.Enabled = false;
ddlBoard.Enabled = true;
ddlMedium.Enabled = true;
ddlStandard.Enabled = true;
// ReportControl1.Visible = false;
DataAccess da = new DataAccess();
DataTable dt = da.GetDataTable("select *from SYS_Board,SYS_Medium,SYS_Standard, SYS_BMS where SYS_Board.BoardID= SYS_BMS.BoardID AND SYS_Medium.MediumID=SYS_BMS.MediumID AND SYS_Standard.StandardID=SYS_BMS.StandardID AND BMSID=" + AppSessions.BMSID.ToString());
if (dt != null && dt.Rows.Count > 0)
{
DropDownFill DdlFilling = new DropDownFill();
DdlFilling.BindDropDownByTable(ddlMedium, dt, "Medium", "MediumID");
DdlFilling.BindDropDownByTable(ddlBoard, dt, "Board", "BoardID");
DdlFilling.BindDropDownByTable(ddlStandard, dt, "Standard", "StandardId");
ddlBoard.SelectedIndex = ddlBoard.Items.IndexOf(ddlBoard.Items.FindByValue(AppSessions.BoardID.ToString()));
ddlMedium.SelectedIndex = ddlMedium.Items.IndexOf(ddlMedium.Items.FindByValue(AppSessions.MediumID.ToString()));
ddlStandard.SelectedIndex = ddlStandard.Items.IndexOf(ddlStandard.Items.FindByValue(AppSessions.StandardID.ToString()));
ddlSchool.Enabled = false;
ddlBoard.Enabled = false;
ddlMedium.Enabled = false;
ddlStandard.Enabled = false;
ddlsubject.Enabled = true;
ddlStandard_SelectedIndexChanged(ddlStandard, e);
}
// //ddlSchool_SelectedIndexChanged(ddlSchool, e);
//}
break;
}
}
}
