public UserObjectCollection GetAll()
{
UserObjectCollection users = new UserObjectCollection();
string str = "";
try
{
str = this.BaseQuery(false, 0) + " ORDER BY " + UserObject.SURNAME + " ";
users = UserConvertor.DataTableToCollection(this.ExecuteDataSet(str, false).Tables[0]);
}
catch (System.Exception exception1)
{
throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
}
return(users);
}
public UserObject GetUserByLogin(string login)
{
UserObject user = new UserObject();
QueryBuilder builder;
try
{
builder = new QueryBuilder();
builder.Append(this.BaseQuery(false, 0));
builder.AppendWhereString(UserObject.LOGIN, DBFunctions.FixStringValue(login), QueryBuilder.ComparisonOperators.Equal, QueryBuilder.ParameterLocation.FIRST_LAST);
user = UserConvertor.UserRowToObject(DBFunctions.FillDataRow(builder.Query
, true, "Generic", 30));
}
catch (Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
return(user);
}
public ServiceResponseBase SignUp(UserDto dto)
{
try
{
//username if using already by another user
if (DbInstance.Users.Any(x => x.EmailAddress == dto.EmailAddress))
{
return new ServiceResponseBase()
{
IsSuccess = false,
Message = "This email address already using by another users"
}
}
;
//name is valid
if (!dto.Name.IsValidName())
{
return new ServiceResponseBase()
{
IsSuccess = false,
Message = $"Error: {MessageService.NotValidUsername} , Hint: name must be only letters "
}
}
;
//surname is valid
if (!dto.Surname.IsValidName())
{
return new ServiceResponseBase()
{
IsSuccess = false,
Message = $"Error: {MessageService.NotValidUsername} , Hint: surname must be only letters"
}
}
;
//password is valid
if (!dto.Password.IsValidPassword())
{
return new ServiceResponseBase()
{
IsSuccess = false,
Message = $"{MessageService.NotValidPassword } ,Hint: The passord can not be include special chars and also it must be letters or number additionally it can not be less than 6 characters or more than 32 characters"
}
}
;
//username validation
if (!Mail.IsValid(dto.EmailAddress))
{
return new ServiceResponseBase()
{
IsSuccess = false,
Message = "This email address is not valid"
}
}
;
//create new user
dto.Password = dto.Password.Encrypt();
var user = UserConvertor.ToEntity(dto);
//
// add data to db
DbInstance.Users.Add(user);
if (DbInstance.SaveChanges() > 0)
{
return(new ServiceResponseBase()
{
IsSuccess = true,
Message = MessageService.Success,
EntityId = user.Id,
TotalCount = 1
});
}
}
catch (Exception ex)
{
throw ex;
}
return(new ServiceResponseBase()
{
IsSuccess = false,
Message = MessageService.Error
});
}
public MiunieUser ConvertUser(DiscordMember m) => UserConvertor.DiscordMemberToMiunieUser(m);
public void CreateUser([FromBody] UserData newUser)
{
DataModel.User_TryAddNew(UserConvertor.ToUserEntry(newUser));
}
public UserData GetShortByLogin(string login)
{
return(UserConvertor.ToUserDataSafely(DataModel.User_GetByLogin(login)));
}
public UserData GetShortById(int id)
{
return(UserConvertor.ToUserDataShort(DataModel.User_GetByUId(id)));
}// GET: api/User/5
public UserData GetById(int id)
{
return(UserConvertor.ToUserDataSafely(DataModel.User_GetByUId(id)));
}
public MiunieUser ConvertUser(SocketGuildUser m) => UserConvertor.DiscordMemberToMiunieUser(m);
