private void BtnRemoveByKey_Click(object sender, RoutedEventArgs e)
{
try
{
// the following two lines produce the same FilterExpression
var exp1 = FilterExpression.Parse("~FirstName = nancy");
exp1 = new FilterExpression("FirstName", "nancy", EqualityEnum.Equal, MatchTypeEnum.IgnoreCase);
var exp2 = new FilterExpression("LastName", "leverling", EqualityEnum.Equal, MatchTypeEnum.IgnoreCase);
var expGrp = new FilterExpressionGroup();
expGrp.Add(BoolOpEnum.Or, exp1);
expGrp.Add(BoolOpEnum.Or, exp2);
Table table = _db.SelectRecords(expGrp, new string[] { "ID" });
foreach (Record record in table)
{
int id = (int)record["ID"];
bool bRet = _db.DeleteRecordByKey(id);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void BtnGetMatchingRecords_Click(object sender, RoutedEventArgs e)
{
try
{
// Use the FilterExpressionGroup's filter parser to create a FilterExpressionGroup
// The syntax is similar to SQL (do not preceed with WHERE)
// Note that there are 2 ways to get a case-INSENSITIVE search:
// Use either ~= or you can prefix the fieldname with ~ to ignore case
// Both methods are shown below
// (FileDb doesn't support UPPER or LOWER)
// Note also that each set of parentheses will create a child FilterExpressionGroup
string filter = "(~FirstName = 'steven' OR [FirstName] ~= 'NANCY') AND LastName = 'Fuller'";
FilterExpressionGroup filterExpGrp = FilterExpressionGroup.Parse(filter);
Table table = _db.SelectRecords(filterExpGrp);
displayRecords(table);
// we can manually build the same FilterExpressionGroup
var fname1Exp = new FilterExpression("FirstName", "steven", ComparisonOperatorEnum.Equal, MatchTypeEnum.IgnoreCase);
// the following two lines produce the same FilterExpression
var fname2Exp = FilterExpression.Parse("FirstName ~= 'NANCY'"); // equal/ignore case
fname2Exp = new FilterExpression("FirstName", "NANCY", ComparisonOperatorEnum.Equal, MatchTypeEnum.IgnoreCase);
var lnameExp = new FilterExpression("LastName", "Fuller", ComparisonOperatorEnum.Equal, MatchTypeEnum.UseCase);
// NOTE: FileDb now supports CONTAINS which is very fast, so you could now do this too
//fname2Exp = FilterExpression.Parse( "~FirstName CONTAINS 'NANCY'" ); // equal/ignore case
//fname2Exp = new FilterExpression( "FirstName", "NANCY", ComparisonOperatorEnum.Contains, MatchTypeEnum.IgnoreCase );
var fnamesGrp = new FilterExpressionGroup();
fnamesGrp.Add(BoolOpEnum.Or, fname1Exp);
fnamesGrp.Add(BoolOpEnum.Or, fname2Exp);
var allNamesGrp = new FilterExpressionGroup();
allNamesGrp.Add(BoolOpEnum.And, lnameExp);
allNamesGrp.Add(BoolOpEnum.And, fnamesGrp);
table = _db.SelectRecords(allNamesGrp);
displayRecords(table);
// or just pass the string expression directly
table = _db.SelectRecords(filter);
displayRecords(table);
// get the same records again as a typed list using your own custom class
IList <Person> persons = _db.SelectRecords <Person>(filter);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void BtnGetMatchingRecords_Click(object sender, RoutedEventArgs e)
{
try
{
// Use the FilterExpressionGroup's filter parser to create a FilterExpressionGroup
// The syntax is similar to SQL (do not preceed with WHERE)
// Note that we prefix the fieldname with ~ to get a case-INSENSITIVE search
// (FileDb doesn't currently support UPPER or LOWER)
// Note that we can also use LIKE when we want to ignore case, but the difference
// is that LIKE will create a RegEx search which would be a little slower
// Note also that each set of parentheses will create a child FilterExpressionGroup
string filter = "(~FirstName = 'steven' OR [FirstName] LIKE 'NANCY') AND LastName = 'Fuller'";
FilterExpressionGroup filterExpGrp = FilterExpressionGroup.Parse(filter);
Table table = _db.SelectRecords(filterExpGrp);
displayRecords(table);
// we can manually build the same FilterExpressionGroup
var lnameExp = new FilterExpression("LastName", "Fuller", EqualityEnum.Equal, MatchTypeEnum.UseCase);
var fname1Exp = new FilterExpression("FirstName", "steven", EqualityEnum.Equal, MatchTypeEnum.IgnoreCase);
// the following two lines produce the same FilterExpression
var fname2Exp = FilterExpression.Parse("FirstName LIKE 'NANCY'");
fname2Exp = new FilterExpression("FirstName", "NANCY", EqualityEnum.Like);
var fnamesGrp = new FilterExpressionGroup();
fnamesGrp.Add(BoolOpEnum.Or, fname1Exp);
fnamesGrp.Add(BoolOpEnum.Or, fname2Exp);
var allNamesGrp = new FilterExpressionGroup();
allNamesGrp.Add(BoolOpEnum.And, lnameExp);
allNamesGrp.Add(BoolOpEnum.And, fnamesGrp);
table = _db.SelectRecords(allNamesGrp);
displayRecords(table);
// or just pass the string expression directly
table = _db.SelectRecords(filter);
displayRecords(table);
// get the same records again as a typed list using your own custom class
IList <Person> persons = _db.SelectRecords <Person>(filter);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void BtnUpdateMatchingRecords_Click(object sender, RoutedEventArgs e)
{
try
{
string filter = "(~FirstName = 'andrew' OR ~FirstName = 'nancy') AND ~LastName = 'fuller'";
FilterExpressionGroup filterExpGrp = FilterExpressionGroup.Parse(filter);
Table table = _db.SelectRecords(filterExpGrp);
displayRecords(table);
// equivalent building it manually
var fname1Exp = new FilterExpression("FirstName", "andrew", EqualityEnum.Equal, MatchTypeEnum.IgnoreCase);
// the following two lines produce the same FilterExpression
var fname2Exp = FilterExpression.Parse("~FirstName = nancy");
fname2Exp = new FilterExpression("FirstName", "nancy", EqualityEnum.Equal, MatchTypeEnum.IgnoreCase);
var lnameExp = new FilterExpression("LastName", "fuller", EqualityEnum.Equal, MatchTypeEnum.IgnoreCase);
var fnamesGrp = new FilterExpressionGroup();
fnamesGrp.Add(BoolOpEnum.Or, fname1Exp);
fnamesGrp.Add(BoolOpEnum.Or, fname2Exp);
var allNamesGrp = new FilterExpressionGroup();
allNamesGrp.Add(BoolOpEnum.And, lnameExp);
allNamesGrp.Add(BoolOpEnum.And, fnamesGrp);
var fieldValues = new FieldValues();
fieldValues.Add("IsCitizen", false);
int nRecs = _db.UpdateRecords(allNamesGrp, fieldValues);
table = _db.SelectRecords(allNamesGrp);
displayRecords(table);
// or easiest of all use the filter string directly
table = _db.SelectRecords(filter);
displayRecords(table);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void BtnRemoveByKey_Click( object sender, RoutedEventArgs e )
{
try
{
var exp1 = new FilterExpression( "FirstName", "Nancy", EqualityEnum.Equal, MatchTypeEnum.IgnoreCase );
var exp2 = new FilterExpression( "LastName", "Leverling", EqualityEnum.Equal, MatchTypeEnum.IgnoreCase );
var expGrp = new FilterExpressionGroup();
expGrp.Add( BoolOpEnum.Or, exp1 );
expGrp.Add( BoolOpEnum.Or, exp2 );
FileDbNs.Table table = _db.SelectRecords( expGrp, new string[] { "ID" } );
foreach( Record record in table )
{
int id = (int) record["ID"];
bool bRet = _db.DeleteRecordByKey( id );
}
}
catch( Exception ex )
{
MessageBox.Show( ex.Message );
}
}
private void RemoveByValue2_Click( object sender, RoutedEventArgs e )
{
try
{
var lnameExp = new FilterExpression( "LastName", "peacock", EqualityEnum.Equal, MatchTypeEnum.IgnoreCase );
var fname1Exp = new FilterExpression( "FirstName", "nancy", EqualityEnum.Equal, MatchTypeEnum.IgnoreCase );
var allNamesGrp = new FilterExpressionGroup();
allNamesGrp.Add( BoolOpEnum.Or, lnameExp );
allNamesGrp.Add( BoolOpEnum.Or, fname1Exp );
// equivalent using parser
string filter = "~LastName = 'peacock' OR ~FirstName = 'nancy'";
allNamesGrp = FilterExpressionGroup.Parse( filter );
int numDeleted = _db.DeleteRecords( allNamesGrp );
// or just call _db.DeleteMatchingRecords( filter );
}
catch( Exception ex )
{
MessageBox.Show( ex.Message );
}
}
private void BtnUpdateMatchingRecords_Click( object sender, RoutedEventArgs e )
{
try
{
string filter = "(~FirstName = 'andrew' OR ~FirstName = 'nancy') AND ~LastName = 'fuller'";
FilterExpressionGroup filterExpGrp = FilterExpressionGroup.Parse( filter );
FileDbNs.Table table = _db.SelectRecords( filterExpGrp );
displayRecords( table );
// equivalent building it manually
var fname1Exp = new FilterExpression( "FirstName", "andrew", EqualityEnum.Equal, MatchTypeEnum.IgnoreCase );
// the following lines produce the same FilterExpression
var fname2Exp = FilterExpression.Parse( "~FirstName = nancy" );
fname2Exp = new FilterExpression( "FirstName", "nancy", EqualityEnum.Equal, MatchTypeEnum.IgnoreCase );
var lnameExp = new FilterExpression( "LastName", "fuller", EqualityEnum.Equal, MatchTypeEnum.IgnoreCase );
var fnamesGrp = new FilterExpressionGroup();
fnamesGrp.Add( BoolOpEnum.Or, fname1Exp );
fnamesGrp.Add( BoolOpEnum.Or, fname2Exp );
var allNamesGrp = new FilterExpressionGroup();
allNamesGrp.Add( BoolOpEnum.And, lnameExp );
allNamesGrp.Add( BoolOpEnum.And, fnamesGrp );
table = _db.SelectRecords( allNamesGrp );
displayRecords( table );
// now update the matching Record
var fieldValues = new FieldValues();
fieldValues.Add( "IsCitizen", false );
int nRecs = _db.UpdateRecords( allNamesGrp, fieldValues );
table = _db.SelectRecords( allNamesGrp );
displayRecords( table );
// or easiest of all use the filter string directly
table = _db.SelectRecords( filter );
displayRecords( table );
}
catch( Exception ex )
{
MessageBox.Show( ex.Message );
}
}
private void BtnGetMatchingRecords_Click( object sender, RoutedEventArgs e )
{
try
{
// Use the FilterExpressionGroup's filter parser to create a FilterExpressionGroup
// The syntax is similar to SQL (do not preceed with WHERE)
// Note that we prefix the fieldname with ~ to get a case-INSENSITIVE search
// (FileDb doesn't currently support UPPER or LOWER)
// Note that we can also use LIKE when we want to ignore case, but the difference
// is that LIKE will create a RegEx search which would be a little slower
// Note also that each set of parentheses will create a child FilterExpressionGroup
string filter = "(~FirstName = 'steven' OR [FirstName] LIKE 'NANCY') AND LastName = 'Fuller'";
FilterExpressionGroup filterExpGrp = FilterExpressionGroup.Parse( filter );
FileDbNs.Table table = _db.SelectRecords( filterExpGrp );
displayRecords( table );
// we can manually build the same FilterExpressionGroup
var fname1Exp = new FilterExpression( "FirstName", "steven", EqualityEnum.Equal, MatchTypeEnum.IgnoreCase );
// the following two lines produce the same FilterExpression
var fname2Exp = FilterExpression.Parse( "FirstName LIKE 'NANCY'" );
fname2Exp = new FilterExpression( "FirstName", "NANCY", EqualityEnum.Like );
var lnameExp = new FilterExpression( "LastName", "Fuller", EqualityEnum.Equal, MatchTypeEnum.UseCase );
var fnamesGrp = new FilterExpressionGroup();
fnamesGrp.Add( BoolOpEnum.Or, fname1Exp );
fnamesGrp.Add( BoolOpEnum.Or, fname2Exp );
var allNamesGrp = new FilterExpressionGroup();
allNamesGrp.Add( BoolOpEnum.And, lnameExp );
allNamesGrp.Add( BoolOpEnum.And, fnamesGrp );
table = _db.SelectRecords( allNamesGrp );
displayRecords( table );
// or just pass the string expression directly
table = _db.SelectRecords( filter );
displayRecords( table );
// get the same records again as a typed list using your own custom class
IList<Person> persons = _db.SelectRecords<Person>( filter );
grid.Columns.Clear();
grid.ItemsSource = persons;
}
catch( Exception ex )
{
MessageBox.Show( ex.Message );
}
}