private void LoadUsers(String type)
{
String query = "SELECT DISTINCT id, name FROM tblUsers WHERE usertype = " + type + " and Active = 1";
DataSet dsStatus = dh.GetData(query, null, out status);
if (dsStatus != null && dsStatus.Tables.Count > 0 && dsStatus.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in dsStatus.Tables[0].Rows)
{
SelectionValues sv = new SelectionValues
{
text = dr["name"].ToString(),
value = dr["id"].ToString()
};
try { cmbVals.Add(sv); } catch { }
}
}
}
private void LoadStatus()
{
String query = "SELECT DISTINCT status FROM tblPMJob ORDER BY status";
DataSet dsStatus = dh.GetData(query, null, out status);
if (dsStatus != null && dsStatus.Tables.Count > 0 && dsStatus.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in dsStatus.Tables[0].Rows)
{
SelectionValues sv = new SelectionValues
{
text = dr["status"].ToString(),
value = dr["status"].ToString()
};
try { cmbVals.Add(sv); } catch { }
}
}
}
private void cmbSelector_SelectedIndexChanged(object sender, EventArgs e)
{
bs.Clear();
cmbVals.Clear();
cmbCriteria.SelectedIndexChanged -= cmbCriteria_SelectedIndexChanged;
SelectionValues svTemp = new SelectionValues()
{
text = "Please select",
value = "0"
};
cmbVals.Add(svTemp);
try
{
switch (cmbSelector.SelectedItem.ToString())
{
case "Status":
LoadStatus();
selectionType = 1;
break;
case "PM":
LoadUsers("2");
selectionType = 2;
break;
case "PA":
LoadUsers("4");
selectionType = 3;
break;
}
cmbCriteria.DataSource = cmbVals;
cmbCriteria.DisplayMember = "text";
cmbCriteria.ValueMember = "value";
cmbCriteria.Refresh();
}
catch { }
cmbCriteria.SelectedIndexChanged += cmbCriteria_SelectedIndexChanged;
}
