private void btnfilter_Click(object sender, EventArgs e)
        {
            string x = cboStores.EditValue.ToString();
            Item itm = new Item();
            DataTable dtItm = new DataTable();
            if (dtFrom.Value <= dtTo.Value)
            {
                // PopulateItemListByDateRange();
                Item itms = new Item();
                _issuesByReceivingUnit = itms.GetIssuesByReceivingUnit(Convert.ToInt32(cboStores.EditValue), Convert.ToInt32(lkRoutes.EditValue), Convert.ToInt32(lkCategories.EditValue), dtFrom.Value, dtTo.Value,Convert.ToInt32( cboStores.EditValue));
                gridDetailReport.DataSource = _issuesByReceivingUnit;
                //FilterByExclude();

                gridView1.Columns["ID"].Visible = false;
                gridView1.Columns["FullItemName"].Width = 300;
                gridView1.Columns["FullItemName"].Fixed = FixedStyle.Left;

            }
        }
 void bw_DoWork(object sender, DoWorkEventArgs e)
 {
     Item itms = new Item();
     e.Result = itms.GetIssuesByReceivingUnit(Convert.ToInt32(cboStores.EditValue),Convert.ToInt32(lkRoutes.EditValue),Convert.ToInt32(lkCategories.EditValue) );
     //e.Result = itms.GetIssuesByReceivingUnitFaster(Convert.ToInt32(cboStores.EditValue), Convert.ToInt32(lkRoutes.EditValue), Convert.ToInt32(lkCategories.EditValue));
 }