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