public void PatternDropDownList(IList<Pattern> _Pattern)
{
NpgsqlDataReader _dr = null;
DataBaseHelper _db = new DataBaseHelper(Command, CommandType.Text);
try
{
_dr = _db.ExecuteReader(returnParam());
_Pattern.Add(new Pattern(0, "Select Pattern"));
while (_dr.Read())
{
_Pattern.Add(new Pattern(int.Parse(_dr[0].ToString()), _dr[1].ToString()));
}
}
catch (Exception ex)
{
throw new Exception(" :: " + ex.Message);
}
finally
{
if(_dr!=null)
{
_db = null;
_dr=null;
_Pattern = null;
}
}
}
public PatternSelect(Pattern _pattern)
{
this.Pattern = _pattern;
Command = "SELECT unitID,unitName,coalesce(isActivePattern,'0') AS path" +
" FROM tblUnits WHERE patternID = :patternID ORDER BY unitName ASC;";
}
public PatternInsert(Pattern _Pattern)
{
this.Pattern = _Pattern;
Command = StoredProcedure.Name.SP_INSERT_PATTERN.ToString();
}
private void selectPattern()
{
Pattern _newPat = new Pattern();
_newPat.ComID = this._comID;
PatternSelect _patternSelect = new PatternSelect(_newPat);
try
{
_patternSelect.selectPattern();
this._ds = _patternSelect.Ds;
}
catch (Exception ex)
{
ex.Message.ToString();
}
finally
{
_patternSelect = null;
}
}
public PatternUpdate(Pattern _Pattern)
{
this.Pattern = _Pattern;
Command = StoredProcedure.Name.SP_UPDATE_PATTREN.ToString();
}
public static void fillDropDownItemsPattern(System.Web.UI.WebControls.DropDownList ddl, Pattern _Pattern)
{
try
{
Pattern _Patterns = new Pattern();
_Patterns = _Pattern;
new PatternSelect(_Patterns).PatternDropDownList(_Patterns._dropDownList);
ddl.DataSource = _Patterns._dropDownList;
ddl.DataTextField = "Name";
ddl.DataValueField = "Value";
ddl.DataBind();
}
catch (Exception ex)
{
throw ex;
}
finally
{
ddl = null;
}
}
