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 List <T> PaginateSorting <T>(string pageNumber, string totalPageNumber,
List <string> sortingList) where T : DbEntity
{
var tableName = UtilAnnotationTableDb <T> .GetTableName();
string sorting = sortingList != null && sortingList.Count > 0
? string.Join(",", sortingList.ToArray())
: "(SELECT NULL)";
return(SqlCommandSelectPaginationAndSorting <T>
.Execute(tableName, pageNumber, totalPageNumber, sorting));
}
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 <T> Filter <T>(string pageNumber, string totalPageNumber,
List <string> columnsAndValues, List <string> sortingList) where T : DbEntity
{
var tableName = UtilAnnotationTableDb <T> .GetTableName();
string queryFilter = FilterLikeBuilder.Build(columnsAndValues, "=", " LIKE ");
string sorting = sortingList != null && sortingList.Count > 0
? string.Join(",", sortingList.ToArray())
: "(SELECT NULL)";
return(SqlCommandSelectPaginationSortingFilter <T> .Execute(tableName, pageNumber,
totalPageNumber, sorting, queryFilter));
}
public static List <T> Paginate <T>(string pageNumber, string totalPageNumber) where T : DbEntity
{
var tableName = UtilAnnotationTableDb <T> .GetTableName();
return(SqlCommandSelectPagination <T> .Execute(tableName, pageNumber, totalPageNumber));
}