public static List <MaterialGroupFilter> GetNumberOfFilterCombos(string code) { List <MaterialGroupFilter> ListOfFilters = new List <MaterialGroupFilter>(); MaterialGroupFilter FilterObject; DataTable dt = new DataTable(); IDatabaseFactory dbFactory = new DatabaseFactory(); IDatabase dbObject = dbFactory.CreateDatabaseInstance(ACTIVE_DATABASE); Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand(SQLClass.GET_NUMBEROFFIILTERCOMBO); command.Parameters.Add("group_code", code.ToUpper()); dt = dbObject.GetDataTable(command); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { FilterObject = new MaterialGroupFilter(); FilterObject.FilterId = int.Parse(dr["filter_id"].ToString()); FilterObject.FilterLabel = dr["description"].ToString(); FilterObject.FieldName = dr["field_name"].ToString(); FilterObject.TableName = dr["table_name"].ToString(); FilterObject.ListPosition = int.Parse(dr["list_position"].ToString()); ListOfFilters.Add(FilterObject); } } return(ListOfFilters); }
public static DropDownList CreateFilterCombo(MaterialGroupFilter filterCombo) { DataTable dt = new DataTable(); DropDownList drp = new DropDownList(); IDatabaseFactory dbFactory = new DatabaseFactory(); IDatabase dbObject = dbFactory.CreateDatabaseInstance(ACTIVE_DATABASE); string query = "SELECT DISTINCT " + filterCombo.FieldName + " FROM " + filterCombo.TableName + " ORDER BY " + filterCombo.FieldName; dt = dbObject.GetDataTable(query); drp = CreateDropdownList(dt); drp.Items.Insert(0, new ListItem("")); return(drp); }
public DropDownList CreteFilterCombo(MaterialGroupFilter mgCombo) { return(BusinessObjectManager.CreateFilterCombo(mgCombo)); }