private void LoadFilters()
{
var currencyListJs = _context.Currencies.OrderBy(p => p.Name).AsNoTracking().ToList();
ViewData["CurrencyListJs"] = currencyListJs;
var companiesListJs = FiltersHelper.GetCompaniesFilterList(_context);
ViewData["CompanyListJs"] = companiesListJs;
var datePeriodListJs = DateFilter.GetDateFiltersSelectList();
ViewData["DatePeriodListJs"] = datePeriodListJs;
}
private void treeView1_DragDrop(object sender, DragEventArgs e)
{
object typeGuid = e.Data.GetData(typeof(Guid));
if (typeGuid == null)
{
return;
}
var filterType = FiltersHelper.GetFilterType((Guid)typeGuid);
var filter = (IFilter)filterType.Assembly.CreateInstance(filterType.FullName);
graphControl1.AddFilter(filter);
}
private void LoadCombos()
{
List <SelectListItem> seekTypes = new List <SelectListItem>
{
new SelectListItem()
{
Value = "NAME", Text = "Name"
},
new SelectListItem()
{
Value = "CODE", Text = "Code"
},
new SelectListItem()
{
Value = "BARCODE", Text = "Barcode"
}
};
ViewData["SeekType"] = new SelectList(seekTypes, "Value", "Text");
var docTypes = Enum.GetValues(typeof(RecurringDocTypeEnum))
.Cast <RecurringDocTypeEnum>()
.Select(c => new SelectListItem()
{
Value = c.ToString(),
Text = c.GetDescription()
}).ToList();
ViewData["DocType"] = new SelectList(docTypes, "Value", "Text");
ViewData["RecurringFrequency"] = FiltersHelper.GetRecurringFrequencyList();
ViewData["CompanyId"] = new SelectList(_context.Companies.OrderBy(p => p.Code).AsNoTracking(), "Id", "Code");
ViewData["PaymentMethodId"] = new SelectList(_context.PaymentMethods.OrderBy(p => p.Name).AsNoTracking(), "Id", "Name");
IQueryable transactorList;
IQueryable docTypeList;
if (CreateFromType == RecurringDocTypeEnum.BuyType)
{
transactorList = _context.Transactors.Where(s => s.TransactorType.Code == "SYS.SUPPLIER").OrderBy(s => s.Name).AsNoTracking();
docTypeList = _context.BuyDocSeriesDefs.OrderBy(p => p.Name).AsNoTracking();
}
else
{
transactorList = _context.Transactors.Where(s => s.TransactorType.Code == "SYS.CUSTOMER" || s.TransactorType.Code == "SYS.DEPARTMENT").OrderBy(s => s.Name).AsNoTracking();
docTypeList = _context.SellDocSeriesDefs.OrderBy(p => p.Name).AsNoTracking();
}
ViewData["TransactorId"] = new SelectList(transactorList, "Id", "Name");
ViewData["DocSeriesId"] = new SelectList(docTypeList, "Id", "Name");
}
public SetFilterValueViewModel()
{
filtersDictionary = FiltersHelper.GetFiltersObjects().ToDictionary(x => x.Filter, x => x.Description);
SaveCommand = ReactiveCommand.Create(() =>
{
OnSaveAction?.Invoke();
FinishInteraction?.Invoke();
});
CancelCommand = ReactiveCommand.Create(() =>
{
OnCancelAction?.Invoke();
FinishInteraction?.Invoke();
});
}
private void LoadFilters()
{
var datePeriods = DateFilter.GetDateFiltersSelectList();
ViewData["DataFilterValues"] = new SelectList(datePeriods, "Value", "Text");
var pageFilterSize = PageFilter.GetPageSizeFiltersSelectList();
ViewData["PageFilterSize"] = new SelectList(pageFilterSize, "Value", "Text");
var companiesList = FiltersHelper.GetCompaniesFilterList(_context);
ViewData["CompanyFilter"] = new SelectList(companiesList, "Value", "Text");
ViewData["CurrencySelector"] = new SelectList(FiltersHelper.GetCurrenciesFilterList(_context), "Value", "Text");
var currencyListJs = _context.Currencies.OrderBy(p => p.Id).AsNoTracking().ToList();
ViewData["CurrencyListJs"] = currencyListJs;
}
/// <summary>
/// Determine if the given user match the defined filters/rules.
/// If that's the case, the UI should display the define color.
///
/// Comparison can be currently done on : double, string.
/// You can then compare with the name, the company name, the age...
/// The following ones could be added in a future version : bool, datetime
/// </summary>
/// <returns>Returns the hexadecimal code, null if there is no filter that match.</returns>
public string DetermineColorForCard(List <EventFieldUserSet> currentUser)
{
string hexaDecimalToReturn = null;
for (int i = 0; i < currentUser.Count; i++)
{
string fieldName = currentUser[i].EventFieldSet.FieldSet.Name;
string fieldValue = currentUser[i].Value;
// Determine the type (numbers and characters are take over)
Regex numbersRegex = new Regex(@"^[0-9]+$", RegexOptions.Compiled | RegexOptions.IgnoreCase);
if (numbersRegex.IsMatch(fieldValue))
{
// Type = NUMBERS
List <FilterSet> relevantFilters = _dbEntities.GetAllFilters(IdEvent)
.Where(f => FiltersHelper.LogicalOperatorsForNumbers.Contains(f.LogicalOperator) &&
f.EventFieldSet.FieldSet.Name.Equals(fieldName))
.ToList();
foreach (FilterSet filter in relevantFilters)
{
if (FiltersHelper.Evaluate(Convert.ToDouble(fieldValue), Convert.ToDouble(filter.Value), filter.LogicalOperator))
{
// There is a MATCH - check if a rule is defined for "Window" target
return(RetrieveWindowColor(filter.ID_Filter));
}
}
}
else
{
// Type = CHARACTERS
List <FilterSet> relevantFilters = _dbEntities.GetAllFilters(IdEvent)
.Where(f => FiltersHelper.LogicalOperatorsForCharacters.Contains(f.LogicalOperator) &&
f.EventFieldSet.FieldSet.Name.Equals(fieldName))
.ToList();
foreach (FilterSet filter in relevantFilters)
{
if (FiltersHelper.Evaluate(fieldValue, filter.Value, filter.LogicalOperator))
{
// There is a MATCH - check if a rule is defined for "Window" target
return(RetrieveWindowColor(filter.ID_Filter));
}
}
}
}
return(hexaDecimalToReturn);
}
private void LoadFilters()
{
var materialNatures = FiltersHelper.GetWarehouseItemNaturesList();
ViewData["MaterialNatureValues"] = new SelectList(materialNatures, "Value", "Text");
var companiesList = FiltersHelper.GetCompaniesFilterList(_context);
ViewData["CompanyFilter"] = new SelectList(companiesList, "Value", "Text");
var pageFilterSize = PageFilter.GetPageSizeFiltersSelectList();
ViewData["PageFilterSize"] = new SelectList(pageFilterSize, "Value", "Text");
ViewData["CurrencySelector"] = new SelectList(FiltersHelper.GetCurrenciesFilterList(_context), "Value", "Text");
var currencyListJs = _context.Currencies.OrderBy(p => p.Id).AsNoTracking().ToList();
ViewData["CurrencyListJs"] = currencyListJs;
}
private void LoadFilters()
{
var materialNatures = FiltersHelper.GetWarehouseItemNaturesList();
ViewData["MaterialNatureValues"] = new SelectList(materialNatures, "Value", "Text");
var pageFilterSize = PageFilter.GetPageSizeFiltersSelectList();
ViewData["PageFilterSize"] = new SelectList(pageFilterSize, "Value", "Text");
//var dbCompanies = _context.Companies.OrderBy(p => p.Code).AsNoTracking();
//List<SelectListItem> companiesList = new List<SelectListItem>();
//companiesList.Add(new SelectListItem() { Value = 0.ToString(), Text = "{All Companies}" });
//foreach (var company in dbCompanies)
//{
// companiesList.Add(new SelectListItem() { Value = company.Id.ToString(), Text = company.Code });
//}
var companiesList = FiltersHelper.GetCompaniesFilterList(_context);
ViewData["CompanyFilter"] = new SelectList(companiesList, "Value", "Text");
}
private async Task LoadCombos()
{
List <SelectListItem> codeTypes = new List <SelectListItem>
{
new SelectListItem()
{
Value = WarehouseItemCodeTypeEnum.CodeTypeEnumCode.ToString(), Text = "Code"
},
new SelectListItem()
{
Value = WarehouseItemCodeTypeEnum.CodeTypeEnumBarcode.ToString(), Text = "Barcode"
},
new SelectListItem()
{
Value = WarehouseItemCodeTypeEnum.CodeTypeEnumSupplierCode.ToString(), Text = "Supplier Code"
}
};
ViewData["CodeType"] = new SelectList(codeTypes, "Value", "Text");
List <SelectListItem> codeUsedUnits = new List <SelectListItem>
{
new SelectListItem()
{
Value = WarehouseItemCodeUsedUnitEnum.CodeUsedUnitEnumMain.ToString(), Text = "Main Unit"
},
new SelectListItem()
{
Value = WarehouseItemCodeUsedUnitEnum.CodeUsedUnitEnumBuy.ToString(), Text = "Buy Unit"
},
new SelectListItem()
{
Value = WarehouseItemCodeUsedUnitEnum.CodeUsedUnitEnumSecondary.ToString(), Text = "Secondary Unit"
}
};
ViewData["CodeUsedUnit"] = new SelectList(codeUsedUnits, "Value", "Text");
ViewData["WarehouseItemId"] = new SelectList(_context.WarehouseItems.OrderBy(p => p.Name).AsNoTracking(), "Id", "Name");
//ViewData["CompanyId"] = FiltersHelper.GetCompaniesFilterList(_context);
ViewData["CompanyId"] = new SelectList(_context.Companies.OrderBy(p => p.Code).AsNoTracking(), "Id", "Code");
ViewData["TransactorId"] = await FiltersHelper.GetTransactorsForTypeFilterListAsync(_context, "SYS.SUPPLIER");
}
private void LoadFilters()
{
var materialNatures = FiltersHelper.GetWarehouseItemNaturesList();
//List<SelectListItem> materialNatures = new List<SelectListItem>
//{
// new SelectListItem() {Value = "0", Text = "{All Natures}"},
// new SelectListItem() {Value = WarehouseItemNatureEnum.WarehouseItemNatureMaterial.ToString(), Text = "Υλικό"},
// new SelectListItem() {Value = WarehouseItemNatureEnum.WarehouseItemNatureService.ToString(), Text = "Υπηρεσία"},
// new SelectListItem() {Value = WarehouseItemNatureEnum.WarehouseItemNatureExpense.ToString(), Text = "Δαπάνη"},
// new SelectListItem() {Value = WarehouseItemNatureEnum.WarehouseItemNatureFixedAsset.ToString(), Text = "Πάγιο"}
//};
ViewData["MaterialNatureValues"] = new SelectList(materialNatures, "Value", "Text");
var pageFilterSize = PageFilter.GetPageSizeFiltersSelectList();
ViewData["PageFilterSize"] = new SelectList(pageFilterSize, "Value", "Text");
}
private void LoadCombos()
{
var financialActions = FiltersHelper.GetFinancialActionsList();
ViewData["FinancialActions"] = new SelectList(financialActions, "Value", "Text");
ViewData["CompanyId"] = new SelectList(_context.Companies.OrderBy(p => p.Code).AsNoTracking(), "Id", "Code");
var dbSeriesList = _context.TransTransactorDocSeriesDefs.OrderBy(p => p.Name).AsNoTracking();
List <SelectListItem> seriesList = new List <SelectListItem>();
seriesList.Add(new SelectListItem()
{
Value = 0.ToString(), Text = "{No Default series}"
});
foreach (var dbSeriesItem in dbSeriesList)
{
seriesList.Add(new SelectListItem()
{
Value = dbSeriesItem.Id.ToString(), Text = dbSeriesItem.Name
});
}
ViewData["DefaultDocSeriesId"] = new SelectList(seriesList, "Value", "Text");
}
private void LoadCombos()
{
List <SelectListItem> seekTypes = new List <SelectListItem>
{
new SelectListItem()
{
Value = "NAME", Text = "Name"
},
new SelectListItem()
{
Value = "CODE", Text = "Code"
},
new SelectListItem()
{
Value = "BARCODE", Text = "Barcode"
}
};
ViewData["SeekType"] = new SelectList(seekTypes, "Value", "Text");
var docTypes = Enum.GetValues(typeof(RecurringDocTypeEnum))
.Cast <RecurringDocTypeEnum>()
.Select(c => new SelectListItem()
{
Value = c.ToString(),
Text = c.GetDescription()
}).ToList();
ViewData["DocType"] = new SelectList(docTypes, "Value", "Text");
ViewData["RecurringFrequency"] = FiltersHelper.GetRecurringFrequencyList();
ViewData["CompanyId"] = new SelectList(_context.Companies.OrderBy(p => p.Code).AsNoTracking(), "Id", "Code");
ViewData["PaymentMethodId"] = new SelectList(_context.PaymentMethods.OrderBy(p => p.Name).AsNoTracking(), "Id", "Name");
IQueryable transactorList;
IQueryable docTypeList;
switch (ItemVm.RecurringDocType)
{
case RecurringDocTypeEnum.BuyType:
transactorList = _context.Transactors.Where(s => s.TransactorType.Code == "SYS.SUPPLIER").OrderBy(s => s.Name).AsNoTracking();
docTypeList = _context.BuyDocSeriesDefs.OrderBy(p => p.Name).AsNoTracking();
ViewData["TransactorId"] = new SelectList(transactorList, "Id", "Name");
ViewData["DocSeriesId"] = new SelectList(docTypeList, "Id", "Name");
break;
case RecurringDocTypeEnum.SellType:
transactorList = _context.Transactors.Where(s => s.TransactorType.Code == "SYS.CUSTOMER" || s.TransactorType.Code == "SYS.DEPARTMENT").OrderBy(s => s.Name).AsNoTracking();
docTypeList = _context.SellDocSeriesDefs.OrderBy(p => p.Name).AsNoTracking();
ViewData["TransactorId"] = new SelectList(transactorList, "Id", "Name");
ViewData["DocSeriesId"] = new SelectList(docTypeList, "Id", "Name");
break;
default:
break;
}
var buyDocSeriesListJs = _context.BuyDocSeriesDefs.OrderBy(p => p.Name)
.Select(p => new SelectListItem()
{
Text = p.Name,
Value = p.Id.ToString()
}).ToList();
var sellDocSeriesListJs = _context.SellDocSeriesDefs.OrderBy(p => p.Name)
.Select(p => new SelectListItem()
{
Text = p.Name,
Value = p.Id.ToString()
}).ToList();
var supplierListJs = _context.Transactors.Where(s => s.TransactorType.Code == "SYS.SUPPLIER").OrderBy(s => s.Name)
.Select(p => new SelectListItem()
{
Text = p.Name,
Value = p.Id.ToString()
}).ToList();
var customerListJs = _context.Transactors.Where(s => s.TransactorType.Code == "SYS.CUSTOMER" || s.TransactorType.Code == "SYS.DEPARTMENT").OrderBy(s => s.Name)
.Select(p => new SelectListItem()
{
Text = p.Name,
Value = p.Id.ToString()
}).ToList();
ViewData["BuyDocSeriesListJs"] = buyDocSeriesListJs;
ViewData["SellDocSeriesListJs"] = sellDocSeriesListJs;
ViewData["SupplierListJs"] = supplierListJs;
ViewData["CustomerListJs"] = customerListJs;
}
public AssignmentHistoryFilterViewModel(FiltersHelper filtersHelper)
{
_filtersHelper = filtersHelper;
}
private static IFilter GetFilter(XElement filterNode)
{
// ReSharper disable PossibleNullReferenceException
var typeGuid = new Guid(filterNode.Attribute(GraphFileFormat.Ver_0_1.Node_Filter_TypeGuid).Value);
var filterType = FiltersHelper.GetFilterType(typeGuid);
var filter = (IFilter)filterType.Assembly.CreateInstance(filterType.FullName);
Debug.Assert(filter != null);
filter.NodeGuid = new Guid(filterNode.Attribute(GraphFileFormat.Ver_0_1.Node_Filter_NodeGuid).Value);
XAttribute nameAttribute = filterNode.Attribute(GraphFileFormat.Ver_0_1.Node_Filter_Name);
if (nameAttribute != null)
{
filter.Name = nameAttribute.Value;
}
var filterPropertyNodes = filterNode.Elements(GraphFileFormat.Ver_0_1.Node_FilterProperty);
foreach (XElement element in filterPropertyNodes)
{
var propertyName = element.Attribute(GraphFileFormat.Ver_0_1.Node_FilterProperty_Name).Value;
var propertyValueAttribute = element.Attribute(GraphFileFormat.Ver_0_1.Node_FilterProperty_Value);
var propertyValue = propertyValueAttribute != null ? propertyValueAttribute.Value : null;
var filterProperty = filter.Properties[propertyName];
switch (filterProperty.Type)
{
case FilterPropertyType.String:
case FilterPropertyType.Enum:
filterProperty.Value = propertyValue;
break;
case FilterPropertyType.Integer:
filterProperty.Value = int.Parse(propertyValue, GraphFileFormat.Ver_0_1.NumberStyles);
break;
case FilterPropertyType.Float:
filterProperty.Value = float.Parse(propertyValue, GraphFileFormat.Ver_0_1.NumberStyles);
break;
case FilterPropertyType.Size:
var sizeParts = propertyValue.Split(',');
var width = int.Parse(sizeParts[0], GraphFileFormat.Ver_0_1.NumberStyles);
var height = int.Parse(sizeParts[1], GraphFileFormat.Ver_0_1.NumberStyles);
filterProperty.Value = new Size(width, height);
break;
case FilterPropertyType.Point:
var pointParts = propertyValue.Split(',');
var x = int.Parse(pointParts[0], GraphFileFormat.Ver_0_1.NumberStyles);
var y = int.Parse(pointParts[1], GraphFileFormat.Ver_0_1.NumberStyles);
filterProperty.Value = new Point(x, y);
break;
default:
throw new ArgumentOutOfRangeException();
}
}
return(filter);
// ReSharper restore PossibleNullReferenceException
}
