private void BWICarchivedCheckBox_CheckedChanged(object sender, EventArgs e)
{
string strVal;
int i;
strVal = "";
//MessageBox.Show(BWICarchivedCheckBox.CheckState.ToString() );
if (BWICarchivedCheckBox.CheckState.ToString().Equals("Checked"))
{
archived = true;
}
else
{
archived = false;
}
//*** READ DATES AND NOTE THE ONES THAT ARE CHECKED
i = 0;
while (i < BWICdatecheckedListBox.Items.Count)
{
strVal = BWICdatecheckedListBox.Items[i].ToString();
if (strVal.IndexOf(":") > 0)
{
strVal = strVal.Substring(0, strVal.IndexOf(":"));
}
if (BWICdatecheckedListBox.GetItemChecked(i))
{
lBWICDates.Add(strVal);
}
i++;
}
i = 0;
while (i < BWICListcheckedListBox.Items.Count)
{
strVal = BWICListcheckedListBox.Items[i].ToString();
if (strVal.IndexOf(":") > 0)
{
strVal = strVal.Substring(0, strVal.IndexOf(":"));
}
if (BWICListcheckedListBox.GetItemChecked(i))
{
lBWICLists.Add(strVal);
}
i++;
}
fillBWICdate();
BWICListcheckedListBox.Items.Clear();
//fillBWIClist();
i = 0;
while (i < BWICdatecheckedListBox.Items.Count)
{
strVal = BWICdatecheckedListBox.Items[i].ToString();
if (strVal.IndexOf(":") > 0)
{
strVal = strVal.Substring(0, strVal.IndexOf(":"));
}
foreach (object element in lBWICDates)
{
//MessageBox.Show(element.ToString());
if (strVal.Equals(element.ToString()))
{
BWICdatecheckedListBox.SetItemChecked(i, true);
}
}
i++;
}
i = 0;
while (i < BWICListcheckedListBox.Items.Count)
{
strVal = BWICListcheckedListBox.Items[i].ToString();
if (strVal.IndexOf(":") > 0)
{
strVal = strVal.Substring(0, strVal.IndexOf(":"));
}
foreach (object element in lBWICLists)
{
//MessageBox.Show(element.ToString());
if (strVal.Equals(element.ToString()))
{
BWICListcheckedListBox.SetItemChecked(i, true);
}
}
i++;
}
//foreach (object element in lBWICDates)
//{
// MessageBox.Show(element.ToString());
//}
//fillBWICdate();
lBWICDates.Clear();
lBWICLists.Clear();
}
private void buildBWICcriteria()
{
string SQL;
string sPiece;
int i;
string[] txtFlds;
txtFlds = new string[2];
//***
SQL = "select BWIC_NAME, COUNT(*) AS CNT from BWICinventory where 1=1 ";
i = 0;
//BWIC_NAME, COUNT(*) AS CNT FROM BWICINVENTORY GROUP BY BWIC_NAME ORDER BY BWIC_NAME ASC;
//mbsRangescheckedListBox.Items.Count
if (BWICdatecheckedListBox.CheckedItems.Count > 0)
{
SQL += " and FILE_DATE IN (";
while (i < BWICdatecheckedListBox.Items.Count)
{
if (BWICdatecheckedListBox.GetItemCheckState(i).ToString().Equals("Checked"))
{
sPiece = BWICdatecheckedListBox.Items[i].ToString();
if (sPiece.IndexOf(":") > 0)
{
sPiece = sPiece.Substring(0, sPiece.IndexOf(":"));
}
SQL += "'" + sPiece + "',";
}
i++;
}
SQL = SQL.Substring(0, SQL.Length - 1);
SQL += ") ";
}
SQL += " GROUP BY BWIC_NAME ORDER BY BWIC_NAME ASC;";
if (usingSQLServer == true)
{
SqlConnection cn = new SqlConnection("Data Source=ZM-SQL-1;" +
"Initial Catalog=ZM_GALLAGHER; Integrated Security=SSPI;");
cn.Open();
SqlCommand cmd = new SqlCommand();
cmd = cn.CreateCommand();
cmd.CommandText = SQL;
SqlDataReader Rdr;
Rdr = cmd.ExecuteReader();
BWICListcheckedListBox.Items.Clear();
while (Rdr.Read())
{
if (Rdr.GetValue(0).ToString().Equals(""))
{
BWICListcheckedListBox.Items.Add("Missing", false);
}
else
{
txtFlds[0] = Rdr.GetValue(0).ToString();
txtFlds[1] = Rdr.GetValue(1).ToString();
BWICListcheckedListBox.Items.Add(txtFlds[0] + ": \t" + txtFlds[1], false);
}
}
Rdr.Close();
}
}
