public IEnumerable <RedirectManagerModel> GetAll(string term, int page, int pageSize)
{
var sql = $"SELECT * FROM RedirectManager WHERE OldUrl like '%{term}%' ORDER BY id OFFSET {(page - 1) * pageSize} ROWS FETCH NEXT {pageSize} ROWS ONLY;";
Logger.Debug($"Start GetAll({term}, {page}, {pageSize})");
Logger.Debug($"SQL: {sql}");
return(SqlUtil.ExecuteQueryReader(sql, RedirectManagerModel.LoadFromRecord));
}
public RedirectManagerModel GetById(int id)
{
var sql = $"SELECT * FROM RedirectManager WHERE id = {id}";
Logger.Debug("Start GetById()");
Logger.Debug($"SQL: {sql}");
return(SqlUtil.ExecuteQueryReader(sql, RedirectManagerModel.LoadFromRecord).FirstOrDefault());
}
public IEnumerable <RedirectManagerModel> GetAll()
{
var sql = "SELECT * FROM RedirectManager";
Logger.Debug("Start GetAll()");
Logger.Debug($"SQL: {sql}");
return(SqlUtil.ExecuteQueryReader(sql, RedirectManagerModel.LoadFromRecord));
}
public RedirectManagerModel Get(string oldUrl)
{
Logger.Debug($"Start Get({oldUrl})");
if (string.IsNullOrEmpty(oldUrl))
{
Logger.Debug("oldUrl is invalid.");
return(null);
}
var sql = $"SELECT * FROM RedirectManager WHERE '{oldUrl}' like '%' + OldUrl + '%' " +
$"ORDER BY CASE WHEN OldUrl = '{oldUrl}' THEN 0 ELSE 1 END";
Logger.Debug($"SQL: {sql}");
return(SqlUtil.ExecuteQueryReader(sql, RedirectManagerModel.LoadFromRecord).FirstOrDefault());
}
