public static List <T> Filter <T>(List <string> filterList) where T : DbEntity
{
var tableName = UtilAnnotationTableDb <T> .GetTableName();
string queryFilter = FilterBuilder.Build(filterList, "=", "=");
return(SqlCommandSelectFilter <T> .Execute(tableName, queryFilter));
}
public static List <T> Filter <T>(List <string> columnsAndValues) where T : DbEntity
{
var tableName = UtilAnnotationTableDb <T> .GetTableName();
string queryFilter = FilterLikeBuilder.Build(columnsAndValues, "=", " LIKE ");
return(SqlCommandSelectFilter <T> .Execute(tableName, queryFilter));
}
public static DbEntityUser FindByUsernamePassword(string username, string password)
{
string tableName = UtilAnnotationTableDb <DbEntityUser> .GetTableName();
StringBuilder userNameAndPassword = new StringBuilder();
userNameAndPassword.Append($"Username='******' AND ");
userNameAndPassword.Append($"Password='******'");
var filteredList = SqlCommandSelectFilter <DbEntityUser> .Execute(
tableName, userNameAndPassword.ToString());
return((filteredList.Count < 1) ? null : filteredList[0]);
}
public static List <EntitySensitiveInformation> Filter(Dictionary <string, string> filters)
{
EntityMappingSensitiveInformation entityMappingSensitiveInformation = new EntityMappingSensitiveInformation();
Dictionary <string, string> columnValuesFilter;
columnValuesFilter = BuilderColumnsValuesFilterSensitiveInformation
.GetColumnsAndValuesToFilter(filters);
return(SqlCommandSelectFilter <EntitySensitiveInformation> .Execute(
tableName,
entityMappingSensitiveInformation,
columnValuesFilter
));
}
