public IEnumerable<AccountUser> ListUsers(string keyword) { var result = new DapperMicroOrmRepository<AccountUser>(_dbContextFactory.GetDbConnection(Global.DbConnection.UserConnection)) .FromSql("SELECT * FROM AccountUser where Name like @keyword", new { keyword = "%" + keyword + "%" }); return result; }
public async Task <IEnumerable <DepartmentDto> > GetDepartmentByKey(DepartmentRequest request) { var qry = $@"SELECT * FROM department where Deleted = 0 {(!string.IsNullOrEmpty(request.DepartmentCode) ? "and DepartmentCode like @code" : "")} {(!string.IsNullOrEmpty(request.DepartmentName) ? "and DepartmentName like @name" : "")} {(!string.IsNullOrEmpty(request.Description) ? "and Description like @description" : "")} "; var param = new DynamicParameters(); param.Add("@code", "%" + request.DepartmentCode + "%"); param.Add("@name", "%" + request.DepartmentName + "%"); param.Add("@description", "%" + request.Description + "%"); var result = await new DapperRepository <DepartmentDto>(_dbContextFactory.GetDbConnection(Global.DbConnection.HrisConnection)) .FromSqlAsync(qry, param); return(result); }