public async Task <ActionResult> Export([FromRoute] long locationId, [FromRoute][FromQuery] AdminSearchReqModel query)
{
if (query.Type != "excel")
{
return(BadRequest(new ErrorModel {
Message = "Not supported type"
}));
}
var res = await _adminService.SearchAdmin(locationId, _authHelpers.GetCurrentUserId().Value, query);
ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
ExcelPackage excel = new ExcelPackage();
var workSheet = excel.Workbook.Worksheets.Add("Sheet1");
workSheet.Cells[1, 1].LoadFromCollection(((AdministratorSearchResult)res.Result).Items, true);
return(File(excel.GetAsByteArray(), "application/vnd.ms-excel", "data.xlsx"));
}
public async Task <ActionResult> Get([FromRoute] long locationId, [FromQuery] AdminSearchReqModel model)
{
return(Ok(await _adminService.SearchAdmin(locationId, _authHelpers.GetCurrentUserId().Value, model)));
}
public async Task <ServiceResponseResult> SearchAdmin(long locationId, long userId, AdminSearchReqModel model)
{
Logger.WriteInformation("Searching admin data.");
model.Takes = model.Takes == 0 || model.Takes > _appSettings.Limit ? _appSettings.Limit : model.Takes;
model.OrderBy = string.IsNullOrEmpty(model.OrderBy) ? "id" : model.OrderBy;
model.OrderDirection = string.IsNullOrEmpty(model.OrderDirection) ? "desc" : model.OrderDirection;
model.Name = string.IsNullOrEmpty(model.Name) ? null : model.Name;
model.Id = string.IsNullOrEmpty(model.Id) ? null : model.Id;
model.Email = string.IsNullOrEmpty(model.Email) ? null : model.Email;
var param = new SqlParameter[] { new SqlParameter("id", (object)model.Id ?? DBNull.Value)
{
SqlDbType = SqlDbType.BigInt, Direction = ParameterDirection.Input, IsNullable = true,
},
new SqlParameter("onlyToolKitUser", (object)model.OnlyToolKitUser ?? DBNull.Value)
{
SqlDbType = SqlDbType.Bit, Direction = ParameterDirection.Input, IsNullable = true
},
new SqlParameter("name", (object)model.Name ?? DBNull.Value)
{
SqlDbType = SqlDbType.VarChar, Direction = ParameterDirection.Input, IsNullable = true
},
new SqlParameter("email", (object)model.Email ?? DBNull.Value)
{
SqlDbType = SqlDbType.VarChar, Direction = ParameterDirection.Input, IsNullable = true
},
new SqlParameter("state", (object)model.State ?? DBNull.Value)
{
SqlDbType = SqlDbType.BigInt, Direction = ParameterDirection.Input, IsNullable = true
},
new SqlParameter("statusid", (object)model.StatusId ?? DBNull.Value)
{
SqlDbType = SqlDbType.BigInt, Direction = ParameterDirection.Input, IsNullable = true
},
new SqlParameter("skip", model.Skips)
{
SqlDbType = SqlDbType.Int, Direction = ParameterDirection.Input, IsNullable = true
},
new SqlParameter("take", model.Takes)
{
SqlDbType = SqlDbType.Int, Direction = ParameterDirection.Input, IsNullable = true
},
new SqlParameter("orderby", model.OrderBy)
{
SqlDbType = SqlDbType.VarChar, Direction = ParameterDirection.Input, IsNullable = true
},
new SqlParameter("orderdir", model.OrderDirection)
{
SqlDbType = SqlDbType.VarChar, Direction = ParameterDirection.Input, IsNullable = true
}, };
var sql = @"EXEC [dbo].[AdminSearch]";
var data = await _context.Set <Administrator>().FromSqlRaw(sql, param).ToListAsync();
var response = new AdministratorSearchResult
{
Items = data.Select(x =>
{
var data = new AdministratorResult
{
DisabledReason = x.DisabledReason,
Email = x.Email,
Id = x.UserId,
Name = x.Name,
Permissions = new UserPermissionResult
{
HasAdminEdit = x.HasAdminEdit.HasValue && x.HasAdminEdit.Value,
HasAdminRead = x.HasAdminRead.HasValue && x.HasAdminRead.Value,
HasConfigEdit = x.HasConfigEdit.HasValue && x.HasConfigEdit.Value,
HasConfigRead = x.HasConfigRead.HasValue && x.HasConfigRead.Value,
HasDeviceEdit = x.HasDeviceEdit.HasValue && x.HasDeviceEdit.Value,
HasDeviceRead = x.HasDeviceRead.HasValue && x.HasDeviceRead.Value,
HasKeyholderEdit = x.HasKeyholderEdit.HasValue && x.HasKeyholderEdit.Value,
HasKeyholderRead = x.HasKeyholderRead.HasValue && x.HasKeyholderRead.Value,
HasSpaceEdit = x.HasSpaceEdit.HasValue && x.HasSpaceEdit.Value,
HasSpaceRead = x.HasSpaceRead.HasValue && x.HasSpaceRead.Value
},
};
if (x.State.HasValue)
{
data.State = Enum.Parse <AdministratorState>(x.State.Value.ToString());
}
if (x.UserActivityId.HasValue)
{
data.RecentActivity = new ActivityResult
{
ActivityText = x.ActivityText,
ActivityTime = x.ActivityTime,
Id = x.UserActivityId.Value
};
}
if (x.StatusId.HasValue)
{
data.Status = new LookupEntityResult
{
Id = x.StatusId.Value,
Name = x.StatusName
};
}
if (x.KeyHolderId.HasValue)
{
data.ToolkitInfo = new ToolkitInfoRespModel
{
Id = x.KeyHolderId.Value,
KeySerialNumber = x.KeySerialNumber,
Pin = x.Pin
};
}
return(data);
}).ToList(),
TotalItems = data.Count()
};
Logger.WriteInformation("Searching admin data.");
return(new ServiceResponseResult
{
Result = response,
StatusCode = System.Net.HttpStatusCode.OK
});
}
