private void Search()
{
Messages oErrMsg = Messages.Instance;
FeedBack oFeedBack = new FeedBack();
DataSet ds = null;
if (this.InvokeRequired)
{
this.Invoke(new MethodInvoker(delegate
{
this.Cursor = Cursors.WaitCursor;
btnSearch.Enabled = false;
}));
}
else
{
this.Cursor = Cursors.WaitCursor;
btnSearch.Enabled = false;
}
if (!Utils.PingTest())
{
if (this.InvokeRequired)
{
this.Invoke(new MethodInvoker(delegate
{
this.Cursor = Cursors.Default;
MessageBox.Show("VPN disconnected. Please connect and try again.", "CSRAssistance");
return;
}));
}
else
{
this.Cursor = Cursors.Default;
MessageBox.Show("VPN disconnected. Please connect and try again.", "CSRAssistance");
return;
}
}
if (chkExcludeCallCust.InvokeRequired)
{
chkExcludeCallCust.Invoke(new MethodInvoker(delegate
{
oErrMsg = oFeedBack.LoadData(dtfrom.Value.ToString("yyyyMMdd"),
dtto.Value.ToString("yyyyMMdd"),
(chkExcludeCallCust.Checked ? 1 : 0),
txtSearch.Text, 1,
Pager.PageSize,
false,
txtJobID.Text,
dtExFrom.Value.ToString("yyyyMMdd"),
dtExTo.Value.ToString("yyyyMMdd"),
(chkRepair.Checked ? 1 : 0),
RangeExclude);
}));
}
else
{
oErrMsg = oFeedBack.LoadData(dtfrom.Value.ToString("yyyyMMdd"),
dtto.Value.ToString("yyyyMMdd"),
(chkExcludeCallCust.Checked ? 1 : 0),
txtSearch.Text, 1,
Pager.PageSize,
false,
txtJobID.Text,
dtExFrom.Value.ToString("yyyyMMdd"),
dtExTo.Value.ToString("yyyyMMdd"),
(chkRepair.Checked ? 1 : 0),
RangeExclude);
}
if (!oErrMsg.IsError)
{
ds = (DataSet) oErrMsg.Results;
if (ds.Tables.Count > 0)
{
if (ds.Tables[0] != null)
{
dtExport = ds.Tables[0];
}
}
if (outlookGrid1.InvokeRequired)
{
outlookGrid1.Invoke(new MethodInvoker(delegate
{
if (ds.Tables.Count > 0)
{
outlookGrid1.BindData(ds, "data");
View = "BoundInvoices";
DataGridViewCellEventArgs evt = new DataGridViewCellEventArgs(2, -1);
object sender = null;
}
}));
}
else
{
if (ds.Tables.Count > 0)
{
outlookGrid1.BindData(ds, "data");
View = "BoundInvoices";
DataGridViewCellEventArgs evt = new DataGridViewCellEventArgs(2, -1);
object sender = null;
}
}
this.Invoke(new Action(() =>
{
this.wfrm.Hide();
Pager.RecordCount = 0;
if (ds.Tables.Count > 0)
Pager.RecordCount = Convert.ToInt32(ds.Tables["counter"].Rows[0]["CNT"].ToString());
Pager.PageSize = 20;
Pager.MaximumNumberofLinks = (Pager.RecordCount > 0 ? 5 : 0);
lblCount.Text = Pager.RecordCount.ToString();
if (Pager.RecordCount > 0)
Pager.Visible = true;
else
Pager.Visible = false;
}));
}
else
{
this.Invoke(new Action(() =>
{
this.wfrm.Hide();
MessageBox.Show(oErrMsg.Message);
}));
}
this.Invoke(new Action(() =>
{
this.btnSearch.Enabled = true;
this.Cursor = Cursors.Default;
}));
}
private void Pager_PageClicked(object sender, PagerControl.PageClickEventHandler e)
{
Messages oErrMsg = Messages.Instance;
FeedBack oFeedBack = new FeedBack();
DataSet ds = null;
oErrMsg = oFeedBack.LoadData(dtfrom.Value.ToString("yyyyMMdd"),
dtto.Value.ToString("yyyyMMdd"),
(chkExcludeCallCust.Checked ? 1 : 0),
txtSearch.Text, e.SelectedPage,
Pager.PageSize,
false,
txtJobID.Text,
dtExFrom.Value.ToString("yyyyMMdd"),
dtExTo.Value.ToString("yyyyMMdd"),
(chkRepair.Checked ? 1 : 0),
(chkExcludeCallCust.Checked ? 1 : 0));
if(!oErrMsg.IsError)
{
ds = (DataSet)oErrMsg.Results;
if (ds.Tables.Count > 0)
{
outlookGrid1.BindData(ds, "data");
View = "BoundInvoices";
DataGridViewCellEventArgs evt = new DataGridViewCellEventArgs(2, -1);
}
}
}