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);
}
