public UserActivateResponseDto UpdateUserActive(UserActivateRequestDto userActivateRequestDto)
{
UserActivateResponseDto userActivateResponseDto = new UserActivateResponseDto();
var cModel = new UserActivateCM
{
UserId = userActivateRequestDto.UserId,
IsActive = userActivateRequestDto.IsActive
};
var response = authenticationRepository.UpdateUserActive(cModel);
userActivateResponseDto.RegisteredUserId = response.RegisteredUserId;
return(userActivateResponseDto);
}
public UserActivateQM UpdateUserActive(UserActivateCM userActivateCM)
{
UserActivateQM userActivateQM;
using (var connection = new DbConnectionProvider().CreateConnection())
{
connection.Open();
var registrationInsertCommand = new UserActivateCommand {
Connection = connection
};
userActivateQM = registrationInsertCommand.Execute(userActivateCM);
}
return(userActivateQM);
}
public UserActivateQM Execute(UserActivateCM userActivateCM)
{
UserActivateQM userActivateQM = new UserActivateQM();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspUpdateUserActivate]";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(this.AddParameter("@UserId", SsDbType.UniqueIdentifier, ParameterDirection.Input, userActivateCM.UserId));
sqlCommand.Parameters.Add(this.AddParameter("@isActive", SsDbType.Bit, ParameterDirection.Input, userActivateCM.IsActive));
sqlCommand.Parameters.Add(this.AddParameter("@RegisteredUserId", SsDbType.UniqueIdentifier, ParameterDirection.Output));
var reader = sqlCommand.ExecuteNonQuery();
userActivateQM.RegisteredUserId = (Guid)sqlCommand.Parameters["@RegisteredUserId"].Value;
}
return(userActivateQM);
}
