public bool FilerRecords(object o)
{
double res;
bool checkNumeric = double.TryParse(FilterText, out res);
var item = o as OrderInfo;
if (item != null && FilterText.Equals(""))
{
return(true);
}
else
{
if (item != null)
{
if (checkNumeric && !FilterOption.Equals("All Columns") && !FilterOption.Equals("OrderDate"))
{
if (FilterCondition == null || FilterCondition.Equals("Contains") || FilterCondition.Equals("StartsWith") || FilterCondition.Equals("EndsWith"))
{
FilterCondition = "Equals";
}
bool result = MakeNumericFilter(item, FilterOption, FilterCondition);
return(result);
}
else if (FilterOption.Equals("All Columns"))
{
if (item.OrderID.ToString().Contains(FilterText) ||
item.CustomerID.ToLower().Contains(FilterText.ToLower()) ||
item.ProductName.ToLower().Contains(FilterText.ToLower()) || item.Quantity.ToString().Contains(FilterText) ||
item.ShipCountry.ToLower().Contains(FilterText.ToLower()) ||
item.ContactNumber.ToString().Contains(FilterText) ||
item.UnitPrice.ToString().Contains(FilterText) ||
item.OrderDate.ToString().Contains(FilterText))
{
return(true);
}
return(false);
}
else if (FilterOption.Equals("OrderDate"))
{
if (FilterCondition == null || FilterCondition.Equals("Contains") || FilterCondition.Equals("StartsWith") || FilterCondition.Equals("EndsWith"))
{
FilterCondition = "Equals";
}
bool result = MakeDateFilter(item, FilterOption, FilterCondition);
return(result);
}
else
{
if (FilterCondition == null || FilterCondition.Equals("Equals") || FilterCondition.Equals("LessThan") || FilterCondition.Equals("GreaterThan") || FilterCondition.Equals("NotEquals"))
{
FilterCondition = "Contains";
}
bool result = MakeStringFilter(item, FilterOption, FilterCondition);
return(result);
}
}
}
return(false);
}
public async Task <bool> CheckAndCommit(char insertedChar)
{
CompletionItem item = CompletionListControl.Items[CompletionListControl.SelectedIndex].item;
List <char> commitCharacters = new List <char>(CompletionList.Rules.DefaultCommitCharacters);
foreach (CharacterSetModificationRule rule in item.Rules.CommitCharacterRules)
{
if (rule.Kind == CharacterSetModificationKind.Add)
{
commitCharacters.AddRange(rule.Characters);
}
else if (rule.Kind == CharacterSetModificationKind.Remove)
{
foreach (char c in rule.Characters)
{
commitCharacters.Remove(c);
}
}
else if (rule.Kind == CharacterSetModificationKind.Replace)
{
commitCharacters = new List <char>(rule.Characters);
}
}
if (commitCharacters.Contains(insertedChar) || insertedChar == '\n' || insertedChar == '\r')
{
await Commit(item);
}
bool tbr = false;
if (insertedChar == '\n' || insertedChar == '\r')
{
EnterKeyRule enterRule = item.Rules.EnterKeyRule;
if (enterRule == EnterKeyRule.Default)
{
enterRule = CompletionList.Rules.DefaultEnterKeyRule;
}
switch (enterRule)
{
case EnterKeyRule.Always:
tbr = false;
break;
case EnterKeyRule.Never:
tbr = true;
break;
case EnterKeyRule.AfterFullyTypedWord:
tbr = FilterText.Equals(item.DisplayText, StringComparison.OrdinalIgnoreCase);
break;
}
}
return(tbr);
}
public bool FilerRecords(object o)
{
double res;
bool checkNumeric = double.TryParse(FilterText, out res);
var item = o as Employee;
if (item != null && FilterText.Equals(""))
{
return(true);
}
else
{
if (item != null)
{
if (checkNumeric && FilterOption.Equals("ContactNumber"))
{
if (FilterCondition == null || FilterCondition.Equals("Equals") || FilterCondition.Equals("LessThan") || FilterCondition.Equals("GreaterThan") || FilterCondition.Equals("NotEquals"))
{
FilterCondition = "Contains";
}
bool result = MakeStringFilter(item, FilterOption, FilterCondition);
return(result);
}
else if (checkNumeric && !FilterOption.Equals("AllColumns"))
{
if (FilterCondition == null || FilterCondition.Equals("Contains") || FilterCondition.Equals("StartsWith") || FilterCondition.Equals("EndsWith"))
{
FilterCondition = "Equals";
}
bool result = MakeNumericFilter(item, FilterOption, FilterCondition);
return(result);
}
else if (FilterOption.Equals("AllColumns"))
{
if (item.FirstName.ToLower().Contains(FilterText.ToLower()) ||
item.LastName.ToLower().Contains(FilterText.ToLower()) || item.City.ToLower().Contains(FilterText.ToLower()) ||
item.Salary.ToString().ToLower().Contains(FilterText.ToLower()) || item.EmployeeID.ToString().ToLower().Contains(FilterText.ToLower()) ||
item.ContactNumber.ToLower().Contains(FilterText.ToLower()))
{
return(true);
}
return(false);
}
else
{
if (FilterCondition == null || FilterCondition.Equals("Equals") || FilterCondition.Equals("LessThan") || FilterCondition.Equals("GreaterThan") || FilterCondition.Equals("NotEquals"))
{
FilterCondition = "Contains";
}
bool result = MakeStringFilter(item, FilterOption, FilterCondition);
return(result);
}
}
}
return(false);
}
private bool UserFilter(object obj)
{
if (FilterText == null)
{
return(true);
}
if (FilterText.Equals(""))
{
return(true);
}
User user = obj as User;
return(user.UserName.ToLower().StartsWith(FilterText.ToLower()));
}
/// <summary>
/// Filter the items based on the filter option
/// </summary>
/// <param name="o">Item to check for filter</param>
/// <returns>Wheter the item can comes under filtered items or not</returns>
public bool FilterRecords(object o)
{
var item = o as OrderInfo;
if (item != null && FilterText.Equals(""))
{
return(true);
}
else
{
if (item != null)
{
if (FilterProperty.Equals("All Columns"))
{
if (item.OrderID.ToString().Contains(FilterText) ||
item.CustomerID.ToLower().Contains(FilterText.ToLower()) || item.ContactNumber.ToString().Contains(FilterText.ToLower()) ||
item.ProductName.ToString().ToLower().Contains(FilterText.ToLower()) || item.Quantity.ToString().ToLower().Contains(FilterText.ToLower()) ||
item.ShipCountry.ToString().ToLower().Contains(FilterText.ToLower()) ||
item.OrderDate.ToString().ToLower().Contains(FilterText.ToLower()))
{
return(true);
}
return(false);
}
else
{
if (FilterColumn == null || FilterColumn.Equals("Contains"))
{
FilterColumn = "Contains";
}
else if (FilterColumn.Equals("StartsWith"))
{
FilterColumn = "StartsWith";
}
else if (FilterColumn.Equals("EndsWith"))
{
FilterColumn = "EndsWith";
}
bool result = MakeStringFilter(item, FilterProperty, FilterColumn);
return(result);
}
}
}
return(false);
}
public bool FilerRecords(object o)
{
double res;
bool checkNumeric = double.TryParse(FilterText, out res);
var item = o as BookInfo;
if (item != null && FilterText.Equals(""))
{
return(true);
}
else
{
if (item != null)
{
if (checkNumeric && !SelectedColumn.Equals("All Columns") && SelectedCondition != "Contains")
{
bool result = MakeNumericFilter(item, SelectedColumn, SelectedCondition);
return(result);
}
else if (SelectedColumn.Equals("All Columns"))
{
if (item.BookName.ToLower().Contains(FilterText.ToLower()) ||
item.Country.ToLower().Contains(FilterText.ToLower()) ||
item.FirstName.ToString().ToLower().Contains(FilterText.ToLower()) ||
item.LastName.ToString().ToLower().Contains(FilterText.ToLower()) ||
item.CustomerID.ToString().ToLower().Contains(FilterText.ToLower()) ||
item.Price.ToString().ToLower().Contains(FilterText.ToLower()) ||
item.BookID.ToString().ToLower().Contains(FilterText.ToLower()))
{
return(true);
}
return(false);
}
else
{
// if (SelectedCondition == null || SelectedCondition.Equals("NotEquals") || SelectedCondition.Equals("Equals"))
// SelectedCondition = "Contains";
bool result = MakeStringFilter(item, SelectedColumn, SelectedCondition);
return(result);
}
}
}
return(false);
}
public bool FilerRecords(object o)
{
double res;
bool checkNumeric = double.TryParse(FilterText, out res);
var item = o as zt_inventarios_conteos;
if (item != null && FilterText.Equals(""))
{
return(true);
}
else
{
if (item != null)
{
if (checkNumeric && !SelectedColumn.Equals("All Columns"))
{
bool result = MakeNumericFilter(item, SelectedColumn, SelectedCondition);
return(result);
}
else if (SelectedColumn.Equals("All Columns"))
{
if (item.Id.ToString().ToLower().Contains(FilterText.ToLower()) ||
item.SKU.ToLower().Contains(FilterText.ToLower()) ||
item.IdInventario.ToLower().Contains(FilterText.ToLower()) ||
item.IdAlmacen.ToLower().Contains(FilterText.ToLower()) ||
item.IdUbicacion.ToLower().Contains(FilterText.ToLower()) ||
item.Material.ToLower().Contains(FilterText.ToLower()) ||
item.CantFisica.ToString().ToLower().Contains(FilterText.ToLower()))
{
return(true);
}
return(false);
}
else
{
bool result = MakeStringFilter(item, SelectedColumn, SelectedCondition);
return(result);
}
}
}
return(false);
}
public bool FilerRecords(object o)
{
double res;
bool checkNumeric = double.TryParse(FilterText, out res);
var item = o as OrderInfo;
if (item != null && FilterText.Equals(""))
{
return(true);
}
else
{
if (item != null)
{
if (checkNumeric && !SelectedColumn.Equals("All Columns"))
{
bool result = MakeNumericFilter(item, SelectedColumn, SelectedCondition);
return(result);
}
else if (SelectedColumn.Equals("All Columns"))
{
//if (item.CustomerID.ToString().ToLower().Contains(FilterText.ToLower()) ||
// item.ShipCountry.ToLower().Contains(FilterText.ToLower()) ||
// item.ShipCity.ToString().ToLower().Contains(FilterText.ToLower()) ||
// item.CustomerName.ToString().ToLower().Contains(FilterText.ToLower()) ||
// item.OrderId.ToString().ToLower().Contains(FilterText.ToLower()))
if (item.CustomerName.ToString().ToLower().Contains(FilterText.ToLower()))
{
return(true);
}
return(false);
}
else
{
bool result = MakeStringFilter(item, SelectedColumn, SelectedCondition);
return(result);
}
}
}
return(false);
}
public bool FilerRecords(object o)
{
double res;
bool checkNumeric = double.TryParse(FilterText, out res);
var item = o as ItemList;
if (item != null && FilterText.Equals("") && !string.IsNullOrEmpty(FilterText))
{
return(true);
}
else
{
if (item != null)
{
if (checkNumeric && !SelectedColumn.Equals("All Columns") && !SelectedCondition.Equals("Contains"))
{
bool result = MakeNumericFilter(item, SelectedColumn, SelectedCondition);
return(result);
}
else if (SelectedColumn.Equals("All Columns"))
{
if (item.CustomerID.ToLower().Contains(FilterText.ToLower()) ||
item.OrderID.ToString().ToLower().Contains(FilterText.ToLower()) ||
item.Freight.ToLower().Contains(FilterText.ToLower()) ||
item.Country.ToLower().Contains(FilterText.ToLower()))
{
return(true);
}
return(false);
}
else
{
bool result = MakeStringFilter(item, SelectedColumn, SelectedCondition);
return(result);
}
}
}
return(false);
}
public bool FilerRecords(object o)
{
double res;
bool checkNumeric = double.TryParse(FilterText, out res);
var item = o as Eva_cat_fuentes_bibliograficas;
if (item != null && FilterText.Equals(""))
{
return(true);
}
else
{
if (item != null)
{
if (checkNumeric && !SelectedColumn.Equals("All Columns"))
{
bool result = MakeNumericFilter(item, SelectedColumn, SelectedCondition);
return(result);
}
else if (SelectedColumn.Equals("All Columns"))
{
if (item.IdFuente.ToString().ToLower().Contains(FilterText.ToLower()) ||
item.NombreFuente.ToLower().Contains(FilterText.ToLower()) ||
item.Autor.ToLower().Contains(FilterText.ToLower()) ||
item.Editorial.ToLower().Contains(FilterText.ToLower()))
{
return(true);
}
return(false);
}
else
{
bool result = MakeStringFilter(item, SelectedColumn, SelectedCondition);
return(result);
}
}
}
return(false);
}
public bool FilerRecords(object o)
{
double res;
bool checkNumeric = double.TryParse(FilterText, out res);
var item = o as Eva_cat_apoyos_didacticos;
if (item != null && FilterText.Equals(""))
{
return(true);
}
else
{
if (item != null)
{
if (checkNumeric && !SelectedColumn.Equals("All Columns"))
{
bool result = MakeNumericFilter(item, SelectedColumn, SelectedCondition);
return(result);
}
else if (SelectedColumn.Equals("All Columns"))
{
if (item.IdApoyoDidactico.ToString().ToLower().Contains(FilterText.ToLower()) ||
item.DesApoyoDidactico.ToLower().Contains(FilterText.ToLower()) ||
item.Activo.ToString().ToLower().Contains(FilterText.ToLower()))
{
return(true);
}
return(false);
}
else
{
bool result = MakeStringFilter(item, SelectedColumn, SelectedCondition);
return(result);
}
}
}
return(false);
}
public bool FilerRecords(object o)
{
double res;
bool checkNumeric = double.TryParse(FilterText, out res);
var item = o as Eva_planeacion_temas;
if (item != null && FilterText.Equals(""))
{
return(true);
}
else
{
if (item != null)
{
if (checkNumeric && !SelectedColumn.Equals("All Columns"))
{
bool result = MakeNumericFilter(item, SelectedColumn, SelectedCondition);
return(result);
}
else if (SelectedColumn.Equals("All Columns"))
{
if (item.IdTema.ToString().ToLower().Contains(FilterText.ToLower()) ||
item.DesTema.ToLower().Contains(FilterText.ToLower()) ||
item.Observaciones.ToLower().Contains(FilterText.ToLower()))
{
return(true);
}
return(false);
}
else
{
bool result = MakeStringFilter(item, SelectedColumn, SelectedCondition);
return(result);
}
}
}
return(false);
}
public bool Equals(IdentifyingInfo other) => other != null && Id.Equals(other.Id) && FilterText.Equals(other.FilterText) && Name.Equals(other.Name);
/// <summary>
/// Populates the list of filter vars with those that match the VarNames found in the provided list of questions.
/// </summary>
/// <param name="questions"></param>
private void GetFilterVars(List <SurveyQuestion> questions)
{
string filterVar;
int filterVarPos = 0;
int filterVarLen;
string filterExp; // the filter expression of the variable e.g. [varname]=1, 2, 8 or 9.
string[] filterOptionsList;
string options;
Regex rx;
MatchCollection results;
while (!FilterText.Equals(""))
{
FilterVar fv;
foreach (SurveyQuestion q in questions)
{
filterVar = q.VarName.RefVarName;
if (!FilterText.Contains(filterVar))
{
continue;
}
rx = new Regex(filterVar + "(=|<|>|<>)" +
"(([0-9]+(,\\s[0-9]+)+\\sor\\s[0-9]+)" +
"|([0-9]+\\sor\\s[0-9]+)" +
"|([0-9]+\\-[0-9]+)" +
"|([0-9]+))");
filterVarPos = FilterText.IndexOf(filterVar);
filterVarLen = filterVar.Length;
results = rx.Matches(FilterText);
if (results.Count > 0)
{
filterExp = results[0].Value;
options = filterExp.Substring(filterVarLen + 1);
options = Regex.Replace(options, "[^0-9 <->]", "");
filterOptionsList = GetOptionList(options).Split(' ');
fv = new FilterVar();
fv.Varname = filterVar;
if (filterOptionsList.Length != 0)
{
fv.ResponseCodes = filterOptionsList.Select(Int32.Parse).ToList();
}
// add to the list of filter vars if it is not already there
if (!FilterVars.Contains(fv))
{
FilterVars.Add(fv);
}
}
else
{
filterVarPos = 0;
continue;
}
filterVarPos = 0;
// trim the filterText to the point after this VarName
FilterText = FilterText.Substring(filterVarPos + filterVarLen);
}
if (filterVarPos == 0)
{
break;
}
}
}
