private NameValidation validateNameCriteria()
{
NameCriteria nameCriteria = (NameCriteria)EnumEx.GetValueFromDescription(typeof(NameCriteria),
nameCriteriaCombo.SelectedItem.ToString());
if (nameCriteria == NameCriteria.Match &&
regexCheck.Checked)
{
try
{
new Regex(nameTextBox.Text);
}
catch (ArgumentException)
{
return(NameValidation.BadRegex);
}
}
searchCriteria.NameCriteria = nameCriteria;
searchCriteria.NameText = nameTextBox.Text;
searchCriteria.MatchCase = caseCheck.Checked;
searchCriteria.UseRegex = regexCheck.Checked;
return(NameValidation.Good);
}
private void nameCriteriaCombo_OnChange(object sender, EventArgs e)
{
NameCriteria nameCriteria = (NameCriteria)EnumEx.GetValueFromDescription(typeof(NameCriteria),
nameCriteriaCombo.SelectedItem.ToString());
switch (nameCriteria)
{
case NameCriteria.Any:
nameTextBox.Visible = false;
regexCheck.Visible = false;
caseCheck.Visible = false;
break;
case NameCriteria.Match:
nameTextBox.Visible = true;
regexCheck.Visible = true;
caseCheck.Visible = true;
break;
}
}
private void DataPortal_Fetch(NameCriteria criteria)
{
RaiseListChangedEvents = false;
using (SqlConnection cn = new SqlConnection(Database.ConnectionString))
{
cn.Open();
using (SqlCommand cm = cn.CreateCommand())
{
cm.CommandType = CommandType.StoredProcedure;
cm.CommandText = "[app_cell].[cell_member_get_byname]";
cm.Parameters.AddWithValue("@name", criteria.Name);
using (SafeDataReader dr = new SafeDataReader(cm.ExecuteReader()))
while (dr.Read())
{
this.Add(CellMember.Get(dr));
}
}
}
RaiseListChangedEvents = true;
}
