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