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)
{
}
}
/// <summary>
/// Method will be used to bind bms to drop down.
/// </summary>
protected void getBMS()
{
try
{
DataSet dsBMS = new DataSet();
dsBMS = BAL_SYS_BMS.BAL_SYS_BMS_SelectAll();
if (dsBMS.Tables[0].Rows.Count > 0 && dsBMS.Tables[0] != null)
{
DDF.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;
DDF.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;
DDF.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;
}
}
catch (Exception ex)
{
WebMsg.Show(ex.Message);
}
}
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;
}
}
protected static string[] GetBMS()
{
List <string> bmsList = new List <string>();
SYS_BMS_BLogic BSysBMS = new SYS_BMS_BLogic();
DataSet dsBMS = new DataSet();
try
{
dsBMS = BSysBMS.BAL_SYS_BMS_SelectAll();
foreach (DataRow dr in dsBMS.Tables[0].Rows)
{
bmsList.Add(dr["BMS"].ToString());
}
}
catch (Exception ex)
{
WebMsg.Show(ex.Message);
}
return(bmsList.ToArray());
}
