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