/// <summary>
///Set Division Table in Viewstate
/// </summary>
private void SetDivisionTableInViewState()
{
SYS_BMSBLogic = new SYS_BMS_BLogic();
DataSet dsDivision = new DataSet();
dsDivision = SYS_BMSBLogic.BAL_SYS_BMS_FillDivisionBySchoolBMSID(AppSessions.SchoolID);
ViewState["DivisionTable"] = dsDivision.Tables[0];
}
/// <summary>
/// Set Division Value in ZZ column of excel sheet.
/// </summary>
private static void SetDivValue(Worksheet xlsWorksheet)
{
SYS_BMS_BLogic BSysBMS = new SYS_BMS_BLogic();
DataSet dsDivision = new DataSet();
dsDivision = BSysBMS.BAL_SYS_BMS_FillDivisionBySchoolBMSID(AppSessions.SchoolID);
if (dsDivision.Tables[0].Rows.Count > 0)
{
int i = 1;
foreach (DataRow oDr in dsDivision.Tables[0].Rows)
{
xlsWorksheet.Range["ZZ" + i + ""].Value = Convert.ToString(oDr["Division"]);
i++;
}
}
SeDivisionDropDown(xlsWorksheet, dsDivision.Tables[0].Rows.Count);
}
