private void btnSearch_Click(object sender, EventArgs e)
{
string search = "";
if (comboBoxName.Text != "Any")
{
search += "Name Like \"" + comboBoxName.Text + "%\" ";
}
else
{
search += "Name Like \"%\"";
}
if (txtUsrDrawWeight.Text != "")
{
search += "and MinDrawWeight<=" + txtUsrDrawWeight.Text + " and MaxDrawWeight >=" + txtUsrDrawWeight.Text + " ";
}
if (txtUsrDrawLength.Text != "")
{
search += "and MinDrawLength <= " + txtUsrDrawLength.Text + " and MaxDrawLength>=" + txtUsrDrawLength.Text + " ";
}
if (txtUsrBraceHeight.Text != "")
{
search += "and BraceHeight <= " + txtUsrBraceHeight.Text + " ";
}
if (txtUsrMaxAtA.Text != "")
{
search += "and AxleToAxle <= " + txtUsrMaxAtA.Text + " ";
}
if (txtUsrMinAtA.Text != "")
{
search += "and AxleToAxle >= " + txtUsrMinAtA.Text + " ";
}
if (txtMaxWeight.Text != "")
{
search += "and Weight <= " + txtMaxWeight.Text + " ";
}
List <string> tmpList = new List <string>();
cCompoundBowTools cTools = new cCompoundBowTools();
tmpList = cTools.FindBows(search);
listBoxSysBows.Items.Clear();
for (int i = 0; i < tmpList.Count; i++)
{
listBoxSysBows.Items.Add(tmpList[i]);
}
lblCount.Text = tmpList.Count.ToString() + " Bows";
}
private void comboBoxBows_SelectedIndexChanged(object sender, EventArgs e)
{
string search = "";
List <string> tmpList = new List <string>();
cCompoundBowTools cTools = new cCompoundBowTools();
if (comboBoxBows.Text != "Any")
{
search = "Name Like \"" + comboBoxBows.Text + "%\" ";
tmpList = cTools.FindBows(search);
}
else
{
tmpList = cTools.GetBows();
}
listBoxSysBows.Items.Clear();
for (int i = 0; i < tmpList.Count; i++)
{
listBoxSysBows.Items.Add(tmpList[i]);
}
}