public async void LoadComboBoxes(object e)
{
var certificationTypes = await GetData.CertificationQueryAsync();
foreach (CertificationModel certification in certificationTypes)
{
CertificationTypes.Add(certification);
}
var restrictionTypes = await GetData.RestrictionQueryAsync();
foreach (RestrictionModel restrictionType in restrictionTypes)
{
RestrictionTypes.Add(restrictionType);
}
var departments = await GetData.DepartmentQueryAsync();
foreach (DepartmentModel department in departments)
{
Departments.Add(department);
}
var jobTitles = await GetData.JobTitleQueryAsync();
foreach (JobTitleModel jobTitle in jobTitles)
{
JobTitles.Add(jobTitle);
}
}
public List <TBase> GetByProperty(string propName, RestrictionTypes restriction, object propValue)
{
return(new EntityQuery <TBase>()
.Read()
.AddRestriction(propName, restriction, propValue)
.Execute());
}
public void AddRestriction(RestrictionTypes type, object value)
{
Parameter parameter = new Parameter(this, value);
Restriction restriction = new Restriction(this, parameter, type);
Parameters.Add(parameter);
Restrictions.Add(restriction);
}
public override IQuery AddRestriction(string property, RestrictionTypes type, object value)
{
Column column = Mapping.TypeTableMapping[baseType].Columns.Single(x => x.PropertyName == property);
column.AddRestriction(type, value);
return(this);
}
public override IQuery AddRestriction(string property, RestrictionTypes type, object value)
{
EntityBeanMapping <TBase> mapping = GetMapping();
Column column = mapping.PropertyMapping[property];
column.AddRestriction(type, value);
return(this);
}
public Restriction(Column column, Parameter parameter, RestrictionTypes rType)
{
if (parameter.DatabaseType == SqlDbType.VarChar && (rType == RestrictionTypes.LessThan || rType == RestrictionTypes.MoreThan))
{
Logger.Error(MethodBase.GetCurrentMethod(), $"Cannot apply '{GetRestrictionString(rType)}' operator to values of type VarChar");
}
Alias = column.Alias;
Handle = parameter.Handle;
RestrictionType = rType;
}
public List <TBase> GetByProperty(string propName, RestrictionTypes restriction, object propValue)
{
Type propType = propValue.GetType();
EntityBeanQuery <TBase> query = new EntityBeanQuery <TBase>();
MethodInfo addRestriction;
addRestriction = query.GetType().GetMethod("AddRestriction", BindingFlags.Instance | BindingFlags.Public);
addRestriction.Invoke(query, new object[] { propName, restriction, propValue });
return(query.Execute());
}
private static string GetRestrictionString(RestrictionTypes type)
{
switch (type)
{
case RestrictionTypes.EqualTo: return("=");
case RestrictionTypes.NotEqualTo: return("<>");
case RestrictionTypes.LessThan: return("<");
case RestrictionTypes.MoreThan: return(">");
case RestrictionTypes.In: return("in");
case RestrictionTypes.NotIn: return("not in");
default:
Logger.Error(MethodBase.GetCurrentMethod(), $"Invalid restriction '{type}'");
return("");
}
}
public Restriction(Column column, string sql, RestrictionTypes rType)
{
Alias = column.Alias;
Handle = sql;
RestrictionType = rType;
}
public abstract IQuery AddRestriction(string property, RestrictionTypes type, object value);
