/// <summary>
///Set BMS Table in Viewstate
/// </summary>
private void SetBMSTableInViewstate()
{
SYS_BMSBLogic = new SYS_BMS_BLogic();
DataSet dsselectBMS = new DataSet();
dsselectBMS = SYS_BMSBLogic.BAL_SYS_BMS_SelectAllBySchoolID(AppSessions.SchoolID);
ViewState["BMSTable"] = dsselectBMS.Tables[0];
}
/// <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);
}
}
/// <summary>
/// Set BMS Value in XX column of excel sheet.
/// </summary>
private void SetBMSValue(Worksheet xlsWorksheet)
{
SYS_BMS_BLogic BSysBMS = new SYS_BMS_BLogic();
DataSet dsBMS = new DataSet();
dsBMS = BSysBMS.BAL_SYS_BMS_SelectAllBySchoolID(AppSessions.SchoolID);
if (dsBMS.Tables[0].Rows.Count > 0)
{
int i = 1;
foreach (DataRow oDr in dsBMS.Tables[0].Rows)
{
xlsWorksheet.Range["XX" + i + ""].Value = Convert.ToString(oDr["BMS"]);
i++;
}
}
SetBMSDropDown(xlsWorksheet, dsBMS.Tables[0].Rows.Count);
}
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;
}
}
