private DataTable FetchSection(int intSchoolID) { // DataTable dtStudent = new DataTable(); SectionBL objSectionBL = new SectionBL(); SectionBO objSectionBO = new SectionBO(); ApplicationResult objResults = new ApplicationResult(); objResults = objSectionBL.Section_SelectAll_ForDropDown(intSchoolID); if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS && objResults.resultDT.Rows.Count > 0) { } return(objResults.resultDT); }
public void getSectionName() { ddlsection.Items.Clear(); ddlclass.Items.Clear(); ddlDivision.Items.Clear(); ApplicationResult objResult = new ApplicationResult(); Controls objControls = new Controls(); SectionBL objSectionBl = new SectionBL(); objResult = objSectionBl.Section_SelectAll_ForDropDown(Convert.ToInt32(Session[ApplicationSession.SCHOOLID])); if (objResult != null) { objControls.BindDropDown_ListBox(objResult.resultDT, ddlsection, "SectionName", "SectionMID"); if (objResult.resultDT.Rows.Count > 0) { } ddlsection.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "")); ddlclass.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "")); ddlDivision.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "")); } }
protected void ddlSchoolName_SelectedIndexChanged(object sender, EventArgs e) { try { ApplicationResult objResult = new ApplicationResult(); Controls objControls = new Controls(); SectionBL objSectionBl = new SectionBL(); objResult = objSectionBl.Section_SelectAll_ForDropDown(Convert.ToInt32(ddlSchoolName.SelectedValue)); if (objResult != null) { objControls.BindDropDown_ListBox(objResult.resultDT, ddlSection, "SectionName", "SectionMID"); if (objResult.resultDT.Rows.Count > 0) { } ddlSection.Items.Insert(0, new ListItem("--Select--", "")); } #region Fetch Academic Month from School SchoolBL objSchoolBl = new SchoolBL(); ApplicationResult objResults = new ApplicationResult(); int intMonth = 0; objResults = objSchoolBl.School_Select(Convert.ToInt32(ddlSchoolName.SelectedValue)); if (objResults != null) { if (objResults.resultDT.Rows.Count > 0) { intMonth = Convert.ToInt32(objResults.resultDT.Rows[0][SchoolBO.SCHOOL_ACADEMICMONTH].ToString()); } } #endregion int month = System.DateTime.Now.Month; int Year = System.DateTime.Now.Year; int lastTwoDigit = Year % 100; string yr = string.Empty; if (month >= intMonth) { yr = (lastTwoDigit.ToString() + (lastTwoDigit + 1).ToString()).ToString(); } else { yr = ((lastTwoDigit - 1).ToString() + lastTwoDigit.ToString()).ToString(); } int f = (Convert.ToInt32(yr.Substring(0, 2))); int l = (Convert.ToInt32(yr.Substring(2, 2))); DataTable dt = new DataTable(); DataRow dr = null; dt.Columns.Add(new DataColumn("AcademicYear", typeof(string))); for (int i = 0; i < 5; i++) { dr = dt.NewRow(); if (i == 0) { dr["AcademicYear"] = Convert.ToString(f.ToString() + "-" + l.ToString()); dt.Rows.Add(dr); } else { if ((f - 1).ToString().Length < 2) { if (f.ToString().Length == 2) { dr["AcademicYear"] = Convert.ToString("0" + (f - 1).ToString() + "-" + (f).ToString()); } else { dr["AcademicYear"] = Convert.ToString("0" + (f - 1).ToString() + "-" + "0" + (f).ToString()); } dt.Rows.Add(dr); } else { dr["AcademicYear"] = Convert.ToString((f - 1).ToString() + "-" + (f).ToString()); dt.Rows.Add(dr); } f = f - 1; l = f; } } objControls.BindDropDown_ListBox(dt, ddlYear, "AcademicYear", "AcademicYear"); ddlYear.Items.Insert(0, new ListItem("-Select-", "-1")); } catch (Exception) { throw; } }