private void SearchData()
{
Cursor.Current = Cursors.WaitCursor;
string strSearchCustomer;
string strSearchUseYN;
try
{
strSearchCustomer = lueSearchCustomer.EditValue.ToString();
if (string.IsNullOrEmpty(strSearchCustomer))
{
strSearchCustomer = "%";
}
strSearchUseYN = lueSearchUseYN.Properties.GetKeyValueByDisplayText(lueSearchUseYN.Text).ToString();
if (string.IsNullOrEmpty(strSearchUseYN))
{
strSearchUseYN = "%";
}
var qry = db.stp_Customer_Select(strSearchCustomer, strSearchUseYN).ToList();
if (qry.Count() > 0)
{
gcList.DataSource = qry;
string[] arr = { "CustomerID" };
Functions.SetInvisible(ref gvList, arr);
gvList.BestFitColumns();
gvList.OptionsBehavior.ReadOnly = true;
gvList.FocusedRowHandle = gvList.GetVisibleRowHandle(0);
}
else
{
gcList.DataSource = null;
MessageBox.Show("No Results", "Success!", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show("Couldn't Search Customer List!" + Environment.NewLine + ex.Message.ToString(), "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
Cursor.Current = Cursors.Default;
}
}
