public async Task <IActionResult> ListUsers([FromQuery] UsersQuery request)
{
try
{
var result = await _service.GetUsers(request);
return(Ok(result));
}
catch (BusinessLogicException ex)
{
return(BadRequest(new Response
{
Status = false,
Message = ex.Message
}));
}
catch (Exception e)
{
return(BadRequest(new Response
{
Status = false,
Message = ErrorMessages.UnkownError
}));
}
}
public Base <object> Inviter(UsersQuery model)
{
Meta meta = new Meta();
PageModel <Users> list = new PageModel <Users>();
//取token值
TokenReponse repository = new TokenReponse();
Token token = repository.First(model.Token);
if (token == null)
{
meta.ErrorCode = ErrorCode.LoginError.GetHashCode().ToString();
meta.ErrorMsg = EnumHelper.GetDescriptionFromEnumValue(ErrorCode.LoginError);
}
else
{
model.UserID = token.UserId;
list = UserService.Inviter(model, ref meta);
}
Base <object> response = new Base <object>
{
Body = list,
Meta = meta
};
return(response);
}
//修改用户
public bool Edit(UsersQuery model, ref Meta meta)
{
string msg = EnumHelper.GetDescriptionFromEnumValue(ErrorCode.Success);
string msgCode = ErrorCode.Success.GetHashCode().ToString();
Try(context =>
{
//查询用户名是否存在
var user = context.Users.Where(c => c.UserID == model.UserID && model.UserStateId == 0).FirstOrDefault();
if (user != null)
{
msgCode = ErrorCode.Error.GetHashCode().ToString();
msg = EnumHelper.GetDescriptionFromEnumValue(ErrorCode.Error);
}
else
{
//开始修改
user.LoginName = model.LoginName;
user.Phone = model.Phone;
user.Icon = model.Icon;
user.Mail = model.Mail;
context.SaveChanges();
}
});
meta.ErrorCode = msgCode;
meta.ErrorMsg = msg;
return(true);
}
public async Task <PagedResult <UserModel> > GetAll(UsersQuery query, ClaimsPrincipal principal)
{
if (!principal.IsSchemeOwner())
{
query.PartyId = principal.GetPartyId();
}
var usersResult = await _usersRepository.GetAll(query);
var users = usersResult.Data;
var identitiesIds = users.Select(c => c.AspNetUserId).ToList();
var identities = await _identityService.GetIdentities(identitiesIds);
var mappedUsers = from user in users
join identity in identities on user.AspNetUserId equals identity.Id
select new UserModel
{
Id = user.Id,
Username = identity.UserName,
PartyId = user.PartyId,
PartyName = user.PartyName,
CreatedDate = user.CreatedDate,
Roles = identity.Roles.ToArray(),
IdentityId = identity.Id,
Active = user.Active
};
return(mappedUsers.ToPagedResult(usersResult.Count));
}
public Base <object> Edit(UsersQuery model)
{
Meta meta = new Meta();
bool editNote = true;
//取token值
TokenReponse repository = new TokenReponse();
Token token = repository.First(model.Token);
if (token == null)
{
meta.ErrorCode = ErrorCode.LoginError.GetHashCode().ToString();
meta.ErrorMsg = EnumHelper.GetDescriptionFromEnumValue(ErrorCode.LoginError);
}
else
{
editNote = UserService.Edit(model, ref meta);
}
Base <object> result = new Base <object>
{
Meta = meta,
Body = editNote
};
return(result);
}
public static void Clear()
{
//удалить старых пользователей
var usersCleaner = new UsersCleaner();
bool result = usersCleaner.RemoveOld();
IUsersQuery usersQuery = new UsersQuery();
List <long> userIds = usersQuery.GetAllUserIds();
var userKnowledgeCleaner = new UsersKnowledgeCleaner();
result &= userKnowledgeCleaner.RemoveDeleted(userIds);
var usersRepetitionIntervalCleaner = new UsersRepetitionIntervalCleaner();
result &= usersRepetitionIntervalCleaner.RemoveWithoutData(userIds);
if (result)
{
Console.WriteLine("Все что хотели удалить - все удалили!");
}
else
{
Console.WriteLine("Не все удалили! При удалении что-то пошло не так:(");
}
Console.ReadLine();
}
public async Task <IEnumerable <UserQueryResponse> > Handle(UsersQuery request, CancellationToken cancellationToken)
{
var users = await this.userRepository.GetAsync();
var usersMapped = users.Select(u => this.MapToResponse(u.Id, u.Name, u.Surname));
return(usersMapped);
}
// Method Login
public UsersModel Login(string username, string password)
{
DataTable dt = DataProvider.Instance.Query(UsersQuery.Login(username, password));
List <UsersModel> users = HelperDao.GenerateList <UsersModel>(dt);
return(users.FirstOrDefault());
}
public async Task <User> GetAsync(Guid id)
{
var query = new UsersQuery {
FilterIds = id.Collect()
};
return((await _queryInvoker.Execute <UsersQuery, User>(query)).SingleOrDefault());
}
public async Task <IActionResult> DeleteAll()
{
await Db.Connection.OpenAsync();
var query = new UsersQuery(Db);
await query.DeleteAllAsync();
return(new OkResult());
}
public async Task <IActionResult> GetLatest()
{
await Db.Connection.OpenAsync();
var query = new UsersQuery(Db);
var result = await query.LatestUserAsync();
return(new OkObjectResult(result));
}
public async Task <IActionResult> GetAll([FromQuery] UsersQuery query)
{
var users = await _usersService.GetAll(query, null);
return(Ok(new PagedResult <UserOverviewViewModel>
{
Data = users.Data.Select(d => d.Map()),
Count = users.Count
}));
}
public static DbQuery <UserBriefModel> ToDbQuery(this UsersQuery query)
{
var spec = LinqSpec.For <UserBriefModel>(x => true);
if (query.Roles != null && query.Roles.Length > 0)
{
spec = spec && Specs.HasAtLeastOneRoleFrom(query.Roles);
}
return(DbQuery.PagedFor <UserBriefModel>().FromClientQuery(query).AndFilterBy(spec));
}
static void Main(string[] args)
{
var result = Microsoft.VisualBasic.Webservices.Bing.SearchEngineProvider.Search("GCModeller");
// Microsoft.VisualBasic.Webservices.Bing.SearchResult nextr = result.NextPage();
var query = new UsersQuery { term ="guigang" };
var queryResult = Search.Users(query.Build(), UserSorts.joined);
Pause();
}
public Base <object> Del(UsersQuery model)
{
Meta meta = new Meta();
bool delNote = UserService.Delete(model, ref meta);
Base <object> result = new Base <object>
{
Meta = meta,
Body = delNote
};
return(result);
}
public IActionResult Get(int startIndex, int numberOfUsers)
{
var query = new UsersQuery
{
StartIndex = startIndex,
NumberOfUsers = numberOfUsers
};
var model = _userService.GetUsersViewModel(query);
return(Ok(model));
}
private string GetCacheKeyForUsersQuery(UsersQuery query)
{
string key = CacheKeys.UsersList.ToString();
if (query.MovieId.HasValue && query.MovieId > 0)
{
key = string.Concat(key, "_", query.MovieId.Value);
}
key = string.Concat(key, "_", query.Page, "_", query.ItemsPerPage);
return(key);
}
public static UserProfileModel GetProfileModel(int userID)
{
using (CallDB db = new CallDB())
{
var profile = new UsersQuery(db).GetProfile(userID);
if (profile == null)
{
return(new UserProfileModel());
}
return(profile);
}
}
static void Main(string[] args)
{
var result = Microsoft.VisualBasic.Webservices.Bing.SearchEngineProvider.Search("GCModeller");
// Microsoft.VisualBasic.Webservices.Bing.SearchResult nextr = result.NextPage();
var query = new UsersQuery {
term = "guigang"
};
var queryResult = Search.Users(query.Build(), UserSorts.joined);
Pause();
}
public async Task <QueryResult <User> > ListAsync(UsersQuery query)
{
// Here I list the query result from cache if they exist, but now the data can vary according to the Movie ID, page and amount of
// items per page. I have to compose a cache to avoid returning wrong data.
string cacheKey = GetCacheKeyForUsersQuery(query);
var users = await _cache.GetOrCreateAsync(cacheKey, (entry) => {
entry.AbsoluteExpirationRelativeToNow = TimeSpan.FromMinutes(1);
return(_userRepository.ListAsync(query));
});
return(users);
}
public async Task TestUserAdd()
{
var query = new UsersQuery()
{
UserName = "******"
};
var data = await _usersService.RetrieveAsync(query);
if (data.FirstOrDefault() != null)
{
Assert.True(data.First().UserName == "测试");
}
}
// Method ListDataByColumn
public List <string> ListDataByColumn(string column)
{
DataTable dt = DataProvider.Instance.Query(UsersQuery.ListDataByColumn(column));
List <string> data = new List <string>();
foreach (DataRow row in dt.Rows)
{
data.Add(row[column].ToString());
}
return(data);
}
public bool RemoveOld()
{
IUsersQuery usersQuery = new UsersQuery();
DateTime maxLastActivity = DateTime.Today.AddDays(-CommonConstants.COUNT_DAYS_TO_HOLD_DATA);
if (!usersQuery.RemoveByLastActivity(maxLastActivity))
{
Console.WriteLine("Не удалось удалить пользователей, которые последний раз заходили ранее {0}!",
maxLastActivity);
return(false);
}
return(true);
}
public async Task <IActionResult> GetOne(int id)
{
await Db.Connection.OpenAsync();
var query = new UsersQuery(Db);
var result = await query.FindOneAsync(id);
if (result is null)
{
return(new NotFoundResult());
}
return(new OkObjectResult(result));
}
public ActionResult GetUsersList()
{
try
{
var queryParams = new NameValueCollection();
if (!ParamHelper.CheckParaQ(ref queryParams))
{
return(Json(new ResponseEntity <int>(RegularFunction.RegularSqlRegexText), JsonRequestBehavior.AllowGet));
}
var query = new UsersQuery(queryParams);
var sqlCondition = new StringBuilder();
sqlCondition.Append("ISNULL(IsDelete,0)!=1");
if (!string.IsNullOrEmpty(query.Name))
{
sqlCondition.Append($" and (Name like '%{query.Name}%' or UserName like '%{query.Name}%')");
}
PageRequest preq = new PageRequest
{
TableName = " [Users] ",
Where = sqlCondition.ToString(),
Order = " Id DESC ",
IsSelect = true,
IsReturnRecord = true,
PageSize = query.PageSize,
PageIndex = query.PageIndex,
FieldStr = "*"
};
var result = new UsersBLL().GetDataByPage(preq);
var response = new ResponseEntity <object>(true, string.Empty,
new DataGridResultEntity <Users>
{
TotalRecords = preq.Out_AllRecordCount,
DisplayRecords = preq.Out_PageCount,
ResultData = result
});
return(Json(response, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new ResponseEntity <object>(-999, string.Empty, ""), JsonRequestBehavior.AllowGet));
}
}
//我的邀请人
public PageModel <Users> Inviter(UsersQuery queryInfo, ref Meta meta)
{
return(Try(context =>
{
string sql = "SELECT * FROM Users WHERE 1=1 ";
List <SqlParameter> paramList = new List <SqlParameter>();
//查询
if (!string.IsNullOrEmpty(queryInfo.ParentID))
{
sql += " AND ParentID= @ParentID";
paramList.Add(new SqlParameter("@ParentID", queryInfo.ParentID));
}
return context.QuerySql <Users>(sql, queryInfo, paramList.ToArray());
}));
}
public IPagedList <UserBriefModel> GetUsers(UsersQuery query)
{
EnsureIsValid(query);
try
{
var usersPage = _deps.Users.PartialProjectThenQueryPage <UserBriefModel>(
User.Spec.Active,
query.ToDbQuery());
return(usersPage);
}
catch (Exception ex)
{
throw new ServiceException("Can't get users.", ex);
}
}
public async Task <IActionResult> DeleteOne(int id)
{
await Db.Connection.OpenAsync();
var query = new UsersQuery(Db);
var result = await query.FindOneAsync(id);
if (result is null)
{
return(new NotFoundResult());
}
await result.DeleteAsync();
return(new OkResult());
}
public async Task <IEnumerable <UserDto> > Handle(UsersQuery request, CancellationToken cancellationToken)
{
if (request == null)
{
throw new ArgumentNullException(nameof(request));
}
var users = await _context.Users
.Include(u => u.Team)
.Include(u => u.Tasks)
.Include(u => u.Projects)
.ToListAsync();
return(_mapper.Map <IEnumerable <UserDto> >(users));
}
public static RegisterModel GetDadosFaturamento(int userID)
{
using (CallDB db = new CallDB())
{
if (FaturamentoExist(userID))
{
var dadosFaturamento = new UsersQuery(db).GetFaturamento(userID);
return(dadosFaturamento);
}
else
{
var dadosFaturamento = new RegisterModel();
return(dadosFaturamento);
}
}
}
public JsonResult SendToMail(long userId, string email)
{
if (IdValidator.IsInvalid(userId) || string.IsNullOrWhiteSpace(email))
{
return(JsonResultHelper.Error());
}
string uniqueUserId = GetUserUniqueId();
if (string.IsNullOrEmpty(uniqueUserId))
{
return(JsonResultHelper.Error());
}
string domain = WebSettingsConfig.Instance.Domain;
//TODO: вынести в конфиг
var mailerConfig = new MailerConfig {
IsHtmlBody = true,
DisplayName = "Сайт " + domain
};
const string SUBJECT = "Ваш уникальный идентификатор";
string body = string.Format("Здравствуйте, Уважаемый пользователь!<br />"
+ "Ваш уникальный идентификатор на сайте {0}:<br /><b>{1}</b><br /><br />"
+ "<span style='font-size:12px;'><b>" + Message + "</b></span><br />"
+
"<span style='font-size: 11px;'>Если Вы не указывали этот адрес почты на сайте {0}, то просто удалите это письмо.<br />" +
"Данное письмо не требует ответа.</span>",
domain, uniqueUserId);
var mailer = new Mailer();
bool isSuccess = mailer.SendMail(MailAddresses.SUPPORT, email, SUBJECT, body, mailerConfig);
if (isSuccess)
{
var usersQuery = new UsersQuery();
if (!usersQuery.UpdateEmail(userId, email))
{
LoggerWrapper.LogTo(LoggerName.Errors).ErrorFormat(
"ProfileController.SendToMail для пользователя с идентификатором {0}, не смогли обновить адрес электронной почты на {1}",
userId, email);
}
}
return(JsonResultHelper.Success(isSuccess));
}
public IPagedList<UserBriefModel> GetUsers(UsersQuery query)
{
EnsureIsValid(query);
try
{
var usersPage = _deps.Users.PartialProjectThenQueryPage<UserBriefModel>(
User.Spec.Active,
query.ToDbQuery());
return usersPage;
}
catch (Exception ex)
{
throw new ServiceException("Can't get users.", ex);
}
}
public IHttpActionResult Get(UsersQuery query)
{
var page = _userService.GetUsers(query);
return Ok(page);
}
